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)

Symptoms

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:

N_BUCKET_NUMBER_CATEGORY
N_BUCKET_NUMBER_SUB_CATEGORY
V_BUCKET_NAME_CATEGORY

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

Executable: scd,3
Wait: N
Batch Parameter: Y

4. Save
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.

Cause

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