If we want to create an invoice with the option to pick the price from Order Entry. Two possible solutions are as follows

Solution 1 : Setup a new order cycle with following steps
Enter Order
Interface to Receivables
Complete Line
Complete Order
This will take care of Pricing as you are creating the Order in OE.

Solution 2 : Write a database trigger on RA_CUSTOMER_TRX_LINES_ALL table. Pick the price from OE and update the price, amount columns of the table to reflect the correct price and amount.

Return to : Oracle Database, SQL, Application, Programming Tips