ORA-00904: "V_BUCKET_NAME_SUB_CATEGORY": Invalid Identifier Running SCD for DIM_RESULT_BUCKET
Last updated on AUGUST 04, 2012
Applies to:Oracle Financial Services Asset LiabilityManagement Analytics - Version 5.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
For an Oracle Financial Services Asset Liability Management Analytics (ALMBI) 5.6 implementation, when you run the SCD process to populate the DIM_RESULT_BUCKET table, the table is not populated with any records and you get the following error in the SCD log located in /<ftpshare>/<Infodom>/logs:
Error Msg :-> ORA-00904: "V_BUCKET_NAME_SUB_CATEGORY": invalid identifier
You may see the same error for the following columns as well:
The error prevents the SCD process from inserting rows into DIM_RESULT_BUCKET.
Steps to Reproduce:
1. Go to Operations > Batch Maintenance
2. Create a new Batch
3. Create a new Task in the batch with the following:
Components = RUN EXECUTABLE
Batch Parameter: Y
5. Go to Batch Execution and run the batch
The DIM_RESULT_BUCKET table is not populated and the error exists in the SCD log.
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