My Oracle Support Banner

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 later
Information 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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.