Search Results val_assignment_type

Overview

The APPS.MRP_VALIDATE_ASSIGNMENT package is a PL/SQL validation package within the Oracle E-Business Suite Oracle Advanced Supply Chain Planning (ASCP) and Material Requirements Planning (MRP) module. Its business function is to validate sourcing assignment definitions used by the MRP/MPS planning engine when resolving how planned demand is sourced from a supplying organization, supplier, or sourcing rule. In Oracle EBS 12.1.1 and 12.2.2, sourcing assignments govern the assignment sets, sourcing rules, and assignment types that determine supply paths for planned items. This package performs attribute-level and identifier-level validation against the assignment data model, ensuring that records entered or altered through sourcing assignment maintenance are consistent before they are consumed by planning processes.

The package is classified as OTHER in the ETRM registry, indicating it is primarily an internal validation utility rather than a public integration API. It has a VALID status in the APPS schema and exposes 39 documented procedures and functions.

Key Procedures and Functions

The documented program units fall into three functional groupings:

• ENTITY and ENTITY_DELETE — These units handle the core entity-level operations for an assignment record, supporting validation and deletion semantics used by the surrounding assignment maintenance logic.
• ATTRIBUTES — A general attribute validation entry point, likely dispatching or applying shared validation rules across the assignment attribute set.
• VAL_ASSIGNMENT_SET_ID and VAL_ASSIGNMENT_TYPE — Identifier and type validators. VAL_ASSIGNMENT_SET_ID verifies the assignment set identifier, and VAL_ASSIGNMENT_TYPE verifies the assignment type value (for example, sourcing-rule or supplier-based assignment).
• VAL_ATTRIBUTE1 through VAL_ATTRIBUTE15 — Fifteen discrete attribute validators that validate the descriptive flexfield-style attribute columns (ATTRIBUTE1–ATTRIBUTE15) associated with assignment records. Each validator applies type, length, or domain constraints relevant to the corresponding attribute position.

The ETRM metadata lists these units by name only; no parameter signatures are documented. Implementers should not assume parameter lists and should reference the package specification in the target instance.

Tables Accessed

The package references the following tables through APPS synonyms:

• MRP_ASSIGNMENT_SETS — The parent assignment set definition; read to validate set identifiers.
• MRP_SOURCING_RULES — Sourcing rule definitions referenced by assignments.
• MTL_SYSTEM_ITEMS — Item master data used to confirm that assigned items exist and are valid.
• MTL_CATEGORIES and MTL_CATEGORY_SETS — Category and category set data, supporting category-based assignment validation.
• HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, and HZ_CUST_SITE_USES_ALL — Trading Community Architecture (TCA) customer and site tables, used to validate supplier or customer references where assignments involve external parties or ship-to/site usage.
• DBMS_OUTPUT — Used for diagnostic or debug message output.

Usage Notes

MRP_VALIDATE_ASSIGNMENT depends on the standard FND_API error-handling framework and on MRP_SRC_ASSIGNMENT_PUB, indicating it participates in the standard EBS API validation pattern and returns results through the FND message stack. It is referenced by MRP_ASSIGNMENT_PVT, MRP_DEFAULT_ASSIGNMENT, and recursively by itself. These callers are the private and defaulting layers of the sourcing assignment feature, which in turn are invoked from the Sourcing Rules and Assignments forms and related concurrent programs. Custom code that inserts or updates MRP assignment data should ideally route through MRP_SRC_ASSIGNMENT_PUB rather than calling this validator directly, so that FND_API error semantics are preserved. Direct calls are appropriate when extending validation logic or troubleshooting assignment records.