OM-02 EBS R12.x Order Management Tier 2 Data Fix

Order Holds Diagnostic

Complete holds inventory — aging, hold type breakdown, credit hold root cause, payment term holds, manual holds, repeat hold patterns, and resolution path for every hold definition.

PlatformOracle EBS R12.x
Input RequiredDate Range or Customer Name
Diagnostic Checks30+
Data Sources6 Oracle tables
Fix Options4 guided fixes
Backup CreatedYes — Automatic

What This Script Diagnoses

OM-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
120arig.pdfOracle Receivables Implementation Guide — Ch. 3: Customer Profile Classespp. 3-6 to 3-16: Credit holds driven by customer profile credit limits
120funmo.pdfOracle Applications Multiple Organizations Implementation GuideOE_ORDER_HOLDS_ALL operating unit scope for order hold aging analysis
120poug.pdfOracle Purchasing User's Guide — Ch. 2: Document ControlDocument hold and control frameworks analogous to OM order hold structure

Ready to Deploy OM-02?

Contact William A. Green Consulting to discuss access to OM-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 →