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

1. Query the existing formula. In the Query by Example field for Name enter Customer Scoring and Enter.

2. Select the row and click Duplicate icon.

3. 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

4. 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

5. Click Next button.

6. Keep the Customer Segments listed. Click Next button.

7. From the Create Scoring Formula: Review, click Save button.

8. 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.

9. Click Score button.

   The following are displayed in the Data Points table:

   1. Component Score: the actual number of delinquencies and total amount of delinquencies for the test account.

   2. Mapped Component Score: how that number translates to each data point detail.

   3. 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

1. Click Schedule New Process button.

2. Select from the list of values: Collections Scoring as Job.

3. 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

4. Click Submit button.

5. 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.