My Oracle Support Banner

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

Last updated on JULY 03, 2018

Applies to:

Oracle Purchasing - Version 12.2.5 and later
Information in this document applies to any platform.

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

To view full details, 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 a vibrant support community of peers and Oracle experts.