Search Results mrp_sr_assignments_s




Overview
Explore in AI Chat

Overview

MRP_DEFAULT_ASSIGNMENT is an Oracle Applications (APPS) PL/SQL package body that supports the Oracle Advanced Supply Chain Planning and Oracle Manufacturing planning modules by programmatically generating and maintaining default sourcing assignments. In Oracle EBS 12.1.1 and 12.2.2, sourcing assignments stored in the MRP_SR_ASSIGNMENTS_S table define the relationships between items, organizations, suppliers, and sources that the planning engine uses to determine how demand is satisfied. The MRP_DEFAULT_ASSIGNMENT package encapsulates the business logic required to automatically create or refresh these default assignments, removing the need for planners to define every sourcing rule manually.

The package sits within the sourcing-assignment subsystem and depends on several companion modules, including FND_API, FND_MESSAGE, FND_MSG_PUB, FND_PROFILE, MRP_ASSIGNMENT_UTIL, MRP_GLOBALS, MRP_SRC_ASSIGNMENT_PUB, and MRP_VALIDATE_ASSIGNMENT. Its reliance on the FND message and API stack confirms that it is built as a standards-compliant application programmatic interface (API), capable of returning structured success, warning, and error messages to its callers.

Key Procedures and Functions

The documented public interface for this package consists of a single procedure or function identified as ATTRIBUTES. This program unit encapsulates the attribute-handling logic used when default sourcing assignments are constructed or defaulted. Rather than requiring callers to supply every column value for a new assignment record, the routine resolves and supplies the appropriate default attribute values from profile options, globals, and the assignment utility layer.

The internal helper units private to the package body are not exposed through the package specification and therefore are not documented as callable entry points. Applications and concurrent programs should treat ATTRIBUTES as the supported entry point and should not invoke undocumented internal logic directly.

Tables Accessed

The package accesses the following documented tables through APPS synonyms:

  • MRP_SR_ASSIGNMENTS_S — the core sourcing-assignment table. The package reads and writes this table to insert or update default sourcing rules, including the source type, source organization, supplier, and assignment attributes associated with each item and organization combination. Because this table is the primary target of the package's DML, it is the object most commonly searched for alongside the package name.
  • DUAL — used as a standard single-row source for scalar evaluations, profile lookups, and validation predicates that do not require data from a business table.

Additional tables may be touched indirectly through the dependent utility packages (for example, MRP_ASSIGNMENT_UTIL and MRP_VALIDATE_ASSIGNMENT), but MRP_SR_ASSIGNMENTS_S and DUAL are the documented direct references.

Usage Notes

MRP_DEFAULT_ASSIGNMENT is not a standalone user-facing program. It is invoked programmatically by the sourcing-assignment framework, by concurrent programs that mass-generate default sourcing rules, or by custom extensions that need to create assignments consistent with Oracle's standard defaulting and validation logic. The package is not referenced by any other database object at the schema level, confirming it is an application-facing API rather than a low-level dependency of other database code.

Because the package calls MRP_VALIDATE_ASSIGNMENT and MRP_SRC_ASSIGNMENT_PUB, callers benefit from built-in validation and message handling. In 12.1.1 and 12.2.2 the package behavior is consistent, though profile-driven defaults should be verified after upgrades. Custom code should initialize the FND message stack and check the returned API status rather than assuming success, and should avoid direct inserts into MRP_SR_ASSIGNMENTS_S to preserve referential and attribute integrity.