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.
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.
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!