Preconfigured Scoring Elements

This appendix describes the preconfigured scoring engines and scoring components provided in the application.

This appendix covers the following topics:

Using Preconfigured Scoring Elements
Preconfigured Scoring Engines
Preconfigured Scoring Components

Using Preconfigured Scoring Elements

Oracle Advanced Collections provides preconfigured elements for scoring that you can use to test your implementation, or use in your live production environment if they suit your business needs.

This appendix contains information regarding the following elements:

Preconfigured Scoring Engines

Preconfigured Scoring Components

Preconfigured Scoring Engines

The following table lists the preconfigured scoring engines available in Oracle Advanced Collections.

Preconfigured Scoring Engines
Scoring Engine	Description	Object	Segment	Number in Scoring Engine Harness
Delinquency Status Determination	Scores transactions to determine status of current or delinquent.	Collections Transactions	Invoice Delinquency Filter	2
Customer Scoring	Scores the party (customer). Displays the score in the Collections Score field in the Collections Header.	Party	Delinquent Parties Filter	1
Account Scoring	Scores the account. Displays the score in the Score field on the Accounts tab.	Account	Accounts Filter	6
Bill To Scoring	Scores the Bill To sites.	Bill To	Delinquent Bill Site To Filter	7
Case Scoring	Scores Lease and Finance Management contracts.	Collections Case	Case Filter	3
Loans Delinquency Scoring	Scores Oracle Loans invoices.
Sample Delinquent Installment	Scores transactions.	Collections Transactions	Oracle Collections Delinquent Invoice Filter	5
Sample Case Delinquency	Scores Lease and Finance Management contracts.	Collections Case	Oracle Collections Delinquent Case Filter	4

Note: Use the Sample Case Delinquency and Sample Delinquent Installment scoring engines only if you used them in earlier releases of Oracle Advanced Collections. For all other installations, these scoring engines have been replaced by Delinquency Status Determination and Case Scoring.

For your reference, this table lists the old names used for preconfigured scoring engines in previous releases.


Scoring Engine	Old Scoring Engine Name
Delinquency Status Determination	Default Invoice Delinquency Management Engine
Customer Scoring	Sample Delinquent Party Score Engine
Account Scoring	Sample Delinquent Account Score Engine
Bill To Scoring	Sample Bill to Score Engine
Case Scoring	Default Case Delinquency Management Engine
Sample Delinquent Installment	Sample Delinquent Installment Score Engine
Sample Case Delinquency	Sample Case Delinquency Score Engine

Preconfigured Scoring Components

The following tables describe the preconfigured scoring components for use with scoring engines.

Aging Bucket Line for Account
Object	Account
Description	Identifies the oldest aged transaction for the account.
Object	Account
Type Value	Select nvl(max(abl.Bucket_Sequence_num),0) From ar_aging_buckets ab, Ar_aging_bucket_lines abl, IEX_app_preferences_vl iex, Ar_payment_Schedules arp, IEX_DELINQUENCIES DEL Where abl.aging_bucket_id = ab.aging_bucket_id AND Ab.bucket_name = iex.preference_value AND Iex.preference_name = 'DUNNING PLAN AGING BUCKET' AND DEL.payment_schedule_id = arp.payment_schedule_id AND (sysdate - arp.due_date) between abl.days_start and abl.days_to and Del.Cust_Account_ID = :ACCOUNT_ID
Function	N
Old Name	Account Aging Bucket Line

Aging Bucket Line for Bill To
Object	Bill To
Description	Identifies the oldest aged transaction for the Bill To.
Component	Select nvl(max(abl.Bucket_Sequence_num),0) From ar_aging_buckets ab, Ar_aging_bucket_lines abl, IEX_app_preferences_vl iex, Ar_payment_Schedules arp, IEX_DELINQUENCIES DEL Where abl.aging_bucket_id = ab.aging_bucket_id AND Ab.bucket_name = iex.preference_value AND Iex.preference_name = 'DUNNING PLAN AGING BUCKET' AND DEL.payment_schedule_id = arp.payment_schedule_id AND (sysdate - arp.due_date) between abl.days_start and abl.days_to and Del.Customer_Site_Use_ID = :BILL_TO_ID
Function	N
Old Name	Bill To Aging Bucket Line

Aging Bucket Line for Customer
Object	Party (used to score customers)
Description	Identifies the oldest aged transaction for the customer.
Type Value	Select nvl(max(abl.Bucket_Sequence_num),0) From ar_aging_buckets ab, Ar_aging_bucket_lines abl, IEX_app_preferences_vl iex, Ar_payment_Schedules arp, IEX_DELINQUENCIES DEL Where abl.aging_bucket_id = ab.aging_bucket_id AND Ab.bucket_name = iex.preference_value AND Iex.preference_name = 'DUNNING PLAN AGING BUCKET' AND DEL.payment_schedule_id = arp.payment_schedule_id AND (sysdate - arp.due_date) between abl.days_start and abl.days_to and Del.Party_Cust_ID = :PARTY_ID
Function	N
Old Name	Party Aging Bucket Line

Aging Bucket Line for Delinquency
Object	Delinquency
Description	Determines the aging of the Delinquency.
Component	Select nvl(abl.Bucket_Sequence_num,0) From ar_aging_buckets ab, Ar_aging_bucket_lines abl, IEX_app_preferences_vl iex, Ar_payment_Schedules arp, IEX_DELINQUENCIES DEL Where abl.aging_bucket_id = ab.aging_bucket_id AND Ab.bucket_name = iex.preference_value AND Iex.preference_name = 'DUNNING PLAN AGING BUCKET' AND DEL.payment_schedule_id = arp.payment_schedule_id AND (sysdate - arp.due_date) between abl.days_start and abl.days_to and Del.delinquency_id = :DELINQUENCY_ID
Function	N
Old Name	Delinquency Aging Bucket Line

Amount Overdue to Delinquency Threshold
Object	Loan
Description	Determines Status of the Delinquent Loan
Component	SELECT trunc(NVL(sum.TOTAL_OVERDUE, 0) / NVL(term.DELINQUENCY_THRESHOLD_AMOUNT, 1)) from LNS_PAYMENTS_SUMMARY_V sum, LNS_TERMS term where sum.loan_id = :loan_id and sum.loan_id = term.loan_id
Function	N

Case Delinquency Determination
Object	Case
Description	Creates a score for a Leasing Case.
Component	Call IEX_SCORE_CASE_PVT.Calculate_Score (:case_id, :score_component_id) into :raw_case_score)
Function	Y
Old Name	Case Scoring Component: What is the latest case score?

Customer Since for Account
Object	Account
Description	Determines how long we've been doing business with the Account.
Component	SELECT TO_CHAR(CREATION_DATE, 'YYYY') FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = :CUST_ACCOUNT_ID
Function	N
Old Name	Account Since

Customer Since for Bill To
Object	Bill To
Description	Determines how long we've been doing business with the Bill To.
Component	SELECT TO_CHAR(CREATION_DATE, 'YYYY') FROM HZ_CUST_SITE_USES WHERE CUSTOMER_SITE_USE_ID = :billto_id
Function	N
Old Name	Customer Since for Bill To

Customer Since for Customer
Object	Party (used to score customers)
Description	Determines how long have we've been doing business with the customer.
Component	SELECT TO_CHAR(CREATION_DATE, 'YYYY') FROM HZ_PARTIES WHERE PARTY_ID = :party_id
Function	N
Old Name	Customer Since for Party

Delinquencies Amount for Account
Object	Account
Description	Identifies the total overdue amount owed by the Account.
Component	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.cust_account_id = :cust_account_id AND del.creation_date >= sysdate -365
Function	N
Old Name	Amount of Delinquencies for Account

Delinquencies Amount for Bill To
Object	Bill To
Description	Identifies the total overdue amount owed by this Bill To.
Component	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
Function	N
Old Name	Amount of Delinquencies for Bill To

Delinquencies Amount for Customer
Object	Party (used to score customers)
Description	Identifies the total overdue amount owed by the Customer.
Scoring Component	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.party_cust_id = :party_id AND del.creation_date >= sysdate -365
Function	N
Old Name	Amount of Delinquencies for Party

Number of Delinquencies for Account
Object	Account
Description	Determines how many delinquencies exist for the Account.
Component	SELECT COUNT(1) FROM IEX_DELINQUENCIES WHERE CUST_ACCOUNT_ID = :CUST_ACOCUNT_ID
Function	N
Old Name	Number of Delinquencies for Account

Number of Delinquencies for Bill To
Object	Bill To
Description	Determines how many delinquencies exist for the Bill To.
Component	SELECT COUNT(1) FROM IEX_DELINQUENCIES WHERE CUSTOMER_SITE_USE_ID = :billto_id
Function	N
Old Name	Number of Delinquencies for Bill To

Number of Delinquencies for Customer
Object	Party (used to score customers)
Description	Determines how many delinquencies exist for the customer.
Score Component Value	SELECT COUNT(1) FROM IEX_DELINQUENCIES WHERE PARTY_CUST_ID = :party_id
Function	N
Old Name	Number of Delinquencies for Party

Payment Schedule Delinquency Determination
Object	Collections Transaction
Description	This scoring component uses a data view that consists of all payment schedules when the current date is greater than the due date, nothing is in dispute, and the remaining amount is greater than zero. The component compares this view with the group of all payment schedules. It assigns a score of 1.0 to 10.99 for payment schedules that are not in the view and a score of 11 to 100 for payment schedules in the view.
Component	SELECT Nvl(Count(1), 0) FROM IEX_DELINQUENCIES_NEW_V WHERE Payment_Schedule_id = :payment_schedule_id
Function	N