Search code examples
oracleoracleapplications

Populating purchase order interface tables?


What are the mandatory fields in the following tables that I need to populate in order that they can pass validation and can be imported in the respective base tables

  • PO_HEADERS_ALL (Purchasing documents open interface)
  • PO_LINES_ALL (Purchasing documents open interface)
  • PO_LINE_LOCATIONS_ALL (Purchasing documents open interface)
  • PO_DISTRIBUTIONS_ALL (Purchasing documents open interface)

Solution

  • These tables ARE the base tables. You should not normaly write directly to them.

    The open interfaces of the Purchasing module (for EBS 11.5.10) are described in Metalink note 359295.1. Review the documentation carefully before using the interfaces. Don't write directly to the base tables -- this could void your support.