My Oracle Support Banner

PFT 8.0.2 Language Pack Installation Fails With Many Errors (Doc ID 2452871.1)

Last updated on SEPTEMBER 28, 2018

Applies to:

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

Symptoms

On PFT 8.0.6, when installing the OFS PFT 8.0.2 language pack on top of a OFS PFT 8.0.6 install, there are several errors reported:

ERROR

Executing file @Migration/CreateView_Cube_NODE_FORMULAE.sql
Executing migration scripts on atomic schema's
Executing migration Scripts on ofsaaepm806
Calling atomic.sql
Error while executing - call generateGUIDRevBIHier('EPMINFO')
ORA-06550: line 1, column 7:
PLS-00905: object OFSAAEPM806.GENERATEGUIDREVBIHIER is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Executing migration Scripts on ofsaaalm806
Calling atomic.sql
Error while executing - call generateGUIDRevBIHier('ALMINFO')
ORA-06550: line 1, column 7:
PLS-00905: object OFSAAALM806.GENERATEGUIDREVBIHIER is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Executing migration Scripts on ofsaafccm806
Calling atomic.sql
Error while executing - call generateGUIDRevBIHier('FCCMINFO')
ORA-06550: line 1, column 7:
PLS-00905: object OFSAAFCCM806.GENERATEGUIDREVBIHIER is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Executing migration Scripts on ofsaaepm806
Calling atomic.sql
Error while executing - call generateGUIDRevBIHier('OFSPFTINFO')
ORA-06550: line 1, column 7:
PLS-00905: object OFSAAEPM806.GENERATEGUIDREVBIHIER is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
...
Error while executing - -- technique master duplicate MERGE INTO MF_TECHNIQUE_MASTER MTUSING (SELECT MT.V_TECHNIQUE_ID,MT.V_NAME,MT.V_DESCRIPTION,MT.V_IS_SAMPLING_TECH,MT.V_SCRIPT,MT.V_IS_AUTHORIZED,MT.V_INFODOM,LOCREP.VALUE V_SOURCE_LANG_CD,MT.V_CREATED_USER,MT.D_CREATION_DATE,MT.V_MODIFIED_USER,MT.D_MODIFICATION_DATE,MT.V_AUTHORIZED_BY,MT.D_AUTHORIZATION_DATE,MT.V_ACTION_TYPE,MT.V_COMMENTS,MT.V_ORE_OPTIONFROM LOCALEREPOSITORY LOCREPLEFT OUTER JOIN ( MF_TECHNIQUE_MASTER MTINNER JOIN MF_TECHNIQUE T ON MT.V_TECHNIQUE_ID = T.V_UNIQUE_IDAND MT.v_Source_Lang_Cd = T.v_Source_Lang_CdAND T.N_LEVEL = 2AND T.V_TYPE = 'P'AND MT.V_INFODOM IS NULL ) ON 1=1WHERE locrep.localecontext = 'INSTALL'AND locrep.parametername = 'POSTFIXSTRING') SSON (MT.V_TECHNIQUE_ID = SS.V_TECHNIQUE_ID AND UPPER(MT.V_SOURCE_LANG_CD) = UPPER(SS.V_SOURCE_LANG_CD) AND MT.V_INFODOM IS NULL)WHEN NOT MATCHED THENINSERT(MT.V_TECHNIQUE_ID,MT.V_NAME,MT.V_DESCRIPTION,MT.V_IS_SAMPLING_TECH,MT.V_SCRIPT,MT.V_IS_AUTHORIZED,MT.V_INFODOM,MT.V_SOURCE_LANG_CD,MT.V_CREATED_USER,MT.D_CREATION_DATE,MT.V_AUTHORIZED_BY,MT.D_AUTHORIZATION_DATE,MT.V_ACTION_TYPE,MT.V_COMMENTS,MT.V_ORE_OPTION)values(SS.V_TECHNIQUE_ID,SS.V_NAME,SS.V_DESCRIPTION,SS.V_IS_SAMPLING_TECH,SS.V_SCRIPT,SS.V_IS_AUTHORIZED,'',UPPER(SS.V_SOURCE_LANG_CD),'SYSADMN',SYSDATE,COALESCE(SS.V_AUTHORIZED_BY,NULL,''),SS.D_AUTHORIZATION_DATE,SS.V_ACTION_TYPE,SS.V_COMMENTS,SS.V_ORE_OPTION)
ORA-01400: cannot insert NULL into ("OFSAACONF806"."MF_TECHNIQUE_MASTER"."V_TECHNIQUE_ID")
...
********************************************************
 Utility execution started
********************************************************
[AESCryptor] The FIC_HOME path (got from GlobalParameters) is null
[AESCryptor] The FIC_HOME path (got from Environment Variable) is /ofsaa/fccm/fccm806
[AESCryptor] Security File Directory path is : /ofsaa/fccm/fccm806/conf/
[AESCryptor] File exists at /ofsaa/fccm/fccm806/conf/AESCryptKey.ext
java.sql.SQLRecoverableException: IO Error: Connection reset
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:752)
  at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666)
  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)
  at java.sql.DriverManager.getConnection(DriverManager.java:664)
  at java.sql.DriverManager.getConnection(DriverManager.java:208)
  at DBUtil.connect(DBUtil.java:77)
  at LMigration.main(LMigration.java:62)

Additional script errors are also found in the logs:

[Mon 27/8/2018 01:59:50] [LANGPACK] [DEBUG] - ########### Executing scripts from insert_aai_source_framework_tl_pt_BR.sql ###########
[Mon 27/8/2018 01:59:50] [LANGPACK] [ERROR] - Error while executing - MERGE INTO AAI_SOURCE_FRAMEWORK_TL T USING ( SELECT 'pt_BR' V_LOCALE_CODE,'MF' V_SOURCE_FRAMEWORK_CODE,'Infraestrutura Avançada do Analytics' V_SOURCE_FRAMEWORK_NAME,'Infraestrutura Avançada do Analytics' V_SOURCE_FRAMEWORK_DESC FROM DUAL ) S ON ( T.V_LOCALE_CODE = S.V_LOCALE_CODE AND T.V_SOURCE_FRAMEWORK_CODE = S.V_SOURCE_FRAMEWORK_CODE ) WHEN MATCHED THEN UPDATE SET T.V_SOURCE_FRAMEWORK_NAME = S.V_SOURCE_FRAMEWORK_NAME, T.V_SOURCE_FRAMEWORK_DESC = S.V_SOURCE_FRAMEWORK_DESC WHEN NOT MATCHED THEN INSERT (V_LOCALE_CODE,V_SOURCE_FRAMEWORK_CODE,V_SOURCE_FRAMEWORK_NAME,V_SOURCE_FRAMEWORK_DESC ) VALUES ( S.V_LOCALE_CODE,S.V_SOURCE_FRAMEWORK_CODE,S.V_SOURCE_FRAMEWORK_NAME,S.V_SOURCE_FRAMEWORK_DESC)
[Mon 27/8/2018 01:59:50] [LANGPACK] [ERROR] - ORA-02291: integrity constraint (OFSAACONF806.AAI_SOURCE_FRAMEWORK_TL_FK_1) violated - parent key not found
...
[Mon 27/8/2018 01:59:50] [LANGPACK] [DEBUG] - ########### Executing scripts from insert_aai_menu_tl_pt_BR.sql ###########

[Mon 27/8/2018 01:59:50] [LANGPACK] [ERROR] - Error while executing - MERGE INTO AAI_MENU_TL T USING ( SELECT 'pt_BR' V_LOCALE_CODE,'OFS_SANDBOX_MODELING' V_MENU_ID,'Modelagem' V_MENU_NAME,'Manter definições de modelagem analítica, exibir saídas do modelo etc.' V_MENU_DESC FROM DUAL ) S ON ( T.V_LOCALE_CODE = S.V_LOCALE_CODE AND T.V_MENU_ID = S.V_MENU_ID ) WHEN MATCHED THEN UPDATE SET T.V_MENU_NAME = S.V_MENU_NAME, T.V_MENU_DESC = S.V_MENU_DESC WHEN NOT MATCHED THEN INSERT (V_LOCALE_CODE,V_MENU_ID,V_MENU_NAME,V_MENU_DESC ) VALUES ( S.V_LOCALE_CODE,S.V_MENU_ID,S.V_MENU_NAME,S.V_MENU_DESC)
[Mon 27/8/2018 01:59:50] [LANGPACK] [ERROR] - ORA-02291: integrity constraint (OFSAACONF806.AAI_MENU_TL_FK) violated - parent key not found

...
[Mon 27/8/2018 01:59:51] [LANGPACK] [DEBUG] - ########### Executing scripts from insert_rev_object_types_mls_pt_BR.sql ###########
[Mon 27/8/2018 01:59:51] [LANGPACK] [ERROR] - Error while executing - MERGE INTO REV_OBJECT_TYPES_MLS T USING ( SELECT 'pt_BR' MLS_CD,'1303' OBJECT_TYPE_ID,'Variável' OBJECT_TYPE_NAME FROM DUAL ) S ON ( T.MLS_CD = S.MLS_CD AND T.OBJECT_TYPE_ID = S.OBJECT_TYPE_ID ) WHEN MATCHED THEN UPDATE SET T.OBJECT_TYPE_NAME = S.OBJECT_TYPE_NAME WHEN NOT MATCHED THEN INSERT (MLS_CD,OBJECT_TYPE_ID,OBJECT_TYPE_NAME ) VALUES ( S.MLS_CD,S.OBJECT_TYPE_ID,S.OBJECT_TYPE_NAME)
[Mon 27/8/2018 01:59:51] [LANGPACK] [ERROR] - ORA-02291: integrity constraint (OFSAACONF806.FK_REV_OBJECT_TYPES_MLS) violated - parent key not found

[Mon 27/8/2018 01:59:51] [LANGPACK] [ERROR] - Error while executing - MERGE INTO REV_OBJECT_TYPES_MLS T USING ( SELECT 'pt_BR' MLS_CD,'1304' OBJECT_TYPE_ID,'Técnica' OBJECT_TYPE_NAME FROM DUAL ) S ON ( T.MLS_CD = S.MLS_CD AND T.OBJECT_TYPE_ID = S.OBJECT_TYPE_ID ) WHEN MATCHED THEN UPDATE SET T.OBJECT_TYPE_NAME = S.OBJECT_TYPE_NAME WHEN NOT MATCHED THEN INSERT (MLS_CD,OBJECT_TYPE_ID,OBJECT_TYPE_NAME ) VALUES ( S.MLS_CD,S.OBJECT_TYPE_ID,S.OBJECT_TYPE_NAME)
[Mon 27/8/2018 01:59:51] [LANGPACK] [ERROR] - ORA-02291: integrity constraint (OFSAACONF806.FK_REV_OBJECT_TYPES_MLS) violated - parent key not found
...
[Mon 27/8/2018 02:03:23] [LANGPACK] [DEBUG] - ########### Executing scripts from insert_mdb_i18n_es_ES.sql ###########
[Mon 27/8/2018 02:03:59] [LANGPACK] [DEBUG] - /vol01/oracle/ofsaa/fccm/fccm806/commonscripts/config/insert_mdb_i18n_es_ES.sql (No such file or directory)

...

[Mon 27/8/2018 04:03:19] [OFS_PFT] [ INFO] - Executing file:/vol01/oracle/ofsaa/fccm/fccm806/scripts/pt_BR/atomic/insert/pft_DIM_CONSOLIDATION_MLS.sql
[Mon 27/8/2018 04:03:19] [OFS_PFT] [ERROR] - Query:'MERGE INTO DIM_CONSOLIDATION_MLS T
USING (
SELECT 'Real' V_CONSOLIDATION,'Real' V_DESCRIPTION,'9100' N_CONSOLIDATION_CD,'pt-BR' 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

The installation appears to be successful however and there are no issues found in the UI.

The issue can be reproduced at will with the following steps:
1. Apply OFS PFT 8.0.2 language pack
2. Check logs

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
References


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