| 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 |