Receive Work Order Service
This service is in the WmOAMFG1227 package and has the following fully-qualified service name: workInProcess1227.intoOA.workOrder:receiveWorkOrder.
This service imports planned orders, planned order update recommendations, and suggested repetitive schedules all at once, from any source including planning systems, order entry systems, finite scheduling packages, production line sequencing programs, spreadsheets, and even custom entry forms.
Database Scripts
This service uses the following database scripts:
Script | Description |
wm_install_into_workorder.sql | Runs the scripts listed below, except the uninstall script. |
wm_into_workorder_pkg.sql | Installs
WM_WIP_IMP_HANDLER_PKG.
WM_HANDLE_WIP_JOB, which calls the
WM_CONC_REQUEST.
WM_REQUEST_SUBMIT
procedure to submit the Work Order Import process. |
wm_into_workorder_seq.sql | Creates the following components:  WM_WIP_GROUP_ID_S, which creates the GROUP_ID sequence WM_WIP_HEADER_ID_S, which creates the HEADER_ID sequence |
wm_drop_into_workorder.sql | Uninstalls all components created by wm_install_into_workorder.sql. |
For more information about using database scripts, see
Database Scripts.
Supporting Transaction Definitions
This service was built from the configured services defined in the following transaction definitions:
setWorkOrderTxn1227.txp
WorkOrderTransaction1227.txp
For information about using the transaction definition files to customize this service, see
Transaction Definitions.
Flow Control
This service uses the following flow steps to import work orders:
specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
specifyConcProgParams specifies the default parameter settings required for concurrent program execution. You should change these settings accordingly.
pickSequence generates a sequence value for group ID.
bizDocMapping service maps the incoming business document structure to the required Oracle Applications data structures (the interface tables).
getInventoryItemId returns the INVENTORY_ITEM_ID corresponding to the supplied ITEM_CODE and the ORGANIZATION_NAME. This service is a transformer in bizDocMapping.
getKanbanCardId returns the KANBAN_CARD_ID corresponding to the supplied KANBAN_CARD_NUMBER. This service is a transformer in bizDocMapping.
convertToDateObject returns the outDate as a date object corresponding to the supplied inDate, which is in text format. This service is a transformer in
bizDocMapping.
getOrgId is a transformer for mapping the business document
IData structure to the interface table
IData structure. It takes ORGANIZATION_NAME as input, and queries the table ORG_ORGANIZATION_DEFINITIONS to get the ORGANIZATION_ID.
getOASystemDateObject returns the Oracle Applications system date as a date object.
getOracleAppsUserId is a transformer for mapping the business document
IData structure to the interface table
IData structure. It takes
ORACLE_APPS_USER_NAME as the input parameter from the business document, and queries the table FND_USER to get the USER_ID. The USER_ID information is required for insertion into the interface tables.
getActivityId gets the Activity ID from CST_ACTIVITIES, given the Activity Name.
getDepartmentId gets Department ID from BOM_DEPARTMENTS, given the Department Code.
getStandardOperationId gets the Standard Operation ID, given the Standard Operation Code.
getLocatorId is a transformer for mapping the business document
IData structure to the interface table
IData structure. It takes LOCATOR and ORGANIZATION_NAME as input, and queries the view MTL_ITEM_LOCATIONS_KFV and the table ORG_ORGANIZATION_DEFINITIONS to get the INVENTORY_LOCATION_ID corresponding to the LOCATOR and ORGANIZATION_NAME.
getProjectId is a transformer for mapping the bizdoc to the interface table data structure. It takes the project name as input, and queries the Oracle Applications database to get the Project ID.
getResourceId queries BOM_RESOURCES table to get the RESOURCE_ID for the corresponding input value.
getWIPEntityId takes
WIP_ENTITY_NAME and
ORGANIZATION_NAME as the input parameters, and queries the WIP_ENTITIES table to get the WIP_ENTITY_ID corresponding to the input parameters.
pickSequence generates the group ID using the custom sequence WM_WIP_GROUP_ID_S.
setWorkOrderTxn inserts data into the interface table. It extracts data from the
IData structure that results from the
bizDocMapping service, and puts the data into the interface table in Oracle Applications for WorkOrder.
importWorkOrder imports data to the production table from the interface table. It calls the services execWorkOrderConcProg and getWorkOrderImport_ERR to execute the corresponding concurrent program that inserts data into the production table and that generates the error/ acknowledgement message. If the status of the execution is SUCCESS (returned by the service execWorkOrderConcProg), getWorkOrderImport_ERR is called to retrieve the errors. If no record is found, it comes out of the flow, indicating success of the data import process. If the status of the execution is FAILED it comes out of execution, giving the errors.
execWorkOrderConcProg invokes the stored procedure Wm_Wip_Imp_Handler_Pkg.WM_HANDLE_WIP_JOB. The procedure calls the corresponding concurrent subroutine to execute the data import process for WorkOrder into Oracle Applications. This service returns Status ID, Request ID, Execution Status Message (for normal concurrent program completion), and database Stored Procedure error message (if an exception occurs in Stored Procedure execution).
getWorkOrderImport_ERR gets the error message that occurs during the data import to the production table from the interface table. Based on the parameter GROUP_ID, it scans the WIP_JOB_SCHEDULE_INTERFACE and WIP_INTERFACE_ERRORS tables, and returns PRIMARY_ITEM_ID, HEADER_ID and ERROR.
checkWorkOrderImportStatus finds the number of errors in the error table corresponding to the GROUP_ID.
Business Document Structure
This service uses the business document WorkOrderBizDoc. Its structure is as follows:
1.0. WORK_ORDER_HEADER
1.1. WORK_ORDER_LINES
1.0. WORK_ORDER_HEADER (Maps to WIP_JOB_SCHEDULE_INTERFACE)
Field Name | Maps to Column | Description |
ALLOW_EXPLOSION | ALLOW_EXPLOSION | Determines whether you can run the exploder, which creates child records in addition to the job header record. |
ALTERNATE_BOM_
DESIGNATOR | ALTERNATE_
BOM_DESIGNATOR | Alternate Bill of Materials used in job or schedule. |
ALTERNATE_ROUTING_
DESIGNATOR | ALTERNATE_
ROUTING_
DESIGNATOR | Alternate routing used in a job or repetitive schedule. |
BOM_REFERENCE_ITEM | BOM_
REFERENCE_ID | Assembly identifier used as a routing reference for scheduling of nonstandard job. |
BOM_REVISION | BOM_REVISION | Revision to the Bill of Materials. |
BOM_REVISION_DATE | BOM_REVISION_DATE | Date of inventory item revision that explodes the Bills of Material used in the job or schedule. |
CLASS_CODE | CLASS_CODE | Required only for Loading Non-Standard Discrete Job. Accounting class associated with job or repetitive assembly. |
COMPLETION_
LOCATOR_SEGMENTS | COMPLETION_
LOCATOR_
SEGMENTS | |
COMPLETION_
SUBINVENTORY | COMPLETION_
SUBINVENTORY | |
DAILY_PRODUCTION_RATE | DAILY_PRODUCTION_
RATE | Required only for Repetitive Schedule. Schedule daily quantity. |
DEMAND_CLASS | DEMAND_CLASS | Type of demand the job or schedule satisfies. |
DESCRIPTION | DESCRIPTION | |
DUE_DATE | DUE_DATE | Due date of the job being created. |
FIRM_PLANNED_FLAG | FIRM_PLANNED_FLAG | Control for MRP rescheduling. |
FIRST_UNIT_START_DATE | FIRST_UNIT_START_DATE | Not required for updating Discrete Job or Schedule. Date job or schedule should start. |
FIRST_UNIT_COMPLETION_
DATE | FIRST_UNIT_
COMPLETION_DATE | Not required for updating Discrete Job or Schedule. Date job or schedule should complete the first unit. |
JOB_NAME | JOB_NAME | WIP job name. |
KANBAN_CARD_NUMBER | KANBAN_CARD_ID | Production kanban replenished by the WIP entity being created. |
LAST_UNIT_COMPLETION_
DATE | LAST_UNIT_
COMPLETION_DATE | Not required only in case of updating discrete jobs. Date job or schedule should end. |
LAST_UNIT_START_DATE | LAST_UNIT_START_DATE | Not required only in case of updating discrete jobs. Date job or schedule should begin processing the last unit. |
LINE_CODE | LINE_CODE | Required for loading repetitive schedule. |
LOAD_TYPE | LOAD_TYPE | Required. Type of interface record. Use: 1 for Create standard discrete job. 2 for Create pending repetitive schedule. 3 for Update standard or non- standard discrete job. 4 for Create non-standard discrete job. |
LOT_NUMBER | LOT_NUMBER | |
NET_QUANTITY | NET_QUANTITY | Job net quantity. |
ORGANIZATION_NAME | ORGANIZATION_ID | Required. Organization name. |
OVERCOMPLETION_TOLERANCE_
TYPE | OVERCOMPLETION_
TOLERANCE_TYPE | Unit of OVERCOMPLETION_ TOLERANCE_VALUE(percent or amount). |
OVERCOMPLETION_
TOLERANCE_VALUE | OVERCOMPLETION_
TOLERANCE_VALUE | Percent or amount above expected quantity that this entity is allowed to complete. |
PRIMARY_ITEM_CODE | PRIMARY_ITEM_ID | Required for loading standard discrete jobs and repetitive schedule. Inventory item identifier for the assembly that the job or repetitive schedule creates. |
PRIORITY | PRIORITY | Priority to assign to the job being created. |
PROCESSING_WORK_DAYS | PROCESSING_
WORK_DAYS | Required only for loading repetitive schedule. Processing days of repetitive schedule. |
PROJECT_NAME | PROJECT_ID | Project reference for the discrete job. Get PROJECT_ID from PA_PROJECTS_ALL. |
REPETITIVE_SCHEDULE_ID | REPETITIVE_
SCHEDULE_ID | WIP repetitive schedule identifier. |
ROUTING_REFERENCE_
NUMBER | ROUTING_
REFERENCE_ID | Assembly identifier used as routing reference for scheduling of nonstandard job. |
ROUTING_REVISION | ROUTING_REVISION | Revision to the assembly routing. |
ROUTING_REVISION_DATE | ROUTING_
REVISION_DATE | |
SCHEDULE_GROUP_NAME | SCHEDULE_
GROUP_NAME | |
SCHEDULING_METHOD | SCHEDULING_
METHOD | |
SOURCE_CODE | SOURCE_CODE | Code of the process that generated the interface record. |
SOURCE_LINE_ID | SOURCE_LINE_ID | Identifier used by source shop floor control system. Null if created by Oracle Work In Process. |
START_QUANTITY | START_QUANTITY | Job start quantity. |
STATUS_TYPE | STATUS_TYPE | Status of the job or repetitive schedule to be loaded. |
TASK_NUMBER | TASK_NUMBER | |
WIP_ENTITY_NAME | WIP_ENTITY_ID | Required only for updating discrete jobs. WIP job or repetitive assembly name. |
WIP_SUPPLY_TYPE | WIP_SUPPLY_TYPE | Method of material consumption within WIP. |
1.1 WORK_ORDER_LINES (Maps to WIP_JOB_DTLS_INTERFACE)
Field Name | Maps to Column | Description |
ACTIVITY_NAME | ACTIVITY_ID | WIP job or repetitive assembly identifier. |
APPLIED_RESOURCE_UNITS | APPLIED_RESOURCE_UNITS | Amount of resource units charged. |
APPLIED_RESOURCE_VALUE | APPLIED_RESOURCE_VALUE | Value of resource units charged. |
ASSIGNED_UNITS | ASSIGNED_UNITS | Required only for adding resource. Number of resources assigned to work. |
AUTOCHARGE_TYPE | AUTOCHARGE_TYPE | Required only for adding resource. Method of charging the resource. |
BACKFLUSH_FLAG | BACKFLUSH_FLAG | Required only for adding operations. Back flush control code. |
BASIS_TYPE | BASIS_TYPE | Required only for adding resource. Basis for scheduling and charging resource. |
COMPLETION_DATE | COMPLETION_DATE | Required only for adding resource. Scheduled completion date of the resource. |
COUNT_POINT_TYPE | COUNT_POINT_TYPE | Required only for adding operations. |
DATE_REQUIRED | DATE_REQUIRED | Operation requirement start date. |
DEPARTMENT_CODE | DEPARTMENT_ID | Required only for adding operations. |
DESCRIPTION | DESCRIPTION | |
FIRST_UNIT_
COMPLETION_DATE | FIRST_UNIT_
COMPLETION_DATE | Required only for adding operations. First unit scheduled completion date. |
FIRST_UNIT_START_DATE | FIRST_UNIT_START_DATE | Required only for adding operations. First unit scheduled receipt date. |
INVENTORY_ITEM_
CODE_NEW | INVENTORY_
ITEM_ID_NEW | Required only for adding components. New material requirement identifier. |
INVENTORY_ITEM_
CODE_OLD | INVENTORY_
ITEM_ID_OLD | Required only for changing components. Old material requirement identifier. |
LAST_UNIT_COMPLETION_
DATE | LAST_UNIT_
COMPLETION_
DATE | Required only for adding operations. Last unit scheduled completion date. |
LAST_UNIT_START_DATE | LAST_UNIT_START_DATE | Required only for adding operations. Last unit scheduled receipt date. |
LOAD_TYPE | LOAD_TYPE | Required. Material or resource Requirement. Use: 1 for Loading a resource. 2 for Loading a component. 3 for Loading an operation. 4 for Loading multiple resource usage. |
MINIMUM_TRANSFER_
QUANTITY | MINIMUM_
TRANSFER_
QUANTITY | Required only for adding operations. Minimum operation transfers quantity. |
MPS_DATE_REQUIRED | MPS_DATE_REQUIRED | Date used by MPS relief process. |
MPS_REQUIRED_QUANTITY | MPS_REQUIRED_QUANTITY | Quantity used by MPS relief process. |
MRP_NET_FLAG | MRP_NET_FLAG | Required only for adding components. Indicates whether or not MRP should consider the component requirement in its netting process. |
OPERATION_SEQ_NUM | OPERATION_SEQ_NUM | Required. Operation sequence number within a routing. |
ORGANIZATION_NAME | ORGANIZATION_ID | |
QUANTITY_ISSUED | QUANTITY_ISSUED | Part quantity issued. Required only for adding components. |
QUANTITY_PER_ASSEMBLY | QUANTITY_PER_ASSEMBLY | Part usage quantity. Required only for adding components. |
REQUIRED_QUANTITY | REQUIRED_QUANTITY | Part quantity required. Required only for adding components. |
RESOURCE_CODE_NEW | RESOURCE_ID_NEW | Resource identifier to be added or changed. Required only for adding resource. |
RESOURCE_CODE_OLD | RESOURCE_ID_OLD | Resource identifier existing in current jobs or schedules. Required only for changing resource. |
RESOURCE_SEQ_NUM | RESOURCE_SEQ_NUM | Resource sequence number. Required only for adding or changing resource. |
SCHEDULED_FLAG | SCHEDULED_FLAG | Method of scheduling the resource. Required only for adding resource. |
STANDARD_RATE_FLAG | STANDARD_RATE_FLAG | Indicates whether the resource is charged at the standard rate. |
STANDARD_OPERATION_
CODE | STANDARD_
OPERATION_ID | Standard Operation Identifier. |
START_DATE | START_DATE | Scheduled start date of the resource. Required only for adding resource. |
SUBSTITUTION_TYPE | SUBSTITUTION_TYPE | Substitution Type. Use: 1 for Delete. 2 for Add. 3 for Change. |
SUPPLY_LOCATOR_
DESCRIPTION | SUPPLY_LOCATOR_
ID | Locator used to supply component to WIP. |
SUPPLY_SUBINVENTORY | SUPPLY_SUBINVENTORY | Subinventory used to supply component to WIP. |
USAGE_RATE_OR_AMOUNT | USAGE_RATE_OR_AMOUNT | Rate per assembly or amount per job or schedule. Required only for adding resource. |
UOM_CODE | UOM_CODE | Code for unit of measure. Required only for adding resource. |
WIP_SUPPLY_TYPE | WIP_SUPPLY_TYPE | Method of material consumption within WIP. |