PO Contract with Multiple Distribution Line Generate Wrong MONETARY_AMOUNT on PS_PO_LINE_DISTRIB
Last updated on JULY 05, 2017
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.
When a PO/Contract is entered with multiple distribution the po's generated from this contract are created with same distribution line but the MONETARY_AMOUNT is calculated incorrectly.
The issue can be replicated with the following steps:
1- Create Contract with process option <Recurring PO Voucher>
2-Create line for 1000$ with a split distribution 50/50
3-Approve Contract and save
4-Run tree processes to generate related PO for this contract
5-Access PO generated
6-Access distribution for line 1
You can see 50% for each distribution and merchandise amount of 500$ for each distribution. This is OK
7-Run SQL to PS_PO_LINE_DISTRIB to browse distribution line and you can see that the MONETARY_AMOUNT as a wrong value.
It should be at 500$ like the MERCHANDISE_AMOUNT but we have 250$ and this is not ok.
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