Symptoms

• An AR customer transaction (credit memo or invoice) has an incorrect RULE_START_DATE or ACCOUNTING_RULE_DURATION on one or more transaction lines in RA_CUSTOMER_TRX_LINES_ALL.
• Revenue recognition schedules are incorrect or cannot be generated because the rule start date and duration do not match those on the originating (previous) transaction line.
• The transaction line references a prior transaction line via PREVIOUS_CUSTOMER_TRX_LINE_ID but the rule attributes were not correctly copied from that originating line.

Root Cause

When a credit memo or adjustment transaction was created against an original invoice, the RULE_START_DATE and ACCOUNTING_RULE_DURATION were not correctly populated on the new transaction lines from the originating transaction lines. The PREVIOUS_CUSTOMER_TRX_LINE_ID link exists, but the rule attributes on the credit memo lines were left incorrect or NULL, preventing proper revenue recognition scheduling.

Resolution

Run data_fix.sql. A backup of the affected RA_CUSTOMER_TRX_LINES_ALL rows is created for the affected transaction.

Update RA_CUSTOMER_TRX_LINES_ALL for the affected transaction to copy RULE_START_DATE and ACCOUNTING_RULE_DURATION from the originating transaction lines, using the PREVIOUS_CUSTOMER_TRX_LINE_ID relationship as the join key.

Issue COMMIT. Re-run the revenue recognition process for the affected transaction and confirm the schedules generate correctly.

Script Inventory

Key Tables Affected