3 Replies Latest reply on Aug 24, 2017 6:27 AM by George Manasseh

    Submitting Request to Create Accounting Program Error

    2772382

      Hi All Of Oracle Masters,

       

      Would You Please Help us to Solved our problem.We face the error while Submitting Request to Create Accounting Program on Receivables Manager.

       

      Requests is always Completed with "Error" Status. This is the log files from that errors :

       

      __________________________________________________________________________________________________________________________

       

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

      Subledger Accounting: Version : 12.2

       

       

      Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

       

       

      XLAACCUP: Accounting Program

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

       

       

      Current system time is 22-AUG-2017 16:23:09

       

       

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

       

       

      **Starts**22-AUG-2017 16:23:09

      **Ends**22-AUG-2017 16:23:26

      An internal error occurred.  Please inform your system administrator or support representative that:

       

       

      An internal error has occurred in the program xla_ar_acct_hooks_pkg.main.  Technical problem : Error encountered in product API for postprocessing

      .

      An internal error occurred.  Please inform your system administrator or support representative that:

       

       

      An internal error has occurred in the program xla_ar_acct_hooks_pkg.main.  Technical problem : Error encountered in product API for postprocessing

      .

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

      Start of log messages from FND_FILE

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

      22-AUG-2017 16:23:09 - Executing Unit Processor ...

      22-AUG-2017 16:23:09 - Initializing variables

      22-AUG-2017 16:23:09 - Security Context Set

      22-AUG-2017 16:23:09 - Ready to cache the Application and Ledger Level Sources ...

      22-AUG-2017 16:23:09 - Cached the Application and Ledger Level Sources

      22-AUG-2017 16:23:09 - AAD Package XLA_00222_AAD_C_011116_PKG is valid. Ledger Category is PRIMARY.

      22-AUG-2017 16:23:09 - Entering the loop to read document units from the queue ...

      22-AUG-2017 16:23:09 - Checking status of the parent Accounting Program

      22-AUG-2017 16:23:09 - Dequeuing the unit from the queue

      22-AUG-2017 16:23:09 - Fetching event information for the documents in the unit

      22-AUG-2017 16:23:09 - 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()-

      l_sob_id: -9999

      ARP_XLA_EXTRACT_MAIN_PKG.extract()-

      event key = 1352-9391577-575524C2961377D1E0531200A8C03EA8

      22-AUG-2017 16:23:09 - extract hook executed successfully

      22-AUG-2017 16:23:10 - executing postprocessing hook

      ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()+

      EXCEPTION OTHERS in arp_xla_extract_main_pkg.postprocessing

      Error      :ORA-08102: index key not found, obj# 192579, file 405, block 181143 (2)

      Technical problem : Error encountered in product API for postprocessing

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

      End of log messages from FND_FILE

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

       

       

       

       

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

      No completion options were requested.

       

       

      Output file size:

      0

       

       

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

      Concurrent request completed

      Current system time is 22-AUG-2017 16:23:26

       

       

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

       

      __________________________________________________________________________________________________________________________

       

      Would You Please Help Us to fix the problem?.

       

      Thank You