Search Results get_acc_class_from_source

Overview

MSC_REL_WF is an Oracle Advanced Supply Chain Planning (ASCP) PL/SQL package that supports the release and rescheduling workflow infrastructure within Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business role is to drive the release of planned supplies into executable execution systems and to orchestrate the workflow activities associated with purchase order reschedule notifications and planner approvals. The package sits between the planning engine outputs (records in the MSC_* planning tables) and the downstream transactional interfaces (purchase order, sales order, and reschedule interfaces), enabling planners to convert planned recommendations into actionable documents.

In addition to release processing, MSC_REL_WF manages the lifecycle of release workflow notifications, including planner notification, decline handling, and activity deletion. It also provides utility functions that support environment validation, such as confirming that a source instance is accessible and that a source database is available before executing cross-instance release operations.

Key Procedures and Functions

The package exposes approximately thirty documented procedures and functions. The RELEASE_SUPPLIES procedure drives the core release of planned supplies into execution systems. RELEASE_SALES_ORDERS performs the corresponding release of planned sales orders. RESCHEDULE_PURCHASE_ORDERS manages the rescheduling of existing purchase orders based on planning recommendations, while START_RESCHEDULE_PO_WF initiates the associated workflow.

Supporting workflow routines include START_RELEASE_BATCH_WF and START_SOURCE_PROGRAM, which launch batch and source-side processing. NOTIFY_PLANNER_PROGRAM and NOTIFY_PLANNER_DECLINE handle planner workflow notifications and decline responses. DELETEACTIVITIES removes completed or obsolete workflow activities.

Utility and lookup functions include GET_DOCK_DATE, GET_LOAD_TYPE, RESET_LOAD_TYPE, SELECT_BUYER_SUPPLIER, GET_JOB_SEQ_FROM_SOURCE, GET_ACC_CLASS_FROM_SOURCE, GET_SUPPLY_DATA, VALIDATE_PROJ_IN_SOURCE, IS_PJM_VALID, and IS_SOURCE_DB_UP. INSERT_TEMP_TABLE supports staging of data for processing. These routines resolve configuration attributes, validate project and source context, and confirm connectivity to remote source databases.

Tables Accessed

MSC_REL_WF references planning and interface tables through APPS synonyms. MSC_SUPPLIES and MSC_DEMANDS hold the planned supply and demand records subject to release. MSC_PURCHASE_ORDER_INTERFACE and MSC_SALES_ORDER_INTERFACE receive released transactional data, while MSC_PO_RESCHEDULE_INTERFACE supports purchase order rescheduling.

Configuration and setup data is drawn from MSC_PLANS, MSC_PLAN_ORGANIZATIONS, MSC_PLANNERS, MSC_PARTNER_CONTACTS, MSC_APPS_INSTANCES, MSC_CALENDARS, and MSC_CALENDAR_DATES. These tables supply plan context, organization scope, planner assignments, partner contacts, source instance definitions, and calendar-based date calculations. MSC_FORM_QUERY_S and FND_USER are used for form query context and user identification, notably for planner notifications.

Usage Notes

MSC_REL_WF is primarily invoked indirectly by planning workflows and release programs rather than being called directly by end users. It is referenced by MSC_DRP_UTIL, MSC_EXP_WF, MSC_RELEASE_PK, MSC_REL_PS_PLAN_PUB, MSC_SELECT_ALL_FOR_RELEASE_PUB, and by itself, indicating its role as a shared dependency within the ASCP release and workflow stack. The package is executed during planned order release, purchase order rescheduling, and planner workflow notification cycles. Customizations should observe the standard ASCP release sequence and avoid direct modification, as the package is a controlled Oracle-delivered object owned by APPS.