IEX_DELINQUENCIES table is not populated, no rows return
Seeded Scoring Component Name: 'Delinquencies Amount for Bill To' Return 0 When a Balance Exists
Seeded Scoring Component Name: Delinquencies Amount for Bill To
Seeded Component Statement:-
Select NVL(sum(ar.acctd_amount_due_remaining),0) from ar_payment_schedules ar, iex_delinquencies del where ar.payment_schedule_id = del.payment_schedule_id AND del.status in ('DELINQUENT', 'PREDELINQUENT') AND del.customer_site_use_id = :billto_id AND del.creation_date >= sysdate -365
When I check running "select * from iex_delinquencies" there is no data available, no rows return..
How to populate data in iex_delinquencies table?, need help.