Statement Generation Process Has Poor Performance (Doc ID 370333.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Receivables - Version 11.5.9 to 11.5.10.3 [Release 11.5.9 to 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 01-Apr-2013***

Symptoms

Statement Generation Program has performance issues.
- Process executes for an extended period of time and fails with ORA-01555 Snapshot too old.
- Poor Performing sql identified after tracing the process:

UPDATE /*+ INDEX(art3 AR_AE_ALLOC_REC_GT_N3) */ ar_ae_alloc_rec_gt art3 set
art3.ae_tax_link_id = decode(:b7, 'Y', :b2, ''), art3.ae_tax_link_id_ed_adj =
decode(:b6, 'Y', :b2, art3.ae_tax_link_id_ed_adj), art3.ae_tax_link_id_uned =
decode(:b5, 'Y', decode(:b4, 'Y', :b3, :b2), art3.ae_tax_link_id_uned),
art3.ae_counted_flag = 'Y' where ae_id = :b1 and art3.ae_account_class = 'TAX'
and art3.ae_counted_flag = 'N'


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