Load POs through Interface

Oracle EBS R12 has Interface table to upload the Open purchase Order from Legacy system or from other source such as Spreadsheet to the Oracle Application.

You need to run PO import program to load the data from Interfaces table to the Oracle Base Tables.

There are three interface tables uses to Upload the Open purchase Orders in Oracle EBS.

• po_headers_interface
• po_lines_interface
• po_distributions_interface

/****** INSERT DATA INTO PO_HEADERS_INTERFACE ******/

INSERT INTO po.po_headers_interface
(interface_header_id,
comments,
process_code,
action,
org_id,
document_type_code,
currency_code,
agent_id,
vendor_id,
vendor_name,