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***
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|
|Still have Questions?|