Instrument Table Allocation With Expression Data Filter Fails With "ORA- 00936: missing expression Driver Function" Errors (Doc ID 2194233.1)

Last updated on NOVEMBER 03, 2016

Applies to:

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

Symptoms

On PFT 8.0, while running a select data filter that includes an expression allocation name, for example like 0.04 and output to instrument table, the allocation fails with error message as below:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] -
oexec(),oexn() SQL Function: [0] - SQL function not found! Oracle Error:
ORA- 00936: missing expression Driver Function:
drv_oci::Execute() SQL Statement: MERGE INTO FSI_D_LOAN_CONTRACTS
TARGET USING (
SELECT IDENTITY_CODE, ID_NUMBER, NVL(GOV_FLG, 0) + 2
TARGET_AMOUNT
from FSI_D_LOAN_CONTRACTS a
where (((a.GL_ACCOUNT_ID = 13563)
or (a.GL_ACCOUNT_ID = 13561)

...

AND TARGET.TRANSFER_RATE>=[0.04.PFTSEG]

 

...

After changing the expression allocation name into A004 for example, the error still same like below:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] -
oexec(),oexn() SQL Function: [0] - SQL function not found! Oracle Error:
ORA- 00936: missing expression Driver Function:
drv_oci::Execute() SQL Statement: MERGE INTO FSI_D_LOAN_CONTRACTS
TARGET USING (
SELECT IDENTITY_CODE, ID_NUMBER, NVL(GOV_FLG, 0) + 2
TARGET_AMOUNT
from FSI_D_LOAN_CONTRACTS a
where (((a.GL_ACCOUNT_ID = 13563)
or (a.GL_ACCOUNT_ID = 13561)

...

AND TARGET.TRANSFER_RATE>=[A004.PFTSEG]

...

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