ORA-00911: invalid character Error When Running Allocation With Multiple Columns Expression (Doc ID 1391583.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Financial Services Profitability Management - Version: 5.6 and later    [Release: 5 and later]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x
OFSPM

Symptoms

In Oracle Financial Services Profitability Management (PFT) 5.6, when running an allocation based on expression build of multiple columns, the generated allocation SQL is incorrect. The result is that the allocation fails and the following error can be found in the allocation log file:

ERROR
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [0] - SQL function not found! Oracle Error:
ORA- 00911: invalid character Driver Function: drv_oci::Execute()
SQL Statement:

STEPS
1. Build an expression with columns that start with the same name (i.e. INCENTIVE_CHG_CRED and
INCENTIVE_CHG_CRED_BV)
2. Create an allocation based on the previous expression
3. Run the allocation

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