Skip to the content.

CST Periodic Inventory Value – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Cost Management · all Cost Management reports

Overview

Imported from BI Publisher Description: Periodic Inventory Value Report Application: Bills of Material Source: Periodic Inventory Value Report (XML) Short Name: CSTRPICR_XML DB package: BOM_CSTRPICR_XMLP_PKG

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Legal Entity, Cost Type, Period, Cost Group, Sort Option, Item From, Item To, Category Set, Category From, Category To, Category Organization, Currency, Exchange Rate

Oracle EBS Tables Used

mtl_item_categories, mtl_categories_kfv, mtl_system_items_vl, cst_pac_item_costs, cst_cost_groups, cst_pac_receiving_values_v, mtl_system_items, mtl_categories, hr_locations, po_lookup_codes, cst_pac_periods, po_vendors

Report Categories

Enginatics, R12 only

INV Items, PO Headers and Lines, GL Account Distribution Analysis, INV Aging, PO Purchase Price Variance, INV Item Upload

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output CST Periodic Inventory Value - Detail 11-Sep-2024 062243.xlsx
Blitz Report™ XML Import CST_Periodic_Inventory_Value.xml
SQL Source CST Periodic Inventory Value.sql
Full Report on Enginatics www.enginatics.com/reports/cst-periodic-inventory-value/

Executive Summary

The CST Periodic Inventory Value report is specifically designed for organizations using Periodic Average Costing (PAC). In PAC, costs are calculated for a specific period (e.g., a month) rather than perpetually. This report provides the inventory valuation based on these periodic costs. It is the PAC equivalent of the standard “Inventory Value Report”.

Business Challenge

Solution

This report lists inventory quantities and values based on the Periodic Average Cost.

Key Features:

Architecture

The report queries the PAC-specific tables, which are distinct from the perpetual costing tables.

Key Tables:

Impact


© Enginatics GmbH