R12.2 IBY/AP - IBY_PAYGROUP_PUB And Other IBY and AP Objects Are Invalid
(Doc ID 1989531.1)
Last updated on JANUARY 16, 2018
Applies to:
Oracle Payables - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
On R12.2.4
There are invalid objects on the database
APPS PACKAGE BODY AP_AWT_CALLOUT_PKG INVALID
APPS PACKAGE BODY AP_BANK_CHARGE_PKG INVALID
APPS PACKAGE BODY IBY_BUILD_INSTRUCTIONS_PUB_PKG INVALID
APPS PACKAGE IBY_CHECKNUMBER_PUB INVALID
APPS PACKAGE BODY IBY_CHECKNUMBER_PUB INVALID
APPS PACKAGE BODY IBY_DISBURSE_SINGLE_PMT_PKG INVALID
APPS PACKAGE BODY IBY_DISBURSE_SUBMIT_PUB_PKG INVALID
APPS PACKAGE BODY IBY_DISBURSE_UI_API_PUB_PKG INVALID
APPS PACKAGE IBY_PAYGROUP_PUB INVALID
APPS PACKAGE BODY IBY_PAYGROUP_PUB INVALID
APPS PACKAGE BODY IBY_PAYINSTR_PUB INVALID
APPS PACKAGE IBY_SINGPAY_PUB INVALID
APPS PACKAGE BODY IBY_SINGPAY_PUB INVALID
*--- IBY_DISBURSE_SUBMIT_PUB_PKG PACKAGE BODY
PLS-00905: object APPS.IBY_CHECKNUMBER_PUB is invalid
PLS-00905: object APPS.IBY_PAYGROUP_PUB is invalid
*--- IBY_BUILD_INSTRUCTIONS_PUB_PKG PACKAGE BODY
PLS-00905: object APPS.IBY_CHECKNUMBER_PUB is invalid
*--- IBY_DISBURSE_UI_API_PUB_PKG PACKAGE BODY
PLS-00905: object APPS.IBY_CHECKNUMBER_PUB is invalid
*--- IBY_DISBURSE_SINGLE_PMT_PKG PACKAGE BODY
PLS-00905: object APPS.IBY_PAYGROUP_PUB is invalid
*--- IBY_PAYINSTR_PUB PACKAGE BODY
PLS-00905: object APPS.IBY_PAYGROUP_PUB is invalid
*--- IBY_CHECKNUMBER_PUB PACKAGE
PLS-00905: object APPS.IBY_PAYGROUP_PUB is invalid
*--- IBY_CHECKNUMBER_PUB PACKAGE BODY
PLS-00304: cannot compile body of 'IBY_CHECKNUMBER_PUB' without its specification
*--- IBY_SINGPAY_PUB PACKAGE BODY
PLS-00304: cannot compile body of 'IBY_SINGPAY_PUB' without its specification
*--- IBY_SINGPAY_PUB PACKAGE
PLS-00905: object APPS.IBY_PAYGROUP_PUB is invalid
*--- IBY_PAYGROUP_PUB PACKAGE BODY
PLS-00304: cannot compile body of 'IBY_PAYGROUP_PUB' without its specification
*--- IBY_PAYGROUP_PUB PACKAGE
528 6 PLS-00201: identifier 'IBY_HOOK_DOCS_IN_PMT_T.DONT_PAY_FLAG' must be declared
532 6 PLS-00201: identifier 'IBY_HOOK_DOCS_IN_PMT_T.DONT_PAY_REASON_CODE' must be declared
536 6 PLS-00201: identifier 'IBY_HOOK_DOCS_IN_PMT_T.DONT_PAY_DESCRIPTION' must be declared
541 6 PLS-00201: identifier 'IBY_HOOK_DOCS_IN_PMT_T.DONT_PAY_FLAG' must be declared
1316 32 PLS-00201: identifier 'IBY_HOOK_DOCS_IN_PMT_T.DOCUMENT_PAYABLE_ID' must be declared
1562 44 PLS-00201: identifier 'IBY_HOOK_DOCS_IN_PMT_T' must be declared
*--- AP_AWT_CALLOUT_PKG PACKAGE BODY
14/26 PLS-00201: identifier 'IBY_HOOK_DOCS_IN_PMT_T.CALLING_APP_DOC_UNIQUE_REF1' must be declared
24/9 PL/SQL: ORA-00980: synonym translation is no longer valid tips
39/29 PL/SQL: ORA-00904: "L_CHECKRUN_ID": invalid identifier
32/11 PLS-00341: declaration of cursor 'C_AWT_TEMP_DISTS' is incomplete or malformed
*--- AP_BANK_CHARGE_PKG PACKAGE BODY
1499 19 PL/SQL: ORA-00980: synonym translation is no longer valid tips
1558 10 PL/SQL: ORA-00980: synonym translation is no longer valid tips
1612 8 PL/SQL: ORA-00980: synonym translation is no longer valid tips
2016 14 PL/SQL: ORA-00980: synonym translation is no longer valid tips
2059 14 PL/SQL: ORA-00980: synonym translation is no longer valid tips
2080 11 PL/SQL: ORA-00980: synonym translation is no longer valid tips
2088 15 PL/SQL: ORA-00980: synonym translation is no longer valid tips
2122 12 PL/SQL: ORA-00980: synonym translation is no longer valid tips
2141 12 PL/SQL: ORA-00980: synonym translation is no longer valid tips
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! |
In this Document
Symptoms |
Cause |
Solution |
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |