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.


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.


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.


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