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

Last updated on SEPTEMBER 13, 2016

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

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