My Oracle Support Banner

Allocation Using Lookup Table Driver Fails with 'ORA-01722: Invalid Number' (Doc ID 1987424.1)

Last updated on MARCH 09, 2015

Applies to:

Oracle Financial Services Profitability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)


In Oracle Financial Services Profitability Management (PFT), an Allocation using a Lookup Table fails with the following ORA-01722 error in the ofspa log from $FIC_DB_HOME/log/FusionApps:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [189] - SQL function not found! Oracle
Error: ORA- 01722: invalid number Driver Function:

Module Logging OFS errors: (908001) Fatal error during processing.

As result of the error, the Allocation fails and outputs no results.


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.