OZFCSTL Settlement Workflow Is Not Populating GL Date For Claim
(Doc ID 1622858.1)
Last updated on JULY 17, 2020
Applies to:Oracle Trade Management - Version 126.96.36.199 and later
Information in this document applies to any platform.
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
DBCXXXXX --> Success.
---------------- DBCXXXXX ----------------
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