My Oracle Support Banner

'ORA-00904: "STOP_AT_HOLIDAY_CAL_FLG": Invalid Identifier' Error Defining ALM 8.0 Process (Doc ID 1991468.1)

Last updated on MARCH 08, 2019

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) 8.0


In Oracle Financial Services Asset Liability Management (ALM) 8.0, in an environment where Liquidity Risk Management (LRM) 8.0 is also installed, you get the following ORA-00904 error when going to the ALM Processing screen:

java.sql.BatchUpdateException: error occurred during batching: ORA-00904:
"STOP_AT_HOLIDAY_CAL_FLG": invalid identifier

See picture below:

As a result, you cannot create an ALM process.

Steps to Reproduce:

  1. Go to Asset Liability Management
  2. Go to ALM Processing
  3. Go to Static Process > Deterministic

The ORA-00904 error appears.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.