My Oracle Support Banner

The Price of the Requisition Item is Updated When the Ship To is Updated on the Fluid Requisition Page (Doc ID 3063032.1)

Last updated on DECEMBER 10, 2024

Applies to:

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

Symptoms


The price of the requisition item is updated when the Ship To is updated on the Fluid Requisition page.

Note: In the Replication Steps, User Details / Company Names / Addresses / Emails / Telephone Numbers / Etc. are fictitious (based upon made-up data used in the Oracle DEMO Environments), any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


The issue can be reproduced at will with the following steps:
1. Navigate : Procurement Contracts > Add/Update contract
     Create a contract for Supplier ID : 0000000044
     Enter Maximum Amount 20000000
     Check Allow Open Item Reference
     Check Can be Changed on Order
     Save (POC0094)
2. Navigate : Setup Financials/Supply Chain > Common Definitions > User Preferences > Define User Preferences > VP1 > Procurement
     Ship To Location : AUS01
     Requester : ABROWN
     Save
3. Navigate : Setup Financials/Supply Chain > Product Related > Procurement Options > Purchasing > Requester > ABROWN
     Ship To : AUS01
     Save
4. Navigate : eProcurement > Create Requisition
     Add special request item
     Price : 2500
     Go to Checkout page
     Click Schedule Details
     Do not make any changes to chart fields
     Click line details
     Check amount only
     Click Yes for the message “The quantity will be set to 1 for an amount only line. The system will reprice the line. Continue ?”
     Select Contract ID
     Click Done
     Click Save
     Click ok for the message “Both Supplier and Supplier Location are required if not Override Suggested Supplier.”
     Go to line details
     Enter Supplier Location
     Click Save
     Click Submit
     Click Pre-check budget
     Click Yes for the message
5. Run Query
     SELECT A.PRICE_INITIAL, A.MERCHANDISE_AMT FROM PS_REQ_LINE A WHERE ( A.BUSINESS_UNIT = 'US001'  AND A.REQ_ID = '0000000185')
          PRICE_INITIAL : 2500
           MERCHANDISE_AMT  : 2500
6. Edit this requisition
     Change the price from 2500 to 4000
     Click Save
7. Run query
     SELECT A.PRICE_INITIAL, A.MERCHANDISE_AMT FROM PS_REQ_LINE A WHERE ( A.BUSINESS_UNIT = 'US001' AND A.REQ_ID = '0000000185')
          PRICE_INITIAL : 2500
           MERCHANDISE_AMT  : 4000
8. Click Submit
     Click Pre-Check Budget
9. Edit this requisition and go to schedule details page
     Update Ship To value from AUS01 to CHE01.
Issue : The Price value was reverted to original price (2500).

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.