My Oracle Support Banner

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


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:

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:

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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