INV-01 EBS R12.x Inventory Tier 2 Data Fix

Inventory Transaction Diagnostic

Pending and errored transactions in MTL_MATERIAL_TRANSACTIONS_TEMP, costing failures, lot/serial control violations, locator issues, and negative quantity creation detection.

PlatformOracle EBS R12.x
Input RequiredTransaction ID or Item Number
Diagnostic Checks35+
Data Sources8 Oracle tables
Fix Options4 guided fixes
Backup CreatedYes — Automatic

What This Script Diagnoses

INV-01 systematically investigates every major condition that can cause the issue this diagnostic targets. Below is the complete coverage breakdown.

Oracle Documentation References

References the Oracle public documentation for this diagnostic area. These links open directly on docs.oracle.com.

R12 Guide (PDF)Title & ChapterDetail
120invug.pdfOracle Inventory User's Guide — TransactionsInventory transactions, transaction types, material transactions interface
120invug.pdfOracle Inventory User's Guide — SetupOrganization setup, transaction types, and inventory control parameters
120funmo.pdfOracle Applications Multiple Organizations Implementation GuideInventory organization structure, operating units, and item master partitioning

Ready to Deploy INV-01?

Contact William A. Green Consulting to discuss access to INV-01 and the complete 65-script diagnostic library for your Oracle environment.

Get Started → ← Back to Library

See this script run autonomously — Oracle AI Platform →