R12.2.X: Performance Issues for Create Settlement Batches program
Last updated on NOVEMBER 22, 2014
Applies to:Oracle Payments - Version 12.2 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.
Users experiencing serious performance issue with the create settlement batches process.
It runs more than a day for only one transaction.
According to the trace file, the following is the most expensive query:
FROM ar_document_lines_v inv_line,ar_docs_receivables_v inv_header,
WHERE(inv_header.doc_unique_ref = inv_line.doc_unique_ref(+))
AND(txn.initiator_extension_id = inv_header.order_ext_id)
AND(txn.trxntypeid IN('8', '9', '100'))
AND(txn.mbatchid = :1)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms