Query to Retrieve Address Verification Batch Job Results in Oracle CDM

Summary:

We recently ran an Address Verification batch job in Oracle Customer Data Management for around 2,000 customer records. The system validated and performed address cleansing suggestions for many records.

Before accepting the suggested changes, we would like to review the data externally because reviewing 2,000+ records one by one through the UI is difficult.

We are trying to identify:

• The tables/views where Address Verification batch job results are stored
• Any SQL query or BI subject area available to extract:
  • Original address
  • Suggested/cleansed address
  • Verification status
  • Batch/job details

We checked the standard customer/address tables but could not clearly identify where the verification job results are maintained.