Statement Generation Process Has Poor Performance
Last updated on JUNE 08, 2016
Applies to:Oracle Receivables - Version 11.5.9 to 188.8.131.52 [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'
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms