A Appendix: Data Mapping
Oracle Fusion REST APIs for Contacts and Accounts are used to integrate with the Person Information Synchronization REST API in your Oracle Utilities customer information system.
The Person ID from your Oracle Utilities customer information system is stored as a Source System Reference Value with Source System of CIS on the Fusion Party record. The Fusion Party Number is stored as a CIS Person characteristic value with characteristic type of C1-EXCID for the External Contact ID.
Data element mappings for the names, contact points, and characteristic values that are synchronized between your Oracle Utilities customer information system and the Oracle Customer Experience for Utilities experiences, are included in the following table.
Data Mapping Details
This table provides data mapping details:
Table A-1 Data Mapping Details
| Fusion REST API | Utility Industry Data Model API | CIS REST API | Description | Data Mappings |
|---|---|---|---|---|
| /contacts | /utilitiesCustomer/v1/individual | /customer/v-model/cxPersons | A contact is an individual who is a customer, a contact for a customer, a prospect, or other individual with a business relationship. | Only contacts as customers related to billing accounts in the CIS are synchronized. |
| /accounts | /utilitiesCommercial/v1/organization | /customer/v-model/cxPersons | An account is a business entity or organization with a relationship as a customer or sales prospect. | Only accounts as customers related to billing accounts in the CIS are synchronized. |
| PartyId | The unique key identifier of the contact or account or record. | |||
| SourceSystem | sourceSystem | The name of external source system where the contact party is integrated. | Value of "CIS" in Fusion. | |
| SourceSystemReferenceValue | sourceSystemReferenceValue | personId | The unique identifier for the contact or account party record from the external source system as specified in the attribute SourceSystem. Person Id is unique system assigned key identifier value for the person record in the CIS system. | |
| PartyNumber | cxContactId | Party number of the customer record in Fusion. This is the alternate key identifier for the contact party that is used in the path parameters for a Fusion contact or account record. | The Fusion party number is stored as CIS characteristic value with characteristic type of C1-EXCID for the External Contact ID. | |
| personOrBusiness | Indicates if the entity is a person or a business and impacts validation in CIS. | Value of" P" is integrated to Individual utilitiesCustomer as a Fusion contact. Value of "B" is integrated to an organization utilitiesCommercial as a Fusion account. | ||
| primaryName | primaryName | A person's primary name is the addressee on the person's bill and other communications unless overridden by an override mailing name. | ||
| FirstName | firstName | firstName | The first name of an individual person, does not apply to an organization. | |
| LastName | lastName | lastName | The last name of an individual person, does not apply to an organization. | |
| ContactPoints | contactPoint | contactDetails | Person contact points capture contact information, such as phone numbers and email addresses, URLs, messenger IDs, and so on. Only approved, active contact points are integrated. | |
| ContactPointId | id | contactExternalId | Unique identifier of the contact point record. | |
| ContactPointType | pointType | Type of the contact point. Fusion standard lookup of COMMUNICATION_TYPE and CIS configurable admin of Person Contact Types. Sample values: PHONE, EMAIL, INSTANT_MESSAGING, WEB, SMS, TLX, EDI, EFT. CIS has an Extenabdle Lookup of C1-CommRoutingMethodLookup with values of CSS (Self-Service User), EMAIL, FAX, and PHONE. |
Utility Configuration: communicationType Example: "ccsValue": "FAX", "faValue": "TLX" |
|
|
EmailAddress PhoneNumber URL |
value | contactDetailValue | Contains specific contact information values, such as the phone number, email address, or URL in the associated format. | |
| EmailPurpose | personContactType | Defines the purpose of using the email contact point. Fusion standard lookup of CONTACT_POINT_PURPOSE. Sample values: PERSONAL, BUSINESS, COLLECTIONS, ASSISTANT, etc. |
Utility Configuration: EMAIL_Purpose Example: "ccsValue": "PRIMARYEMAIL", "faValue": "PERSONAL" |
|
| PhonePurpose | personContactType | Defines the purpose of using the email contact point. Fusion standard lookup of CONTACT_POINT_PURPOSE. Sample values: PERSONAL, BUSINESS, COLLECTIONS, ASSISTANT, etc. |
Utility Configuration: PHONE_Purpose Example: "ccsValue": "CELLPHONE", "faValue": "PERSONAL" |
|
| WebPurpose | personContactType | Defines the purpose of using the WEB contact point. Fusion standard lookup of CONTACT_POINT_PURPOSE_WEB. Sample values: HOMEPAGE, RSS_FEED, etc. |
Utility Configuration: WEB_Purpose Example: "ccsValue": "WEB", "faValue": "HOMEPAGE" |
|
| PhoneExtension | phoneExtension | contactDetailValueExtension | If it exists, this is the extension of the contact information when the contact’s contact routing is phone or fax. | |
| SourceSystem | The name of external source system where the contact point is integrated. | Value of "CIS" | ||
| SourceSystemReferenceValue | contactPointId | The unique identifier for the contact point from the external source system specified in the attribute SourceSystem. Contact Point Id is unique system assigned identifier value in the CIS system. | ||
| PrimaryFlag | primaryFlag | contactDetailPrimary | Indicates that the preferred contact point. | |
| Status | status | Indicates if the contact point is active or inactive. Fusion EndDate reflects active with future date in year 4712 and old date of year 1900 as inactive. | ||
| characteristics | The Oracle Utilities CIS supports configuration of characteristic types to store additional data on person record objects. This collection of data can be mapped to Fusion party attributes as part of contact or account records. | |||
| characteristicType | This is an extended field in the Oracle Utilities CIS that is configured per implementation as needed to store additional values. |
CXIF adapters map CIS characteristics to designated Fusion attributes. Utility Configuration: characteristics Examples: "ccsValue": "C2MBTHDT", "faValue": "DateOfBirth" |
||
| characteristicValue | This is an extensible data attribute, and stores values of the implementation defined type/value pairs. |