Results for “inbound_rule”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MSC_RULE is an APPS-owned PL/SQL package in the Oracle E-Business Suite Advanced Planning and Scheduling (ASCP) schema, classified under ETRM as an OTHER-type API rather than a standard open interface or public API. It is a small, tightly scoped package whose documented responsibility centers on the processing of inbound business rule definitions within the supply chain planning data model. Its role is to consume rule information delivered as inbound events and to translate that information into the planning repository so that the planning engine can enforce the intended business constraints and prioritization logic.
The package's dependency footprint is deliberately narrow. MSC_RULE references only APPS.WF_EVENT_T and the SYS.STANDARD library, meaning that it operates against the Workflow event queue rather than constructing its own staging structures, and it relies on standard PL/SQL data type constructs for its internal declarations. The package body contains no direct SQL against the core planning tables; instead, the inbound rule payload arrives through the AQ-backed workflow event mechanism and is processed within the package. This design keeps the package lightweight and decoupled from the bulk planning tables, leaving the heavy data movement to the ASCP data collection and plan run engines.
Key Procedures and Functions
- INBOUND_RULE — The single documented entry point. INBOUND_RULE handles the inbound processing of a rule definition received as a workflow event. It is responsible for interpreting the event payload describing the rule and applying the corresponding change to the planning repository so that the rule becomes effective for subsequent planning runs. Because the ETRM metadata for this package does not publish a parameter list, no signature is asserted here; callers should reference the installed package specification in the target environment for the precise argument order and types.
Tables Accessed
- APPS.WF_EVENT_T — The Oracle Workflow event table, exposed to the package through an APPS synonym. MSC_RULE reads from this table to retrieve the inbound rule event and its associated payload. This confirms that rule delivery into ASCP is event-driven and routed through the Workflow Business Event System rather than through a direct table insert or a concurrent program staging table.
- DBMS_AQ — The Oracle Advanced Queuing package, referenced as an APPS synonym. Its presence indicates that the package interacts with the workflow queue infrastructure to dequeue or inspect the inbound rule message as part of the same processing flow.
Usage Notes
In practice, MSC_RULE is not an end-user or form-level API. It is invoked internally when a rule-related business event is raised and delivered to the ASCP inbound subscription. Administrators and technical consultants typically encounter it indirectly, through Workflow event subscription configuration and the ASCP setup that governs which rule changes are permitted to flow into the planning instance. Because the ETRM record shows the package as referenced by no other packages, custom code should not assume it is a shared utility; any direct invocation in a bespoke extension should be treated as an unsupported, environment-verified integration. Organizations requiring programmatic rule maintenance should prefer the documented ASCP setup forms and standard concurrent processes, using MSC_RULE only as the mechanism that the standard inbound flow already employs. When troubleshooting missing or unapplied rules, verifying that the corresponding workflow event was raised and successfully processed by INBOUND_RULE is the appropriate diagnostic starting point.
-
PACKAGE: APPS.MSC_RULE 12.1.1
-
PACKAGE BODY: APPS.MSC_RULE 12.1.1
-
PACKAGE: APPS.MSC_RULE 12.2.2
-
PACKAGE BODY: APPS.MSC_RULE 12.2.2
-
PACKAGE BODY: APPS.ECX_RULE 12.1.1
-
PACKAGE: APPS.ECX_RULE 12.2.2
-
PACKAGE BODY: APPS.ECX_RULE 12.2.2
-
PACKAGE: APPS.ECX_RULE 12.1.1
-
PACKAGE BODY: APPS.MSC_RULE 12.1.1
-
PACKAGE BODY: APPS.MSC_RULE 12.2.2
-
PACKAGE: APPS.MSC_RULE 12.2.2
-
PACKAGE: APPS.ECX_RULE 12.2.2
-
PACKAGE: APPS.MSC_RULE 12.1.1
-
PACKAGE: APPS.ECX_RULE 12.1.1
-
PACKAGE BODY: APPS.ECX_RULE 12.1.1
-
PACKAGE BODY: APPS.ECX_RULE 12.2.2