OPM Actual Cost Adjustment Upload – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Upload to create, update and delete OPM actual cost adjustments per organization, item, calendar period, cost type, component class, analysis code and adjustment type, as in the Actual Cost Adjustments form. The adjustments are applied by the next actual cost process.

Quantity applies to average cost adjustments only and is stored as zero for value and unit cost adjustments. A subledger entry is dated within the period, by default on its first day.

Delete marks an adjustment for purge, as the form does. Adjustments posted to GL, and those of frozen or closed periods, cannot be changed. Changing an applied adjustment sets its status to Modified.

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

Upload Mode, Organization Code, Calendar, Period, Cost Type, Item

Oracle EBS Tables Used

mtl_parameters, cm_adjs_dtl, mtl_system_items_vl, gmf_period_statuses, cm_mthd_mst, cm_cmpt_mst_vl, org_access_view

Report Categories

Enginatics, R12 only, Upload

CAC OPM Costed Formula, CAC OPM Batch Material Summary, CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, CAC Inventory Lot and Locator OPM Value (Period-End), CAC OPM Item Cost Detail, INV Slow Moving Inventory, CAC Inventory Organization Summary

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 Example
Blitz Report™ XML Import OPM_Actual_Cost_Adjustment_Upload.xml
SQL Source OPM Actual Cost Adjustment Upload.sql
Full Report on Enginatics www.enginatics.com/reports/opm-actual-cost-adjustment-upload/

© Enginatics GmbH