PFT LP 8.0 Applied Successfully With Some FATAL Errors in the Log (Doc ID 2136164.1)

Last updated on MAY 10, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Language Pack (LP)

Symptoms

On PFT 8.0.0, the PFT LP 8.0 is applied successfully with some FATAL errors in the log :

ERRORS

Error 1:

[Fri 01/4/2016 01:54:23] [OFS_PFT] [ERROR] - Query:'MERGE INTO DIM_CONSOLIDATION_MLS T
USING (
SELECT 'Réel' V_CONSOLIDATION,'Réel' V_DESCRIPTION,'5100' N_CONSOLIDATION_CD,'fr-ca' V_MLS_CD,to_date('16-06-2015','dd-mm-yyyy') FIC_MIS_DATE FROM DUAL
) S
ON (T.N_CONSOLIDATION_CD = S.N_CONSOLIDATION_CD)
WHEN MATCHED THEN
UPDATE
SET T.V_CONSOLIDATION = S.V_CONSOLIDATION,
  T.V_DESCRIPTION = S.V_DESCRIPTION,
  T.V_MLS_CD = S.V_MLS_CD,
  T.FIC_MIS_DATE = S.FIC_MIS_DATE
WHEN NOT MATCHED THEN
INSERT
 (V_CONSOLIDATION,V_DESCRIPTION,N_CONSOLIDATION_CD,V_MLS_CD,FIC_MIS_DATE)
VALUES
 (S.V_CONSOLIDATION,S.V_DESCRIPTION,S.N_CONSOLIDATION_CD,S.V_MLS_CD,S.FIC_MIS_DATE )'
 Error:ORA-00904: "FIC_MIS_DATE": invalid identifier

Error 2:

[Fri 01/4/2016 01:54:37] [OFS_PFT] [FATAL] - =====Exception====
java.io.FileNotFoundException: /opt/oracle/base/form/ofsaa8/scripts/config/insert/populate_mdb_ofs_pft_locale.sql (No such file or directory).

The issue can be reproduced at will with the following steps:
1. Run the PFT 8.0 LP application patch
2. Check the generated 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