ORA-00904 on Dynamic Driver Allocation after Upgrade to 6.1.1.1 (Doc ID 2046159.1)

Last updated on SEPTEMBER 01, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.1.1 to 6.1.1.1 [Release 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When attempting to run an allocation on a transaction table the following error occurs:

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: "VOLUME_ID": invalid identifier Driver
Function: drv_oci::Execute() SQL Statement: MERGE INTO
SHARED_SERVICES_TRANS TARGET USING (SELECT SUM
(IVW_SOURCE.IVW_TARGET_AMOUNT) TARGET_AMOUNT, BANK_ID,
COST_TYPE_ID, GL_ACCOUNT_ID, IDENTITY_CODE, ID_NUMBER,
ORG_UNIT_ID, PRODUCT_1_ID, PRODUCT_3_ID, VOLUME_ID
FROM (SELECT (Src.SOURCE_AMOUNT * Drv.drv_factor)
IVW_TARGET_AMOUNT, Drv.IDENTITY_CODE, Drv.ID_NUMBER
FROM (SELECT ( SUM(NVL(VOLUME, 0) * 202069.47077 ) )
SOURCE_AMOUNT
from SHARED_SERVICES_TRANS a
where a.ORG_UNIT_ID IN (SELECT leaf_node
FROM OFSA_IDT_ROLLUP
WHERE (node_08=99998880000)
AND sys_id_num=175937)
and a.PRODUCT_1_ID=90000000
and a.VOLUME_ID=918720400
and a.COST_TYPE_ID=186231
and (((a.AS_OF_DATE = TO_DATE('01/ 31/ 2015', 'MM/ DD/ YYYY'))
or (a.AS_OF_DATE = TO_DATE('02/ 28/ 2015', 'MM/ DD/ YYYY'))

Changes

 Upgraded to 6.1.1.1.

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