Search Results create_work_order

Overview

MSC_A2A_XML_WF is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that forms part of the Advanced Supply Chain Planning (ASCP) application-to-application (A2A) integration framework. It is declared with AUTHID CURRENT_USER and carries the RCS header MSCXMLWS.pls 115.4 2002/10/04, indicating the file has been stable since the 11i era and remains present in both 12.1.1 and 12.2.2. The package bridges the planning engine and the Oracle Workflow engine: it provides the standard entry points through which supply chain planning output (planned orders, requisitions, work orders, purchase order reschedules) is pushed into external or downstream execution systems by way of Workflow-based A2A (application-to-application) XML messages. In practice, MSC_A2A_XML_WF is the PL/SQL wrapper that the A2A / "XML" outbound integration layer calls when the plan must be communicated to an execution system, whether that system is Oracle Purchasing, Oracle Work in Process, or a legacy/target application reached through a Web Services or XML gateway.

Key Procedures and Functions

The package exposes eight documented procedures, each aligned with a specific planning output or integration event:

• LOG_MESSAGE — a generic utility used to write diagnostic or status messages to the A2A/Workflow log, typically for troubleshooting outbound integrations.
• PURGE_INTERFACE — removes processed interface rows identified by a map code and a unique identifier, cleaning up staging data once an A2A message has been successfully consumed.
• RESCHEDULE_PO — generates an outbound message (default map MSC_POO_OAG71_OUT) to reschedule a purchase order, keyed by instance and purchase order identifier.
• CREATE_REQ — emits a requisition creation message (default map MSC_REQUISITNO_OAG71_OUT) for a source line and instance, driving the supply of planned items.
• SYNC_WORK_ORDER — synchronises an existing work order with planning data (default map MSC_PRODORDERO_OAG71_OUT).
• CREATE_WORK_ORDER — creates a new work order in the execution system (default map MSC_PRODORDERC_OAG71_OUT).
• PUSH_PLAN_OUTPUT — the broadest entry point, pushing the complete plan output (default map MSC_PLANSCHDO_OAG71_OUT) with a compile designator and a buy-items-only flag.
• LEGACY_RELEASE — a release procedure retained for legacy integration scenarios, invoked by instance identifier.

Tables Accessed

The package reads and writes several ASCP interface tables through APPS synonyms:

• MSC_PO_REQUISITIONS_INTERFACE — staging for outbound requisitions generated by CREATE_REQ.
• MSC_PO_RESCHEDULE_INTERFACE — the source and target rows for RESCHEDULE_PO.
• MSC_WIP_JOB_DTLS_INTERFACE and MSC_WIP_JOB_SCHEDULE_INTERFACE — interface artefacts supporting CREATE_WORK_ORDER and SYNC_WORK_ORDER.
• WF_PARAMETER_LIST_T and PLITBLM — Workflow parameter list and PL/SQL index-by table types used to build and pass Workflow API parameters. PLITBLM is the standard DBMS_SQL.VARCHAR2_TABLE type used throughout EBS for bulk Workflow parameter transfer.

Usage Notes

MSC_A2A_XML_WF is not documented as being referenced by any other package, meaning it is called directly from the A2A / Advanced Planning integration layer, from concurrent programs, or from custom code rather than from within another PL/SQL package. The presence of hard-coded default map codes such as MSC_POO_OAG71_OUT confirms that the procedure signatures are designed for direct, parameter-light invocation: callers need only supply the instance, source line, or PO identifier, and the default map code is applied unless overridden. When extending or troubleshooting ASCP outbound integrations, administrators typically enable the relevant map in the A2A configuration, invoke these procedures from the planning output processing step, and use LOG_MESSAGE output and row counts in the MSC_* interface tables to verify message generation and error capture. Because the package is AUTHID CURRENT_USER, execution privileges follow the invoking schema, and grants are normally made to APPS or the planning integration role.