EAR9.0: ARUPDATE Warning Message 'UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE' (Doc ID 825366.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9 to 9 [Release 9]
Information in this document applies to any platform.
*** Proactive Support Update 25-Jul-2011 ***
*** Checked for Relevance 28-Oct-2010 ***
***Checked for Relevance on 26-Jun-2013***
***Checked for Relevance on 27-Nov-2014***

Symptoms

PeopleSoft Receivables Information Center 1343389.2

ARUPDATE produces a warning about Forcing use of base table for COMB_EXP_TAO, COMB_S30_TAO and FS_GRRULE_TAO.

After running ARUPDATE, the log has the following messages:
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR COMB_EXP_TAO (108,541)
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR COMB_S30_TAO (108,541)
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR FS_GRRULE_TAO (108,541)


EXPECTED BEHAVIOR
-----------------------
When ARUPDATE runs, there should not be any warning message for these tables COMB_EXP_TAO, COMB_S30_TAO and FS_GRRULE_TAO

ACTUAL BEHAVIOR
-----------------------
When ARUPDATE runs, there is always warning message for these tables COMB_EXP_TAO, COMB_S30_TAO and FS_GRRULE_TAO

STEPS
-----------------------
By following these steps the issue can be reproduced:

  1. Create an item.
  2. Run ARUPDATE to post the item.
  3. ARUPDATE is successful, but Message log has a warning message

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