R12 AP: Poor Performance : 'Upgrade Historical Subledger Transaction Accounting' for Payables

(Doc ID 1370490.1)

Last updated on JANUARY 16, 2018

Applies to:

Oracle Payables - Version 12.1.2 and later
Information in this document applies to any platform.
***Checked for relevance on 06-Jan-2016***


Performance issue:

Upgrade Historical Subledger Transaction Accounting for Payables
runs for 30+ hours and then it fails.

Upgrade Historical Subledger Transaction Accounting ( XLAONDEUPG )
spawns the following process :
Payables SLA On Demand Upgrade Child Process ( APXLASUB )

The XLAONDEUPG fails because the child process (APXLASUB) fails.

The APXLASUB log file shows that after 30+ hours of running,
this process failed with the following error:

Error: -1555: ORA-01555: snapshot too old: rollback segment number 16 with
name "_SYSSMU16_1313346263$" too small

The versions are the following:

AP_XLA_UPGRADE_PKG -- $Header: apxlaupb.pls 120.12.12010000.7
XLA_UPGRADE_PUB -- $Header: xlaugupg.pkb 120.41.12010000.7



The slow SQL statements are the following:






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