WIP Tables with description

 

Table Name	Description
WIP_ACCOUNTING_CLASSES	stores accounting flexfield information for
	standard discrete jobs, non-standard asset jobs, non-standard expense
	jobs, and repetitive assemblies. Oracle Work in Process stores a
	General Ledger account for each cost element associated with a class.
	The CLASS_CODE column uniquely identifies each class. Oracle Work in
	Process uses this information to create the journal entries that post
	cost transactions.
WIP_BIS_EFF_TEMP	Temporary table that holds data from wip_indicators_temp for efficiency for faster data manipulation based on indicator (group_id = 1)
WIP_BIS_MNRA_TEMP	Temporary table that stores the resource information for calculating WIP resource utilization
WIP_BIS_PERF_TO_PLAN	WIP_BIS_PERF_TO_PLAN contains information about the scheduled and actual production of all assemblies in all organizations for every day in a given date range. The Capture Production Performance concurrent program populates information into this table for a given date range. The WIP Performance to MPS report is based on this table.
WIP_BIS_PERIOD_BALANCE	Table that stores WIP inventory balance for each inventory accounting period.
WIP_BIS_PROD_ASSY_YIELD	WIP_BIS_PROD_ASSY_YIELD is the summary table that contains
	information about completions and scrap transactions with reference to a job and assembly.
	The Capture Production Indicators concurrent program populates this table for a given date range.
	The WIP Product Quality report is based on this table.
WIP_BIS_PROD_ASSY_YIELD_TEMP	Temporary table that contains information about completions and scrap transactions with reference to a job and assembly.
WIP_BIS_PROD_DEPT_YIELD	WIP_BIS_PROD_DEPT_YIELD is the summary table that contains information about yield with reference to a job, assembly, and department. It includes information about assemblies scrapped at each department operation. The Capture Production Indicators concurrent program populates this table for a given date range. The WIP Product Quality report is based on this table.
WIP_BIS_PROD_DEPT_YIELD_TEMP	Temporary table that contains information about yield with reference to a job, assembly, and department. It includes information about assemblies scrapped at each department operation.
WIP_BIS_PROD_INDICATORS	WIP_BIS_PROD_INDICATORS is the summary table that contains information about productivity, utilization and yield with reference to a job, assembly, department, or resource. The Capture Production Indicators concurrent program populates this table for a given date range. The WIP Production Efficiency and Resource Utilization reports are based on this table.
WIP_BIS_PROD_INDICATORS_TEMP	Temporary table that contains information about productivity, utilization and yield with reference to a job, assembly, department, or resource.
WIP_BIS_UTZ_TEMP	Temporary table that holds data from wip_indicators_temp for utilization for faster data manipulation based on indicator (group_id = 2)
WIP_BIS_YLD_TEMP	Temporary table that holds data from wip_indicators_temp for yield for faster data manipulation based on indicator (group_id = 3)
WIP_COST_TXN_INTERFACE	WIP_COST_TXN_INTERFACE contains information about cost transactions
	that Oracle Work in Process needs to process. Each row represents
	either a resource transaction, an overhead transaction, an outside
	processing transaction, a cost update transaction, a period close
	variance transaction, or a job close variance transaction. Each row
	contains the transaction date, the job or repetitive schedule to
	charge, the resource to charge, the primary unit of measure
	transaction quantity, and the actual unit of measure transaction
	quantity. Each row also has foreign key references to
	move and receiving transaction tables. Oracle Work in Process uses
	this table to support all resource cost transactions including
	transactions loaded from other systems through the
	Oracle Work in Process Open Resource Transaction Interface.
WIP_DEF_CAT_ACC_CLASSES	WIP_DEF_CAT_ACC_CLASSES stores accounting classes by category and
	possibly by cost group. Information is entered into this table using
	the Default WIP Accounting Classes for Categories window in Oracle
	Cost Management
WIP_DISCRETE_JOBS	WIP_DISCRETE_JOBS stores discrete job information. Each row
	represents a discrete job, and contains information about the assembly
	being built, the revision of the assembly, the job quantity, the
	status of the job, the material control method, accounting
	information, and job schedule dates. Oracle Work in Process uses this
	information to control discrete production
WIP_DJ_CLOSE_TEMP	WIP_DJ_CLOSE_TEMP is a temporary table that holds information for
	discrete jobs that have a status of Pending Close. Oracle Work in
	Process inserts records into this table from the Close Discrete Jobs
	window and also the Discrete Job Close process. Records are deleted
	from this table once jobs are closed.
WIP_EAM_DIRECT_ITEMS	This table stores the description based direct items associated with an EAM work order.
WIP_EAM_PARAMETERS	For EAM enabled organization, this table stores organization parameters specific to EAM functionality.
	Whenever an organization level default is required, all EAM modules obtain the default value from this table through the view WIP_EAM_PARAMETERS_V.
WIP_EAM_PERIOD_BALANCES	This table stores summary accounting information for EAM jobs. Each row represents job charges within a given accounting period, and contains the summary values for each cost element. Oracle Work in Process uses this information to report job and schedule values and to calculate job and period variances
WIP_EAM_WORK_REQUESTS	This table stores work request information. It stores work request attributes like priority, contact person, owning department ID etc.
	Please note that the details of the work request will be held in WIP_EAM_WORK_REQ_NOTES table.
WIP_EAM_WORK_REQ_NOTES	This table stores change history and audit information for individual work request. When users create a work request, they enter a brief description of the problem. They could subsequently update the work request to shed more light on the problem. All these description and updates are stored in this table.
WIP_EMPLOYEE_LABOR_RATES	WIP_EMPLOYEE_LABOR_RATES stores information about employee labor
	rates. Each row represents an employee's hourly labor rate as of a
	certain effective date. This information is used when you charge a
	resource at an actual labor rate rather than the standard cost of the
	resource. Information is entered into this table using the Employee
	Labor Rates window.
WIP_ENTITIES	WIP_ENTITIES stores information about jobs, repetitive assemblies, and
	flow schedules. Each row includes a unique entity name, the entity type, and
	the assembly being built. Oracle Work in Process uses this
	information to control production activities and to ensure that
	entities with duplicate names are not created.
WIP_EXCEPTIONS	WIP_EXCEPTIONS holds exceptions for job operation combinations.
WIP_FLOW_SCHEDULES	WIP_FLOW_SCHEDULES stores Work Order-less Flow schedule information. Each row represents a Flow schedule and contains information about the assembly being built, the assembly revision, the schedule quantity, the status of the Flow schedule, and accounting information. Oracle Work in Process uses this information to control Flow schedule production
WIP_INDICATORS_TEMP	WIP_INDICATORS_TEMP is the temporary table that is used to calculate production indicators, such as productivity, utilization, and yield, from transaction information. The table is used as a transient table by the Capture Production Indicators concurrent program for a given date range.
WIP_INTERFACE_ERRORS	WIP_INTERFACE_ERRORS stores the text of errors or warnings issued when loading information through the WIP Scheduling and Open Job and
	Schedule interfaces. It also stores information about the load
	requests that generate the errors. When the WIP Mass Load program loads records from the WIP Scheduling Interface, you can print a report showing these errors