5 Replies Latest reply on Mar 23, 2016 9:11 PM by Bashar.

    Report error

    2907350

      Hi,

       

      reports are completed in error. I cannot find any errors in the log.

       

      image.png

      l1430470_SUNLimited_Yash.l1430470_SUNLimited_Yash

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

      Subledger Accounting: Version : 12.2

       

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

       

      XLAACCPB: Create Accounting

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

       

      Current system time is 23-MAR-2016 10:13:11

       

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

       

      XDO Data Engine Version No: 10.1.3.4.2

      Resp: 51072

      Org ID : 125

      Request ID: 1430470

      All Parameters: P_APPLICATION_ID=222:P_SOURCE_APPLICATION_ID=222:P_DUMMY=Y:P_LEDGER_ID=2075:P_PROCESS_CATEGORY_CODE=:P_END_DATE="2016/03/23 00:00:00":P_CREATE_ACCOUNTING_FLAG=Y:P_DUMMY_PARAM_1=Y:P_ACCOUNTING_MODE=F:P_DUMMY_PARAM_2=Y:P_ERRORS_ONLY_FLAG=N:P_REPORT_STYLE=N:P_TRANSFER_TO_GL_FLAG=Y:P_DUMMY_PARAM_3=Y:P_POST_IN_GL_FLAG=Y:P_GL_BATCH_NAME=:P_MIN_PRECISION=:P_INCLUDE_ZERO_AMOUNT_LINES=N:P_REQUEST_ID=:P_ENTITY_ID=:P_SOURCE_APPLICATION_NAME=Receivables:P_APPLICATION_NAME=Receivables:P_LEDGER_NAME=Sun Ltd Ledger:P_PROCESS_CATEGORY_NAME=:P_CREATE_ACCOUNTING=Yes:P_ACCOUNTING_MODE_NAME=Final:P_ERRORS_ONLY=No:P_ACCOUNTING_REPORT_LEVEL=No Report:P_TRANSFER_TO_GL=Yes:P_POST_IN_GL=Yes:P_INCLUDE_ZERO_AMT_LINES=No:P_VALUATION_METHOD_CODE=:P_SECURITY_INT_1=:P_SECURITY_INT_2=:P_SECURITY_INT_3=:P_SECURITY_CHAR_1=:P_SECURITY_CHAR_2=:P_SECURITY_CHAR_3=:P_CONC_REQUEST_ID=:P_INCLUDE_USER_TRX_ID_FLAG=N:P_INCLUDE_USER_TRX_IDENTIFIERS=No:DebugFlag=N:P_USER_ID=1363:ScalableFlag=N:P_LAUNCH_BALANCE_PROGRAM=Y:P_LAUNCH_BAL_PROGRAM=Yes

      Data Template Code: XLAACCPB

      Data Template Application Short Name: XLA

      Debug Flag: N

      {P_ACCOUNTING_REPORT_LEVEL=No Report, P_DUMMY=Y, P_ACCOUNTING_MODE_NAME=Final, P_ERRORS_ONLY_FLAG=N, P_REPORT_STYLE=N, P_GL_BATCH_NAME=, P_END_DATE=2016/03/23 00:00:00, P_SECURITY_INT_3=, P_SECURITY_INT_2=, P_SECURITY_INT_1=, P_VALUATION_METHOD_CODE=, P_LAUNCH_BAL_PROGRAM=Yes, P_POST_IN_GL=Yes, P_TRANSFER_TO_GL=Yes, P_TRANSFER_TO_GL_FLAG=Y, P_INCLUDE_USER_TRX_IDENTIFIERS=No, P_USER_ID=1363, P_PROCESS_CATEGORY_NAME=, P_ERRORS_ONLY=No, P_DUMMY_PARAM_3=Y, P_SECURITY_CHAR_3=, P_DUMMY_PARAM_2=Y, P_SECURITY_CHAR_2=, P_DUMMY_PARAM_1=Y, P_SECURITY_CHAR_1=, P_ENTITY_ID=, P_PROCESS_CATEGORY_CODE=, P_INCLUDE_ZERO_AMT_LINES=No, P_LEDGER_ID=2075, P_POST_IN_GL_FLAG=Y, P_APPLICATION_ID=222, P_INCLUDE_USER_TRX_ID_FLAG=N, P_APPLICATION_NAME=Receivables, P_REQUEST_ID=, P_CONC_REQUEST_ID=, P_LEDGER_NAME=Sun Ltd Ledger, P_LAUNCH_BALANCE_PROGRAM=Y, P_SOURCE_APPLICATION_ID=222, P_CREATE_ACCOUNTING=Yes, P_CREATE_ACCOUNTING_FLAG=Y, P_MIN_PRECISION=, P_SOURCE_APPLICATION_NAME=Receivables, P_INCLUDE_ZERO_AMOUNT_LINES=N, P_ACCOUNTING_MODE=F}

      Calling XDO Data Engine...

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

      Start of log messages from FND_FILE

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

      23-MAR-2016 10:21:47 - FND: Debug Log Enabled : No

      23-MAR-2016 10:21:47 - Beginning of the Report

      23-MAR-2016 10:21:47 - Starting of the Parent Thread

      Starting main program for the source application = 222

      23-MAR-2016 10:21:47 - Dynamic conditions built

      23-MAR-2016 10:21:47 - Event Applications Determined

      23-MAR-2016 10:21:47 - Security Context Set

      23-MAR-2016 10:21:47 - Session Identifier Set

      23-MAR-2016 10:21:47 - Setup for the ledger and Event applications Read

      23-MAR-2016 10:21:47 - executing preaccounting hook

      arp_xla_extract_main_pkg.preaccounting()+

        p_application_id    :222

        p_ledger_id         :2075

        p_process_category  :

        p_end_date          :23-MAR-16

        p_accounting_mode   :F

        p_valuation_method  :

        p_security_id_int_1 :

        p_security_id_int_2 :

        p_security_id_int_3 :

        p_security_id_char_1:

        p_security_id_char_2:

        p_security_id_char_3:

        p_report_request_id :

      arp_xla_extract_main_pkg.preaccounting -

      event key = 7217-1430470

      23-MAR-2016 10:21:47 - preaccounting hook executed successfully

      23-MAR-2016 10:21:47 - Pre-Accounting steps performed

      23-MAR-2016 10:21:47 - Queue Created = XLA.XLA_1430470_DOC_Q

      23-MAR-2016 10:21:47 - Queue Created = XLA.XLA_1430470_COMP_Q

      23-MAR-2016 10:21:47 - Queue Started = XLA.XLA_1430470_DOC_Q

      23-MAR-2016 10:21:47 - Queue Started = XLA.XLA_1430470_COMP_Q

      23-MAR-2016 10:21:47 - Global Context Initialized

      23-MAR-2016 10:21:47 - Calling sequencing batch_init

      23-MAR-2016 10:21:47 - Returned from sequencing batch_init

      23-MAR-2016 10:21:47 - Begin enqueue

      23-MAR-2016 10:21:47 - Ready to Enqueue documents in the queue

      23-MAR-2016 10:21:47 - Ready to Enqueue documents in the queue

      23-MAR-2016 10:21:47 - Spawning unit processors

      23-MAR-2016 10:21:47 - Unit processors spawned

      23-MAR-2016 10:21:51 - Ready to Enqueue documents in the queue

      23-MAR-2016 10:22:51 - Enqueueing completed

      23-MAR-2016 10:22:51 - Waiting for Unit Processor requests to complete

      23-MAR-2016 10:22:51 -  Child Threads completed

      23-MAR-2016 10:22:51 - Global Context cleared

      23-MAR-2016 10:22:51 - Queue stopped = XLA.XLA_1430470_DOC_Q

      23-MAR-2016 10:22:51 - Queue stopped = XLA.XLA_1430470_COMP_Q

      23-MAR-2016 10:22:51 - Queue dropped = XLA.XLA_1430470_DOC_Q

      23-MAR-2016 10:22:51 - Queue dropped = XLA.XLA_1430470_COMP_Q

      23-MAR-2016 10:22:51 - Calling sequencing batch_exit

      23-MAR-2016 10:22:51 - Returned from sequencing batch_exit

      23-MAR-2016 10:22:51 - Executed post-accounting routine

      23-MAR-2016 10:22:51 -  Accounting Program completed successfully

      23-MAR-2016 10:22:51 - executing postaccounting hook

      event key = 7217-1430470

      23-MAR-2016 10:22:51 - postaccounting hook executed successfully

      - Accounting Time = 64.19 secs

      - Transfer Time   = 0 secs

      23-MAR-2016 10:22:51 - End of the Report

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

      End of log messages from FND_FILE

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

       

       

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

      Executing request completion options...

       

      Output file size:

      2015

       

       

      Finished executing request completion options.

       

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

      Concurrent request completed

      Current system time is 23-MAR-2016 10:22:59

       

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

       

       

      Thanks,

      Roshan

        • 1. Re: Report error
          J. Darwish

          Hi,

           

          Submit the Create accounting program again but this time enter the 'Report' Parameter as "Detail".

          Click on View output and attach the file if any and attach the log file.

           

          Regards,

          • 2. Re: Report error
            2907350

            This request finished with an error and produced the following completion message: The journal entry cannot be saved.  Please inform your system admiministrator or support representative that:

             

             

            The Accounting Program for Oracle Subledger Accounting cannot successfully save the entry for technical reasons. ORA-01502: inde

             

             

            The processing began on 23-MAR-2016 10:28:59 and ended on 23-MAR-2016 10:29:01. You may find more information on the cause of the error in the request log or the concurrent manager log.

            • 3. Re: Report error
              Bashar.

              You have unusable index(s). Use this query to find them and run the resulting SQL statements to correct the issue:

               

              select 'alter index ' || owner || '.' || index_name || ' rebuild;' rebuild_idx

              from dba_indexes

              where status = 'UNUSABLE';

               

              Regards,

              Bashar

              • 4. Re: Report error
                2907350

                Result = none

                 

                Capture.PNG

                • 5. Re: Report error
                  Bashar.

                  The error you posted clearly mentions that index "XLA_AE_LINES_U1" is in an unusable state.

                   

                  Please post the output of this query:

                   

                  select * from dba_indexes

                  where index_name = 'XLA_AE_LINES_U1';

                   

                  Regards,

                  Bashar