Performance issue on "Settlement Batch Accompanying Letter" program (Doc ID 2251476.1)

Last updated on APRIL 04, 2017

Applies to:

Oracle Payments - Version 12.1.0 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Following is the SQL which is causing this performance issue.

SELECT /*+ NO_MERGE(inv_header) PUSH_PRED(inv_header)
OPT_PARAM('_optimizer_join_factorization','FALSE')*/
inv_header.TRX_NUMBER,inv_header.document_date,
inv_header.creation_date,
inv_header.document_type,
inv_header.document_description,
inv_header.document_amount,
inv_header.document_currency_code,
inv_header.settlement_amount,
inv_header.discount_amount,inv_header.freight_amount,null,inv_header.local_tax_amount,
inv_header.national_tax_amount,
inv_header.vat_tax_amount,
null,
null,
null,
null,
null,
null,
null,
null,null,null,null,null,null,null,null,null,null,
txn.transactionid,
txn.initiator_extension_id,
inv_header.doc_unique_ref,
inv_header.BR_DRAWEE_ISSUED_FLAG,
inv_header.BR_SIGNED_FLAG
,null,null,null,null,null,null FROM ARBR_DOCS_RECEIVABLES_V inv_header,
iby_trxn_summaries_all txn WHERE txn.initiator_extension_id =
inv_header.order_ext_id
AND(txn.trxntypeid IN('8', '9', '100'))
AND(txn.mbatchid = :1)

 

Changes

 The hint in the select query while inserting data in gt table is not required for BILLS RECEIVABLE.

Cause

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