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 JULY 23, 2018

Applies to:

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

Symptoms

On : 12.2.7 version, Purchasing Processes

ACTUAL BEHAVIOR
---------------
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.


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


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

 

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.