R12: AP: Oracle Payables Command Center Incremental Data Load Is Having Bad Performance.
(Doc ID 2828243.1)
Last updated on NOVEMBER 20, 2023
Applies to:
Oracle Enterprise Command Center Framework - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
Oracle Payables Command Center Incremental Data Load is having bad performance.
Oracle ECC Payables Incremental Data Load is taking ~12 hrs with Trace enabled and log level as Trace, ~7 hrs with Log Level as Error and trace disabled.
EXPECTED BEHAVIOR
-----------------------
Expect ECC Payables Incremental Data Load not to take this long.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
- Navigate to "CDC AP Invoice Entry".
- Launch a new SRS request "Payables Command Center Data Load" and pass parameters:
- Load Type : INCREMENTAL_LOAD, Log Level : Error >> This ran for ~7 hrs.
- Load Type : INCREMENTAL_LOAD, Log Level : Trace, SQL Trace : TRUE >> This ran for ~ 12 hrs.
Concurrent program Log file shows the following:
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
ECCRUNDL: ECC Run Data Load
+---------------------------------------------------------------------------+
Current system time is 31-AUG-2021 01:58:53
+---------------------------------------------------------------------------+
CP main executing runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP
APPS_FRAMEWORK_AGENT: https://ufmsproject.hhs.gov:443
datasetsForSerialLangsProfile is empty
Parameter [name:pSystemId, value:EBS]
Parameter [name:pAppShortName, value:ap]
Parameter [name:pDataSetKey, value:]
Parameter [name:pLoadType, value:INCREMENTAL_LOAD]
Parameter [name:pLang, value:]
Parameter [name:pTraceFlag, value:TRUE]
Parameter [name:pLogLevel, value:TRACE]
Parameter [name:Parameter1, value:]
Parameter [name:Parameter2, value:]
Parameter [name:Parameter3, value:]
Parameter [name:Parameter4, value:]
Parameter [name:Parameter5, value:]
Parameter [name:Parameter6, value:]
Parameter [name:Parameter7, value:]
Parameter [name:Parameter8, value:]
Parameter [name:Parameter9, value:]
Parameter [name:Parameter10, value:]
Parameter [name:Parameter11, value:]
Parameter [name:Parameter12, value:]
Parameter [name:Parameter13, value:]
Parameter [name:Parameter14, value:]
Parameter [name:Parameter15, value:]
Parameter [name:pLastRunDateIdentifier, value:]
Parameter [name:pForceCreate, value:]
Concurrent request ID is 98246484
PARAMETERS LIST :
SystemId -> EBS
Application Short Name -> ap
Load Type -> INCREMENTAL_LOAD
DataSet Key ->
Language ->
Trace Flag -> TRUE
Force Create Flag ->
Last Run Date Identifier ->
Log Level -> TRACE
Running Incremental Load
DEBUG: ECC service url: https://ufmsproject.hhs.gov:443/ecc/ir/data/ap/datasets
?loadType=INCREMENTAL_LOAD&sqlTrace=true&logLevel=TRACE&updateLastRunDate=true
&forceCreate=true&reqId=98246484&&gfmString=X_xxbuPsGBks60VLVgh46A..
JobId -> 37118
...
...
Error Details: <-- END --->
CP main completed runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested.
Output file size: 151508
+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 31-AUG-2021 13:38:08
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
ECCRUNDL: ECC Run Data Load
+---------------------------------------------------------------------------+
Current system time is 31-AUG-2021 01:58:53
+---------------------------------------------------------------------------+
CP main executing runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP
APPS_FRAMEWORK_AGENT: https://ufmsproject.hhs.gov:443
datasetsForSerialLangsProfile is empty
Parameter [name:pSystemId, value:EBS]
Parameter [name:pAppShortName, value:ap]
Parameter [name:pDataSetKey, value:]
Parameter [name:pLoadType, value:INCREMENTAL_LOAD]
Parameter [name:pLang, value:]
Parameter [name:pTraceFlag, value:TRUE]
Parameter [name:pLogLevel, value:TRACE]
Parameter [name:Parameter1, value:]
Parameter [name:Parameter2, value:]
Parameter [name:Parameter3, value:]
Parameter [name:Parameter4, value:]
Parameter [name:Parameter5, value:]
Parameter [name:Parameter6, value:]
Parameter [name:Parameter7, value:]
Parameter [name:Parameter8, value:]
Parameter [name:Parameter9, value:]
Parameter [name:Parameter10, value:]
Parameter [name:Parameter11, value:]
Parameter [name:Parameter12, value:]
Parameter [name:Parameter13, value:]
Parameter [name:Parameter14, value:]
Parameter [name:Parameter15, value:]
Parameter [name:pLastRunDateIdentifier, value:]
Parameter [name:pForceCreate, value:]
Concurrent request ID is 98246484
PARAMETERS LIST :
SystemId -> EBS
Application Short Name -> ap
Load Type -> INCREMENTAL_LOAD
DataSet Key ->
Language ->
Trace Flag -> TRUE
Force Create Flag ->
Last Run Date Identifier ->
Log Level -> TRACE
Running Incremental Load
DEBUG: ECC service url: https://ufmsproject.hhs.gov:443/ecc/ir/data/ap/datasets
?loadType=INCREMENTAL_LOAD&sqlTrace=true&logLevel=TRACE&updateLastRunDate=true
&forceCreate=true&reqId=98246484&&gfmString=X_xxbuPsGBks60VLVgh46A..
JobId -> 37118
...
...
Error Details: <-- END --->
CP main completed runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested.
Output file size: 151508
+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 31-AUG-2021 13:38:08
+---------------------------------------------------------------------------+
NOTICE: The Log Starting at 31-AUG-2021 01:58:53 and Ending at 31-AUG-2021 13:38:08. More than eleven (11+) hours of execution
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |