R12 AP: Create Accounting Performance Issue For Multi Period Accounting (Doc ID 1511087.1)

Last updated on DECEMBER 25, 2015

Applies to:

Oracle Payables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 25-Dec-2015***

Symptoms



Performance problem:
For Multi period accounting Create Accounting Program is taking too long time and then is getting error out.

Submit the Create Accounting program, and it spawns the Accounting program, which runs for hours (5, 10 and so far still going) - before ending in error.

The log file shows this message:

 

"An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program XLA_AE_JOURNAL_ENTRY_PKG.AdjustMpaLine. ORA-30036: unable to extend segment by 8 in undo tab
An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program XLA_AE_JOURNAL_ENTRY_PKG.AdjustMpaLine. ORA-30036: unable to extend segment by 8 in undo tab"
and we have asked the DBA to increase the undo tablespace.


Cause

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