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
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

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
  Symptoms
  Cause
  Solution
  References

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