My Oracle Support Banner

OFS IFRS PACK V8.0.5.1.0 Installation Completed with Errors (Doc ID 2876769.1)

Last updated on JUNE 20, 2022

Applies to:

Oracle Financial Services Loan Loss Forecasting and Provisioning - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

LLFP v8.0.5.1.0 installation completed with below errors.

Filename = OFS_IFRS_patch_installation.log
See the following error:

[OFS_IFRS] [ INFO] - Executing file:/Apps/oracle/ofsaai/scripts/atomic/insert/fsi_llfp_ecl_scenarios.sql
[OFS_IFRS] [ERROR] - Query:'insert into fsi_llfp_ecl_scenarios(v_scenario_cd,n_scenario_id,n_probability_weight) values ('BASE',1,100)'
Error:ORA-00942: table or view does not exist

[OFS_IFRS] [ INFO] - Executing file:/Apps/oracle/ofsaai/scripts/atomic/create/ofs_llfp_atomic_create_805_1.sql
[OFS_IFRS] [ERROR] - Query:'CREATE OR REPLACE VIEW VW_IFRS_ACCOUNT_ORIG_RATINGS (V_ACCOUNT_NUMBER, N_RATING_SKEY) AS
select v_Account_number,
(case when v_component_value = 'ACCOUNT' then n_acct_rating_skey
when v_component_value = 'PARTY' then n_party_rating_skey
else n_sovereign_rating_skey end) n_rating_skey
from fsi_ifrs_acct_orig_ratings,setup_master where setup_master.v_component_code='LLFP_PREFERRED_RATING_TYPE' and v_rating_src_code = ( select v_component_value from setup_master where v_component_code='LLFP_PREFERRED_RATING_PROVIDER')
and v_st_lt_rating_flag = ( select v_component_value from setup_master where v_component_code='LLFP_PREFERRED_RATING_ST_LT_IND')'
Error:ORA-00942: table or view does not exist

[OFS_IFRS] [ERROR] - Query:'CREATE OR REPLACE VIEW VW_STG_PD_TERM_STRUCTURE_DTL (N_PD_TERM_STRUCTURE_SKEY, V_PD_TERM_STRUCTURE_ID, FIC_MIS_DATE, N_PERIOD_APPLICABLE, V_CREDIT_RISK_BASIS_CD, N_PD_PERCENT, N_SCENARIO_ID) AS
SELECT Dim_Pd_Term_Structure.N_Pd_Term_Structure_Skey,
Dim_Pd_Term_Structure.V_PD_TERM_STRUCTURE_ID,
Stg_Pd_Term_Structure_Dtl.Fic_Mis_Date,
STG_PD_TERM_STRUCTURE_DTL.N_PERIOD_APPLICABLE,
STG_PD_TERM_STRUCTURE_DTL.V_CREDIT_RISK_BASIS_CD,
STG_PD_TERM_STRUCTURE_DTL.N_PD_PERCENT,
FSI_LLFP_ECL_SCENARIOS.N_SCENARIO_ID
FROM STG_PD_TERM_STRUCTURE_DTL
INNER JOIN Dim_Pd_Term_Structure
ON STG_PD_TERM_STRUCTURE_DTL.V_PD_TERM_STRUCTURE_ID = DIM_PD_TERM_STRUCTURE.V_PD_TERM_STRUCTURE_ID
AND DIM_PD_TERM_STRUCTURE.F_LATEST_RECORD_INDICATOR = 'Y'
inner join fsi_llfp_ecl_scenarios
ON STG_PD_TERM_STRUCTURE_DTL.V_SCENARIO_CD = FSI_LLFP_ECL_SCENARIOS.V_SCENARIO_CD'
Error:ORA-00942: table or view does not exist

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!


In this Document
Symptoms
Cause
Solution


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