My Oracle Support Banner

Amount Only eProcurement Requisition Line Price Getting Reset Incorrectly With New PRICE_INITIAL (Doc ID 2812048.1)

Last updated on OCTOBER 11, 2021

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

In the below examples, the PRICE_INITIAL in an Amount Only ePro Requisition is erroneously overriding other price fields.

There are two issues identified where the PeopleCode was incorrect or missed.
1) Changing the Price on an Amount Only requisition (in Test Scenarios A & B below):
2) Copying a Requisition into a New requisition then changing the Requisition to an Amount Only (in Test Scenario C below)

REPLICATION STEPS:

[A] ISSUE: PRICE_INITIAL erroneously overrides PRICE_REQ when editing a Req by changing to Amt Only and updating Contract for Req Line which changes the Price
a) ePro > Requisition, click on Special Request, add a new req for Qty 1, Price 500, click Add to Cart, then click Checkout
b) on Edit Requisition page, click on Line Details icon; on Line Details page, check Amount Only checkbox, click OK
c) on Edit Requisition page, change Price to 750, then click Save for Later
d) when query REQ_LINE see that PRICE_INITIAL 500, PRICE_REQ 750
e) on Edit Requisition page, click on Line Details icon; on Line Details page, select in a Contract and Contract Line No, click OK
f) on Edit Requisition page, see that Price erroneously changed back to 500 (retrieved from PRICE_INITIAL)

[B] ISSUE: PRICE_INITIAL erroneously overrides PRICE_REQ when editing a Req by changing to Amt Only then changing the Price
a) ePro > Requisition, click on Special Request, add a new req for Qty 1, Price 100, click Add to Cart, then click Checkout
b) on Edit Requisition page, click on Line Details icon; on Line Details page, check Amount Only checkbox, click OK
c) on Edit Requisition page, change Price to 200, then click Save for Later
d) when query REQ_LINE see that PRICE_INITIAL 100, PRICE_REQ 200
e) on Edit Requisition page, click on Line Details icon; on Line Details page, "un"check Amount Only checkbox, click OK
f) on Edit Requisition page, see Price 200, click Save for Later
g) on Edit Requisition page, click on Line Details icon; on Line Details page, recheck Amount Only checkbox, click OK
h) on Edit Requisition page, see that Price is back to 100 (incorrect should be 200), click Save for Later
i) when query REQ_LINE see that PRICE_INITIAL 100, PRICE_REQ 100 (incorrect, should be 200)

[C] ISSUE: PRICE_INITIAL erroneously overrides PRICE_REQ  when copying a Req into a new Req then changing the Req to Amt Only
When you copy a Req into a new one, PRICE_INITIAL is not populated or is zero. Especially for existing data where site is going from PUM 29 to PUM 37 and this is a new change where PRICE_INITIAL is being populated. Site has over several hundred thousand Reqs in their system and users use them to copy to create a new one. If they do so, REQ_LINE.PRICE_INITIAL which is currently $0, is copied into the new Req and causes the Req Price to change to Zero if the req line is updated to Amt Only.

Replication Steps:
a) locate existing Req where PRICE_INITIAL = $0 in REQ_LINE
b) eProcurement > Manage Requisition > click on Edit Requisitions from Actions dropdown, retrieve above Req then do Action = Copy, click Go
c) get Checkout - Review & Submit page with entire Req
d) in req line 1 see Qty 3, Price $30, Total $90, then click on Line Details icon
e) on Line Details page, check Amt Only checkbox, then click OK
f) return to Checkout - Review & Submit page, see req line 1 now has Qty 1 (correct), Price $0 (incorrect. should be $30), Total blank (incorrect, should be $90)

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.