EGL 9.1 Allocation(FS_ALLC): Warning: Unable To Perform Commit - Forcing Use Of Base Table After Upgrade To 9.1 When Temporary Tables Are Available. (Doc ID 1307491.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.
***Checked for relevance on 28-Nov-2012***
***Checked for relevance on 13-MAY-2014***
***Checked for Currency on 19-OCT-2015***

Symptoms

Release 9.1, Bundle 7

Issue
=====
Unreasonable amount of user review required to evaluate if any action is required on their part where the warnings never existed before.

Steps:

=====

  1) Define Allocation step with edit, post and budject check boxes checked on.
  2) Define allocation group
  3) Run allocation process.
  4) Process goes to success but there are warning messages in Trace when there the Edit check box is checked "ON".


Error
=====
No errors but warnings. Many regarding the TAO temp tables using the base table.  This is the warning message:

WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE ......


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