12.2.3 online enablement reports invalid JMF_GTA_xxx_OBS tables (Doc ID 2032728.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Outsourced Manufacturing for Discrete Industries - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

Validate Apps Schema is run as post-patching step by all customers. It is essential to ensure that this report is perceived properly by customer.In many cases there are errors that are reported as Must-fix but in reality many of these can be safely ignored. We need to guide customers either by fixing these errors that are reported or updating the relevant documentation with the information about which errors they must indeed fix and which ones can be safely ignored.

Run the "Recreate grants and synonyms for APPS schema(s)" task from the AD Administration
"Maintain Applications Database Objects" menu

DOC> **********************************************************************
DOC> EBS Online Patching Database Compliance Checker (12.2.0 rev 22)
DOC> **********************************************************************
DOC>#

INSTANCE_NAME      VERSION            SYSDATE

HAEAPSD                   11.2.0.4.0           27-JUN-14

Online Patching Enabled?
--------------------------------
Yes
...
DOC> **********************************************************************
DOC> SECTION-20
DOC> **********************************************************************
DOC> "Table must have an Editioning View"
DOC>
DOC> - P2: These tables may not be patched using Online Patching
DOC> - Fix violations by calling the table upgrade procedure: SQL> exec ad_zd_table.upgrade(table_owner, new_table_name)

OWNER NAME
---------------- ------------------------------
JMF JMF_GTA_BATCH_NUMBERING_OBS
JMF JMF_GTA_RULE_DFFS_ALL_OBS
JMF JMF_GTA_RULE_HEADERS_ALL_OBS
JMF JMF_GTA_RULE_TRX_TYPES_ALL_OBS
JMF JMF_GTA_SYSTEM_PARAMETERS_OBS
JMF JMF_GTA_TAX_LIMITS_ALL_OBS
JMF JMF_GTA_TRXIMP_TMP_OBS
JMF JMF_GTA_TRX_HEADERS_ALL_OBS
JMF JMF_GTA_TRX_LINES_ALL_OBS
JMF JMF_GTA_TYPE_MAPPINGS_OBS

Missing synonym : APPS.JMF_GTA_AR_DIFFERENCE_TEMP_OBS
- for
- JMF.JMF_GTA_AR_DIFFERENCE_TEMP_OBS
Missing synonym : APPS.JMF_GTA_BATCH_NUMBERING_OBS
- for
- JMF.JMF_GTA_BATCH_NUMBERING_OBS
Missing synonym : APPS.JMF_GTA_DIFFERENCE_TEMP_OBS
- for
- JMF.JMF_GTA_DIFFERENCE_TEMP_OBS
Missing synonym : APPS.JMF_GTA_GENERATE_S_OBS
- for
- JMF.JMF_GTA_GENERATE_S_OBS
Missing synonym : APPS.JMF_GTA_IMPORT_REP_TEMP_OBS
- for
- JMF.JMF_GTA_IMPORT_REP_TEMP_OBS
Missing synonym : APPS.JMF_GTA_IMPORT_REP_TEMP_S_OBS
- for
- JMF.JMF_GTA_IMPORT_REP_TEMP_S_OBS
Missing synonym : APPS.JMF_GTA_MISSING_ARTRX_TEMP_OBS
- for
- JMF.JMF_GTA_MISSING_ARTRX_TEMP_OBS
Missing synonym : APPS.JMF_GTA_RULE_DFFS_ALL_OBS
- for
- JMF.JMF_GTA_RULE_DFFS_ALL_OBS
Missing synonym : APPS.JMF_GTA_RULE_DFFS_S_OBS
- for
- JMF.JMF_GTA_RULE_DFFS_S_OBS
Missing synonym : APPS.JMF_GTA_RULE_HEADERS_ALL_OBS
- for
- JMF.JMF_GTA_RULE_HEADERS_ALL_OBS
Missing synonym : APPS.JMF_GTA_RULE_HEADERS_S_OBS
- for
- JMF.JMF_GTA_RULE_HEADERS_S_OBS
Missing synonym : APPS.JMF_GTA_RULE_TRX_DFFS_S_OBS
- for
- JMF.JMF_GTA_RULE_TRX_DFFS_S_OBS
Missing synonym : APPS.JMF_GTA_RULE_TRX_TYPES_ALL_OBS
- for
- JMF.JMF_GTA_RULE_TRX_TYPES_ALL_OBS
Missing synonym : APPS.JMF_GTA_RULE_TRX_TYPE_S_OBS
- for
- JMF.JMF_GTA_RULE_TRX_TYPE_S_OBS
Missing synonym : APPS.JMF_GTA_SYSTEM_PARAMETERS_OBS
- for
- JMF.JMF_GTA_SYSTEM_PARAMETERS_OBS
Missing synonym : APPS.JMF_GTA_TAX_LIMITS_ALL_OBS
- for
- JMF.JMF_GTA_TAX_LIMITS_ALL_OBS
Missing synonym : APPS.JMF_GTA_TAX_LIMITS_S_OBS
- for
- JMF.JMF_GTA_TAX_LIMITS_S_OBS
Missing synonym : APPS.JMF_GTA_TRANSFER_TEMP_OBS
- for
- JMF.JMF_GTA_TRANSFER_TEMP_OBS
Missing synonym : APPS.JMF_GTA_TRANSFER_TEMP_S_OBS
- for
- JMF.JMF_GTA_TRANSFER_TEMP_S_OBS
Missing synonym : APPS.JMF_GTA_TRXIMP_TMP_OBS
- for
- JMF.JMF_GTA_TRXIMP_TMP_OBS
Missing synonym : APPS.JMF_GTA_TRX_HEADERS_ALL_OBS
- for
- JMF.JMF_GTA_TRX_HEADERS_ALL_OBS
Missing synonym : APPS.JMF_GTA_TRX_HEADERS_ALL_S_OBS
- for
- JMF.JMF_GTA_TRX_HEADERS_ALL_S_OBS
Missing synonym : APPS.JMF_GTA_TRX_LINES_ALL_OBS
- for
- JMF.JMF_GTA_TRX_LINES_ALL_OBS
Missing synonym : APPS.JMF_GTA_TRX_LINES_ALL_S_OBS
- for
- JMF.JMF_GTA_TRX_LINES_ALL_S_OBS
Missing synonym : APPS.JMF_GTA_TYPE_MAPPINGS_OBS
- for
- JMF.JMF_GTA_TYPE_MAPPINGS_OBS
Missing synonym : APPS.JMF_GTA_TYPE_MAPPINGS_S_OBS
- for
- JMF.JMF_GTA_TYPE_MAPPINGS_S_OBS
Missing synonym : APPS.JMF_GTA_UNMATCHED_TEMP_OBS
- for
- JMF.JMF_GTA_UNMATCHED_TEMP_OBS
 
Missing or incorrect synonyms in "APPS" reported in validate apps log.
The tables for which synonyms are missing mentioned are obsoleted
tables in 12.2. But per standard any table shipped
(including any backup tables or obsoleted ones) should have a synonym
and the associated grants.
 

Changes

At one point the ADADMIN option to recreate grants & synonyms
was decided to be disabled/removed in 12.2 upgrade. So these missing
synonyms were reported in validate apps log.

But recently ADADMIN option to recreate grants & synonyms has been
re-introduced in 12.2 upgrade. So these objects will not be reported
anymore in the validate apps 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