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)

Symptoms

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:
drv_oci::Execute()

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

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

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


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