ORA-00904: "USER_GENERATED": invalid identifier Errors Running Command Line (Offline) Migration For PFT Objects
Last updated on JUNE 08, 2017
Applies to: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)
Oracle Financial Services Profitability Management (PFT)
On OFSAA 8.0.4, there appears to be an issue in Command Line (Offline) Migration for PFT Objects. When trying to export PFT Object(Allocation Rule) through Command Line Utility where platform is 8.0.4 and PFT is 8.0.4 and the export is generating the .DMP file, the export is failed with following message in the FUSIONSUBSYSTEMSService.log and offline_migration.log:
Only one object is selected for migration and the same is failing.
[FUSIONSUBSYSTEMS] May 2,17 02:19:14 : [DBUTIL]Migration Completed With Errors.Number Of Objects Failed to Migrate is ...1
Also, there is another error in the offline_migration.log in the webserver context path.
[02-05-17 02:19:15 AM] ~ INFO ~ MIGRATION ~ Export-->Query::: SELECT COLUMN_NAME,DATA_TYPE FROM USER_TAB_COLS WHERE upper(TABLE_NAME)=upper(?) AND VIRTUAL_COLUMN='NO' and USER_GENERATED='YES' order by column_name
[02-05-17 02:19:15 AM] ~ ERROR ~ MIGRATION ~ Error in creating xml for table_name::ORA-00904: "USER_GENERATED": invalid identifier
java.sql.SQLSyntaxErrorException: ORA-00904: "USER_GENERATED": invalid identifier
The issue can be reproduced at will with the following steps:
1. Attempt to use offline object migration for single object.
2. Check logs
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