Oracle Apps Functional All About Oracle Apps functional & Technical FAQs, Tutorials

MAIN ORDER IMPORT TABLES

Order Import Interface Tables

OE_HEADERS_IFACE_ALL
OE_LINES_IFACE_ALL
OE_PRICE_ADJS_IFACE_ALL
OE_PRICE_ATTS_IFACE_ALL
OE_CREDITS_IFACE_ALL
OE_LOTSERIALS_IFACE_ALL
OE_RESERVTNS_IFACE_ALL
OE_ACTIONS_IFACE_ALL
OE_CUSTOMER_INFO_IFACE_ALL
OE_PAYMENTS_IFACE_ALL
of the table OE_CUSTOMER_INFO_IFACE_ALL and a column in the OE_HEADERS_IFACE_ALL table
Note, the OE_CUSTOMER_INFO_IFACE_ALL table (used for adding Customer/Address/Contact information) is the only table from above that does not have an ORDER_SOURCE_ID column. A link between the order header record is made through the column CUSTOMER_INFO_REF

Related Posts

• Order workflow statuses
• Order Management List of Shipping Statuses
• What is SUPPLY-TO-ORDER?
• Create a Customer
• Defining Release Rules
• API to partially Backorder a Pick Released Order Line
• OE Header or OE Lines Table Column Links Back To A Purchase REQ for Back To Back Orders
• Set Defaulting Shipping Document at the time of ship confirm based on the customers
• How To Progress ATO Lines Passed Supply Eligible?
• Can I update an imported Internal Order through order import?