EGL: 9.0 FSPCCURR Not Releasing Non-Shared Tables After Applying Bundles. (Doc ID 1348245.1)

Last updated on MARCH 14, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9 and later
Information in this document applies to any platform.

Symptoms



Environment
==============
FSCM 9 bundle #31
PT 8.49

Sequence of events
=================
1. Apply bundles 29-31 to FSCM 9 environment
2. Process multicurrency (FSPCCURR) job
3. The non-shared tables curr_wrk_rt, curr_wrk_tbl, curr_wrk1_tbl and tree_sel10_r are still locked even though the process completed successfully.

Error
=====
None

What works
==========
Multicurrency (FSPCCURR) job completes to success

What does not work
=================
Non-shared tables curr_wrk_rt, curr_wrk_tbl, curr_wrk1_tbl and tree_sel10_r are locked

What is expected
==============
Non-shared tables should not lock after the process completes

Business Impact
================
Cannot complete multicurrency processing unless the tables are unlocked, resulting in considerable delays.

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