Aging - 4 Buckets Report - Performance Issues
(Doc ID 2596204.1)
Last updated on OCTOBER 07, 2019
Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
Performance issues when running the Aging 4 Buckets Report
Top query identified is:
SQL ID: 2pnytmxxsjwna Plan Hash: 569605030
select ps . org_id invoice_org_id , decode ( UPPER ( : p_order_by ) ,
'CUSTOMER' , NULL , types . cust_trx_type_id ) dummy_id_inv , decode (
UPPER ( : p_order_by ) , 'CUSTOMER' , NULL , types . name ) dummy_type_inv ,
decode ( party . party_name , null , '2' , rtrim ( rpad ( substrb ( '1' ||
party . party_name , 1 , 50 ) , 36 ) ) ) customer_name_inv , cust_acct .
cust_account_id customer_id_inv , cust_acct . account_number
Tkprof shows a full table scan in AR_RECEIVABLE_APPLICATIONS_ALL and AR_PAYMENT_SCHEDULES_ALL
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.