WIP Tables (96)

WIP - Work in Process — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
WIP_ACCOUNTING_CLASSES	65	Accounting classes
WIP_BIS_EFF_TEMP	35
WIP_BIS_MNRA_TEMP	6
WIP_BIS_PERF_TO_PLAN	16	Scheduled production and actual production
WIP_BIS_PERIOD_BALANCE	9	the summary table for WIP inventory trend BIS report.
WIP_BIS_PROD_ASSY_YIELD	37	Production assembly yield
WIP_BIS_PROD_ASSY_YIELD_TEMP	37
WIP_BIS_PROD_DEPT_YIELD	37	Yield by department
WIP_BIS_PROD_DEPT_YIELD_TEMP	37
WIP_BIS_PROD_INDICATORS	48	Productivity, utilization, and yield, by job, assembly, department, and resource
WIP_BIS_PROD_INDICATORS_TEMP	48
WIP_BIS_UTZ_TEMP	35
WIP_BIS_YLD_TEMP	35
WIP_COST_TXN_INTERFACE	90	Requests to process cost transactions
WIP_DEF_CAT_ACC_CLASSES	30	Default accounting classes
WIP_DISCRETE_JOBS	121	Discrete jobs
WIP_DJ_CLOSE_TEMP	7	Temporary information on jobs being closed
WIP_EAM_DIRECT_ITEMS	47	Table for storing description based direct items.
WIP_EAM_PARAMETERS	34	Organization parameters for EAM enabled organization
WIP_EAM_PERIOD_BALANCES	28	EAM Job charges by accounting period
WIP_EAM_WORK_REQUESTS	45	Table for work request information
WIP_EAM_WORK_REQ_NOTES	10	Table to store work requests log information
WIP_EMPLOYEE_LABOR_RATES	30	Employee hourly labor rates
WIP_EMPLOYEE_LABOR_RATES_EFC	5	EURO as a functional currency table for WIP_EMPLOYEE_LABOR_RATES.
WIP_ENTITIES	16	Information common to jobs and schedules
WIP_EXCEPTIONS	39	Wip exceptions
WIP_FLOW_SCHEDULES	78	Work order-less flow schedules
WIP_INDICATORS_TEMP	35	Temporary table used for calculating the production indicators from the transaction information
WIP_INTERFACE_ERRORS	8	Errors encountered while processing open interface requests
WIP_JOB_DTLS_INTERFACE	92	Requests to add/delete/ modify material/resource requirements for jobs and schedules
WIP_JOB_SCHEDULE_INTERFACE	119	Requests to create or modify jobs and schedules
WIP_LEADTIME_TEMP	3	This table is used while calculating leadtime for a item. This is required to determine order of operation on Network.
WIP_LINES	41	Production lines
WIP_LPN_COMPLETIONS	55	This table contains material for WIP Lpn completions (Mobile Apps)
WIP_LPN_COMPLETIONS_LOTS	91	This table contains lot information for materials being processed in WIP Lpn completions (Mobile Apps)
WIP_LPN_COMPLETIONS_SERIALS	73	This table contains serial information for materials being processed in WIP Lpn completions (Mobile Apps)
WIP_MOVE_TRANSACTIONS	61	Shop floor move transactions
WIP_MOVE_TXN_ALLOCATIONS	14	Move transaction allocations for repetitive schedules
WIP_MOVE_TXN_INTERFACE	73	Requests to process shop floor move transactions
WIP_MSC_OPEN_JOB_STATUSES	2	This table is used by MRP to improve snapshot refresh performance. It contains only one column for job status. It should only be populated w
WIP_MTL_ALLOCATIONS_TEMP	16	This table holds temporary repetitive schedule allocation data for completion transactions. It is used during completion transactions to det
WIP_OPERATIONS	76	Operations necessary for jobs and schedules
WIP_OPERATION_NETWORKS	25	Operation dependency
WIP_OPERATION_OVERHEADS	26	Overheads for operations in an average costing organization
WIP_OPERATION_OVERHEADS_EFC	11	EURO as a functional currency table for WIP_OPERATION_OVERHEADS.
WIP_OPERATION_RESOURCES	70	Resources necessary for operations
WIP_OPERATION_RESOURCES_EFC	11	EURO as a functional currency table for WIP_OPERATION_RESOURCES.
WIP_OPERATION_RESOURCE_USAGE	20	Resource usage in an operation resource according to the shift and calendar information
WIP_OPERATION_YIELDS	24	This table keeps all costing information for operation yield costing.
WIP_OPERATION_YIELDS_EFC	8	EURO as a functional currency table for WIP_OPERATION_YIELDS.
WIP_OP_RESOURCE_INSTANCES	14	resource instances
WIP_OP_YIELD_HISTORY	16	This table stores total Estimated scrap absorption, scrap reversal, Estimated scrap reversal, Estimated scrap variance at job close of a wsm
WIP_OP_YIELD_REALLOCATIONS	17	This table stores allocation of Estimated scrap absorption cost due to completion of assembly in a job. This table have one row for each WSM
WIP_PAC_ACTUAL_COST_DETAILS	22	Stores the cost of each resource, overhead, outside processing and job close transaction by entity, period, and cost group
WIP_PAC_ACTUAL_COST_DETAIL_EFC	5	EURO as a functional currency table for WIP_PAC_ACTUAL_COST_DETAIL.
WIP_PAC_PERIOD_BALANCES	68	Stores periodic balance of all WIP entities within a cost group by period
WIP_PAC_PERIOD_BALANCES_EFC	31	EURO as a functional currency table for WIP_PAC_PERIOD_BALANCES.
WIP_PARAMETERS	89	WIP specific organization level parameters
WIP_PERIOD_BALANCES	45	Job and schedule charges, by accounting period
WIP_PERIOD_BALANCES_EFC	34	EURO as a functional currency table for WIP_PERIOD_BALANCES.
WIP_PREFERENCES	12	WIP Specific user level parameters
WIP_PREFERENCE_DEFINITIONS	14	Stores the preference definition
WIP_PREFERENCE_LEVELS	13	Stores the preference levels
WIP_PREFERENCE_VALUES	13	Stores the preference values.
WIP_PURGE_TEMP	10	Temporary information on jobs and schedules being purged
WIP_REPETITIVE_ITEMS	40	Line/assembly associations
WIP_REPETITIVE_SCHEDULES	60	Repetitive schedules
WIP_REQUIREMENT_OPERATIONS	79	Components required by jobs and schedules
WIP_REQ_OPERATION_COST_DETAILS	19	Costs for material requirements in an average costing organization
WIP_REQ_OPERATION_COST_DET_EFC	10	EURO as a functional currency table for WIP_REQ_OPERATION_COST_DETAILS.
WIP_RESOURCE_ACTUAL_TIMES	30	Stores the start and stop time of a resource
WIP_SCHEDULE_GROUPS	30	Discrete job schedule groups
WIP_SCHEDULING_EXCEPTIONS	22	Stores scheduling exceptions for discrete jobs
WIP_SCHEDULING_INTERFACE	23	Requests to schedule operations and resources
WIP_SCHED_RELATIONSHIPS	14	Stores scheduling relationships between work orders
WIP_SCRAP_VALUES	14	Cost information for assembly scrap transactions
WIP_SCRAP_VALUES_EFC	6	EURO as a functional currency table for WIP_SCRAP_VALUES.
WIP_SERIAL_MOVE_INTERFACE	14	Store serial number related to move transaction ID
WIP_SERIAL_MOVE_TRANSACTIONS	14	Store serial number related to move transaction ID
WIP_SHOP_FLOOR_STATUSES	27	Statuses assigned to particular jobs and schedules
WIP_SHOP_FLOOR_STATUS_CODES	26	Statuses that a job or schedule may assume
WIP_SO_ALLOCATIONS	20	Allocations of job assemblies to sales orders
WIP_SO_ALLOCATIONS_TEMP	27	Temporary sales order allocation information
WIP_SUB_OPERATION_RESOURCES	60	Resources necessary for operations
WIP_SUB_OPERATION_RESOURCE_EFC	11	Resources necessary for operations
WIP_TEMP_REPORTS	24	Temporary information used while generating reports
WIP_TRANSACTIONS	75	WIP resource transactions
WIP_TRANSACTIONS_EFC	4	EURO as a functional currency table for WIP_TRANSACTIONS.
WIP_TRANSACTION_ACCOUNTS	35	Debits and credits due to resource transactions
WIP_TRANSACTION_ACCOUNTS_EFC	7	EURO as a functional currency table for WIP_TRANSACTION_ACCOUNTS.
WIP_TXN_ALLOCATIONS	14	Resource transaction allocations for repetitive schedules
WIP_TXN_INTERFACE_ERRORS	12	Errors encountered during resource and move transaction processing
WIP_VALID_INTRAOPERATION_STEPS	25	Types of intraoperation steps possible in an organization
WIP_WS_CRITICAL_COMP_TEMP	6
WIP_WS_CRITICAL_RES_TEMP	7
WIP_WS_PTP_GT	10