Search Results cst_rcv_acq_costs




Overview
Explore in AI Chat

Overview

The CST_RCV_ACQ_COSTS table is a core data repository within the Oracle E-Business Suite Bills of Material (BOM) module, specifically designed for Periodic Costing. Its primary function is to store the calculated acquisition costs for received items, segmented by accounting period and cost group. This table acts as a critical junction point, linking procurement transactions (receipts) to the cost accounting engine. By maintaining period-specific acquisition costs, it enables accurate inventory valuation and cost absorption for organizations utilizing periodic average costing methodologies, forming a foundational element for the period-end costing processes.

Key Information Stored

The table's structure is defined by its foreign key relationships, which highlight the essential dimensions of the stored cost data. The primary identifier is the HEADER_ID. Each record is anchored to a specific receipt transaction via the RCV_TRANSACTION_ID, linking to the RCV_TRANSACTIONS table. For cost accounting purposes, each record is associated with a COST_TYPE_ID (CST_COST_TYPES) and a COST_GROUP_ID (CST_COST_GROUPS), defining the costing method and organizational cost group. Crucially, the PERIOD_ID (CST_PAC_PERIODS) ties the acquisition cost to a specific accounting period, which is vital for periodic costing calculations. The table likely contains columns for the calculated acquisition cost amount and currency, serving as the header for more granular cost detail stored in the related CST_RCV_ACQ_COST_DETAILS table.

Common Use Cases and Queries

The primary use case is supporting period-end close and inventory valuation reports within a periodic costing environment. Cost accountants and financial analysts query this table to validate and analyze acquisition costs posted during a specific period. A typical query would join to related transaction and costing tables to review costs. For example:

  • Validating Receipt Costs for a Period: A query to summarize acquisition costs by cost group for a given period, often used for reconciliation.
  • Troubleshooting Cost Absorption: Investigating discrepancies in inventory valuation by tracing from the general ledger back to specific receipt costs stored in this table.
  • Data Integrity Checks: Ensuring all significant receipt transactions in a period have corresponding cost records in CST_RCV_ACQ_COSTS as part of the month-end checklist.

Related Objects

CST_RCV_ACQ_COSTS is centrally connected to several key EBS tables. It is a parent table to CST_RCV_ACQ_COST_DETAILS, which holds the detailed cost elements (like material, overhead, freight) that roll up to the header. As documented, it has four primary foreign key dependencies: RCV_TRANSACTIONS (transaction source), CST_COST_GROUPS (organizational cost segmentation), CST_COST_TYPES (costing method), and CST_PAC_PERIODS (accounting period). In operational and reporting contexts, it is frequently joined with CST_PAC_ITEM_COSTS to assess period item costs and with MTL_SYSTEM_ITEMS for item descriptions. Updates to this table are typically managed through dedicated costing programs and APIs rather than direct DML.