Module: ARCustomersSeverity: BLOCKER
Bill-To or Ship-To Customer Site Inactive on Transaction Date
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
customer site inactivebill to site inactiveAR_SITE_INACTIVEhz_cust_site_uses_all
Root Cause Analysis
Customer site use {siteUseId} has status = "I" (Inactive) preventing transaction generation.
Diagnostic SQL Queries (Read-Only)
CHECK_SITE_STATUSVerify status of HZ_CUST_SITE_USES_ALL record
SELECT u.site_use_id, u.site_use_code, u.status, a.status AS acct_status
FROM hz_cust_site_uses_all u
JOIN hz_cust_acct_sites_all a ON u.cust_acct_site_id = a.cust_acct_site_id
WHERE u.site_use_id = :siteUseIdRemediation Mode: MANUAL_UI
Verification Query
SELECT status FROM hz_cust_site_uses_all WHERE site_use_id = :siteUseIdExecute 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.