Import Purchase Orders Process Inserts Extra Record in PO_DISTRIBUTIONS_INTERFACE (Doc ID 1932570.1)

Last updated on DECEMBER 08, 2014

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Populating the following  interface tables
 PO_HEADERS_INTERFACE ,
 PO_LINES_INTERFACE,
 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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms