INV Item ABC Assignment Upload – Oracle EBS SQL Report

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

Overview

Assigns items to ABC classes within an ABC assignment group, changes an item’s ABC class, or removes the assignment, as the ABC Assignment Updates window (Inventory > Planning > ABC Codes > ABC Assignments).

The ABC group and its classes are set up in the ABC Groups window; an item can be assigned to any class of the group, also when the ABC compile did not include it.

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, ABC Group, ABC Class, Item

Oracle EBS Tables Used

mtl_parameters, mtl_abc_assignment_groups, mtl_abc_assignments, mtl_abc_classes, mtl_system_items_vl, org_access_view

Report Categories

Enginatics, R12 only, Upload

INV Item Upload, INV Onhand Quantities, INV Cycle count listing, INV Cycle count entries and adjustments, INV Cycle counts pending approval, INV Cycle count unscheduled items, INV Cycle count hit/miss analysis, INV Cycle count open requests listing, INV ABC assignments

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 INV_Item_ABC_Assignment_Upload.xml
SQL Source INV Item ABC Assignment Upload.sql
Full Report on Enginatics www.enginatics.com/reports/inv-item-abc-assignment-upload/

© Enginatics GmbH