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

Item Setup Diagnostic

Item attribute completeness across all functional groups, UOM validity, category assignment, organization assignment status, lot/serial control consistency, and planner/buyer assignment.

PlatformOracle EBS R12.x
Input RequiredItem Number or Inventory Organization
Diagnostic Checks35+
Data Sources7 Oracle tables
Fix Options5 guided fixes
Backup CreatedYes — Automatic

What This Script Diagnoses

INV-03 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 — ItemsItem master setup, item attributes, categories, and organization assignment
120invug.pdfOracle Inventory User's Guide — Setup — Inventory Profile OptionsProfile options controlling item defaulting, cost accounting, and lot control
120funmo.pdfOracle Applications Multiple Organizations Implementation GuideMaster organization and child organization item assignment in multi-org setup

Ready to Deploy INV-03?

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

Get Started → ← Back to Library

See this script run autonomously — Oracle AI Platform →