Technology Stack - EBS (MOSC)

MOSC Banner

ADZDDBCC.sql issue

edited Aug 20, 2021 11:36AM in Technology Stack - EBS (MOSC) 2 commentsAnswered

Hi,


We are working on an Oracle EBS 12.0.6 to 12.2.4 upgrade.

Database Standards Checker has returned some custom tables for which the EXEC ad_zd_table.upgrade('', '') would not work.

Please advise on the course action for these tables.



**********************************************************************
DOC>  SECTION-15
DOC>  **********************************************************************
DOC>  "Synonym must point to an object"
DOC>
DOC>   - P3: broken synonyms cause clutter and confusion
DOC>   - Fix or drop these synonyms
DOC>#

OWNER            SYNONYM_NAME                   TABLE_OWNER      TABLE_NAME
---------------- ------------------------------ ---------------- ------------------------------
APPS             XXIRIS_ADJ_424_DO_CODE_TBL     XXIRIS           XXIRIS_ADJ_424_DO_CODE_TBL#
APPS             XXIRIS_ADJ_459_ER_MOD_CODE_TBL XXIRIS           XXIRIS_ADJ_459_ER_MOD_CODE_TB#

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center