My Oracle Support Banner

Why are distribution gl_date created in prior periods for applied credit memos with rules? (Doc ID 956854.1)

Last updated on AUGUST 09, 2021

Applies to:

Oracle Receivables - Version to [Release 11.5.10]
Information in this document applies to any platform.
EXECUTABLE:ARGLTP - General Ledger Transfer Program
EXECUTABLE:ARTERRPM - Revenue Recognition Master Program
REPORT:ARBARL.RDF - Revenue Recognition
EXECUTABLE:ARBARL - Revenue Recognition
ConcurrentProgram:ARBARL_NON_SRS2 - Revenue Recognition Execution Report


This note is consolidated into Note 1110573.1, Troubleshooting Credit Memos in Receivables

Why are distribution gl_date created in prior periods for applied credit memos with rules?

Applied credit memos are created specifically for a transaction. If

ra_customer_trx_all.previous_customer_trx_id is populated then this is an applied credit memo.


CM -
An applied credit memo is generated specifically against an invoice (in other words, ra_customer_trx_all.previous_customer_trx_id is populated)
Invoicing Rule = In Advance
Accounting Rule = Immediate
rule_start_date = 22-MAY-2009
receivable (REC) gl_date = 24-JUL-2009

rule_start_date = 22-MAY-2009


Period        Status
May-09     Opened
Jun-09       Opened
Jul-09        Opened


-100               22-May-09           REV
100                 22-May-09          UNBILL

-100                24-Jul-09             REC
-100                24-Jul-09             UNBILL
      0                24-Jul-09             TAX

The above is from ra_cust_trx_gl_dist_all. The problem I'm discussing is line 1-2. These are the distributions. You notice that the distribution gl_date shows 22-MAY-2009 even though the CM REC gl_date shows 24-JUL-2009.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.