Results for “cs_system_options”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WIP_ACCOUNTING_CLASSES is the Work in Process accounting class definition table in Oracle EBS 12.1.1 and 12.2.2. An accounting class groups the General Ledger accounts that WIP transactions from discrete jobs, repetitive schedules, and flow schedules will debit and credit during costing, completion, scrap, and variance recognition. Each row defines a named class (CLASS_CODE) within a specific inventory organization (ORGANIZATION_ID), and the numerous GL account columns point into GL_CODE_COMBINATIONS via foreign keys. Because so many of its columns resolve to GL_CODE_COMBINATIONS, this table is the primary bridge between manufacturing cost collection in WIP and financial posting in GL, and it is the object most frequently reached when a user searches for "gl_code_combinations" in a WIP costing context.

The heuristic Data Vault classification mined from the foreign key structure is hub-leaning. This is a modeling suggestion: CLASS_CODE plus ORGANIZATION_ID form a stable business key that behaves like a hub, while the descriptive and account-mapping columns act as satellite attributes and the outbound GL_CODE_COMBINATIONS references act as links.

Key Information Stored

The physical schema documents 65 columns and two unique indexes: WIP_ACCOUNTING_CLASSES_PK and WIP_ACCOUNTING_CLASSES_U1, both defined on (CLASS_CODE, ORGANIZATION_ID). This composite is the business key; there is no separate meaningless surrogate key, so the primary key itself doubles as the natural business identifier. The most operationally significant columns are:

• CLASS_CODE and ORGANIZATION_ID — the composite business key and unique index columns that identify a class.
• CLASS_TYPE — classifies the accounting class for WIP usage.
• DESCRIPTION and DISABLE_DATE — descriptive text and the date the class becomes inactive.
• MATERIAL_ACCOUNT, RESOURCE_ACCOUNT, OVERHEAD_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT — the primary charge accounts for the four cost elements.
• MATERIAL_VARIANCE_ACCOUNT, RESOURCE_VARIANCE_ACCOUNT, OVERHEAD_VARIANCE_ACCOUNT, OUTSIDE_PROC_VARIANCE_ACCOUNT, STD_COST_ADJUSTMENT_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT — variance and adjustment accounts.
• COMPLETION_COST_SOURCE, COST_TYPE_ID (referencing CST_COST_TYPES), and SYSTEM_OPTION_ID (referencing CS_SYSTEM_OPTIONS) — control the costing behavior of the class.
• BRIDGING_ACCOUNT, EXPENSE_ACCOUNT, EST_SCRAP_ACCOUNT, EST_SCRAP_VAR_ACCOUNT, and ENCUMBRANCE_ACCOUNT — supplemental posting accounts for scrap, expense, and purchasing integration.

Common Use Cases and Queries

The dominant reporting need is to explode a WIP accounting class into its underlying GL account combinations, typically to audit the manufacturing-to-GL mapping. A representative pattern joins the account columns to GL_CODE_COMBINATIONS using CONCATENATED_SEGMENTS:

• List all classes for an organization: SELECT class_code, description, class_type FROM wip_accounting_classes WHERE organization_id = :org_id;
• Resolve account strings: join each account column to GL_CODE_COMBINATIONS.CODE_COMBINATION_ID to return CONCATENATED_SEGMENTS for material, resource, overhead, and outside processing.
• Identify classes in use: join WIP_DISCRETE_JOBS.CLASS_CODE and ORGANIZATION_ID to see which classes active jobs reference.
• Check default assignment: join WIP_PARAMETERS.DEFAULT_DISCRETE_CLASS to WIP_ACCOUNTING_CLASSES to confirm the organization's default discrete class.
• Project integration: join PJM_PROJECT_PARAMETERS.WIP_ACCT_CLASS_CODE and PJM_TASK_WIP_ACCT_CLASSES to trace project and task-level WIP account assignments.

Related Objects

WIP_ACCOUNTING_CLASSES sits at the center of a hub-and-spoke account mapping. The most significant related objects are:

• GL_CODE_COMBINATIONS — referenced by eleven account columns, including MATERIAL_ACCOUNT, RESOURCE_ACCOUNT, OVERHEAD_ACCOUNT, and their variance counterparts; the destination of the "gl_code_combinations" search that led here.
• WIP_PARAMETERS — source of ORGANIZATION_ID and holds DEFAULT_DISCRETE_CLASS back to this table.
• CST_COST_TYPES and CS_SYSTEM_OPTIONS — referenced by COST_TYPE_ID and SYSTEM_OPTION_ID.
• WIP_DISCRETE_JOBS, WIP_REPETITIVE_ITEMS, WIP_FLOW_SCHEDULES, and WIP_JOB_SCHEDULE_INTERFACE — carry CLASS_CODE and ORGANIZATION_ID as foreign keys.
• PJM_PROJECT_PARAMETERS and PJM_TASK_WIP_ACCT_CLASSES — enforce project/task-level WIP and EAM accounting class defaults.
• AHL_ROUTES_B, WSM_LOT_JOB_INTERFACE, and WSM_SECTOR_EXTENSIONS — additional dependents supplying ACCOUNTING_CLASS_CODE or DEFAULT_ACCT_CLASS_CODE.