Search Results jobs
The WIP_JOB_DTLS_INTERFACE table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical interface table used in the Work in Process (WIP) module for processing job-related data before it is transferred to the base tables. This table facilitates the import and validation of job details from external systems or legacy applications into Oracle WIP. Below is a detailed summary of its purpose, structure, key columns, and functional significance.
Purpose and Functionality
The WIP_JOB_DTLS_INTERFACE table acts as a staging area for job-related transactions, enabling bulk data loading while ensuring data integrity through validation routines. It supports the creation, update, and deletion of WIP jobs, including discrete jobs, repetitive schedules, and flow schedules. The data loaded into this table is processed by the WIP Mass Load program (or concurrent request), which validates and transfers the records to the base WIP tables (e.g., WIP_DISCRETE_JOBS, WIP_REPETITIVE_SCHEDULES).Key Columns and Structure
The table consists of columns that map to essential attributes of WIP jobs. Key columns include:- GROUP_ID: Identifies a batch of records for processing.
- PROCESS_PHASE: Indicates the processing status (e.g., 1 for pending, 2 for validated, 3 for processed).
- PROCESS_STATUS: Reflects the outcome (e.g., PENDING, ERROR, COMPLETE).
- WIP_ENTITY_ID: Unique identifier for the job or schedule.
- ORGANIZATION_ID: Specifies the inventory organization.
- JOB_TYPE: Distinguishes between discrete (1), repetitive (2), or flow (3) jobs.
- JOB_NAME: User-defined name of the job.
- DESCRIPTION: Optional job description.
- STATUS_TYPE: Job status (e.g., Unreleased, Released, Complete).
- START_QUANTITY: Initial quantity of the job.
- PRIMARY_ITEM_ID: Item being manufactured.
- BOM_REFERENCE_ID: Bill of Materials (BOM) for the job.
- ROUTING_REFERENCE_ID: Routing for the job.
- SCHEDULED_START_DATE: Planned start date.
- SCHEDULED_COMPLETION_DATE: Planned completion date.
Data Flow and Processing
The typical workflow involves:- Data Loading: External systems or scripts populate the WIP_JOB_DTLS_INTERFACE table with job details.
- Validation: The WIP Mass Load program validates records against WIP business rules (e.g., valid item, BOM, and routing).
- Error Handling: Records with errors are flagged in PROCESS_STATUS, and error details are logged in WIP_INTERFACE_ERRORS.
- Transfer to Base Tables: Validated records are moved to the appropriate WIP base tables.
Integration and Customization
The table integrates with other Oracle modules like Inventory (INV), Bills of Materials (BOM), and Shop Floor Management (SFM). Customizations may include:- Adding custom columns for extended attributes.
- Implementing PL/SQL triggers or APIs for additional validation.
- Using Oracle Integration Repository (OIC) for automated data flows.
Best Practices
- Ensure mandatory columns (e.g., ORGANIZATION_ID, JOB_NAME) are populated.
- Use unique GROUP_ID values to isolate batches.
- Monitor WIP_INTERFACE_ERRORS for troubleshooting.
- Schedule WIP Mass Load during off-peak hours for large data volumes.
-
Lookup Type: WIP_WS_WORKORDER_ACTIONS
12.1.1
product: WIP - Work in Process , meaning: Available actions from work orders tab , description: Available actions from work orders tab ,
-
Lookup Type: WIP_WS_WORKORDER_ACTIONS
12.2.2
product: WIP - Work in Process , meaning: Available actions from work orders tab , description: Available actions from work orders tab ,
-
Lookup Type: WIP_TRANSACTION_TYPE
12.2.2
product: WIP - Work in Process , meaning: WIP TRANSACTION TYPE ,
-
Lookup Type: WIP_TRANSACTION_TYPE
12.1.1
product: WIP - Work in Process , meaning: WIP TRANSACTION TYPE ,
-
Lookup Type: WIP_ENTITIES
12.1.1
product: WIP - Work in Process , meaning: WIP ENTITIES ,
-
Lookup Type: WIP_PURGE_ENTITIES
12.1.1
product: WIP - Work in Process , meaning: WIP PURGE ENTITIES ,
-
Lookup Type: WIP_PURGE_ENTITIES
12.2.2
product: WIP - Work in Process , meaning: WIP PURGE ENTITIES ,
-
Lookup Type: WIP_ENTITIES
12.2.2
product: WIP - Work in Process , meaning: WIP ENTITIES ,
-
Lookup Type: WIP_WS_RELATED_JOBS
12.2.2
product: WIP - Work in Process , meaning: Related Jobs , description: Related Jobs ,
-
Lookup Type: WIP_SCHEDULE_SELECT_JOBS
12.2.2
product: WIP - Work in Process , meaning: WIP SCHEDULE SELECT JOBS ,
-
Lookup Type: WIP_SCHEDULE_SELECT_JOBS
12.1.1
product: WIP - Work in Process , meaning: WIP SCHEDULE SELECT JOBS ,
-
Concurrent Program: WICDCL
12.1.1
execution_filename: wip_jobclose_priv.WIP_CLOSE_MGR , product: WIP - Work in Process , user_name: WICDCL , description: Discrete Job Close , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Lookup Type: WIP_EXCEPTION_ACTIONS
12.2.2
product: WIP - Work in Process , meaning: Exception Actions , description: Exception Actions ,
-
Lookup Type: WIP_WS_RELATED_JOBS
12.1.1
product: WIP - Work in Process , meaning: Related Jobs , description: Related Jobs ,
-
Lookup Type: WIP_EXCEPTION_ACTIONS
12.1.1
product: WIP - Work in Process , meaning: Exception Actions , description: Exception Actions ,
-
Concurrent Program: WICDCL
12.2.2
execution_filename: wip_jobclose_priv.WIP_CLOSE_MGR , product: WIP - Work in Process , user_name: WICDCL , description: Discrete Job Close , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Lookup Type: WIP_WS_GLOBAL_ACTIONS
12.1.1
product: WIP - Work in Process , meaning: Global Actions , description: Global Actions ,
-
Lookup Type: WIP_WS_GLOBAL_ACTIONS
12.2.2
product: WIP - Work in Process , meaning: Global Actions , description: Global Actions ,
-
Table: WIP_JOB_DTLS_INTERFACE
12.2.2
owner:WIP, object_type:TABLE, fnd_design_data:WIP.WIP_JOB_DTLS_INTERFACE, object_name:WIP_JOB_DTLS_INTERFACE, status:VALID, product: WIP - Work in Process , description: Requests to add/delete/ modify material/resource requirements for jobs and schedules , implementation_dba_data: WIP.WIP_JOB_DTLS_INTERFACE ,
-
Table: WIP_PURGE_TEMP
12.2.2
owner:WIP, object_type:TABLE, fnd_design_data:WIP.WIP_PURGE_TEMP, object_name:WIP_PURGE_TEMP, status:VALID, product: WIP - Work in Process , description: Temporary information on jobs and schedules being purged , implementation_dba_data: WIP.WIP_PURGE_TEMP ,
-
Table: WIP_JOB_DTLS_INTERFACE
12.1.1
owner:WIP, object_type:TABLE, fnd_design_data:WIP.WIP_JOB_DTLS_INTERFACE, object_name:WIP_JOB_DTLS_INTERFACE, status:VALID, product: WIP - Work in Process , description: Requests to add/delete/ modify material/resource requirements for jobs and schedules , implementation_dba_data: WIP.WIP_JOB_DTLS_INTERFACE ,
-
Lookup Type: WIP_WS_JOBOP_ACTIONS
12.1.1
product: WIP - Work in Process , meaning: Job operation actions , description: Job operation actions ,
-
Table: WIP_PURGE_TEMP
12.1.1
owner:WIP, object_type:TABLE, fnd_design_data:WIP.WIP_PURGE_TEMP, object_name:WIP_PURGE_TEMP, status:VALID, product: WIP - Work in Process , description: Temporary information on jobs and schedules being purged , implementation_dba_data: WIP.WIP_PURGE_TEMP ,
-
Lookup Type: WIP_CLOSE_SELECT_JOBS
12.2.2
product: WIP - Work in Process , meaning: WIP CLOSE SELECT JOBS ,
-
Lookup Type: WIP_CLOSE_SELECT_JOBS
12.1.1
product: WIP - Work in Process , meaning: WIP CLOSE SELECT JOBS ,
-
Table: WIP_DJ_CLOSE_TEMP
12.2.2
owner:WIP, object_type:TABLE, fnd_design_data:WIP.WIP_DJ_CLOSE_TEMP, object_name:WIP_DJ_CLOSE_TEMP, status:VALID, product: WIP - Work in Process , description: Temporary information on jobs being closed , implementation_dba_data: WIP.WIP_DJ_CLOSE_TEMP ,
-
Table: WIP_DJ_CLOSE_TEMP
12.1.1
owner:WIP, object_type:TABLE, fnd_design_data:WIP.WIP_DJ_CLOSE_TEMP, object_name:WIP_DJ_CLOSE_TEMP, status:VALID, product: WIP - Work in Process , description: Temporary information on jobs being closed , implementation_dba_data: WIP.WIP_DJ_CLOSE_TEMP ,
-
Table: WIP_SCHEDULING_EXCEPTIONS
12.1.1
owner:WIP, object_type:TABLE, fnd_design_data:WIP.WIP_SCHEDULING_EXCEPTIONS, object_name:WIP_SCHEDULING_EXCEPTIONS, status:VALID, product: WIP - Work in Process , description: Stores scheduling exceptions for discrete jobs , implementation_dba_data: WIP.WIP_SCHEDULING_EXCEPTIONS ,
-
Table: WIP_SCHEDULING_EXCEPTIONS
12.2.2
owner:WIP, object_type:TABLE, fnd_design_data:WIP.WIP_SCHEDULING_EXCEPTIONS, object_name:WIP_SCHEDULING_EXCEPTIONS, status:VALID, product: WIP - Work in Process , description: Stores scheduling exceptions for discrete jobs , implementation_dba_data: WIP.WIP_SCHEDULING_EXCEPTIONS ,
-
Lookup Type: WIP_WS_JOBOP_ACTIONS
12.2.2
product: WIP - Work in Process , meaning: Job operation actions , description: Job operation actions ,
-
Table: WIP_SHOP_FLOOR_STATUSES
12.2.2
owner:WIP, object_type:TABLE, fnd_design_data:WIP.WIP_SHOP_FLOOR_STATUSES, object_name:WIP_SHOP_FLOOR_STATUSES, status:VALID, product: WIP - Work in Process , description: Statuses assigned to particular jobs and schedules , implementation_dba_data: WIP.WIP_SHOP_FLOOR_STATUSES ,
-
View: WIP_BIS_PERIOD_BALANCE_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:WIP.WIP_BIS_PERIOD_BALANCE_V, object_name:WIP_BIS_PERIOD_BALANCE_V, status:VALID, product: WIP - Work in Process , description: Value of WIP for discrete jobs and repetitive schdules , implementation_dba_data: APPS.WIP_BIS_PERIOD_BALANCE_V ,
-
View: WIP_BIS_PERIOD_BALANCE_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:WIP.WIP_BIS_PERIOD_BALANCE_V, object_name:WIP_BIS_PERIOD_BALANCE_V, status:VALID, product: WIP - Work in Process , description: Value of WIP for discrete jobs and repetitive schdules , implementation_dba_data: APPS.WIP_BIS_PERIOD_BALANCE_V ,
-
Table: WIP_SHOP_FLOOR_STATUSES
12.1.1
owner:WIP, object_type:TABLE, fnd_design_data:WIP.WIP_SHOP_FLOOR_STATUSES, object_name:WIP_SHOP_FLOOR_STATUSES, status:VALID, product: WIP - Work in Process , description: Statuses assigned to particular jobs and schedules , implementation_dba_data: WIP.WIP_SHOP_FLOOR_STATUSES ,
-
Concurrent Program: WIPDJNBD
12.2.2
execution_filename: wip_osp.updatePOReqNBDManager , product: WIP - Work in Process , user_name: WIP Update PO/requsition Need-by Date , description: WIP Update PO/requsition Need-by Date , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Table: WIP_JOB_SCHEDULE_INTERFACE
12.1.1
owner:WIP, object_type:TABLE, fnd_design_data:WIP.WIP_JOB_SCHEDULE_INTERFACE, object_name:WIP_JOB_SCHEDULE_INTERFACE, status:VALID, product: WIP - Work in Process , description: Requests to create or modify jobs and schedules , implementation_dba_data: WIP.WIP_JOB_SCHEDULE_INTERFACE ,
-
Table: WIP_JOB_SCHEDULE_INTERFACE
12.2.2
owner:WIP, object_type:TABLE, fnd_design_data:WIP.WIP_JOB_SCHEDULE_INTERFACE, object_name:WIP_JOB_SCHEDULE_INTERFACE, status:VALID, product: WIP - Work in Process , description: Requests to create or modify jobs and schedules , implementation_dba_data: WIP.WIP_JOB_SCHEDULE_INTERFACE ,
-
Concurrent Program: WIPDJNBD
12.1.1
execution_filename: wip_osp.updatePOReqNBDManager , product: WIP - Work in Process , user_name: WIP Update PO/requsition Need-by Date , description: WIP Update PO/requsition Need-by Date , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
View: WIP_TXN_DISCRETE_JOBS_VAL_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:WIP.WIP_TXN_DISCRETE_JOBS_VAL_V, object_name:WIP_TXN_DISCRETE_JOBS_VAL_V, status:VALID, product: WIP - Work in Process , description: Released and complete discrete jobs , implementation_dba_data: APPS.WIP_TXN_DISCRETE_JOBS_VAL_V ,
-
Table: WIP_REQUIREMENT_OPERATIONS
12.1.1
owner:WIP, object_type:TABLE, fnd_design_data:WIP.WIP_REQUIREMENT_OPERATIONS, object_name:WIP_REQUIREMENT_OPERATIONS, status:VALID, product: WIP - Work in Process , description: Components required by jobs and schedules , implementation_dba_data: WIP.WIP_REQUIREMENT_OPERATIONS ,
-
View: WIP_TXN_DISCRETE_JOBS_VAL_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:WIP.WIP_TXN_DISCRETE_JOBS_VAL_V, object_name:WIP_TXN_DISCRETE_JOBS_VAL_V, status:VALID, product: WIP - Work in Process , description: Released and complete discrete jobs , implementation_dba_data: APPS.WIP_TXN_DISCRETE_JOBS_VAL_V ,
-
View: WIP_ACTIVE_DISCRETE_JOBS_VAL_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:WIP.WIP_ACTIVE_DISCRETE_JOBS_VAL_V, object_name:WIP_ACTIVE_DISCRETE_JOBS_VAL_V, status:VALID, product: WIP - Work in Process , description: Active discrete jobs , implementation_dba_data: APPS.WIP_ACTIVE_DISCRETE_JOBS_VAL_V ,
-
View: WIP_ACTIVE_DISCRETE_JOBS_VAL_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:WIP.WIP_ACTIVE_DISCRETE_JOBS_VAL_V, object_name:WIP_ACTIVE_DISCRETE_JOBS_VAL_V, status:VALID, product: WIP - Work in Process , description: Active discrete jobs , implementation_dba_data: APPS.WIP_ACTIVE_DISCRETE_JOBS_VAL_V ,
-
View: WIP_OPEN_DISCRETE_JOBS_VAL_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:WIP.WIP_OPEN_DISCRETE_JOBS_VAL_V, object_name:WIP_OPEN_DISCRETE_JOBS_VAL_V, status:VALID, product: WIP - Work in Process , description: Open discrete jobs , implementation_dba_data: APPS.WIP_OPEN_DISCRETE_JOBS_VAL_V ,
-
View: WIP_OPEN_DISCRETE_JOBS_VAL_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:WIP.WIP_OPEN_DISCRETE_JOBS_VAL_V, object_name:WIP_OPEN_DISCRETE_JOBS_VAL_V, status:VALID, product: WIP - Work in Process , description: Open discrete jobs , implementation_dba_data: APPS.WIP_OPEN_DISCRETE_JOBS_VAL_V ,
-
Table: WIP_REQUIREMENT_OPERATIONS
12.2.2
owner:WIP, object_type:TABLE, fnd_design_data:WIP.WIP_REQUIREMENT_OPERATIONS, object_name:WIP_REQUIREMENT_OPERATIONS, status:VALID, product: WIP - Work in Process , description: Components required by jobs and schedules , implementation_dba_data: WIP.WIP_REQUIREMENT_OPERATIONS ,
-
View: WIP_OSP_JOBS_VAL_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:WIP.WIP_OSP_JOBS_VAL_V, object_name:WIP_OSP_JOBS_VAL_V, status:VALID, product: WIP - Work in Process , description: Active jobs with outside processing resources , implementation_dba_data: APPS.WIP_OSP_JOBS_VAL_V ,
-
View: WIP_OSP_JOBS_VAL_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:WIP.WIP_OSP_JOBS_VAL_V, object_name:WIP_OSP_JOBS_VAL_V, status:VALID, product: WIP - Work in Process , description: Active jobs with outside processing resources , implementation_dba_data: APPS.WIP_OSP_JOBS_VAL_V ,
-
Table: WIP_OPERATIONS
12.2.2
owner:WIP, object_type:TABLE, fnd_design_data:WIP.WIP_OPERATIONS, object_name:WIP_OPERATIONS, status:VALID, product: WIP - Work in Process , description: Operations necessary for jobs and schedules , implementation_dba_data: WIP.WIP_OPERATIONS ,
-
Table: WIP_OPERATIONS
12.1.1
owner:WIP, object_type:TABLE, fnd_design_data:WIP.WIP_OPERATIONS, object_name:WIP_OPERATIONS, status:VALID, product: WIP - Work in Process , description: Operations necessary for jobs and schedules , implementation_dba_data: WIP.WIP_OPERATIONS ,