Search Results create_ir_iso




Overview
Explore in AI Chat

Overview

The APPS.MRP_CREATE_SCHEDULE_ISO package is an Oracle E-Business Suite PL/SQL component that belongs to the Oracle Advanced Supply Chain Planning (ASCP) and Manufacturing Planning family of programs. Its principal business function is to create and schedule supplier release documents—specifically supplier schedules and internal requisitions—that are generated as output from a planning run. When a plan produces recommendations that require procurement action, the planning engine must translate those recommendations into executable transactional documents such as purchase order releases, internal requisitions, and supplier scheduling releases. MRP_CREATE_SCHEDULE_ISO encapsulates that translation and scheduling logic.

Within the Oracle EBS 12.1.1 and 12.2.2 architectures, planning modules utilize the schema-level synonym approach: the package is owned by APPS and interacts with tables across the planning, order management, purchasing, and receivables schemas through APPS-resolved synonyms. The package carries a status of VALID and is classified as an OTHER API in the ETRM repository, meaning it is a documented, developer-accessible object but is not a formally supported open interface for external integration.

Key Procedures and Functions

The ETRM metadata documents four procedures and functions within this package:

  • LOG_MESSAGE — Provides internal logging of diagnostic and error messages generated during the schedule and release operations. This routine supports troubleshooting by recording processing outcomes for the calling session.
  • MSC_RELEASE_ISO — Handles release processing for supply chain scheduling artifacts, coordinating with the MSC (Advanced Planning) schema to move plan-approved recommendations into actionable release state.
  • CREATE_AND_SCHEDULE_ISO — Serves as the principal orchestration routine. It creates the scheduling entities and applies scheduling logic, combining creation and scheduling into a single operation.
  • CREATE_IR_ISO — Creates internal requisitions (IR). Internal requisitions are used for intra-company stock transfers and are a common output when a plan recommends moving inventory between organizations.

These four routines operate together: plan output is converted into internal requisitions and supplier releases, which are then scheduled and logged for traceability.

Tables Accessed

The package reads from and writes to a set of core EBS transactional and setup tables through APPS synonyms:

  • MRP_ORG_TRANSFER_RELEASE — Stores organization transfer release information, central to the internal requisition creation logic.
  • OE_ORDER_HEADERS_ALL — The Order Management order header table, accessed to reference or create order documents associated with releases.
  • PO_SYSTEM_PARAMETERS_ALL — Provides purchasing system-level parameters and defaults that govern release processing behavior.
  • FINANCIALS_SYSTEM_PARAMS_ALL — Supplies financial system parameters that determine accounting and configuration defaults.
  • FND_PROFILE_OPTIONS and FND_PROFILE_OPTION_VALUES — Read to resolve profile option settings that influence scheduling and document creation.
  • HZ_CUST_ACCOUNTS and HZ_PARTIES — The Trading Community Architecture tables, accessed to resolve supplier and party details for releases.
  • PLITBLM — An internal PL/SQL table (ORA_FFI style) used for in-memory array processing within the package.

Usage Notes

MRP_CREATE_SCHEDULE_ISO is typically invoked indirectly rather than through a user-facing form. It is referenced by the MSC_SRP_RELEASE package, confirming that it executes as part of the supply chain release workflow triggered during plan release or schedule generation. Administrators and technical consultants encounter it when tracing why internal requisitions or supplier schedules are (or are not) created during a planning cycle.

Because the package is not a supported public API, custom code should avoid calling its procedures directly; instead, releases should be executed through the standard ASCP release concurrent programs. When debugging, DBMS_OUTPUT or the package's own LOG_MESSAGE routine can be used to trace processing. In 12.2.2 the online patching (adop) model treats this package as a standard APPS object, so modifications must follow the supported customization and extension framework.