Error: ORA- 00904: "A"."ISO_CURRENCY_CD": Invalid Identifier Driver Function While Running Allocation (Doc ID 2207330.1)

Last updated on JANUARY 20, 2017

Applies to:

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

Symptoms

On PFT 6.1.1.1, after upgrade / migration to 6.1.1.1, working allocation in 6.1.0.3, a percent distribution (% dist) dynamic driver allocation ledger * instrument allocation is failing with errors:

ERROR

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: "A"."ISO_CURRENCY_CD": invalid identifier
Driver Function: drv_oci::Execute()


Module Logging OFS errors: (908001) Fatal error during processing the following Allocation merge statement:

Module Logging OFS Access module data: MERGE INTO CIB_D_ALL_TRANSACTIONS TARGET USING (SELECT SUM
(IVW_SOURCE.IVW_TARGET_AMOUNT) TARGET_AMOUNT, CHANNEL_ID,
COMMON_COA_ID, CUSTOMER_ID, CUS_ID, GL_ACCOUNT_ID, IDENTITY_CODE,
ID_NUMBER, LOB_ID, OFFICER_ID, ORG_UNIT_ID, PRODUCT_ID, TRANS_ID
FROM (SELECT (Src.SOURCE_AMOUNT * Drv.drv_factor)
IVW_TARGET_AMOUNT, Drv.CHANNEL_ID, Drv.COMMON_COA_ID,
Drv.CUSTOMER_ID, Drv.CUS_ID, Drv.GL_ACCOUNT_ID,
Drv.IDENTITY_CODE, Drv.ID_NUMBER, Drv.LOB_ID, Drv.OFFICER_ID,
Drv.ORG_UNIT_ID, Drv.PRODUCT_ID, Drv.TRANS_ID
FROM (SELECT ( (DECODE(a.year_s, 2016, a.month_04, 0) ) )
SOURCE_AMOUNT , PRODUCT_ID, TRANS_ID
from LEDGER_STAT a
where a.FINANCIAL_ELEM_ID=8800002
and a.GL_ACCOUNT_ID=4200
and a.COST_CENTER_ID IN (SELECT leaf_node
FROM OFSA_IDT_ROLLUP
WHERE OFSA_IDT_ROLLUP.sys_id_num = 225022
and (OFSA_IDT_ROLLUP.LEAF_NODE IN (
select REV_HIERARCHY_FILTER.LEAF_NODE
from REV_HIERARCHY_FILTER
where REV_HIERARCHY_FILTER.sys_id_num = 280520 ) ))
and (a.identity_code) IN (select distinct a.parent_identity_code
from FSI_M_DATA_IDENTITY_DETAIL a
where a.identity_code in (71593)
and a.as_of_date = '04/ 30/ 2016'
and a.src_drv_type = 'S' )
and a.year_s IN (2016)
and a.CONSOLIDATION_CD = 100 ) Src JOIN (SELECT ( ColVal / mTotal
) drv_factor , a.PRODUCT_ID, a.TRANS_ID , a.CHANNEL_ID,
a.ORG_UNIT_ID, a.GL_ACCOUNT_ID, a.COMMON_COA_ID, a.CUSTOMER_ID,
a.LOB_ID, a.OFFICER_ID, a.CUS_ID, a.ISO_CURRENCY_CD, <<== Failing here
IDENTITY_CODE, ID_NUMBER
from (SELECT a.IDENTITY_CODE, a.ID_NUMBER, ( VOLUME ) ColVal,
(SUM (VOLUME) over( PARTITION BY a.PRODUCT_ID, a.TRANS_ID ))
mTotal, a.PRODUCT_ID, a.TRANS_ID , a.CHANNEL_ID, a.ORG_UNIT_ID,
a.GL_ACCOUNT_ID, a.COMMON_COA_ID, a.CUSTOMER_ID, a.LOB_ID,
a.OFFICER_ID, a.CUS_ID, a.ISO_CURRENCY_CD
from CIB_D_ALL_TRANSACTIONS a
where a.LOB_ID IN (SELECT leaf_node
FROM OFSA_IDT_ROLLUP

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