XLA tables?

XLA_EVENTS

XLA_AE_HEADERS 

XLA_AE_LINES

XLA_DISTRIBUTION_LINKS

XLA_TRANSACTION_ENTITIES 

XLA_ACCOUNTING_ERRORS

What are the different types of released_status in wsh_delivery_details table while booking the sales order?

Booking the sales order                      record(s) will be created in wsh_delivery_details with released_status =’R’ (Ready to Release)

Pick release the order                         released_status =’S’ (Ready to Wareshouse)

Ship confirm the order                       released_status =’C’ (Ship confirmed)

What are the different types of released_status in wsh_delivery_details table?

B: Backordered- Line failed to be allocated in Inventory

C: Shipped -Line has been shipped

D: Cancelled -Line is Cancelled

N: Not Ready for Release -Line is not ready to be released

R: Ready to Release: Line is ready to be released

S: Released to Warehouse: Line has been released to Inventory for processing

X: Not Applicable- Line is not applicable for Pick Release

Y: Staged- Line has been picked and staged by Inventory

How to make concurrent program will error out for package, procedure, function and report?

For package, procedure, function

Pass RETCODE :=2

For report:

begin

srw.USER_EXIT ('FND SRWEXIT');

CNC_RET := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',' ');

return (CNC_RET);

end; 

Can we create the program without RETCODE and ERRBUFF?

No, Program will error out with below message

PLS-00306: wrong number or types of arguments

API to create Routing?

BOM_RTG_PUB.PROCESS_RTG