3 Replies Latest reply on May 26, 2015 2:19 PM by MariaKarpa(MK)

    ORA-6508

      Hi all,

       

      EBS R12.2

       

      We encountered the following error:

       

      <Moderator Edit - deleted contents of MOS Doc 1900747.1 - pl do NOT post such content - it is a violation of your Support agreement - this abuse has been reported to Admins>

       

      The docs is for 12.1 can this be applied in R12.2?

       

      Thanks a lot.

      MK

        • 1. Re: ORA-6508
          yoonas

          MK,

           

          Applies to section says 12.1.3 and later. so there is no harm i think

           

          Regards

          Yoonas

          1 person found this helpful
          • 2. Re: ORA-6508
            Bashar.

            Hi,

             

            The solution in the document is to recompile an invalid package. This should work the same in 12.2.

            Just check if that package is invalid and recompile it.

             

            If it does not work then post the errors encountered.

             

            Regards,

            Bashar

            1 person found this helpful
            • 3. Re: ORA-6508

              Thanks all,

               

              But I check the object status, and it is valid

               

              1*  select object_name,object_type,status from dba_objects where object_name like '%IBY_ASSIGN_PUB%'

              SQL>

               

              OBJECT_NAME          OBJECT_TYPE         STATUS

              -------------------- ------------------- -------

              IBY_ASSIGN_PUB       PACKAGE             VALID

              IBY_ASSIGN_PUB       PACKAGE BODY        VALID

               


              And the app error log is:


              +---------------------------------------------------------------------------+

              Start of log messages from FND_FILE

              +---------------------------------------------------------------------------+

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Enter Build :: Concurrent Request ID::536308

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:+-----------------------------------------------------------------------------------------------------+

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:|STEP 1: Insert Payment Service Request:: Timestamp:26-MAY-15 05.55.24.963042000 AM -04:00|

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:+-----------------------------------------------------------------------------------------------------+

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:+----------------------------------------------------------------------------------------------------+

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:|STEP 2: Insert Documents :Timestamp:26-MAY-15 05.55.24.969643000 AM -04:00|

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:+----------------------------------------------------------------------------------------------------+

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:+--------------------------------------------------------------------------------------------------------+

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:|STEP 3: Account/Profile Assignment :Timestamp:26-MAY-15 05.55.24.979881000 AM -04:00|

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:+--------------------------------------------------------------------------------------------------------+

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Request status after assignments: ASSIGNMENT_COMPLETE

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:+----------------------------------------------------------------------------------------------------+

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:|STEP 4: Document Validation :Timestamp:26-MAY-15 05.55.24.982913000 AM -04:00|

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:+----------------------------------------------------------------------------------------------------+

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Exception occured when validating documents. Document validation will be aborted and no document statuses will be committed for payment request 288

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: -6508

              IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: ORA-06508: PL/SQL: could not find program unit being called

              Build program error: Exception occured when attempting to validate the documents payable of the provided payment service request.

              +---------------------------------------------------------------------------+

              End of log messages from FND_FILE

              +---------------------------------------------------------------------------+

               

               

              Thanks a lot ....