Populating purchase order interface tables?

Orapps picture Orapps · Sep 18, 2009 · Viewed 15.7k times · Source

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)

Answer

Vincent Malgrat picture Vincent Malgrat · Sep 21, 2009

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.