R12.2 IBY/AP - IBY_PAYGROUP_PUB And Other IBY and AP Objects Are Invalid (Doc ID 1989531.1)

Last updated on JUNE 19, 2019

Applies to:

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  

Changes

Cause

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