Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Search report results for contacts.any_phone_raw vs. any_phone — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Search report results for contacts.any_phone_raw vs. any_phone



Looking to understand why the rows analyzed are different for the two fields


Why do the fields have a different number of analyzed rows if they're both searching the phone fields? Report definition for the original report  is attached. 

In April 2020 we imported around a half million contact records from product registration to assist servicing warranty inquires. In May 2020 we upgraded from 19C to 20A. 

After the upgrade our "Find a Contact" report could not be processed because it exceeds the query size limitation. Agents are searching by 10 digit phone number in the report filter field contacts.any_phone_raw

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!