Module: APDistributionsSeverity: BLOCKER
Invoice Distribution Code Combination ID is Disabled or Expired
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
distribution ccid disabledAPP-SQLAP-10006dist_code_combination_id is not validinvalid accounting flexfield
Root Cause Analysis
Invoice distribution CCID {ccid} is disabled in the accounting flexfield.
Diagnostic SQL Queries (Read-Only)
CHECK_DIST_CCIDVerify status of dist_code_combination_id in GL_CODE_COMBINATIONS
SELECT cc.code_combination_id, cc.enabled_flag, cc.start_date_active, cc.end_date_active
FROM ap_invoice_distributions_all d
JOIN gl_code_combinations cc ON d.dist_code_combination_id = cc.code_combination_id
WHERE d.invoice_id = :invoiceId AND (cc.enabled_flag = 'N' OR SYSDATE > NVL(cc.end_date_active, SYSDATE + 1))Remediation Mode: MANUAL_UI
Verification Query
SELECT enabled_flag FROM gl_code_combinations WHERE code_combination_id = :ccidExecute 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.