0 Replies Latest reply on Sep 3, 2015 9:49 AM by Williams Oluwafemi

    journal import not completinig

    Williams Oluwafemi

      Hi everyone,  

       

      Please my user sent me the bellow (2 in 1) message, journal import not completing and a program running for too long.

       

       

       

       

      Please respond. Journals import isn’t completing

       

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

      Subledger Accounting: Version : 12.0.0

       

      XLAACCUP module: Accounting Program

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

       

      Current system time is 02-SEP-2015 13:35:22

       

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

       

      **Starts**02-SEP-2015 13:35:22

      **Ends**02-SEP-2015 15:22:44

       

      02-SEP-2015 13:34:34 - Executing Unit Processor ...

      02-SEP-2015 13:34:34 - Initializing variables

      02-SEP-2015 13:34:34 - Security Context Set

      02-SEP-2015 13:34:34 - Ready to cache the Application and Ledger Level Sources ...

      02-SEP-2015 13:34:35 - Cached the Application and Ledger Level Sources

      02-SEP-2015 13:34:35 - Entering the loop to read document units from the queue ...

      02-SEP-2015 13:34:35 - Checking status of the parent Accounting Program

      02-SEP-2015 13:34:35 - Dequeuing the unit from the queue

      02-SEP-2015 13:34:35 - Fetching event information for the documents in the unit

      02-SEP-2015 13:34:35 - executing extract hook

      event key = 1459-22518687-1EC8E9A3C8EC70A8E0530A010D3B70A8

      02-SEP-2015 13:34:39 - extract hook executed successfully

       

      02-SEP-2015 13:34:53 - executing postprocessing hook

      event key = 1459-22518687-1EC8E9A3C8EC70A8E0530A010D3B70A8

      02-SEP-2015 13:34:53 - postprocessing hook executed successfully

      02-SEP-2015 13:34:53 - Completing Journal Entries

      02-SEP-2015 13:34:53 - Checking status of the parent Accounting Program

      02-SEP-2015 13:34:53 - Dequeuing the unit from the queue

      02-SEP-2015 13:34:53 - Fetching event information for the documents in the unit

      02-SEP-2015 13:34:53 - executing extract hook

      event key = 1459-22518687-1EC8E9A3C8ED70A8E0530A010D3B70A8

      02-SEP-2015 13:34:54 - extract hook executed successfully

       

      02-SEP-2015 13:34:56 - executing postprocessing hook

      event key = 1459-22518687-1EC8E9A3C8ED70A8E0530A010D3B70A8

      02-SEP-2015 13:34:56 - postprocessing hook executed successfully

      02-SEP-2015 13:34:56 - Completing Journal Entries

      02-SEP-2015 13:34:56 - Checking status of the parent Accounting Program

      02-SEP-2015 13:34:56 - Dequeuing the unit from the queue

      02-SEP-2015 13:34:56 - Submitting the transfer to GL

      GL Inerface tablename = XLA_GLT_76118

      GL Inerface tablename = XLA_GLT_76118

      tablename = XLA_GLT_76118

      02-SEP-2015 13:34:59- Submitting the Journal Import

      02-SEP-2015 15:21:56 -  End of the transfer to GL

      02-SEP-2015 15:21:56 - Unit Processor completed successfully ...

       

      Current system time is 02-SEP-2015 15:22:44

       

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





      and





      image001.png



       

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

      Assets: Version : 12.0.0

       

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

       

      FAACCPB module: Create Accounting - Assets

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

       

      Current system time is 02-SEP-2015 13:34:41

       

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

       

      XDO Data Engine Version No: 5.6.3

      Resp: 50537

      Org ID : 81

      Request ID: 22518687

      All Parameters: P_VALUATION_METHOD_CODE=ACCESSBANKBOOK2:P_SOURCE_APPLICATION_ID=140:P_APPLICATION_ID=140:P_DUMMY=Y:P_LEDGER_ID=2024:P_PROCESS_CATEGORY_CODE=ADDITIONS:P_END_DATE="2015/09/02 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=D:P_TRANSFER_TO_GL_FLAG=Y:P_DUMMY_PARAM_3=Y:P_POST_IN_GL_FLAG=N:P_GL_BATCH_NAME=AUGUST ADDITIONS:P_MIN_PRECISION=:P_INCLUDE_ZERO_AMOUNT_LINES=N:P_REQUEST_ID=:P_ENTITY_ID=:P_SOURCE_APPLICATION_NAME=Assets:P_APPLICATION_NAME=Assets:P_LEDGER_NAME=ACCESS:P_PROCESS_CATEGORY_NAME=Additions:P_CREATE_ACCOUNTING=Yes:P_ACCOUNTING_MODE_NAME=Final:P_ERRORS_ONLY=No:P_ACCOUNTING_REPORT_LEVEL=Detail:P_TRANSFER_TO_GL=Yes:P_POST_IN_GL=No:P_INCLUDE_ZERO_AMT_LINES=No: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=:P_USER_ID=1130

      Data Template Code: FAACCPB

      Data Template Application Short Name: OFA

      Debug Flag:

      {P_ACCOUNTING_REPORT_LEVEL=Detail, P_DUMMY=Y, P_ACCOUNTING_MODE_NAME=Final, P_ERRORS_ONLY_FLAG=N, P_REPORT_STYLE=D, P_GL_BATCH_NAME=AUGUST ADDITIONS, P_END_DATE=2015/09/02 00:00:00, P_SECURITY_INT_3=, P_SECURITY_INT_2=, P_SECURITY_INT_1=, P_VALUATION_METHOD_CODE=ACCESSBANKBOOK2, P_POST_IN_GL=No, P_TRANSFER_TO_GL=Yes, P_TRANSFER_TO_GL_FLAG=Y, P_INCLUDE_USER_TRX_IDENTIFIERS=No, P_USER_ID=1130, P_PROCESS_CATEGORY_NAME=Additions, 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=ADDITIONS, P_INCLUDE_ZERO_AMT_LINES=No, P_LEDGER_ID=2024, P_POST_IN_GL_FLAG=N, P_APPLICATION_ID=140, P_INCLUDE_USER_TRX_ID_FLAG=N, P_APPLICATION_NAME=Assets, P_REQUEST_ID=, P_CONC_REQUEST_ID=, P_LEDGER_NAME=ACCESS, P_SOURCE_APPLICATION_ID=140, P_CREATE_ACCOUNTING=Yes, P_CREATE_ACCOUNTING_FLAG=Y, P_MIN_PRECISION=, P_SOURCE_APPLICATION_NAME=Assets, P_INCLUDE_ZERO_AMOUNT_LINES=N, P_ACCOUNTING_MODE=F}

      Calling XDO Data Engine...