You are browsing the archive for Oracle Work In Process.

Oracle Work In Process Overview

Oracle WIP module facilitates in creating WIP job or work order to manufacture the goods. Oracle WIP supports discrete, repetitive, project and assemble-to-order (ATO) type of work orders.

Non-standard WIP Job: When the material and resources needed to manufacture is not pre-determined or pre-calculated then non-standard WIP job can facilitate issuing material and resources as needed. Prototype manufacturing is a good example to this.

WIP Accounting Classes: Accounting class is a setup that have pre-defined list of valuation and variance accounts. Each discrete job is assigned with a accounting class.

Out-Side-Processing (OSP): With more and more industries are moving towards Outsourcing or contract manufacturing, ERP systems should have functionality to send goods out and receive back after performing certain operations. Oracle WIP module have Out side processing (OSP) functionality to support this.

Work Order Less Completion (WOLC): This is an alternative to standard discrete job. In this method on-hand can be increased by performing WOLC transaction instead of creating a WIP Job. This functionality will be very useful if you are using other legacy system as your shop floor manufacturing tool and WIP is used for inventory tracking purpose.

Backflushing: When you manufacture a job or assembly you need to issue material or resources to the job, this can be done in two ways. Manually issuing or automatically backflushing. Backflushing deducts reduces the onhand of sub components and updates configuration of assembly being manufactured as components issued.

Views in Oracle Work In Process Module

List of views in Oracle WIP module

WIP_ACCOUNTING_CLASSES_DFV
WIP_ACCOUNTING_CLASSES1_DFV
WIP_ACTIVE_DISCRETE_JOBS_VAL_V
WIP_BIS_LATE_PROD_COMP_V
WIP_BIS_PERF_TO_PLAN_V
WIP_BIS_PERIOD_BALANCE_V
WIP_BIS_PROD_ASSY_YIELD_V
WIP_BIS_PROD_DEPT_YIELD_V
WIP_BIS_PROD_VAL_EMP_V
WIP_BIS_PRODUCTIVITIES_V
WIP_BIS_SCRAP_REASONS_V
WIP_BIS_UTZ_CAT_V
WIP_BIS_UTZ_CATNOITEM_V
WIP_BIS_UTZ_NOCAT_V
WIP_COMMENT_CODES_V
WIP_COMP_SALES_ORDERS_VAL_V
WIP_COST_TXN_INTERFACE_DFV
WIP_COST_TXN_INTERFACE_V
WIP_CUMULATIVE_SCRAP_V
WIP_CUR_NET_AVAILABLE_VIEW
WIP_CUR_SUB_LOC_NET_AVAIL_VIEW
WIP_DEF_CAT_ACC_CLASSES_V
WIP_DEPT_IMM_DISPATCH_V
WIP_DEPT_RESOURCES_V
WIP_DEPT_UPS_DISPATCH_V
WIP_DISC_INTRAOP_STEPS_VAL_V
WIP_DISCRETE_CLASSES_ALL_V
WIP_DISCRETE_JOBS_ALL_V
WIP_DISCRETE_JOBS_DFV
WIP_DISCRETE_JOBS_V
WIP_EAM_COST_DETAILS_V
WIP_EAM_CST_HEADER_V
WIP_EAM_DIRECT_ITEMS_V
WIP_EAM_ENTITIES_V
WIP_EAM_NEXT_OPERATIONS_V
WIP_EAM_OP_COST_DETAILS_V
WIP_EAM_OSP_V
WIP_EAM_PARAMETERS_V
WIP_EAM_PRIOR_OPERATIONS_V
WIP_EAM_REQUIREMENTS_ALL_V
WIP_EAM_WO_SRV_ASSOC_V
WIP_EAM_WORK_ORDER_DTLS_V
WIP_EAM_WORK_ORDERS_V
WIP_EAM_WORK_REQUESTS_DFV
WIP_EAM_WORK_REQUESTS_V
WIP_EMPLOYEE_LABOR_RATES_DFV
WIP_ENTITY_COMMENTS_V
WIP_EXCEPTIONS_DFV
WIP_EXPLOSIONS_V
WIP_FIRST_ACTIVE_SCHEDULE_V
WIP_FIRST_OPEN_SCHEDULE_V
WIP_FIRST_TXN_SCHEDULE_V
WIP_FLOW_ASSEMBLIES_V
WIP_FLOW_ASSEMBLY_EVENTS_V
WIP_FLOW_LINE_LINEARITY_V
WIP_FLOW_MIX_LINEARITY_V
WIP_FLOW_OPEN_ALLOCATIONS_V
WIP_FLOW_SCHEDULE_EVENTS_V
WIP_FLOW_SCHEDULES_DFV
WIP_FLOW_SCHEDULES_V
WIP_ICX_COMPONENTS_V
WIP_ICX_OSP_WORKBENCH_V
WIP_INST_EMP_IMM_DISPATCH_V
WIP_INST_EMP_UPS_DISPATCH_V
WIP_INST_EQP_IMM_DISPATCH_V
WIP_INST_EQP_UPS_DISPATCH_V
WIP_INTERFACE_ERRORS_V
WIP_JOB_ASSY_LINE_V
WIP_JOB_LOT_COMPOSITION_V
WIP_JOB_OPEN_ALLOCATIONS_V
WIP_JOB_SCHEDULE_INTERFACE_V
WIP_JOB_SERIAL_NUMBERS_V
WIP_JOBS_AND_SCHEDULES_V
WIP_JOBS_RESERVATIONS_V
WIP_LINE_OPERATIONS_V
WIP_LINES_ALL_V
WIP_LINES_DFV
WIP_LINES_VAL_V
WIP_LOTJOB_OPEN_ALLOCATIONS_V
WIP_MATERIAL_SHORTAGES_V
WIP_MOVE_TRANSACTIONS_V
WIP_MOVE_TXN_INTERFACE_DFV
WIP_MOVE_TXN_INTERFACE_V
WIP_NET_AVAILABLE_VIEW
WIP_NON_STANDARD_CLASSES_VAL_V
WIP_ON_DISCRETE_JOBS_V
WIP_OP_RES_INSTANCE_USAGE_V
WIP_OP_RESOURCE_INSTANCES_V
WIP_OPEN_DEMANDS_V
WIP_OPEN_DISCRETE_JOBS_VAL_V
WIP_OPEN_FLOW_SCHEDULES_V
WIP_OPEN_SCHEDULES_VAL_V
WIP_OPERATION_INSTRUCTIONS_V
WIP_OPERATION_RESOURCE_USAGE_V
WIP_OPERATION_RESOURCES_INQ_V
WIP_OPERATION_RESOURCES_V
WIP_OPERATION_SKILLS_V
WIP_OPERATIONS_ALL_V
WIP_OPERATIONS_INQ_V
WIP_OPERATIONS_V
WIP_OSP_DEST_OPERATION_V
WIP_OSP_JOBS_VAL_V
WIP_OSP_LINES_VAL_V
WIP_OSP_OPERATIONS_VAL_V
WIP_OSP_REP_ASSY_VAL_V
WIP_OSP_REP_SCHED_VAL_V
WIP_OSP_REQS_POS_V
WIP_OSP_RESOURCES_VAL_V
WIP_PARAMETERS_DFV
WIP_PARAMETERS_V
WIP_PCB_BOM_DEPARTMENTS_V
WIP_PCB_DEPT_IMM_DISPATCH_V
WIP_PCB_DEPT_RESOURCES_V
WIP_PCB_DEPT_UPS_DISPATCH_V
WIP_PCB_EMP_IMM_DISPATCH_V
WIP_PCB_EMP_UPS_DISPATCH_V
WIP_PCB_EQP_IMM_DISPATCH_V
WIP_PCB_EQP_UPS_DISPATCH_V
WIP_PCB_FLOW_ASSEMBLIES_V
WIP_PCB_FLOW_ASSEMBLY_EVENTS_V
WIP_PCB_FLOW_SCHEDULE_EVENTS_V
WIP_PCB_OPEN_FLOW_SCHEDULES_V
WIP_PCB_RES_IMM_DISPATCH_V
WIP_PCB_RES_INST_EMPLOYEES_V
WIP_PCB_RES_INST_EQUIPMENTS_V
WIP_PCB_RES_UPS_DISPATCH_V
WIP_REP_ASSY_VAL_V
WIP_REP_INTRAOP_STEPS_VAL_V
WIP_REP_OPEN_ALLOCATIONS_V
WIP_REP_QUANTITY_SCRAPPED_V
WIP_REPETITIVE_CLASSES_VAL_V
WIP_REPETITIVE_ENTITIES_V
WIP_REPETITIVE_ITEMS_V
WIP_REPETITIVE_SCHEDULES_DFV
WIP_REPETITIVE_SCHEDULES_V
WIP_REQUIREMENT_OPERATIONS_V
WIP_REQUIREMENT_OPS_INQ_V
WIP_RES_IMM_DISPATCH_V
WIP_RES_INST_EMPLOYEES_V
WIP_RES_INST_EQUIPMENTS_V
WIP_RES_UNITS_WORKED_VIEW
WIP_RES_UPS_DISPATCH_V
WIP_RESERVATIONS_V
WIP_RET_SALES_ORDERS_VAL_V
WIP_SALES_ORDER_LINES_V
WIP_SCHEDULE_GROUPS_DFV
WIP_SCHEDULE_GROUPS_VAL_V
WIP_SCHEDULING_ERRORS_V
WIP_SCHEDULING_EXCEPTIONS_V
WIP_SHOP_FLOOR_STATUS_CODE_DFV
WIP_SHOP_FLOOR_STATUSES_V
WIP_SHOP_FLOOR_STATUSES_VAL_V
WIP_SO_ALLOCATIONS_V
WIP_STANDARD_CLASSES_VAL_V
WIP_SUB_LOC_NET_AVAIL_VIEW
WIP_SUB_OPERATION_RESOURCES_V
WIP_TRANSACTIONS_DFV
WIP_TRANSACTIONS_V
WIP_TX_REP_INTRAOP_STEPS_VAL_V
WIP_TXN_COMP_INTERFACE_V
WIP_TXN_DISCRETE_JOBS_VAL_V
WIP_TXN_REP_ASSY_VAL_V
WIP_VALID_INTRAOPERATION_S_DFV
WIP_WORKFLOW_V
WIP_WS_PTPKPI_AGG_V
WIPBV_ACCOUNTING_CLASSES
WIPBV_FLOW_SCHED_COMPS
WIPBV_FLOW_SCHEDULES
WIPBV_INTRAOP_STEP_STATUSES
WIPBV_JOB_CLOSE_VARIANCE_TXNS
WIPBV_MFG_COST_UPDATE_TXNS
WIPBV_MFG_ORDERS
WIPBV_MFG_RESOURCE_TXNS
WIPBV_MFG_TRANSACTIONS
WIPBV_MTL_TXN_ALLOCATIONS
WIPBV_OSP_MFG_TXNS
WIPBV_OVERHEAD_MFG_TXNS
WIPBV_PERIOD_CLOSE_VAR_TXNS
WIPBV_REPETITIVE_SCHEDULES
WIPBV_WIP_COMPONENTS
WIPBV_WIP_EMPLOYEE_LABOR_RATES
WIPBV_WIP_INTRAOPERATION_STEPS
WIPBV_WIP_JOBS
WIPBV_WIP_MOVE_TRANSACTIONS
WIPBV_WIP_MOVE_TXN_ALLOCATIONS
WIPBV_WIP_OPERATION_RESOURCES
WIPBV_WIP_OPERATIONS
WIPBV_WIP_PERIOD_BALANCES
WIPBV_WIP_REPETITIVE_ITEMS
WIPBV_WIP_RESERVATIONS
WIPBV_WIP_SCHEDULE_GROUPS
WIPBV_WIP_STATUS_CODES
WIPBV_WIP_TXN_ALLOCATIONS
WIPFV_ACCOUNTING_CLASSES
WIPFV_FLOW_SCHED_COMPS
WIPFV_FLOW_SCHEDULES
WIPFV_INTRAOP_STEP_STATUSES
WIPFV_JOB_CLOSE_VARIANCE_TXNS
WIPFV_MFG_COST_UPDATE_TXNS
WIPFV_MFG_ORDERS
WIPFV_MFG_RESOURCE_TXNS
WIPFV_MFG_TRANSACTIONS
WIPFV_MTL_TXN_ALLOCATIONS
WIPFV_OSP_MFG_TXNS
WIPFV_OVERHEAD_MFG_TXNS
WIPFV_PERIOD_CLOSE_VAR_TXNS
WIPFV_REPETITIVE_SCHEDULES
WIPFV_WIP_COMPONENTS
WIPFV_WIP_EMPLOYEE_LABOR_RATES
WIPFV_WIP_INTRAOPERATION_STEPS
WIPFV_WIP_JOBS
WIPFV_WIP_MOVE_TRANSACTIONS
WIPFV_WIP_MOVE_TXN_ALLOCATIONS
WIPFV_WIP_OPERATION_RESOURCES
WIPFV_WIP_OPERATIONS
WIPFV_WIP_PERIOD_BALANCES
WIPFV_WIP_REPETITIVE_ITEMS
WIPFV_WIP_RESERVATIONS
WIPFV_WIP_SCHEDULE_GROUPS
WIPFV_WIP_STATUS_CODES
WIPFV_WIP_TXN_ALLOCATIONS