Ledger Stat Allocation Converts Original Currency to Functional Currency When "Same As Source" Selected in Debit/Credit (Doc ID 2086227.1)

Last updated on DECEMBER 09, 2015

Applies to:

Oracle Financial Services Profitability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT), when you run a Ledger Stat Allocation against multiple currencies, the original, non-functional currency balances are getting converted into functional currency balances when you have "Same As Source" selected for Currency in the Debit and/or Credit screen.  You expect the Allocation to output balances in the original source currency in this case.

If you check the SQL output to the ofspa.xxxxx.log in $FIC_DB_HOME/log/FusionApps, you can see the values are converted to the functional currency during the insert into the Global Temporary Table (GTT):

CREATE GLOBAL TEMPORARY TABLE GLBL17619TMP ON COMMIT PRESERVE
ROWS AS
SELECT *
FROM (
SELECT vm.ACCUM_TYPE_CD, vm.ALT_GL_ACCOUNT_ID,
vm.BALANCE_TYPE_CD, vm.BANK_IND_ID, vm.BUSINESS_PROD_ID,
vm.COMMON_COA_ID, vm.CONSOLIDATION_CD, vm.CURRENCY_TYPE_CD,
vm.FINANCIAL_ELEM_ID, vm.GL_ACCOUNT_ID, vm.ISO_CURRENCY_CD,
vm.IDENTITY_CODE, vm.LEGAL_ENTITY_ID, vm.MONTH_01, vm.MONTH_02,
vm.MONTH_03, vm.MONTH_04, vm.MONTH_05, vm.MONTH_06, DECODE
(YEAR_S, 2015, DECODE (vm.ISO_CURRENCY_CD, 'IDR', vm.MONTH_07 /
0.000081994, vm.MONTH_07) , vm.MONTH_07) MONTH_07


But the balances are not converted back into the original source currency by the Merge into statement:

MERGE INTO LEDGER_STAT TARGET USING (SELECT *
FROM (SELECT SUM(src_amount * 1 * DECODE (ISO_CURRENCY_CD, 'USD',
1/ 1.0, 'IDR', 1, 1) ) BALANCE_AMOUNT,
 

You expect the non-functional currencies to be output in their source currency and not the functional currency.

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