2 Replies Latest reply on Jul 13, 2012 5:31 PM by 949352

    Need Help With Inserting Orders


      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?