R12 AP: Poor Performance : 'Upgrade Historical Subledger Transaction Accounting' for Payables
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***
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