Module: INVInter-OrgSeverity: HIGH
Inter-Organization Transfer In-Transit Quantity Unreconciled
Enterprise troubleshooting playbook from the OAG ADK 5.0 knowledge base. Designed for Oracle Apps DBAs, techno-functional consultants, and support teams.
Recognized Error Signatures & Log Keywords
inter-org transfer unreconciledin-transit inventory discrepancymtl_supply in-transit
Root Cause Analysis
In-transit shipment {shipmentNum} was shipped but not received in target org {toOrgCode}.
Diagnostic SQL Queries (Read-Only)
CHECK_IN_TRANSIT_SUPPLYQuery MTL_SUPPLY for in-transit shipments between orgs
SELECT supply_type_code, shipment_header_id, item_id, quantity,
from_organization_id, to_organization_id
FROM mtl_supply
WHERE supply_type_code = 'SHIPMENT' AND to_organization_id = :toOrgIdRemediation Mode: MANUAL_UI
Verification Query
SELECT count(*) FROM mtl_supply WHERE shipment_header_id = :shipmentHeaderIdExecute This Fix Safely with OAG AI Consultant
OAG AI Consultant runs directly on your Windows desktop behind your corporate firewall, connecting to your Oracle TNS tier with zero cloud data exposure.