My Oracle Support Banner

PO Contract with Multiple Distribution Line Generate Wrong MONETARY_AMOUNT on PS_PO_LINE_DISTRIB (Doc ID 2283306.1)

Last updated on NOVEMBER 07, 2019

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.




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.