Customer Update Process Integration Overview
An Oracle Utilities Work and Asset Management v1.9.1.x user can pass updated Customer data collected in the field (such as a phone number or mailing address) to Oracle Utilities Customer Care and Billing. The information may be changed either online in the service request or from the Oracle Utilities Work and Asset Management v1.9.1.x mobile application. Information is stored in the SA_CREW_WORK_LOG table as changes to the service request prior to sending to Oracle Utilities Customer Care and Billing. This synchronous request creates Customer Contact and To Do records in Oracle Utilities Customer Care and Billing.
Crew log entry in SA_CREW_WORK_LOG table is created in Oracle Utilities Work and Asset Management v1.9.1.x when one or more of these fields change:
• Customer_ID
• Customer_last_name
• Customer_first_name
• Company
• Number_prefix
• Street_number_char
• Number_suffix
• Street_name
• Street_direction
• Suite
• City
• State_province
• Postal_code
• Post_office_box
• Customer_phone
• Customer_phone_ext
• Customer_home_phone