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***

Symptoms



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:

 

XLAONDEUPG

 

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 Standard patching Process
 Patch Wizard
 Still have Questions?
References


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