My Oracle Support Banner

Missing Columns ORA-00904 OPTION_RFR_IRC_CD and PURCHASE_SALE_LOGIC After Applying ALM 8.0.5.0.4 (Doc ID 2392361.1)

Last updated on JUNE 25, 2018

Applies to:

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

Symptoms

After upgrading to ALM 8.0.5.0.4 Patch 26945242 without merging the new ALM Data Model (.erwin file is missing from patch), the following errors appear in the debug log when running ALM :

ERROR

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [4] -
SELECT Oracle Error: ORA- 00904: "A"."PURCHASE_SALE_LOGIC":
invalid identifier Driver Function: drv_oci::Execute() SQL
Statement:
...
a.purchase_sale_logic, a.OPTION_VOL_IRC_CD, a.OPTION_RFR_IRC_CD
from FSI_D_LOAN_CONTRACTS a

AND

SELECT Oracle Error: ORA- 00904: "A"."OPTION_RFR_IRC_CD": invalid
identifier Driver Function: drv_oci::Execute() SQL Statement:
...
a.ACCRUED_TRANSFER_AMT, a.OPTION_VOL_IRC_CD, a.OPTION_RFR_IRC_CD
from FSI_D_FUTURES a
 

The issue can be reproduced at will with the following steps:
1. Upgrade to ALM 8.0.5.0.4
2. Run previously working ALM processes.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.