Search Results wip_pac_actual_cost_details




Overview
Explore in AI Chat

Overview

The WIP_PAC_ACTUAL_COST_DETAILS table is a core transactional data repository within the Oracle E-Business Suite Work in Process (WIP) module, specifically for installations utilizing Periodic Costing (PAC). In Oracle EBS 12.1.1 and 12.2.2, this table serves as the definitive ledger for capturing and storing the granular, actual costs of manufacturing activities. Its primary role is to record the cost impact of resource usage, overhead application, outside processing, and job close transactions, segmented by specific cost entity, accounting period, and cost group. This detailed cost accumulation is essential for accurate period-end cost reconciliation, variance analysis, and inventory valuation in a periodic costing environment.

Key Information Stored

The table structures cost details along several critical dimensions, as indicated by its foreign key relationships. Each record ties a specific transaction to its financial context. Key stored information includes the transaction identifier (TRANSACTION_ID) linking to the source activity in WIP_TRANSACTIONS. The cost is categorized by resource (RESOURCE_ID) or cost element (COST_ELEMENT_ID), allowing differentiation between material, resource, overhead, and outside processing costs. Crucially, every cost entry is stamped with its applicable accounting period (PAC_PERIOD_ID), cost group (COST_GROUP_ID), and costing method (COST_TYPE_ID). The table will also store the actual monetary cost amounts for these transactions, enabling the roll-up of total actual costs for jobs and assemblies within a given period.

Common Use Cases and Queries

The primary use case is supporting period-end closing and cost analysis for discrete manufacturing under periodic costing. Financial analysts run queries against this table to calculate actual production costs, compare them to standard costs to determine variances, and validate inventory balances. A typical reporting query would join to dimension tables to produce a readable cost summary. For example:

  • Analyzing resource costs for a specific job in a closed period.
  • Aggregating total overhead applied by cost group for variance reporting.
  • Troubleshooting cost collection issues by tracing transactions from WIP_TRANSACTIONS to their final posted actual cost in this table.

A sample SQL pattern to retrieve cost details would involve joining WIP_PAC_ACTUAL_COST_DETAILS (WPACD) to CST_PAC_PERIODS for the period name, WIP_TRANSACTIONS for transaction details, and BOM_RESOURCES or CST_COST_ELEMENTS for cost component descriptions.

Related Objects

The table is centrally connected to other key costing and transaction entities via documented foreign keys. These relationships are critical for accurate joins in reporting and integrity of the cost accounting structure.

  • CST_PAC_PERIODS via WPACD.PAC_PERIOD_ID: Links each cost detail to its unique accounting period.
  • CST_COST_GROUPS via WPACD.COST_GROUP_ID: Associates costs with a specific cost group for inventory valuation.
  • CST_COST_TYPES via WPACD.COST_TYPE_ID: Identifies the costing method (e.g., Periodic Costs).
  • WIP_TRANSACTIONS via WPACD.TRANSACTION_ID: Provides the source manufacturing transaction that generated the cost.
  • CST_COST_ELEMENTS via WPACD.COST_ELEMENT_ID: Categorizes the cost as Material, Resource, Overhead, or Outside Processing.
  • BOM_RESOURCES via WPACD.RESOURCE_ID: Identifies the specific resource, such as a machine or labor, when applicable.