WICMLP Concurrent Program Configuration

The WICMLP Concurrent Program executes the open interface for work orders. You can use it to create a new job or schedule, or update an existing job or schedule information. It processes the records from the following tables: WIP_JOB_SCHEDULE_INTERFACE and WIP_JOB_DTLS_INTERFACE.

The WICMLP Concurrent Program includes the following parameters:

Name Type Required Displayed Description
Group ID FND_NUMBER15_REQUIRED Yes Yes Used to batch the interface records.
Validation Level FND_NUMBER15 Yes No Indicates what validation should be performed.
Print Report WIP_SRS_YES_NO_MAND Yes Yes Indicates whether the report is printed.

The WICMLP Concurrent Program includes the following open interface tables or views:

Name Direction Status Description
WIP_JOB_SCHEDULE_INTERFACE Inbound Active Contains the requests to create or modify discrete jobs or repetitive schedules.
WIP_JOB_DTLS_INTERFACE Inbound Active Contains requests to add, delete, and modify material and/or resource requirements for existing discrete jobs or repetitive schedules.

The following figure shows the WICMLP Concurrent Program configuration of the OracleCP project:

Note: The responsibility and the user selected in this example are valid in the Vision Demo environment.

The following table lists the inputs of the WICMLP Concurrent Program of the OracleCP project:

Parameter Type Input
Group ID VARCHAR2 See process property WIP_input/Request_GroupID
Print Report VARCHAR2 2

The following table lists the important inputs of the interface tables of the OracleCP project:

Parameter Type Input
Group ID NUMBER See process property WIP_input/Request_GroupID
SOURCE_CODE VARCHAR2 WICDOL
ORGANIZATION_ID NUMBER 207
CLASS_CODE VARCHAR2 Discrete
JOB_NAME VARCHAR2 See process property WIP_input/JobName1
DESCRIPTION VARCHAR2 See process property WIP_input/JobName1
ORGANIZATION_CODE VARCHAR2 M1
ROUTING_REVISION VARCHAR2 A
BOM_REVISION VARCHAR2 A
COMPLETION_SUBINVENTORY VARCHAR2 FGI
ALLOW_EXPLOSION VARCHAR2 Y

If you use the Concurrent Program activity to insert data into the interface tables, you must clear the Concurrent Request check box in the General tab. You can also use the TIBCO BusinessWorks JDBC activity or other tools to insert records into the interface tables.

Note: The Group_ID input value must be identical within the example. Otherwise, an empty request is submitted.