1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORA-04062: signature of package "APPS.IBY_DISBURSEMENT_COMP_PUB" has been changed err

Discussion in 'Oracle Apps Technical' started by jagadekara, Jun 16, 2015.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    we recently refresh one instance. now when ever we try to query AP invoices, then above error coming.
    Also it is not allowing to create new invoice, because payments method not showing any list of values.

    So what is the issue?
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Re: ORA-04062: signature of package "APPS.IBY_DISBURSEMENT_COMP_PUB" has been changed

    Please review the following metalink notes:

    Entering Invoice Get ORA-04062: Signature Of Package APPS.IBY_DISBURSEMENT_COMP_PUB Has Changed (Doc ID 1563343.1)
    R12 APXINWKB Error ORA-04062 Signature Of Package APPS.IBY_DISBURSEMENT_COMP_PUB Has Been Changed (Doc ID 1966007.1)
    APXINWKB ORA-04062: Signature Of Package APPS.IBY_DISBURSEMENT_COMP_PUB Has Changed (Doc ID 1903598.1)
     
    jagadekara likes this.
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Re: ORA-04062: signature of package "APPS.IBY_DISBURSEMENT_COMP_PUB" has been changed

    Hi,

    While compiling those forms getting errors like below...

    Compiling package body APXINWKB...
    Compilation error on package body APXINWKB:
    PL/SQL ERROR 49 at line 411, column 52
    bad bind variable 'ZX_PARAMETERS.OVERRIDE_STATUS'
    PL/SQL ERROR 49 at line 411, column 52
    bad bind variable 'ZX_PARAMETERS.OVERRIDE_STATUS'



    Compiling package body INV_SUM_BALANCE...
    Compilation error on package body INV_SUM_BALANCE:
    PL/SQL ERROR 49 at line 159, column 8
    bad bind variable 'parameter.G_query_find'
    PL/SQL ERROR 49 at line 159, column 8
    bad bind variable 'parameter.G_query_find'
    PL/SQL ERROR 49 at line 163, column 8
    bad bind variable 'parameter.G_query_find'


    Compiling package body INV_SUM_FOLDER_ITEM_RATE1...
    Compilation error on package body INV_SUM_FOLDER_ITEM_RATE1:
    PL/SQL ERROR 307 at line 599, column 21
    too many declarations of 'GET_RATE' match this call
    PL/SQL ERROR 0 at line 599, column 5
    Statement ignored
    PL/SQL ERROR 307 at line 732, column 17
    too many declarations of 'CONVERT_AMOUNT' match this call
    PL/SQL ERROR 0 at line 731, column 13

    so we copied those .fmb and .fmx and IBYFDOBJ.PLX from another working instance to current instance. now error resolved.
    But after query the invoice and click on the line, then it is giving the below error.

    FRM-40105: Unable to resolve reference item INV_SUM_FOLDER.VALIDATION_REQUEST_ID

    After the it's giving the following error.

    ORA-00904: "AP_INVOICE_DISTRIBUTIONS_PKG.IS_AWT_COMPUTED_DIST" invalid identifier

    This is happening for new invoices also.

    So Any possible way to resolve this?
     
  4. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Re: ORA-04062: signature of package "APPS.IBY_DISBURSEMENT_COMP_PUB" has been changed

    That you copied a core form from a working instance to this one and got different results indicates a configuration problem. Perhaps a patch is missing or a RUP?