1. Using Customer Data Management for Sales and Fusion Service
  2. Create Data Verification Batches

Create Data Verification Batches

You can use data verification cleansing to verify addresses, phone numbers, and email addresses data that already exists in the registry.

This process updates and completes the addresses, phone numbers, email addresses in your database using the verified address from Oracle Address, Email, and Phone Verification. For example, it can add a missing postal code in an address.

You can create an data verification batch and specify selection criteria on the Create Data Verification Batch page. You specify selection criteria, also known as filter criteria, to narrow down the list of candidate records for data verification.

You can use this procedure to create a data verification batch and specify the selection criteria:

  1. Navigate to the Create Address Cleansing Batch page as follows: Navigator > Customer Data Management > Data Verification.

  2. Click Create from the Actions menu.

  3. Enter a Batch Name.

  4. Select an appropriate batch mode. Select Simulated mode to review and accept the verified data before committing the data verification job. Select Automated mode to verify the data and save it automatically.

  5. Provide a batch description, if required.

  6. Specify the following Cleansing Configuration Parameters to override the configuration that was specified using the Manage Address Cleansing Configurations task:

    • Minimum Verification Level: Used to specify the level of verification to which the input data matches the available reference data during the verification process.

    • Minimum Verification Score: Used to specify the similarity between the address entry and closest reference data match as a percentage between 0 (no match) and 100 (perfect match).

    • Default Country: Used to specify the country to cleanse the address, if no identifiable country can be found in an input address.

    • Output Casing: Used to specify the letter case for an output address. For example, the Output Casing is set to Mixed, this 411 THEODORE FREMD AVE # 300 RYE NY 10580 input address is displayed as 411 Theodore Fremd Ave # 300 Rye NY 10580.

    • Correct Partially Verified Addresses: Determines if you want to correct the addresses entry that are partially verified.

    • Correct Ambiguous Addresses: Determines if you want to correct the unclear addresses entry and resolve it to the correct address.

    • Return Verified Address in Native Script: Displays verified addresses in the native script of the country selected in the Default Country field. This is supported for a native (local) language to Latin (English) output or from Latin to a native output. Note that requests in a non-Latin language can't have a verified output in another non-Latin language. When this option Return Verified Address in Native Script is selected, addresses are cleansed in the native script of the input address when possible. When this option isn't selected, DaaS automatically decides whether the data has to be cleansed in the native script based on the input address.

    Note: The configuration settings that you set in the Manage Address Cleansing Configurations setup task are displayed as the default values on this page. The values that you specified on this page are applicable only to this address cleansing batch request. For more information about the configuration parameters, see the Address Cleaning Setup chapter of the Implementing Customer Data Management guide.

  7. Click Create on the Action menu in the section Address Cleansing Batch: Selection Criteria.

  8. Enter the Selection Criteria. We highly recommend that each time you submit a batch request, you ensure that the batch size and the number of results of the selection criteria do not exceed the data verification usage quota. Tightly knit the conditions in the selection criteria to narrow down the number of records that will be submitted for the data verification cleansing process.The following table contains sample selection criteria.

    Object

    Attribute

    Operator

    Value

    Location

    Country

    Equal to

    US

    Location

    State

    Equal to

    CA

    Location

    Creation Date

    Before

    7/18/19

    Location

    Creation Date

    After

    1/11/19

    Phone Phone Number Contains 90

  9. Click Schedule to specify process options. The Schedule Address Cleansing Batch page appears.

  10. Click Submit.

  11. Click OK to confirm the batch submission.

Related Topics