Populating purchase order interface tables?

Question

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 1

You're using Oracle Apps right? Well, that's a complicated schema. But you should be able to DESCribe the table in SQL*Plus or whatever IDE you're using. In which case, the minmim set of columns you have to populate are the ones which are declared NOT NULL.

Answer 2

Hi Bhavya3p,

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.