You are browsing the archive for Technical Design.

Oracle WIP Forms

Oracle Work In Process forms:

FORM SHORT CODEORACLE FORM NAME
WIPDJMDFDefine Discrete Job
WIPJSINTPending Jobs and Schedules
WIPMRMDFMaterial Requirements
WIPMRQAWMaterial Requirements across WIP
WIPOPMDFUpdate WIP Operations
WIPOPQAWOperations across WIP
WIPPCBDWDiscrete Workstation
WIPPCBFWFlow Workstation
WIPREMALRepetitive Line/Assembly Associations
WIPREMDFDefine Repetitive Schedules
WIPREMLNProduction Line
WIPRRQAWResource Requirements across WIP
WIPSGMDFSchedule Groups
WIPSTMSCUpdate Shop Floor Statuses
WIPSUMCLDefine WIP Accounting Class
WIPSUMLREmployee Labor Rates
WIPSUMPMDefine Work in Process Parameters
WIPSUMSTDefine Shop Floor Statuses
WIPTIRSCResource Transactions Interface
WIPTISFMMove Transactions Interface
WIPTQJLCJob Lot Composition
WIPTQRSCView Resource Transactions
WIPTQSFMView Move Transactions
WIPTXCFMWork Order-less Completions
WIPTXCMPCompletion Transactions
WIPTXMATWIP Material Transactions
WIPTXRSCResource Transactions
WIPTXSFMMove Transactions
WIPCMPPKComponent Pick Release
WMA_MOBILE_FORMWMA Mobile Forms
WIPZJBWBJob Workbench
WIPZRSWBResource Workbench
WIPZEMWBScheduler Workbench

Work In Process Concurrent Programs

Oracle WIP Concurrent Programs

CONCURRENT PROGRAM SHORT CODECONCURRENT PROGRAM NAME
WIPDJDATDiscrete Job Data Report
WIPUTVALWIP Value Report
WIPTSMOVMove Transaction Report
WIPSUPMTWIP Parameters Report
WIPREDATRepetitive Schedule Data Report
WIPSUSTAShop Floor Statuses Report
WIPSULINProduction Line Report
WICMEXWIP Discrete Job Concurrent Exploder
WIPMTDLTJob Lot Composition Report
WICTWSWIP Move Transaction Worker
WICTMSWIP Move Transaction Manager
WIPSUEMPEmployee Rates Listing
WICDOLAutoCreate Final Assembly Orders
WIPLBPERResource Performance Report
WIPRELINRepetitive Line Report
WIPTRTXNResource Transaction Report
WIPUTOACWIP Offsetting Account Report
WIPDJPCKDiscrete Job Pick List Report
WIPREPCKRepetitive Pick List Report
WIPRDJVRDiscrete Job Value Report – Standard Costing
WIPDJLISDiscrete Job Listing Report
WIPDJDSPDiscrete Job Dispatch Report
WIPDJORQDiscrete Job Shortage Report
WIPREORQRepetitive Schedule Shortage Report
WIPDJATOAssemble To Order Mass Load Report
WIPSUCLSWIP Accounting Classes Report
WIPRERTGRepetitive Routing Sheet
WIPDJRTGDiscrete Job Routing Sheet
WIPUTACSWIP Account Summary Report
WIPREJVRExpense Job Value Report
WIPUTACDWIP Account Distribution Report
WIPMTLCTWIP Location Report
WIPREVALRepetitive Value Report
WIPLBOSPWIP Outside Processing Report
WIXTOPWIP Transaction Processor
WIXSOPWIP Sales Order Processor
WICDCLClose Discrete Jobs
WIPMLINTJob and Schedule Interface Report
WIPPURGEWIP Purge
WIPSGLISSchedule Group Listing
WICMLPWIP Mass Load
WIPBINDCapture Production Indicators
WIPBPTPCapture Production Performance
WIPSILDWLoad WIP (WIP Scheduling Interface)
WIPRECMPRepetitive Schedule Component Pick Release
WIPDJCMPDiscrete Job Component Pick Release
WIPBWITCapture WIP Inventory Trend
WIPDJNBDDiscrete Update OSP Need-by Dates
WIPRSNBDRepetitive Update OSP Need-by Dates
WIPWSSHDiscrete MES Shortage Calculation
WIPDJDAT_XMLDiscrete Job Data Report
WIPDJDSP_XMLDiscrete Job Dispatch Report
WIPMTLCT_XMLWIP Location Report
WIPPURGE_XMLWIP Purge
WIPRDJVR_XMLDiscrete Job Value Report – Standard Costing
WIPREDAT_XMLRepetitive Schedule Data Report
WIPREJVR_XMLExpense Job Value Report
WIPRELIN_XMLRepetitive Line Report
WIPREORQ_XMLRepetitive Schedule Shortage Report
WIPREPCK_XMLRepetitive Pick List Report
WIPRERTG_XMLRepetitive Routing Sheet
WIPREVAL_XMLRepetitive Value Report
WIPDJLIS_XMLDiscrete Job Listing Report
WIPDJORQ_XMLDiscrete Job Shortage Report
WIPDJPCK_XMLDiscrete Job Pick List Report
WIPDJRTG_XMLDiscrete Job Routing Sheet
WIPLBOSP_XMLWIP Outside Processing Report
WIPLBPER_XMLResource Performance Report
WIPMLINT_XMLJob and Schedule Interface Report
WIPMTDLT_XMLJob Lot Composition Report
WIPSGLIS_XMLSchedule Group Listing
WIPSUCLS_XMLWIP Accounting Classes Report
WIPSUEMP_XMLEmployee Rates Listing
WIPSULIN_XMLProduction Line Report
WIPSUPMT_XMLWIP Parameters Report
WIPSUSTA_XMLShop Floor Statuses Report
WIPTRTXN_XMLResource Transaction Report
WIPTSMOV_XMLMove Transaction Report
WIPUTACD_XMLWIP Account Distribution Report
WIPUTACS_XMLWIP Account Summary Report
WIPUTOAC_XMLWIP Offsetting Account Report
WIPUTVAL_XMLWIP Value Report
WIP_WS_LAB_METRICSDiscrete MES Labor Performance Metrics Calculation
WIP_TIME_ENTRY_DATADiscrete MES Import Actual Times
MESPTPCALCDiscrete MES Production to Plan Calculation
MESFPYCALCDiscrete MES First Pass Yield Calculation
MESPPMDCALCDiscrete MES Parts per Million Defects Calculation

Work In Process Tables

Oracle Work In Process (WIP) Tables:

  • WIP_ACCOUNTING_CLASSES
  • WIP_BIS_EFF_TEMP
  • WIP_BIS_MNRA_TEMP
  • WIP_BIS_PERF_TO_PLAN
  • WIP_BIS_PERIOD_BALANCE
  • WIP_BIS_PROD_ASSY_YIELD
  • WIP_BIS_PROD_ASSY_YIELD_TEMP
  • WIP_BIS_PROD_DEPT_YIELD
  • WIP_BIS_PROD_DEPT_YIELD_TEMP
  • WIP_BIS_PROD_INDICATORS
  • WIP_BIS_PROD_INDICATORS_TEMP
  • WIP_BIS_UTZ_TEMP
  • WIP_BIS_YLD_TEMP
  • WIP_COST_TXN_INTERFACE
  • WIP_DEF_CAT_ACC_CLASSES
  • WIP_DISCRETE_JOBS
  • WIP_DJ_CLOSE_TEMP
  • WIP_EAM_DIRECT_ITEMS
  • WIP_EAM_PARAMETERS
  • WIP_EAM_PERIOD_BALANCES
  • WIP_EAM_WORK_REQUESTS
  • WIP_EAM_WORK_REQ_NOTES
  • WIP_EMPLOYEE_LABOR_RATES
  • WIP_EMPLOYEE_LABOR_RATES_EFC
  • WIP_ENTITIES
  • WIP_EXCEPTIONS
  • WIP_FLOW_SCHEDULES
  • WIP_INDICATORS_TEMP
  • WIP_INTERFACE_ERRORS
  • WIP_JOB_DTLS_INTERFACE
  • WIP_JOB_SCHEDULE_INTERFACE
  • WIP_LEADTIME_TEMP
  • WIP_LINES
  • WIP_LPN_COMPLETIONS
  • WIP_LPN_COMPLETIONS_LOTS
  • WIP_LPN_COMPLETIONS_SERIALS
  • WIP_MOVE_TRANSACTIONS
  • WIP_MOVE_TXN_ALLOCATIONS
  • WIP_MOVE_TXN_INTERFACE
  • WIP_MSC_OPEN_JOB_STATUSES
  • WIP_MTL_ALLOCATIONS_TEMP
  • WIP_OPERATIONS
  • WIP_OPERATION_NETWORKS
  • WIP_OPERATION_OVERHEADS
  • WIP_OPERATION_OVERHEADS_EFC
  • WIP_OPERATION_RESOURCES
  • WIP_OPERATION_RESOURCES_EFC
  • WIP_OPERATION_RESOURCE_USAGE
  • WIP_OPERATION_YIELDS
  • WIP_OPERATION_YIELDS_EFC
  • WIP_OP_RESOURCE_INSTANCES
  • WIP_OP_YIELD_HISTORY
  • WIP_OP_YIELD_REALLOCATIONS
  • WIP_PAC_ACTUAL_COST_DETAILS
  • WIP_PAC_ACTUAL_COST_DETAIL_EFC
  • WIP_PAC_PERIOD_BALANCES
  • WIP_PAC_PERIOD_BALANCES_EFC
  • WIP_PARAMETERS
  • WIP_PERIOD_BALANCES
  • WIP_PERIOD_BALANCES_EFC
  • WIP_PREFERENCES
  • WIP_PREFERENCE_DEFINITIONS
  • WIP_PREFERENCE_LEVELS
  • WIP_PREFERENCE_VALUES
  • WIP_PURGE_TEMP
  • WIP_REPETITIVE_ITEMS
  • WIP_REPETITIVE_SCHEDULES
  • WIP_REQUIREMENT_OPERATIONS
  • WIP_REQ_OPERATION_COST_DETAILS
  • WIP_REQ_OPERATION_COST_DET_EFC
  • WIP_RESOURCE_ACTUAL_TIMES
  • WIP_SCHEDULE_GROUPS
  • WIP_SCHEDULING_EXCEPTIONS
  • WIP_SCHEDULING_INTERFACE
  • WIP_SCHED_RELATIONSHIPS
  • WIP_SCRAP_VALUES
  • WIP_SCRAP_VALUES_EFC
  • WIP_SERIAL_MOVE_INTERFACE
  • WIP_SERIAL_MOVE_TRANSACTIONS
  • WIP_SHOP_FLOOR_STATUSES
  • WIP_SHOP_FLOOR_STATUS_CODES
  • WIP_SO_ALLOCATIONS
  • WIP_SO_ALLOCATIONS_TEMP
  • WIP_SUB_OPERATION_RESOURCES
  • WIP_SUB_OPERATION_RESOURCE_EFC
  • WIP_TEMP_REPORTS
  • WIP_TRANSACTIONS
  • WIP_TRANSACTIONS_EFC
  • WIP_TRANSACTION_ACCOUNTS
  • WIP_TRANSACTION_ACCOUNTS_EFC
  • WIP_TXN_ALLOCATIONS
  • WIP_TXN_INTERFACE_ERRORS
  • WIP_VALID_INTRAOPERATION_STEPS