Supply Chain Cost Rollup Errors - need IDMS process internals expertise
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