PRC: Create accounting is taking a long time
hi
PRC: Create Accounting is taking a very long time for finishing. I am attaching the log file and the status is still Running: Normal
Also I have checked the back-end
select * from apps.fnd_concurrent_requests
where request_id = 154891681.
Phase code is 'R' and Status Code is 'R'
+---------------------------------------------------------------------------+
Projects: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
PAXACCPB module: PRC: Create Accounting
+---------------------------------------------------------------------------+
Current system time is 13-SEP-2015 23:47:57
+---------------------------------------------------------------------------+
XDO Data Engine Version No: 5.6.3
Resp: 53660
Org ID : 102
Request ID: 154891681
All Parameters: P_SOURCE_APPLICATION_ID=275:P_APPLICATION_ID=275:P_DUMMY=Y:P_LEDGER_ID=1001:P_PROCESS_CATEGORY_CODE=MISCELLANEOUS_COST:P_END_DATE=2015/09/13: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=S: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=:P_APPLICATION_NAME=:P_LEDGER_NAME=:P_PROCESS_CATEGORY_NAME=:P_CREATE_ACCOUNTING=:P_ACCOUNTING_MODE_NAME=Final:P_ERRORS_ONLY=:P_ACCOUNTING_REPORT_LEVEL=:P_TRANSFER_TO_GL=:P_POST_IN_GL=:P_INCLUDE_ZERO_AMT_LINES=:P_VALUATION_METHOD_CODE=:P_SECURITY_INT_1=145:P_SECURITY_INT_2=:P_SECURITY_INT_1=: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=N:P_USER_ID=1173