Allocation Fails With 'OCI Error: 904 ORA- 00904: "M"."BANK_CD": invalid identifier' (Doc ID 3035714.1)

Last updated on AUGUST 21, 2024

Applies to:

Symptoms

When executing an Allocation that aggregates data from FSI_D_TERM_DEPOSITS_TXNS into FSI_D_MANAGEMENT_LEDGER, the Allocation fails and gets the following ORA-00904 in the log:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Error: 904 ORA- 00904:
    "M"."BANK_CD": invalid identifier SQL: MERGE INTO
    FSI_D_MANAGEMENT_LEDGER TARGET USING (
SELECT *
FROM (
SELECT (SOURCE_AMOUNT * 1)ENTERED_BALANCE, (FUN_AMT_V *
    1)FUNCTIONAL_BALANCE, SRC_IOVW.*
FROM (
SELECT SUM(IVWSRC_AMOUNT) SOURCE_AMOUNT, SUM(IVWSRC_AMOUNT *
    DECODE(ISO_CURRENCY_CD, 'AED', 1/ .08108919000008, 'AUD', 1/
    .0335555831457, 'CAD', 1/ .02963999999994, 'CHF', 1/
    .01905999999994, 'CNH', 1/ .15874000000544, 'CNY', 1/
    .1585200000098, 'DKK', 1/ .15199000000885, 'EUR', 1/
    .02037999999981, 'GBP', 1/ .01741571663932, 'HKD', 1/
    .17262511004851, 'INR', 1/ 1.83283999939868, 'JPY', 1/
    3.26188713218145, 'KES', 1/ 3.53380802976597, 'MGA', 1/
    99.24573243350536, 'MUR', 1/ 1, 'NOK', 1/ .23119999997706, 'NZD',
    1/ .03606996129693, 'RWF', 1/ 27.85794675789216, 'SAR', 1/
    .08278999999754, 'SCR', 1/ .29197932786359, 'SEK', 1/
    .22985000000952, 'SGD', 1/ .02956742852074, 'TZS', 1/
    56.07895917451772, 'UGX', 1/ 84.11843876177658, 'USD', 1/
    .0220782718895, 'XOF', 1/ 13.40040683635155, 'ZAR', 1/
    .4133256179218, 'MUR', 1, 1))FUN_AMT_V, ORG_UNIT_ID,
    LEGAL_ENTITY_ID
FROM (
SELECT SUM(NVL(VOLUME, 0))* 1 IVWSRC_AMOUNT, m.ORG_UNIT_ID,
m.LEGAL_ENTITY_ID, m.ISO_CURRENCY_CD
FROM FSI_D_TERM_DEPOSITS_TXNS m
WHERE m.AS_OF_DATE = '01/ 31/ 2024'
AND m.C_BANK_CODE IN ('200')
AND m.BANK_CD IN ('200')
etc.

As a result of this error, the Allocation fails.

Cause

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