Oracle Fusion - Advance Collection Diagnostics

--------------------------------------------------------

List of Invoices to be sent for dunning

--------------------------------------------------------

select hp.party_name, hca.account_number, rca.trx_number,hou.name org_name,  ida.*
  from IEX_DELINQUENCIES_ALL  ida, hz_cust_accounts hca, hz_parties hp, ra_customer_trx_all rca, hr_operating_units hou
 where ida.cust_account_id = hca.cust_account_id 
   --and hca.account_number = 'XXXXXXX' 
   and hp.party_id = hca.party_id
   and hp.party_name = 'XXXXXXXX'
   and rca.customer_trx_id = ida.transaction_id
   and hou.organization_id = ida.org_id
   and ida.STATUS = 'DELINQUENT';

--------------------------------------------

Solution 1
--------------------------------------------

--A dunning letter is not generated because there are no valid transactions to be included in the dunning letter. (Doc ID 2875705.1)
--1. Tools > Scheduled Processes > Schedule the following ESS processes in the following sequence:
----a. Refresh Receivables Transactions for Customer Account Summaries
----b. Collections Delinquency Management
----c. Collections Scoring and Strategy Assignment
----d. Update Collections Summary Data
--4. Retest the issue.
--5. Migrate the solution as appropriate to other environments.

--------------------------------------------
Solution 2

--------------------------------------------

--Oracle Fusion Advanced Collections Cloud Service - Version 11.13.19.04.0 and later
--Symptoms
------Collections Scoring & Strategy Assignment / Collections Delinquency Management not processing
------Upon running the Collections Jobs, both Collections Scoring and Strategy Assignment as well as Collections Delinquency Management. 
------When running the job, no data is found nor is any item scored. Ran Refresh Receivables Transactions process to update delinquency status.
--Cause
------The issue is caused by the following setup:
------The Delinquency Status Determination, Pre-Delinquency Status Determination , Quick Delinquency Status Determination , 
------Predelinquency Status Determination by Segment scoring are all disabled within Manage Collections Scoring - this is why nothing has been scored.
------
------The Collections Delinquency Management process identifies the delinquency and pre-delinquency statuses for your customers, customer transactions, accounts, and sites accordingly based on the business level and pre-delinquency options.

--------------------------------------------

Solution 3

--------------------------------------------

------The issue will be resolved once this setup is corrected:
------1. The Delinquency Status Determination, Pre-Delinquency Status Determination , Quick Delinquency Status Determination , 
---------Predelinquency Status Determination by Segment scoring should be enabled within Manage Collections Scoring
------2. Run Collections Scoring and Strategy Assignment
------3. Run Collections Delinquency Management


--------------------------------------------
Solution 4
--------------------------------------------

--To diagnose, run "Validate Customer Dunning Setup Report" Job and if required run 'Dunning Diagnostic' and 'Collections Setup Diagnostic'
--No Dunning Site Found, Looping through delinquent Billto Sites.