My Oracle Support Banner

Import Purchase Order Program Is S Not Populating Correct Amount on Line When There Is Multiple Distributions on a Shipment (Doc ID 2425832.1)

Last updated on FEBRUARY 19, 2019

Applies to:

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


On : 12.2.7 version, Purchasing Processes

PDOI is not populating correct amount on line when there is more than one shipment, each shipment having one distribution and one of the distributions has the req_distribution_id populated, the other distribution does not.

Example :

The interface lines table has an amount of $16. There are 2 shipments under that line, one in the amount of $7 and the other $9.

Each shipment has one distribution. One distribution in the amount of $7 and one distribution in the amount of $9. The first distribution has the req_distribution_id filled in, the second distribution which is under the second shipment does not have req_distribution_id filled in.

When it is imported. the line amount says $7, but each shipment and distribution has the correct amounts of $7 and $9.

If the scenario is repeated without filling in the req_distribtuon_id on the one shipment it works correctly populating the line amount for $16.

PO amount on line should match the sum of amounts on the shipments under that line

1. Populate data in interface table
2. Run import standard purchase order program



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.