After upgrade to R12.2.5 - ORA-00980: synonym translation is no longer valid (Doc ID 2170544.1)

Last updated on MARCH 03, 2024

Applies to:

Symptoms

On : 12.2.5 version, Approvals - Req, PO

Cannot successfully compile invalid objects.

Note:
Patch internal <patch 18359637>:R12.PO.D is applied.

ERROR
-----------------------

PO_CLM_COLS_SUB_CHECK PO_CLM_COLS_SUB_CHECK.plb 120.30.12020000.9 BODY INVALID
Errors for PACKAGE BODY PO_CLM_COLS_SUB_CHECK
PL/SQL: ORA-00980: synonym translation is no longer valid
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00980: synonym translation is no longer valid
PL/SQL: SQL Statement ignored
PLS-00364: loop index variable 'C_GET_PO_LINES_REC' use is invalid
...

PO_CONTRACTS_S pocontvb.pls 120.2.12020000.2 BODY INVALID
Errors for PACKAGE BODY PO_CONTRACTS_S
PL/SQL: ORA-00980: synonym translation is no longer valid
PL/SQL: SQL Statement ignored

PO_DOCUMENT_CHECKS_PVT POXVDCKB.pls 120.177.12020000.140 BODY INVALID
Errors for PACKAGE BODY PO_DOCUMENT_CHECKS_PVT
PL/SQL: ORA-00980: synonym translation is no longer valid

PO_LINK_REQ_DIST_PVT PO_LINK_REQ_DIST_PVT.plb 120.17.12020000.22 BODY INVALID
Errors for PACKAGE BODY PO_LINK_REQ_DIST_PVT
PL/SQL: ORA-00980: synonym translation is no longer valid
..
PLS-00364: loop index variable 'CALIBRATE_SCH_CUR' use is invalid

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot resolve purchasing invalid objects after upgrade.

Changes

 Upgrade from 11.5.x to R12.2.5

Cause

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