Advanced Collections - EBS (MOSC)

MOSC Banner

IEX_DELINQUENCIES table is not populated, no rows return

edited Apr 5, 2016 5:00AM in Advanced Collections - EBS (MOSC) 12 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center