ORA-00904: "V_BUCKET_NAME_SUB_CATEGORY": Invalid Identifier Running SCD for DIM_RESULT_BUCKET
(Doc ID 1478893.1)
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.
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