Getting ORA-01722 on Detail Client Data Loader Sub-Request
Last updated on MAY 07, 2010
Applies to:Oracle Enterprise Performance Foundation - Version: 11.5.10 to 22.214.171.124 - Release: 11.5 to 11.5
Information in this document applies to any platform.
Checked for relevance on 7-May-2010.
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).
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