EGL9.2: Getting Warning Messages Related to Summary Ledger Temp Tables While Journal Posting is invoked by Journal Generator, Allocations, Multicurrency Processing etc (Doc ID 2224308.1)

Last updated on SEPTEMBER 24, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:
-------

While running Journal generator for any subsystem with Edit & Post checked to update ledger & summary ledger encountered a no of warnings related to temp tables that are used in summary ledger processing.

Steps to Replicate:
---------------------
1. Make sure to have Accounting entries in the Accounting entry record for any subsystem.
2. Make set up related to summary ledger & Build summary ledger.
3. In General Ledger User preferences under Journal post defaults section make sure 'Skip Summary Ledger Update' flag is unchecked.
4. Run Journal generator for the subsystem to pick up the accounting entries.
5. Check the outfile of Journal generator to see if there are any warnings.

Please see Replication screenshots for more details.

Actual Behavior:
-------------------

In the out file, following warning messages could be seen:

WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR GL_INCR_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR INCR_LEDB_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR INCR_LED_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_GRPD_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_GRPT_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_GRP_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S01_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S02_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S03_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S04_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S05_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S06_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S07_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S08_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S09_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S10_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S11_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S12_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S13_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S14_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S15_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S16_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S17_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S18_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S19_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S20_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S21_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S22_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S23_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S24_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S25_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S26_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S27_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S28_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S29_TAO
WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR SUML_S30_TAO

Expected Behavior:
-------------------

No warning messages should appear.

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