--------------------------------------------------------
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';
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
--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.
--No Dunning Site Found, Looping through delinquent Billto Sites.
