My Oracle Support Banner

R12 AP: Poor Performance : 'Upgrade Historical Subledger Transaction Accounting' for Payables (Doc ID 1370490.1)

Last updated on FEBRUARY 26, 2019

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:








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
 Standard patching Process
 Patch Wizard
 Still have Questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.