Symptoms

• AR adjustment records exist in AR_ADJUSTMENTS_ALL but the corresponding accounting distribution rows are missing from AR_DISTRIBUTIONS_ALL.
• The General Ledger Transfer process for AR adjustments fails or skips the affected adjustments because the required debit and credit distribution rows do not exist.
• The AR Closing diagnostic report shows the affected customer transactions as unaccounted or with incomplete distributions.

Root Cause

Accounting distribution records were not created in AR_DISTRIBUTIONS_ALL for several AR adjustment IDs at the time the adjustments were posted. Each AR adjustment requires a balanced pair of distribution lines: one with source_type = 'ADJ' (the adjustment account debit or credit) and one with source_type = 'REC' (the receivable account credit or debit). Without these rows, the GL Transfer cannot generate the journal entries for the adjustments. The fix manually inserts the missing balanced DR/CR distribution pairs for each affected adjustment using ra_cust_trx_line_gl_dist_s.nextval for the line IDs.

Identification SQL

Use the following query to identify AR adjustments missing distribution records:

SELECT adj.adjustment_id, adj.amount, adj.status
FROM   ar_adjustments_all adj
WHERE  adj.customer_trx_id IN (&customer_trx_ids)
  AND  NOT EXISTS (
         SELECT 1
         FROM   ar_distributions_all dis
         WHERE  dis.source_table = 'ADJ'
           AND  dis.source_id    = adj.adjustment_id
       );

Resolution

Run 01_gl_date_fix.txt. A backup of any existing AR_DISTRIBUTIONS_ALL rows for the affected adjustments (joined via AR_ADJUSTMENTS_ALL) is created in RSI_AR_DIST_00028013.

For each affected adjustment_id, insert two rows into AR_DISTRIBUTIONS_ALL:

1. Adjustment account line (source_type = 'ADJ'): Uses the adjustment CCID; populates amount_dr and acctd_amount_dr (or amount_cr/acctd_amount_cr for credit adjustments). Uses ra_cust_trx_line_gl_dist_s.nextval for line_id.
2. Receivable account line (source_type = 'REC'): Uses the receivable CCID; populates the opposing amount column to balance the entry.

Each insert includes org_id, currency_code, third_party_id, and third_party_sub_id from the original transaction. Commit after all inserts.

Run the ARAdjustmentInfo diagnostics report for the affected adjustment IDs to verify the distributions are correct. Submit the GL Transfer concurrent program for adjustments. Run the ARClosing diagnostic to confirm the transactions are now accounted.

Script Inventory

Key Tables Affected