ORA-01722: Invalid Number Error During Offline Migration Import
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)
On : 8.0.4 version
When attempting to run offline migration import for Funds Transfer Pricing rules, the following error occurs.
[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.
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