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

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.

Symptoms

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

Cause

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