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 18.104.22.168 [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