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?