Last updated on DECEMBER 08, 2014
Applies to:Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
Populating the following interface tables
PO_DISTRIBUTIONS_INTERFACE this record has the charge_account_id you want to use.
No records are in PO_LINE_LOCATIONS_INTERFACE
After the interface is run we see the
one record in PO_HEADERS_INTERFACE , PO_LINES_INTERFACE, and PO_LINE_LOCATIONS_INTERFACE
BUT there are now Two records in PO_DISTRIBUTIONS_INTERFACE
You can get an error from the account generator or the PO is created with the wrong account
The record you had put in PO_DISTRIBUTIONS_INTERFACE was not processed
It shows NULL for REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID so we know the record was ignored.
We also see the the customer's distribution record column INTERFACE_LINE_LOCATION_ID does not match the record in PO_LINE_LOCATIONS_INTERFACE
But the second new record in PO_DISTRIBUTIONS_INTERFACE has INTERFACE_LINE_LOCATION_ID that does match the record in PO_LINE_LOCATIONS_INTERFACE
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms