WIP Tables with description

 

Table NameDescription
  
WIP_ACCOUNTING_CLASSESstores 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_TEMPTemporary table that holds data from wip_indicators_temp for efficiency for faster data manipulation based on indicator (group_id = 1)
WIP_BIS_MNRA_TEMPTemporary table that stores the resource information for calculating WIP resource utilization
WIP_BIS_PERF_TO_PLANWIP_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_BALANCETable that stores WIP inventory balance for each inventory accounting period.
WIP_BIS_PROD_ASSY_YIELDWIP_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_TEMPTemporary table that contains information about completions and scrap transactions with reference to a job and assembly.
 
WIP_BIS_PROD_DEPT_YIELDWIP_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_TEMPTemporary 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_INDICATORSWIP_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_TEMPTemporary table that contains information about productivity, utilization and yield with reference to a job, assembly, department, or resource.
WIP_BIS_UTZ_TEMPTemporary table that holds data from wip_indicators_temp for utilization for faster data manipulation based on indicator (group_id = 2)
WIP_BIS_YLD_TEMPTemporary table that holds data from wip_indicators_temp for yield for faster data manipulation based on indicator (group_id = 3)
WIP_COST_TXN_INTERFACEWIP_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_CLASSESWIP_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_JOBSWIP_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_TEMPWIP_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_ITEMSThis table stores the description based direct items associated with an EAM work order.
WIP_EAM_PARAMETERSFor 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_BALANCESThis 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_REQUESTSThis 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_NOTESThis 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_RATESWIP_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_ENTITIESWIP_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_EXCEPTIONSWIP_EXCEPTIONS holds exceptions for job operation combinations.
WIP_FLOW_SCHEDULESWIP_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_TEMPWIP_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_ERRORSWIP_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

No comments:

Post a Comment

WIP Tables with description

  Table Name Description     WIP_ACCOUNTING_CLASSES stores accounting flexfield information for standard discrete jobs, non-standard asset j...