Edit a Scoring Formula
This example shows how to take an existing formula and use the duplicate feature to make edits to the formula.
Oracle Fusion Advanced Collections delivers a set of formulas you can use to score customers. You can modify the existing formulas to meet your business requirements by copy and modifying them.
Editing an Existing Formula
You are using the formula, Customer Scoring and want to change the weight in the existing formula to give customers who are 91+ days overdue lower scores.
Navigation: Setup and Maintenance > All Tasks > Define Collections > Manage Collections Scoring > Go to Task icon > Manage Scoring Formulas
-
Query the existing formula. In the Query by Example field for Name enter Customer Scoring and Enter.
-
Select the row and click Duplicate icon.
-
Edit the formula information using the subsequent table:
Field
Value
Name
-
Required
-
Replace Copy of Customer Scoring. This must be a unique name
91+ Customer Scoring
Description: Optional
Modified copy of the Customer Scoring formula. Change in weighted values.
Start Date: Required
Current Date
End Date: Optional
Leave Blank: Use an end date if the formula has limited availability.
Type: Determines the type of data points you can add to the formula.
Customer
Description
This is an optional field.
From Score: Required
1: The lowest possible score the formula calculates.
From Score: Required
100: The highest possible score the formula calculates.
Enabled: Activates the formula.
Yes
-
-
Alter the weights according to the following table:
Data Point
Weight
The Percent of Delinquencies 1-30 Days Overdue
0.1 Lower value to increase the other data point
The Percent of Delinquencies 31-60 Days Overdue
0.1 Lower value to increase the other data point
The Percent of Delinquencies 61-90 Days Overdue
0.1 Lower value to increase the other data point
The Percent of Delinquencies 91+ Days Overdue
0.7 Lower value to increase the other data point
Total Must equal 1.00
1.00
-
Click Next button.
-
Keep the Customer Segments listed. Click Next button.
-
From the Create Scoring Formula: Review, click Save button.
-
In the Sample Score section test your formula using the information in the subsequent table:
Field
Value
Account Number
Select an account known to have 91+ delinquent transactions.
Business Unit
Select a Business Unit that contains those transactions.
-
Click Score button.
The following are displayed in the Data Points table:
-
Component Score: the actual number of delinquencies and total amount of delinquencies for the test account.
-
Mapped Component Score: how that number translates to each data point detail.
-
Weighted Score: the Mapped Component Score multiplied by the data point weight.
The Total Score displays the sum of the weighted scores for all data points.
-
Assigning the Formula
Your formula is now activated and you want to apply it by doing the following:
Navigation: Navigator > Scheduled Process > Collections Scoring as Job
-
Click Schedule New Process button.
-
Select from the list of values: Collections Scoring as Job.
-
Enter the parameters according to the subsequent table:
Parameter
Value
Business Unit
Select a Business Unit that contains the account you tested previously.
Scoring Formula
91+ Customer Scoring
-
Click Submit button.
-
Verify by navigating to the Collections Work Area. Query for the customer, account, or bill-to site and review. The score appears in the Customer Hierarchy task pane.