Requisition Line Base Currency (REQ_LINE.CURRENCY_CD_BASE) is Not Populating Correctly in Requisition Line (Doc ID 2829861.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Requisition Line Base Currency (REQ_LINE.CURRENCY_CD_BASE) is Not Populating Correctly in Requisition Line

Steps to reproduce the issue:

1) Navigate to Classic eProcurement > Requisition
2) click on Requisition settings
3) Change Requester as XXXX and currency as CAD. Get the message:

"Changing Requester will change the default settings "

Click Yes to the message above.

4) Click on Fixed Cost Service and Add a service with Supplier ID: AUS0000009 and click Add to Cart
5) Go to checkout page and click on Save and submit
6) Now query CURRENCY_CD, CURRENCY_CD_BASE FROM REQ_HDR, REQ_LINE, REQ_LINE_SHIP, REQ_LN_DISTRIB tables respectively

REQ_HDR shows CURRENCY_CD as CAD and CURRENCY_CD_BASE as CAD which comes from Purchasing BU definition page correctly.
REQ_LINE shows CURRENCY_CD as CAD and CURRENCY_CD_BASE as USD which is incorrect
REQ_LN_SHIP shows CURRENCY_CD as CAD and CURRENCY_CD_BASE as CAD which comes from Purchasing BU definition page correctly.
REQ_LN_DISTRIB shows CURRENCY_CD as CAD and CURRENCY_CD_BASE as USD which is correct and coming from GL BU base currency. The Distributions are always driven based on GL BU and ths value should be always derived form GL BU Base currency.

Expected Behavior:  REQ_LINE.CURRENCY_CD_BASE value should be defaulted correctly like REQ_HDR and REQ_LINE_SHIP tables.

Changes

Cause

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