EGL9.0 - 9.1: Multi-currency Process(FSPCCURR) Not Releasing Non-Shared Temp Tables

(Doc ID 1348245.1)

Last updated on FEBRUARY 08, 2018

Applies to:

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

Symptoms

Issue:
-------

Non-shared temp tables CURR_WRK_RT, CURR_WRK_TBL, CURR_WRK1_TBL, TREE_SEL_10_R are still locked even though multi-currency process completed successfully.

Steps to Replicate:
---------------------
1. Set up multi-currency revaluation/translation steps
2. Include the steps in a multi-currency process group
3. Request to run multi-currency process


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

Non-shared temp tables CURR_WRK_RT, CURR_WRK_TBL, CURR_WRK1_TBL, TREE_SEL_10_R are locked after process completes.

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

Non-shared temp tables should be released by process after use

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