AR_RECEIPT_API_PUB.APPLY: Functional Currency Remains Unchage After The Org Context Is Changed (Doc ID 1377905.1)

Last updated on NOVEMBER 22, 2011

Applies to:

Oracle Receivables - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms

Attempting to apply a Receipt using AR_RECEIPT_API_PUB.APPLY and the ORG Context is changed, but the Functional Currency Remains Unchanged.

Details:

ARP_PROCESS_APPLICATION PROCEDURE RECEIPT_APPLICATION calls

arp_ps_util.update_invoice_related_columns |
and arp_ps_util.update_cm_related_columns

which calls

arp_util.calc_acctd_amount

which calls this to get the functional currency:

lc_currency_code := NVL(p_currency, arpcurr.FunctionalCurrency);

arpcurr.FunctionalCurrency is set by an initial call to arpcurr.init

But arpcurr.init does not get re-initialized when there is an org context change.

If the receipt is loaded using the CZ operating unit, which has a functional currency of CZK, then arpcurr.FunctionalCurrency is set to CZK

If a UK receipt is loaded in GBP after doing as many possible ways to change the org context, arpcurr.FunctionalCurrency remains at CZK. When the receipt is called after the ORG context change, the functional currency remains at CZK.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms