You are browsing the archive for Technical Design.

Oracle WIP Forms

Oracle Work In Process forms:

FORM SHORT CODE ORACLE FORM NAME
WIPDJMDF Define Discrete Job
WIPJSINT Pending Jobs and Schedules
WIPMRMDF Material Requirements
WIPMRQAW Material Requirements across WIP
WIPOPMDF Update WIP Operations
WIPOPQAW Operations across WIP
WIPPCBDW Discrete Workstation
WIPPCBFW Flow Workstation
WIPREMAL Repetitive Line/Assembly Associations
WIPREMDF Define Repetitive Schedules
WIPREMLN Production Line
WIPRRQAW Resource Requirements across WIP
WIPSGMDF Schedule Groups
WIPSTMSC Update Shop Floor Statuses
WIPSUMCL Define WIP Accounting Class
WIPSUMLR Employee Labor Rates
WIPSUMPM Define Work in Process Parameters
WIPSUMST Define Shop Floor Statuses
WIPTIRSC Resource Transactions Interface
WIPTISFM Move Transactions Interface
WIPTQJLC Job Lot Composition
WIPTQRSC View Resource Transactions
WIPTQSFM View Move Transactions
WIPTXCFM Work Order-less Completions
WIPTXCMP Completion Transactions
WIPTXMAT WIP Material Transactions
WIPTXRSC Resource Transactions
WIPTXSFM Move Transactions
WIPCMPPK Component Pick Release
WMA_MOBILE_FORM WMA Mobile Forms
WIPZJBWB Job Workbench
WIPZRSWB Resource Workbench
WIPZEMWB Scheduler Workbench

Work In Process Concurrent Programs

Oracle WIP Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
WIPDJDAT Discrete Job Data Report
WIPUTVAL WIP Value Report
WIPTSMOV Move Transaction Report
WIPSUPMT WIP Parameters Report
WIPREDAT Repetitive Schedule Data Report
WIPSUSTA Shop Floor Statuses Report
WIPSULIN Production Line Report
WICMEX WIP Discrete Job Concurrent Exploder
WIPMTDLT Job Lot Composition Report
WICTWS WIP Move Transaction Worker
WICTMS WIP Move Transaction Manager
WIPSUEMP Employee Rates Listing
WICDOL AutoCreate Final Assembly Orders
WIPLBPER Resource Performance Report
WIPRELIN Repetitive Line Report
WIPTRTXN Resource Transaction Report
WIPUTOAC WIP Offsetting Account Report
WIPDJPCK Discrete Job Pick List Report
WIPREPCK Repetitive Pick List Report
WIPRDJVR Discrete Job Value Report – Standard Costing
WIPDJLIS Discrete Job Listing Report
WIPDJDSP Discrete Job Dispatch Report
WIPDJORQ Discrete Job Shortage Report
WIPREORQ Repetitive Schedule Shortage Report
WIPDJATO Assemble To Order Mass Load Report
WIPSUCLS WIP Accounting Classes Report
WIPRERTG Repetitive Routing Sheet
WIPDJRTG Discrete Job Routing Sheet
WIPUTACS WIP Account Summary Report
WIPREJVR Expense Job Value Report
WIPUTACD WIP Account Distribution Report
WIPMTLCT WIP Location Report
WIPREVAL Repetitive Value Report
WIPLBOSP WIP Outside Processing Report
WIXTOP WIP Transaction Processor
WIXSOP WIP Sales Order Processor
WICDCL Close Discrete Jobs
WIPMLINT Job and Schedule Interface Report
WIPPURGE WIP Purge
WIPSGLIS Schedule Group Listing
WICMLP WIP Mass Load
WIPBIND Capture Production Indicators
WIPBPTP Capture Production Performance
WIPSILDW Load WIP (WIP Scheduling Interface)
WIPRECMP Repetitive Schedule Component Pick Release
WIPDJCMP Discrete Job Component Pick Release
WIPBWIT Capture WIP Inventory Trend
WIPDJNBD Discrete Update OSP Need-by Dates
WIPRSNBD Repetitive Update OSP Need-by Dates
WIPWSSH Discrete MES Shortage Calculation
WIPDJDAT_XML Discrete Job Data Report
WIPDJDSP_XML Discrete Job Dispatch Report
WIPMTLCT_XML WIP Location Report
WIPPURGE_XML WIP Purge
WIPRDJVR_XML Discrete Job Value Report – Standard Costing
WIPREDAT_XML Repetitive Schedule Data Report
WIPREJVR_XML Expense Job Value Report
WIPRELIN_XML Repetitive Line Report
WIPREORQ_XML Repetitive Schedule Shortage Report
WIPREPCK_XML Repetitive Pick List Report
WIPRERTG_XML Repetitive Routing Sheet
WIPREVAL_XML Repetitive Value Report
WIPDJLIS_XML Discrete Job Listing Report
WIPDJORQ_XML Discrete Job Shortage Report
WIPDJPCK_XML Discrete Job Pick List Report
WIPDJRTG_XML Discrete Job Routing Sheet
WIPLBOSP_XML WIP Outside Processing Report
WIPLBPER_XML Resource Performance Report
WIPMLINT_XML Job and Schedule Interface Report
WIPMTDLT_XML Job Lot Composition Report
WIPSGLIS_XML Schedule Group Listing
WIPSUCLS_XML WIP Accounting Classes Report
WIPSUEMP_XML Employee Rates Listing
WIPSULIN_XML Production Line Report
WIPSUPMT_XML WIP Parameters Report
WIPSUSTA_XML Shop Floor Statuses Report
WIPTRTXN_XML Resource Transaction Report
WIPTSMOV_XML Move Transaction Report
WIPUTACD_XML WIP Account Distribution Report
WIPUTACS_XML WIP Account Summary Report
WIPUTOAC_XML WIP Offsetting Account Report
WIPUTVAL_XML WIP Value Report
WIP_WS_LAB_METRICS Discrete MES Labor Performance Metrics Calculation
WIP_TIME_ENTRY_DATA Discrete MES Import Actual Times
MESPTPCALC Discrete MES Production to Plan Calculation
MESFPYCALC Discrete MES First Pass Yield Calculation
MESPPMDCALC Discrete 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