1 Reply Latest reply on Apr 29, 2013 1:23 PM by shreevat

    standard purchase order upload to oracle

    AHS
      hi,

      we are on oracle apps 11i, database 9i.

      I have a custom requirement that requires importing purchase orders to Oracle Apps through database. I was advised to use the following interface tables:
      PO_HEADERS_INTERFACE
      PO_LINES_INTERFACE
      PO_LINE_LOCATIONS_INTERFACE
      PO_DISTRIBUTIONS_INTERFACE


      insert the data to these tables using a PLSQL procedure and then running the program IMPORT STANDARD PURCHASE ORDERS from front end.


      If someone confirms the above is the right method, it would be appreciated.


      thanks & regards