PC_POADJUST create CRV with incorrect Currency on Foreign Currency Voucher (Doc ID 1341102.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Goal

When a multi-currency requisition or a purchase order is created, PC_PO_TO_PC creates a corresponding REQ or COM row in the PS_PROJ_RESOURCE table that has both the transaction and base currencies. However, if PC_POADJUST creates a reversal row (RRV or CRV for REQ and COM respectively), only the base currency is present on PS_PROJ_RESOURCE. The original transaction currency is not stored in the RRV or CRV rows.

ACTUAL BEHAVIOR
---------------
PC_POADJUST created CRV or RRV with incorrect FOREIGN_CURRENCY when PO/REQ is created in different currency.

EXPECTED BEHAVIOR
-----------------------
CRV/RRV should be created using AUD

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. creating a PO for AUD (in a GLBU with USD as Base Currency)
2. Run PC_PO_TO_PC --> a COM is generated for AUD.
3. Creating invoice in AUD
4. Run PC_AP_TO_PC --> an ACT is generated for AUD
5. Run PC_POADJUST --> A CRV is generated in USD (not AUD).

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot correctly report the Commitment reversal

Solution

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