Search Results g_excep_groups

Overview

APPS.MSC_CL_POST_PUBLISH is a PL/SQL package belonging to the Oracle Advanced Supply Chain Planning (ASCP) schema, part of the MSC (Material Supply Chain) family of modules in Oracle E-Business Suite. It is declared with AUTHID CURRENT_USER, meaning that execution privileges for any dynamic SQL or unqualified object references are evaluated against the invoking schema rather than the package owner. In the 12.1.1 and 12.2.2 releases, this package is classified under the generic API classification OTHER, indicating that it is not published as an externally supported open interface. Its primary responsibility is post-publish cleanup within the planning data collection and publish workflow, reconciling exception summary data and purging transient planning records after a plan or collection run has been published.

Key Procedures and Functions

The package exposes two documented procedures:

• POST_CLEANUP — the central cleanup routine, invoked after a publish operation completes. It accepts an organization selector and a logical record type selector, and returns an out status code (0 = success, 1 = warning, 2 = error) consistent with the G_SUCCESS, G_WARNING, and G_ERROR constants declared in the specification. Its work is scoped by the package-level constants that define which exception types and exception groups are considered eligible for cleanup, including a distinct duplicate-exception list.
• UPDATE_EXCEPTION_SUMMARY — refreshes exception summary data following the cleanup activity and returns an out status value indicating the outcome of the summary update.

The specification also declares a PL/SQL associative/collection type number_arr (a table of NUMBER) used internally to pass sets of numeric identifiers, and the three constants G_EXCEP_TYPES, G_EXCEP_GROUPS, and G_DUPLICATE_EXCEP_TYPES, which enumerate the exception classifications handled during post-publish processing.

Tables Accessed

Three objects are referenced via APPS synonyms:

• MSC_ITEM_EXCEPTIONS — the item-level exception table where planning exceptions are stored per plan and organization. Post-publish cleanup and the exception summary refresh read and modify this data.
• MSC_X_EXCEPTION_DETAILS — holds detailed exception records accompanying the item-level exceptions, used when reconciling or removing exception detail rows.
• PLITBLM — the standard Oracle Applications PL/SQL index-by table of NUMBER used as a bind array utility, supporting bulk operations within the cleanup logic.

Usage Notes

MSC_CL_POST_PUBLISH is not intended for direct customer invocation. It is invoked internally by the planning publish process, most commonly from concurrent programs and from within other MSC packages; the ETRM metadata records it as referenced by one other package. In practice it executes at the tail end of a plan publish or data collection cycle, after the plan's exception records have been surfaced to the user, when transient workspace data must be purged and the exception summary tables harmonized. Because the package uses AUTHID CURRENT_USER, administrators troubleshooting invalidations or privilege errors should confirm that the invoking schema owns the necessary grants on the underlying MSC tables. Custom code should avoid calling these procedures directly, as their signatures and behavior are undocumented in the public API sense and may change between patch levels of 12.1.1 and 12.2.2.