My Oracle Support Banner

Fluid Requisition: Amount Changing on Requisition Distribution Page When Dividing 1 Requisition Line Into Multiple Distribution Lines (Doc ID 2825457.1)

Last updated on JUNE 13, 2022

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Fluid Requisition: Amount changing on requisition distribution page when dividing 1 requisition line into multiple distribution lines.

When splitting an amount based requisition distribution line into multiple distribution lines, the amounts on the data tables are different from the amounts inserted on the requisition distribution page.

Also, distribution lines were affected after save requisition creating discrepancies between merchandise amount and open amount.

The issue can be reproduced at will with the following steps:

1. Create Fluid Requisition. Navigation: Go to Create Requisition Tile
2. Add Special Requests item. Enter with exactly price $613538.00
3. Go to Checkout. Add Shipto and Go to Distribution line
4. Change Requisition distribute by ‘Amt’ and add more 7 lines
5. Enter with the exactly the same merchandise amount showing in the page. Done
6. The system returned to Schedule line. Go back to Distribution line
7. Line 8 merchandise amount was updated with the total line merchandise amount. That is wrong
8. Save Requisition
9. Go back to Distribution page. Lines 2 and 4 have merchandise amount and open amount different. Line 6 changed from 271705.19 to 271705.39 (Added 0.20). Line 8 still showing total merchandise amount
10. Get query from REQ_LN_DISTRIB:
SELECT BUSINESS_UNIT, REQ_ID, DISTRIB_LINE_NUM, MERCHANDISE_AMT, MERCH_AMT_BSE, AMT_OPEN, AMT_OPEN_BSE, MONETARY_AMOUNT, MONETARY_AMT_BSE FROM PS_REQ_LN_DISTRIB WHERE BUSINESS_uNIT = 'XXXXX' AND REQ_ID = 'XXXXXXXXXX'

Queries results showing lines 2, 4 and 6 with merchandise amount and open amount different



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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.