OZFCSTL Settlement Workflow Is Not Populating GL Date For Claim (Doc ID 1622858.1)

Last updated on JULY 17, 2020

Applies to:

Goal

Data interfaced from Channel revenue to AR -- GL Date is coming as Null
 
 Steps to reproduce
 ==================
 Enter a negative chargeback batch via resale tables.
 Clear disputes and create the DBC claim,
 Batch status will be closed on creation of claim.
 Settle the chargeback batch as Credit Memo in AR.
 On approval claim will be updated as Pending close and data will
 be transferred to AR RA_INTERFACE_LINES_ALL table (auto invoice tables).
 
 When we reviewed data in RA_INTERFACE_LINES_ALL, we could find GL_DATE for
 positive claims and No GL DATE populated for negative /DBC/ Debit Claims. 

This issue is replicatable  :
 1. Load a Negative chargeback batch
 2. Clear the disputes and process the batch
 3. Initiate payment
 4. DBC claim will be created
 5. Settle the claim as Debit memo and approve the same
 6. Claim status will be updated as "Pending Close" and data will be
 interfaced to RA_INTERFACE_LINES_ALL table
 7. Verify GL_DATE for above data in RA_INTERFACE_LINES_ALL table.  -- you
 will find GL_DATE as null.

 
 File :  Claim_Settlement_Fetcher
 
  -------------- DBCXXXXX --------------
  claim amount settled             = -7.81
  claim amount remaining           = 0
  Credit/Debit Memo total amount   = 7.81
  Credit/Debit Memo line amount    = 7.81
  Credit/Debit Memo tax amount     = 0
  Credit/Debit Memo freight amount = 0
                                    ----
  Difference Amount                = 0
  Recalculated Settlement Amount = 7.81
  Before Create_Settlement_Doc
  DBCXXXXX --> Success.
  ---------------- DBCXXXXX ----------------

Solution

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