My Oracle Support Banner

R12.2: CE: CEXCABMR.fmx がジェネレートできない ORA-00980: synonym translation is no longer valid(CE_AVAILABLE_TRANSACTIONS_TMP2) (Doc ID 2266869.1)

Last updated on MAY 23, 2017

適用範囲:

Oracle Cash Management - バージョン 12.2 以降
この文書の内容はすべてのプラットフォームに適用されます。

目的

TSP(Translation Synchronization patch for Customer)を適用時や多数のパッチを適用後に

CEXCABMR.fmx がジェネレートできません。

ORA-00980が発生して、INVALID OBJECTが多数あります。

 

LOG:

The following Oracle Forms objects did not generate successfully:

ce forms/JA CEXCABMR.fmx

 

 

SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE from dba_objects where status = 'INVALID';

OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------------ -----------------------
APPS CE_MISC_TRANSACTIONS_V VIEW
APPS CE_STATEMENT_LINES_V VIEW
APPS CE_AVAILABLE_BATCHES_V VIEW
APPS CE_REVERSAL_TRANSACTIONS_V VIEW
APPS CE_AVAILABLE_TRANSACTIONS_V VIEW
APPS CE_RECONCILED_TRANSACTIONS_V VIEW
APPS CE_AUTO_BANK_UNREC PACKAGE BODY
APPS CE_AUTO_BANK_REC PACKAGE BODY
APPS CE_AUTO_BANK_MATCH PACKAGE BODY
APPS CE_AUTO_BANK_CLEAR1 PACKAGE BODY
APPS CE_AUTO_BANK_CLEAR PACKAGE BODY
APPS IBY_VALIDATIONSETS_PUB PACKAGE BODY
APPS CE_BNK_STMT_RECON_RPT_PKG PACKAGE BODY
APPS CE_CEXAVTRX_XMLP_PKG PACKAGE BODY
APPS CE_CEXSTMSR_XMLP_PKG PACKAGE BODY
APPS CE_CEXSTMRR_XMLP_PKG PACKAGE BODY
APPS FV_SLA_PO_PROCESSING_PKG PACKAGE BODY
APPS FV_SLA_UTL_PROCESSING_PKG PACKAGE BODY
APPS CLJ_AP_OTS_SCH_FOR_PAYMENT_V VIEW
APPS CLJ_AP_SCHEDULE_FOR_PAYMENT_V VIEW
APPS CLJAP_SCHEDULE_FOR_PAYMENT_V VIEW
APPS CLJ_AP_PROOF_LIST_PKG PACKAGE BODY
APPS CLJ_AP_GL_INHERIT_HOOK_PKG PACKAGE BODY
APPS CLJ_AP_PTS_MAILHCOPY_PKG PACKAGE BODY
APPS CLJ_AP_GL_INHERIT_PKG PACKAGE BODY

25 rows selected.

 

SQL> show errors
Errors for PACKAGE BODY CE_AUTO_BANK_MATCH:

LINE/COL ERROR
-------- -----------------------------------------------------------------
855/5 PL/SQL: SQL Statement ignored
896/13 PL/SQL: ORA-00980: synonym translation is no longer valid
921/5 PL/SQL: SQL Statement ignored
964/13 PL/SQL: ORA-00980: synonym translation is no longer valid
4308/9 PL/SQL: SQL Statement ignored
4353/13 PL/SQL: ORA-00980: synonym translation is no longer valid
4370/9 PL/SQL: SQL Statement ignored
4410/13 PL/SQL: ORA-00980: synonym translation is no longer valid
4435/21 PL/SQL: SQL Statement ignored
4479/25 PL/SQL: ORA-00980: synonym translation is no longer valid
4504/17 PL/SQL: SQL Statement ignored

LINE/COL ERROR
-------- -----------------------------------------------------------------
4546/21 PL/SQL: ORA-00980: synonym translation is no longer valid
5199/2 PL/SQL: SQL Statement ignored
5218/17 PL/SQL: ORA-00980: synonym translation is no longer valid
8612/3 PL/SQL: SQL Statement ignored
8612/10 PL/SQL: ORA-00980: synonym translation is no longer valid
8685/7 PL/SQL: SQL Statement ignored
8685/19 PL/SQL: ORA-00980: synonym translation is no longer valid
8859/7 PL/SQL: SQL Statement ignored
8859/19 PL/SQL: ORA-00980: synonym translation is no longer valid
SQL>
SQL> alter package CE_AUTO_BANK_CLEAR1 compile;

Warning: Package altered with compilation errors.

SQL> show errors
No errors.
SQL> alter package CE_AUTO_BANK_CLEAR1 compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY CE_AUTO_BANK_CLEAR1:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3057/7 PL/SQL: SQL Statement ignored
3057/14 PL/SQL: ORA-00980: synonym translation is no longer valid

解決策

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.