This content has been marked as final. Show 4 replies
946349 wrote:You'd be better off in the oracle apps forum: General EBS Discussion
We are using oracle 11i with oracle applications. I want to insert a new order into oracle but I don't know what tables I need to insert into or update. I want to take the order all the way from creation to remittance and finally closed. I am using PHP oci to pull data for reporting right now (discoverer views) but there are so many tables that I don't know which ones to insert a new order for. I think two of the tables are oe_order_headers_all and e_order_lines_all.
Has anyone accomplished this type of thing before?
1. You will have to use the Order management interface tables to get the order into oracle. Run order import process and this will validate the SO data before creating the sales order in oracle.
2. Once SO is created in oracle, then BOOK the SO, either it can be imported as BOOKED or a user has to book it. it is entirely upon what is the requirement.
3. Once the SO is booked, run pick release process, this can be scheduled or kicked off through code using APIs. I recommend scheduling with an appropriate frequency.
4. After pick release the Oracle apps can be configured to auto pick confirm and auto ship confirm, this will bypass all user intervention and eventually the SO will be closed and ready for invoicing.
1. When pick released if inventory level are not appropriate the SO will be back order and then user intervention is required to fix the issue (either change the SO or correct the inventory). Pick release again and if everything is good it will auto pick and ship and close. Next it will be invoiced.
Always user the oracle order management interface tables bypassing this is cause a lot of pain. I have been through it so I am saying this through experience.
The order import process is complex and using the standard oracle import will weed out a lot of bad SO before they get into the system leaving oracle data clean enough for reporting.
The OE tables you have mentioned are oracle seeded OM tables. Oracle order import process will create rows in those tables, dont insert directly into them. let the Order import program handle that. It is again a complex process so dont by pass Order import.
Use the order interface tables, oracle has provided them for exactly what you are trying to do.
All the best.