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

Inventory Costing Diagnostic

Cost update status, pending cost transactions, standard vs. actual variances, average cost layer imbalances, overhead rate validity, and purchase price variance analysis.

PlatformOracle EBS R12.x
Input RequiredCost Type or Organization
Diagnostic Checks30+
Data Sources8 Oracle tables
Fix Options4 guided fixes
Backup CreatedYes — Automatic

What This Script Diagnoses

INV-02 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 — CostingCost update, item cost definition, and standard vs. average cost accounting
120invug.pdfOracle Inventory User's Guide — Period CloseInventory period close, pending transactions, and cost accounting to GL
120glug.pdfOracle General Ledger User's Guide — Journal ImportInventory cost accounting journal transfer to GL and GL_INTERFACE cleanup

Ready to Deploy INV-02?

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

Get Started → ← Back to Library

See this script run autonomously — Oracle AI Platform →