Error 'ORA-00904: "ISO_CURRENCY_CD": invalid identifier Driver' Running Lookup / Static Table Driver Allocation (Doc ID 2592757.1)

Last updated on MARCH 18, 2021

Applies to:

Symptoms

In Oracle Financial Services Profitability Management (PFT) 8.0.7, when attempting to run a Lookup Table Driver or Static Table Allocation that has "Aggregate to Ledger" = Yes in the Debit or Credit screen, the following error occurs in the Allocation Engine log output to /<ftpshare>/logs/<AsofDate>/<Infodom>:

Module Logging OFS Access module data: MERGE INTO FSI_D_LOAN_CONTRACTS TARGET USING (
SELECT *
FROM (
SELECT (SOURCE_AMOUNT * 1)TARGET_AMOUNT, SRC_IOVW.*
FROM (
SELECT SUM(IVWSRC_AMOUNT) SOURCE_AMOUNT, IDENTITY_CODE,
ID_NUMBER, ISO_CURRENCY_CD
FROM (
SELECT m.IDENTITY_CODE, m.ID_NUMBER, (SUM(NVL(AVG_BOOK_BAL, 0) *
NVL(pg1lkup2, 0)) ) IVWSRC_AMOUNT
FROM (
SELECT lkp.N_FACTOR1 pg1lkup2, g.*
FROM (
SELECT mv.ACCIDENT_HEALTH_PREMIUM, mv.ACCID_HEALTH_INS_CO_CD,
mv.ACCOUNT_CLASSIFICATION_CD, mv.ACCOUNT_CLOSE_DATE,
mv.ACCOUNT_CONTRIB, mv.ACCOUNT_CONTRIB_AFTER_TAX,
mv.ACCOUNT_GROUP_CD, mv.ACCOUNT_NUMBER, mv.ACCOUNT_OFFICER_CD,
mv.ACCRUAL_BASIS_CD, mv.ACCRUED_GROSS_AMT, mv.ACCRUED_INTEREST,
mv.ACCRUED_TRANSFER_AMT, mv.ACC_HEALTH_INS_FLG,
mv.ACTUAL_ACCOUNT_NUMBER, mv.ADJUSTABLE_TYPE_CD,
mv.ADJ_EFFECTIVE_DATE, mv.AFTER_PAYMENT_BALANCE,
mv.ALLOCATED_EQUITY, mv.ALLOC_LLR, mv.ALLOC_LLR_CR,
mv.ALL_IN_TP_RATE, mv.AMENABILITY_CAT_CD,
mv.AMORT_DISC_PREM_CHG_CR, mv.AMORT_METH_PDFC_CD, mv.AMRT_TERM,
mv.AMRT_TERM_MULT, mv.AMRT_TYPE_CD, mv.AS_OF_DATE, mv.ATM_EXP,
mv.AUTOPAY_ACCT_NUMBER, mv.AUTOPAY_BANK_TRANSIT_NBR,
mv.AUTOPAY_FLG, mv.AUTOPAY_INSTR_TYPE_CD, mv.AVERAGE_LIFE_C,
DECODE(mv.ISO_CURRENCY_CD, 'AED', mv.AVG_BOOK_BAL/ 3.673039996,
'AUD', mv.AVG_BOOK_BAL/ 1.419144256, 'BBD', mv.AVG_BOOK_BAL/ 2,
.
.
.
mv.TRANSFER_RATE, mv.TRANSFER_RATE_ALT, mv.TRAN_RATE_REM_TERM,
mv.TRAN_RATE_REM_TERM_ALT, mv.T_RATE_INT_RATE_CD, mv.UNDRAWN_AMT,
mv.VIP_ACCOUNT_FLG, mv.WAIVED_FEES
FROM FSI_D_LOAN_CONTRACTS mv) g, LOOKUP_FACTOR lkp
WHERE g.PRODUCT_ID = lkp.N_PRODUCT_ID) m
WHERE m.AS_OF_DATE = '04/ 30/ 2019'
GROUP BY m.IDENTITY_CODE, m.ID_NUMBER )IVW_SOURCE
WHERE IVWSRC_AMOUNT <> 0
GROUP BY IDENTITY_CODE, ID_NUMBER, ISO_CURRENCY_CD) SRC_IOVW
WHERE SOURCE_AMOUNT IS NOT NULL
AND round(SOURCE_AMOUNT, 6) <> 0 )
WHERE TARGET_AMOUNT <> 0) SOURCE ON (TARGET.AS_OF_DATE = '4/ 30/
2019'
AND TARGET.IDENTITY_CODE = SOURCE.IDENTITY_CODE
AND TARGET.ID_NUMBER = SOURCE.ID_NUMBER) WHEN MATCHED THEN
UPDATE
SET IDENTITY_CODE_CHG = 388993517, TARGET.MNT_FDIC_CHARGE =
(DECODE(ISO_CURRENCY_CD, 'AED', 3.673039996, 'AUD', 1.419144256,
'BBD', 2, 'BEF', 32.193400437, 'BHD', 2.652308835, 'BSD', 1,
'BWP', 6.640106242, 'BZD', 1.975, 'CAD', 1.34145, 'CHF', 1.01905,
.
.
.
31.910500492, 'TND', 1.619889999, 'TTD', 6.748500013, 'TWD',
29.50799984, 'TZS', 1065.69021025, 'USD', 1, 'ZAR', 14.331399922,
'USD', 1, 1)* SOURCE.TARGET_AMOUNT)

Module Logging OFS errors: (203105) Oracle drv_oci error:
OCI Function: [4] - oexec(), oexn()
SQL Function: [189] - SQL function not found!
Oracle Error: ORA- 00904: "ISO_CURRENCY_CD": invalid identifier Driver
Function: drv_oci::Execute() 

As a result of this error, the Allocation fails to output results.

Cause

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