5 Replies Latest reply: Oct 12, 2012 12:24 AM by Hussein Sawwan-Oracle RSS

    Unit Processor completed normally with some events in error

    931117
      Hi all,

      I am getting this error in R12.0.4

      Online accounting could not be created for this transaction. Please inform your system administrator that the create accounting program has encountered an internal error in AR.

      Please help me out to resolve this issue.Here is log file


      Subledger Accounting: Version : 12.0.0

      Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

      XLAACCUP module: Accounting Program
      ---------------------------------------------------------------------------

      Current system time is 15-APR-2012 12:47:31

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

      **Starts**15-APR-2012 12:47:31
      **Ends**15-APR-2012 12:47:57
      Unit Processor completed normally with some events in error
      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      15-APR-2012 13:10:21 - Executing Unit Processor ...
      15-APR-2012 13:10:21 - Initializing variables
      15-APR-2012 13:10:21 - Security Context Set
      15-APR-2012 13:10:21 - Ready to cache the Application and Ledger Level Sources ...
      15-APR-2012 13:10:21 - Cached the Application and Ledger Level Sources
      15-APR-2012 13:10:21 - Entering the loop to read document units from the queue ...
      15-APR-2012 13:10:21 - Checking status of the parent Accounting Program
      15-APR-2012 13:10:21 - Dequeuing the unit from the queue
      15-APR-2012 13:10:21 - Fetching event information for the documents in the unit
      15-APR-2012 13:10:21 - executing extract hook
      ARP_XLA_EXTRACT_MAIN_PKG.extract()+
      p_application_id :222
      p_accounting_mode :F
      Calling upgrade_11i_r12_post +
      Get 11i application to upgrade
      End upgrade_11i_r12_post -
      arp_xla_extract_main_pkg.load_header_data_ctlgd ()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_ctlgd()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()-
      arp_xla_extract_main_pkg.load_line_data_app_from_cm ()+
      arp_xla_extract_main_pkg.load_line_data_app_from_cm ()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()-
      arp_xla_extract_main_pkg.load_line_data_app_from_cr()+
      arp_xla_extract_main_pkg.load_line_data_app_from_cr ()-
      arp_xla_extract_main_pkg.load_line_data_app_to_trx ()+
      arp_xla_extract_main_pkg.load_line_data_app_to_trx ()-
      arp_xla_extract_main_pkg.load_line_data_mcd()+
      arp_xla_extract_main_pkg.load_line_data_mcd()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()-
      ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()+
      ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()-
      ARP_XLA_EXTRACT_MAIN_PKG.extract()-
      event key = 227511-9036463-BDB5E9C3783F5721E0440015176F838C
      15-APR-2012 13:10:21 - extract hook executed successfully
      ***************************************************************************************************
      The following REVERSAL events could not be processed. The event/process status is U/U:
      Note: this warning may be ignored for any events whose ledger is a cash-basis ledger
      -------NO SUCH EVENTS-----------
      ***************************************************************************************************
      15-APR-2012 13:10:21 - executing postprocessing hook
      ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()+
      ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()-
      event key = 227511-9036463-BDB5E9C3783F5721E0440015176F838C
      15-APR-2012 13:10:21 - postprocessing hook executed successfully
      15-APR-2012 13:10:21 - Completing Journal Entries
      15-APR-2012 13:10:21 - Checking status of the parent Accounting Program
      15-APR-2012 13:10:21 - Dequeuing the unit from the queue
      15-APR-2012 13:10:22 - Fetching event information for the documents in the unit
      15-APR-2012 13:10:22 - executing extract hook
      ARP_XLA_EXTRACT_MAIN_PKG.extract()+
      p_application_id :222
      p_accounting_mode :F
      Calling upgrade_11i_r12_post +
      Get 11i application to upgrade
      End upgrade_11i_r12_post -
      arp_xla_extract_main_pkg.load_header_data_ctlgd ()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_ctlgd()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()-
      arp_xla_extract_main_pkg.load_line_data_app_from_cm ()+
      arp_xla_extract_main_pkg.load_line_data_app_from_cm ()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()-
      arp_xla_extract_main_pkg.load_line_data_app_from_cr()+
      arp_xla_extract_main_pkg.load_line_data_app_from_cr ()-
      arp_xla_extract_main_pkg.load_line_data_app_to_trx ()+
      arp_xla_extract_main_pkg.load_line_data_app_to_trx ()-
      arp_xla_extract_main_pkg.load_line_data_mcd()+
      arp_xla_extract_main_pkg.load_line_data_mcd()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()-
      ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()+
      ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()-
      ARP_XLA_EXTRACT_MAIN_PKG.mfar_hook ()+
      ARP_XLA_EXTRACT_MAIN_PKG.mfar_hook ()-
      ARP_XLA_EXTRACT_MAIN_PKG.extract()-
      event key = 227511-9036463-BDB5E9C378405721E0440015176F838C
      15-APR-2012 13:10:22 - extract hook executed successfully
      ***************************************************************************************************
      The following REVERSAL events could not be processed. The event/process status is U/U:
      Note: this warning may be ignored for any events whose ledger is a cash-basis ledger
      Event 84001003 of ledger 2021
      ***************************************************************************************************
      15-APR-2012 13:10:22 - executing postprocessing hook
      ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()+
      ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()-
      event key = 227511-9036463-BDB5E9C378405721E0440015176F838C
      15-APR-2012 13:10:22 - postprocessing hook executed successfully
      15-APR-2012 13:10:22 - Completing Journal Entries
      15-APR-2012 13:10:22 - Checking status of the parent Accounting Program
      15-APR-2012 13:10:22 - Dequeuing the unit from the queue
      15-APR-2012 13:10:23 - Fetching event information for the documents in the unit
      15-APR-2012 13:10:23 - executing extract hook
      ARP_XLA_EXTRACT_MAIN_PKG.extract()+
      p_application_id :222
      p_accounting_mode :F
      Calling upgrade_11i_r12_post +
      Get 11i application to upgrade
      End upgrade_11i_r12_post -
      arp_xla_extract_main_pkg.load_header_data_ctlgd ()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_ctlgd()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()-
      arp_xla_extract_main_pkg.load_line_data_app_from_cm ()+
      arp_xla_extract_main_pkg.load_line_data_app_from_cm ()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()-
      arp_xla_extract_main_pkg.load_line_data_app_from_cr()+
      arp_xla_extract_main_pkg.load_line_data_app_from_cr ()-
      arp_xla_extract_main_pkg.load_line_data_app_to_trx ()+
      arp_xla_extract_main_pkg.load_line_data_app_to_trx ()-
      arp_xla_extract_main_pkg.load_line_data_mcd()+
      arp_xla_extract_main_pkg.load_line_data_mcd()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()-
      ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()+
      ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()-
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()+
      ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()-
      ARP_XLA_EXTRACT_MAIN_PKG.mfar_hook ()+
      ARP_XLA_EXTRACT_MAIN_PKG.mfar_hook ()-
      ARP_XLA_EXTRACT_MAIN_PKG.extract()-
      event key = 227511-9036463-BDB5E9C378415721E0440015176F838C
      15-APR-2012 13:10:23 - extract hook executed successfully
      ***************************************************************************************************
      The following REVERSAL events could not be processed. The event/process status is U/U:
      Note: this warning may be ignored for any events whose ledger is a cash-basis ledger
      -------NO SUCH EVENTS-----------
      ***************************************************************************************************
      15-APR-2012 13:10:24 - executing postprocessing hook
      ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()+
      ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()-
      event key = 227511-9036463-BDB5E9C378415721E0440015176F838C
      15-APR-2012 13:10:24 - postprocessing hook executed successfully
      15-APR-2012 13:10:24 - Completing Journal Entries
      15-APR-2012 13:10:25 - Checking status of the parent Accounting Program
      15-APR-2012 13:10:25 - Dequeuing the unit from the queue
      15-APR-2012 13:10:25 - Submitting the transfer to GL
      GL Inerface tablename = XLA_GLT_1278635
      GL Inerface tablename = XLA_GLT_1278635
      tablename = XLA_GLT_1278635
      15-APR-2012 13:10:26- Submitting the Journal Import
      15-APR-2012 13:10:46- Journal Import completed
      15-APR-2012 13:10:46 - End of the transfer to GL
      15-APR-2012 13:10:46 - Unit Processor completed successfully ...
      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------


      ---------------------------------------------------------------------------
      Executing request completion options...


      Finished executing request completion options.

      ---------------------------------------------------------------------------
      Concurrent request completed
      Current system time is 15-APR-2012 12:47:57

      ---------------------------------------------------------------------------
        • 1. Re: Unit Processor completed normally with some events in error
          Kiran Gaddam
          No need to worry. We had the same issue earlier. It's the issue with Creating Accounting program and there is a patch for this. Please create a SR with Oracle, they will suggest you the right patch.

          Kiran
          • 2. Re: Unit Processor completed normally with some events in error
            Sesh Abhinand
            HI I am as well getting the similar error in AP 12.0.4, Can I know how you have resolved the issue ?

            ---------------------------------------------------------------------------
            Subledger Accounting: Version : 12.0.0

            Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

            XLAACCUP module: Accounting Program
            ---------------------------------------------------------------------------

            Current system time is 07-OCT-2012 14:24:46

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

            **Starts**07-OCT-2012 14:24:46
            **Ends**07-OCT-2012 14:24:53
            Unit Processor completed normally with some events in error
            ---------------------------------------------------------------------------
            Start of log messages from FND_FILE
            ---------------------------------------------------------------------------
            07-OCT-2012 14:24:46 - Executing Unit Processor ...
            07-OCT-2012 14:24:46 - Initializing variables
            07-OCT-2012 14:24:46 - Security Context Set
            07-OCT-2012 14:24:46 - Ready to cache the Application and Ledger Level Sources ...
            07-OCT-2012 14:24:48 - Cached the Application and Ledger Level Sources
            07-OCT-2012 14:24:48 - Entering the loop to read document units from the queue ...
            07-OCT-2012 14:24:48 - Checking status of the parent Accounting Program
            07-OCT-2012 14:24:48 - Dequeuing the unit from the queue
            07-OCT-2012 14:24:48 - Fetching event information for the documents in the unit
            07-OCT-2012 14:24:49 - executing extract hook
            event key = 20878-624045-CB7D3807C9A3260BE040060A3A017BBB
            07-OCT-2012 14:24:49 - extract hook executed successfully
            ***************************************************************************************************
            The following REVERSAL events could not be processed. The event/process status is U/U:
            Note: this warning may be ignored for any events whose ledger is a cash-basis ledger
            -------NO SUCH EVENTS-----------
            ***************************************************************************************************
            07-OCT-2012 14:24:51 - executing postprocessing hook
            event key = 20878-624045-CB7D3807C9A3260BE040060A3A017BBB
            07-OCT-2012 14:24:51 - postprocessing hook executed successfully
            07-OCT-2012 14:24:51 - Completing Journal Entries
            07-OCT-2012 14:24:52 - Checking status of the parent Accounting Program
            07-OCT-2012 14:24:52 - Dequeuing the unit from the queue
            07-OCT-2012 14:24:52 - Fetching event information for the documents in the unit
            07-OCT-2012 14:24:52 - executing extract hook
            event key = 20878-624045-CB7D3807C9A4260BE040060A3A017BBB
            07-OCT-2012 14:24:52 - extract hook executed successfully
            ***************************************************************************************************
            The following REVERSAL events could not be processed. The event/process status is U/U:
            Note: this warning may be ignored for any events whose ledger is a cash-basis ledger
            -------NO SUCH EVENTS-----------
            ***************************************************************************************************
            07-OCT-2012 14:24:53 - executing postprocessing hook
            event key = 20878-624045-CB7D3807C9A4260BE040060A3A017BBB
            07-OCT-2012 14:24:53 - postprocessing hook executed successfully
            07-OCT-2012 14:24:53 - Completing Journal Entries
            07-OCT-2012 14:24:53 - Checking status of the parent Accounting Program
            07-OCT-2012 14:24:53 - Dequeuing the unit from the queue
            07-OCT-2012 14:24:53 - Submitting the transfer to GL
            07-OCT-2012 14:24:53 - End of the transfer to GL
            07-OCT-2012 14:24:53 - Unit Processor completed successfully ...
            ---------------------------------------------------------------------------
            End of log messages from FND_FILE
            ---------------------------------------------------------------------------


            ---------------------------------------------------------------------------
            Executing request completion options...


            Finished executing request completion options.

            ---------------------------------------------------------------------------
            Concurrent request completed
            Current system time is 07-OCT-2012 14:24:53

            ---------------------------------------------------------------------------
            • 3. Re: Unit Processor completed normally with some events in error
              Hussein Sawwan-Oracle
              ***************************************************************************************************
              The following REVERSAL events could not be processed. The event/process status is U/U:
              Note: this warning may be ignored for any events whose ledger is a cash-basis ledger
              -------NO SUCH EVENTS-----------
              Please see these docs.

              Reversed Receipts fails XLAACCUP Accounting Program - The following REVERSAL events could not be processed [ID 1073836.1]
              Error: Reversal Events Could Not Be Processed The Event/Process Status Code Is U/U [ID 1298603.1]
              List Of Code Fixes - Uninvoiced Receipts Report (URR) & Receipt Accrual Period End Process [ID 1145884.1]
              'Reversal Events Cannot Be Processed' Warning in Subledger Create Accounting Program Log File [ID 1296409.1]
              Create Accounting Completes in Warning but There are No Accounting Errors [ID 1192300.1]

              Thanks,
              Hussein
              • 4. Re: Unit Processor completed normally with some events in error
                user120276
                I do have the same error.
                Kindly update the solution if anyone knows other than patch. I guess the Patch is not solution for this.

                Thanks,
                Aakash
                • 5. Re: Unit Processor completed normally with some events in error
                  Hussein Sawwan-Oracle
                  Kindly update the solution if anyone knows other than patch. I guess the Patch is not solution for this.
                  Do you have the patch applied or not? If not, please apply it and try then.

                  Thanks,
                  Hussein