Results for “ret_org_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MSC_ST_UTIL is a utility package body in the APPS schema that supports the Oracle Advanced Supply Chain Planning (ASCP) and Strategic Network Optimization (SNO) staging and interface layer within Oracle E-Business Suite 12.1.1 and 12.2.2. Its classification as a UTIL object indicates that it does not expose a public business API for external callers; instead it provides shared helper routines consumed internally by planning data-collection, staging, and load programs. The package centralises two broad categories of work: derivation of surrogate keys and identifiers required to populate MSC staging tables, and consistent error and message handling for batch planning jobs. The ETRM metadata records the object as VALID, with 43 documented procedures and functions, and notes that although it is not referenced by any database object directly, it is referenced by 14 other packages, confirming its role as a common dependency in the ASCP staging code base.

Key Procedures and Functions

The documented routines fall into several functional groups.

• Error and message handling: LOG_ERROR and LOG_MESSAGE record diagnostic output, while GET_ERROR_MESSAGE retrieves formatted text for downstream reporting. These routines depend on FND_MESSAGE and FND_FILE.
• Key derivation: DERIVE_COMPANY_ID, DERIVE_ITEM_ID, DERIVE_PARTNER_ORG_ID, DERIVE_PARTNER_SITE_ID, and DERIVE_PROJ_TASK_ID resolve the internal identifiers needed when staging planning transactions and supplies.
• Sequence and structure derivation: DERIVE_BILL_SEQUENCE_ID, DERIVE_ROUTING_SEQUENCE_ID, DERIVE_LEVEL_ID, DERIVE_LEVEL_PK, DERIVE_SR_LEVEL_PK, and DERIVE_SR_PK resolve bill of material, routing, and planning-level surrogate keys.
• Validation: VALIDATE_UOM checks unit-of-measure values, and VALIDATE_DMD_CLASS verifies demand class codes before staging.
• Session and control helpers: SET_PROCESS_FLAG, GET_INSTANCE_CODE, RETN_DELETE_FLAG, and RETN_SCHEDULE_ID support process status, instance identification, and purge or scheduling logic.

No parameter lists are documented in the ETRM record; callers should inspect the package specification in the target instance before invoking these routines directly.

Tables Accessed

The package body references FND_RESPONSIBILITY, FND_USER_RESP_GROUPS, FND_PROFILE, and FND_GLOBAL for session, responsibility, and profile context, and uses FND_FILE for log output. Planning-specific data is drawn from MSC_APPS_INSTANCES, MSC_COMPANIES, MSC_COMPANY_USERS, MSC_ERRORS, MSD_ST_TIME, and MSD_TIME, which supply instance configuration, company and user mapping, error logging, and staging time-window information. DUAL and the STANDARD package are used for trivial SQL evaluations and standard operations.

Usage Notes

MSC_ST_UTIL is not intended for direct invocation from forms or custom code. It is called by the planning data-collection and staging packages that populate the MSC_ST_* interface tables, and its LOG_ERROR and LOG_MESSAGE routines surface in concurrent program logs and request output. Because 14 packages depend on it, changes to its specification can cascade across ASCP staging code; it should be treated as an internal, version-sensitive dependency. In 12.1.1 and 12.2.2 the package ships as a VALID APPS object and is not referenced by any database object, so troubleshooting should focus on its calling packages rather than on database-level dependencies.