ORA-01722: Invalid Number Error During Offline Migration Import

(Doc ID 2334450.1)

Last updated on DECEMBER 11, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - 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 Profitability Management - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 8.0.4 version

When attempting to run offline migration import for Funds Transfer Pricing rules, the following error occurs.


Import Error:
[FUSIONSUBSYSTEMS] Nov 16,17 22:18:05 : [HIERARCHYMIGRATIONSERVICE]Exception occurred while trying to get Migration Hierarchy.com.ofs.reveleus.migration.util.MigrationException: error occurred during batching: ORA-01722: invalid number


Steps to Replicate:
1. Export funds transfer pricing rules succesfully.
2. Import transfer pricing rule and received the above error in FUSIONSUBSYSTEMSService.log web server directory.


Changes

 

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