Results for “pjm_task_wip_acct_classes”

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

Overview

PJM.PJM_TASK_WIP_ACCT_CLASSES is a Project Manufacturing (PJM) table in Oracle E-Business Suite that associates a default WIP accounting class with a specific task within a specific organization. Its documented description states that it "associates default WIP accounting class for a task in each organization," making it the configuration bridge between project task structures and the Work in Process accounting classes used during manufacturing transactions.

In Oracle EBS, WIP accounting classes drive the valuation and variance accounts posted when discrete jobs, repetitive schedules, or maintenance work orders are created and closed. In a project manufacturing environment, those accounting classes must be resolved at the intersection of a project and a task, and per organization. This table stores exactly that intersection: the default accounting class that should be applied to work orders consuming or producing against the given task in the given organization. It is therefore a configuration and defaulting table consulted during WIP transaction processing rather than a high-volume transaction table.

The ETRM metadata classifies this object heuristically as a link in Data Vault terms — a modeling suggestion, not a documented fact. That classification is consistent with its structure: it resolves a many-to-many relationship between project tasks, organizations, and WIP accounting classes, and it carries descriptive attributes (the two accounting class codes) alongside its keys.

Key Information Stored

The table is documented with 10 columns in the 12.2.2 physical schema. The most significant are the composite key columns and the two accounting class codes.

• PROJECT_ID, ORGANIZATION_ID, TASK_ID — The three-column composite primary key (PJM_TASK_WIP_ACCT_CLASSES_PK), also mirrored by the unique index PJM_TASK_WIP_ACCT_CLASS_U1. Together these form the business key: one default row per task per organization per project. No separate surrogate (sequence-generated) primary key column is documented; the primary key is itself the natural composite key.
• WIP_ACCT_CLASS_CODE — The default WIP accounting class code applied to standard manufacturing activity on the task.
• EAM_ACCT_CLASS_CODE — The default accounting class code used for Enterprise Asset Management (maintenance) work orders associated with the task, distinguishing EAM activity from standard WIP activity.
• CREATION_DATE, CREATED_BY — Standard audit columns recording who created the default mapping and when.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns capturing the most recent modification and the login/session responsible for it.

Common Use Cases and Queries

Typical scenarios involve resolving the accounting class that a WIP or EAM transaction should default to for a project task. A straightforward lookup joins the composite key to the task and organization:

SELECT WIP_ACCT_CLASS_CODE, EAM_ACCT_CLASS_CODE FROM PJM.PJM_TASK_WIP_ACCT_CLASSES WHERE PROJECT_ID = :project_id AND ORGANIZATION_ID = :org_id AND TASK_ID = :task_id;

Reporting use cases include: auditing which tasks in a project have explicit accounting class defaults versus relying on organization-level defaults; verifying that EAM and standard WIP classes are consistently assigned across organizations; and supporting data migration or setup validation by comparing these assignments to WIP_ACCOUNTING_CLASSES. A common diagnostic query lists all tasks for a project with their assigned classes:

SELECT TASK_ID, ORGANIZATION_ID, WIP_ACCT_CLASS_CODE, EAM_ACCT_CLASS_CODE FROM PJM.PJM_TASK_WIP_ACCT_CLASSES WHERE PROJECT_ID = :project_id ORDER BY ORGANIZATION_ID, TASK_ID;

Related Objects

• PJM_PROJECT_PARAMETERS — Referenced by PROJECT_ID and ORGANIZATION_ID; establishes the project/organization combination under which project manufacturing is enabled.
• PA_TASKS — Referenced by TASK_ID; the project task against which the default accounting class is assigned.
• WIP_ACCOUNTING_CLASSES — Referenced twice, by WIP_ACCT_CLASS_CODE and EAM_ACCT_CLASS_CODE within ORGANIZATION_ID; the source of the defaulted accounting class definitions and their valuation/variance accounts.
• WIP_DISCRETE_JOBS / WIP_ENTITIES — WIP work orders that consume the defaulted accounting class when created against a project task.
• PJM_PROJECT_DEFAULTS / PJM_ORG_PARAMETERS — Project Manufacturing setup tables that provide organization-level defaulting rules layered above the task-level assignments stored here.