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.

For more details on receive transactions, see Overview of Receive Service Transaction Processing.

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.