This discussion is archived
2 Replies Latest reply: Jul 13, 2012 10:31 AM by 949352 RSS

Need Help With Inserting Orders

949352 Newbie
Currently Being Moderated
Hi,

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?

Thanks!!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points