REIMPOSTING Batch Starts Too Many Threads
(Doc ID 2989085.1)
Last updated on NOVEMBER 24, 2023
Applies to:
Oracle Retail Invoice Matching - Version 19.0.1 and laterInformation in this document applies to any platform.
Symptoms
REIMPOSTING batch starts many threads (more than 100) which runs in parallel and execute the same SQL statement:
"DELETE FROM IM_POSTING_DOC_ACCOUNTS IPDA
WHERE POSTING_AMT_ID NOT IN (SELECT POSTING_AMT_ID
FROM IM_POSTING_DOC_ERRORS IPDE, IM_POSTING_DOC_AMOUNTS IPDAMT
WHERE IPDE.POSTING_ID = IPDAMT.POSTING_ID
AND IPDAMT.POSTING_ID = :1 ) "
This is leading to performance issue.
Changes
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 |
Changes |
Cause |
Solution |
References |