My Oracle Support Banner

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

Last updated on MARCH 04, 2019

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

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.