ORA-00904: "USER_GENERATED": invalid identifier Errors Running Command Line (Offline) Migration For PFT Objects

(Doc ID 2275040.1)

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