Cost Management - EBS (MOSC)

MOSC Banner

Supply Chain Cost Rollup Errors - need IDMS process internals expertise

edited Mar 23, 2022 9:40PM in Cost Management - EBS (MOSC) Question

We have been experiencing Supply Chain Cost Rollups ending in Error due to a lock being held on one of the cost tables by another process, despite implementing suggestions from notes 2106359.1 and 2198257.1 and having added personalizations to form CSTFITCT/function CST_CSTFITCT to lock out cost updates if such a concurrent request is executing.


SR 3-24235489011 produced patch 33074934 which added the following code to the package CSTPSCCR:


----------------------------------------

----------------------------------------

FUNCTION list_locked_sessions (

     i_tabname IN VARCHAR2)

    RETURN VARCHAR2 IS


    l_status       VARCHAR2(1);

    l_industry      VARCHAR2(1);

    l_oracle_schema    VARCHAR2(30);

    l_return       BOOLEAN;


 BEGIN


    l_return := FND_INSTALLATION.get_app_info

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center