Ledger Stat Allocation Converts Original Currency to Functional Currency When "Same As Source" Selected in Debit/Credit
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)
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms