My Oracle Support Banner

Statement Generation Process Has Poor Performance (Doc ID 370333.1)

Last updated on FEBRUARY 13, 2019

Applies to:

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


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'


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.