ORA-00942: table or view does not exist Error Running Populate_mdb_common_locale.sql While Performing Upgrade of PFT App Pack 803 (Doc ID 2237555.1)

Last updated on FEBRUARY 24, 2017

Applies to:

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

Goal

When performing PFT upgrade from 8.0.2 to 8.0.3, the installation completed and the  data model upload was successful, but in the installation log has the below error:

ERROR

[Thu 23/2/2017 05:00:08] [OFS_PFT] [ INFO] - Executing file:/u01/ofsaa/local/ofsaa8/scripts/config/insert/populate_mdb_common_locale.sql
[Thu 23/2/2017 05:00:08] [OFS_PFT] [ERROR] - Query:'MERGE INTO METADATA_BROWSER_LOCALE MBL

USING (SELECT TAB.PACKAGE,
  TAB.CODE,
  TAB.CODE_VALUE,
  TAB.DSN_ID,
  TAB.LANGUAGE
  FROM (SELECT DISTINCT L.LOCALEIDENTIFIER LANGUAGE,
  L.VALUE,
  MSLV.CODE_COL_NAME CODE,
  MSLV.VALUE_COL_NAME CODE_VALUE,
  UPPER(MSLV.TABLE_NAME) PACKAGE,
  ALD.V_INFODOM DSN_ID
  FROM atomic.MDB_SETUP_LIST_V MSLV,
(select 'en_US' V_LOCALE,
  aab.v_mdb_app_id V_CONTEXT,
  tab.V_INFODOM,
  '8.0.3.0.0' V_VERSION
  from (select v_app_id, v_infodom_code V_INFODOM
  from aai_app_pack_audit_trail
  where v_app_pack_id = 'OFS_PFT_PACK') tab
  inner join aai_app_b aab on tab.v_app_id =
  aab.v_app_id
  union
  SELECT V_LOCALE, V_CONTEXT, l.V_INFODOM, l.V_VERSION
  FROM APP_LOCALE_DETAILS l
  left outer join aai_app_b b on b.v_mdb_app_id =
  l.v_context
  inner join aai_app_pack_audit_trail t on b.v_app_id =
  t.v_app_id
  AND l.V_VERSION =
  '8.0.3.0.0'
  AND l.V_INFODOM =
  t.v_infodom_code) ALD,
  LOCALEREPOSITORY L
  WHERE L.LOCALECONTEXT = 'NLS'
  AND L.PARAMETERNAME = 'ISOLANGUAGE'
  AND MSLV.LOCALE_COL_NAME = L.VALUE
  AND ALD.V_CONTEXT = MSLV.APP_ID
  AND ALD.V_LOCALE = L.LOCALEIDENTIFIER) TAB) PROXY
ON (MBL.PACKAGE = PROXY.PACKAGE AND MBL.CODE = PROXY.CODE AND MBL.DSN_ID = PROXY.DSN_ID AND MBL.LANGAUGE = PROXY.LANGUAGE)
WHEN MATCHED THEN
 UPDATE SET MBL.VALUE = PROXY.CODE_VALUE
WHEN NOT MATCHED THEN
 INSERT
  (MBL.PACKAGE, MBL.CODE, MBL.VALUE, MBL.DSN_ID, MBL.LANGAUGE)
 VALUES
  (PROXY.PACKAGE,
  PROXY.CODE,
  PROXY.CODE_VALUE,
  PROXY.DSN_ID,
  PROXY.LANGUAGE)'
  Error:ORA-00942: table or view does not exist


While debugging the error, it is found that there is a privilege issue in this table MDB_SETUP_LIST_V.

SQL> select * from dba_tab_privs where table_name='MDB_SETUP_LIST_V';

GRANTEE OWNER TABLE_NAME
------------------------------ ------------ ------------------------------
GRANTOR PRIVILEGE GRA HIE
------------------------------ ---------------------------------------- --- ---
CONFIG ATOMIC MDB_SETUP_LIST_V
ATOMIC SELECT NO NO

Is there any issue to resolve the permissions and run the sql script?

Solution

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