My Oracle Support Banner

Hierarchy Migration Import Fails with 'ORA-01722: invalid number' Error (Doc ID 2468958.1)

Last updated on FEBRUARY 12, 2021

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.4 and later
Oracle Financial Services Asset Liability Management - Version 8.0.4 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.4 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT), Funds Transfer Pricing (FTP), or Asset Liability Management (ALM) 8.0.4+, when attempting to migrate objects, the command line / offline migration fails during the 'import' and the following error appears in the web server's FUSIONSUBSYSTEMSService.log:

[FUSIONSUBSYSTEMS] Oct 24,18 11:01:19 : [MIGRATIONCOMMONSERVICE]Query being added to batch:INSERT INTO rev_hierarchies (hierarchy_id, dimension_id, hierarchy_type_code, multi_top_flag, hierarchy_usage_code, automatic_inheritance, show_member_code, init_display_level, orphan_branch, display_signage, created_by, creation_date, last_modified_by, last_modified_date) VALUES (5011347, 6, 'Open', 'N', 'STANDARD', 'N', 'N', 'null', 'N', 'N', 'USER1', SYSDATE, 'USER1', SYSDATE)
.
.
.
[FUSIONSUBSYSTEMS] Oct 24,18 11:01:19 : [MIGRATIONCOMMONSERVICE]Before Executing Batch:
[FUSIONSUBSYSTEMS] Oct 24,18 11:01:19 : [MIGRATIONCOMMONSERVICE]Exception occurred while executing the query:
[FUSIONSUBSYSTEMS] Oct 24,18 11:01:19 : [MIGRATIONCOMMONSERVICE]
java.sql.BatchUpdateException: error occurred during batching: ORA-01722: invalid number

       at oracle.jdbc.driver.OracleStatement.executeBatch(OracleStatement.java:5031)
       at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246)
       at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecuteBatch(WSJdbcStatement.java:1658)
       at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeBatch(WSJdbcStatement.java:843)
       at com.ofs.reveleus.migration.impl.MigrationCommonService.executeQueryList(MigrationCommonService.java:1286)
       at com.ofs.reveleus.migration.impl.HierarchyMigrationService.importHierarchy(HierarchyMigrationService.java:945)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
       etc.


The import fails as a result of the error.

Changes

 

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