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