ORA-00942 on FSI_D_DERIVATIVES in Log Running ALM Process (Doc ID 1340919.1)

Last updated on AUGUST 07, 2011

Applies to:

Oracle Financial Services Asset Liability Management - Version: 5.5 and later   [Release: 5 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Asset Liability Management (ALM) 5.5 or higher, when you run an ALM process that includes all instrument tables, ORA-00942 errors like the following appear in the ofsrm log file in $FIC_DB_HOME/logs/FusionApps:

FROM fsi_d_derivatives, FSI_D_CAPFLOORS
WHERE fsi_d_derivatives.id_number = FSI_D_CAPFLOORS.id_number
AND fsi_d_derivatives.identity_code =
FSI_D_CAPFLOORS.identity_code
AND fsi_d_derivatives.LEG_TYPE = 1


Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [10] -
CREATE VIEW Oracle Error: ORA- 00942: table
or view does not exist Driver Function: drv_oci::Execute()

and


Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [0] - SQL function not found! Oracle Error:
ORA- 00942: table
or view does not exist Driver Function: drv_oci::Execute() SQL
Statement:
select distinct a.PRODUCT_ID, a.ISO_CURRENCY_CD, a.LEG_TYPE
from alm_242_v_23_R a
where AS_OF_DATE = TO_DATE('05/ 31/ 2011', 'MM/ DD/ YYYY')
order by a.PRODUCT_ID, a.ISO_CURRENCY_CD, a.LEG_TYPE

As a result, you get no rows in the Result Detail table.

Steps to Reproduce:
  1. Go to Asset Liability Management
  2. Go to ALM Processing > Static Process > Static Deterministic
  3. Create and run an ALM Process that selects all tables in the Source

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