Getting ORA-01722 on Detail Client Data Loader Sub-Request (Doc ID 550202.1)

Last updated on MAY 07, 2010

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10 to 11.5.10.2 - Release: 11.5 to 11.5
Information in this document applies to any platform.
Checked for relevance on 7-May-2010.

Symptoms

In Enterprise Performance Foundation Administration or Profitability Manager, when trying to load data into a user defined table using the Detail Client Data Loader program, the program fails and no records are loaded.  The View Log of the main Detail Client Data Loader request does not contain an error but one of the sub-requests does contain the following error:

An unexpected error has occurred: ORA-01722: invalid number. Please contact your System Administrator.

Parent request 3780403
Sub-request 3780404 : Engine program aborted before completing

The table being loaded contains user defined columns.  Some of the user defined columns have a "CPM Data Type" of "Dimension" in the Table Registration wizard (Administration > Registration > Tables and Columns).

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