Artifacts | Value |
---|---|
Integration Process Name | Oracle Utilities OCI Stream Notif linkChannel |
Integration Package Name | outl.ba.notifications_hub.1.22.1000 |
OCI Streaming Adapter | • Poller to Consume Message • Operation: Consume messages from Stream • Stream: Source Notification Stream • ConsumerGroup: SourceNotificationGroup • Partition: Default • Polling Frequence: 60 s • Maximum Number of records to Fetch: 200 • Message Structure: JSON • Publish to Stream • Operation: Publish messages to Stream • Stream: Target Notification Stream • Partition: Default • Message Structure: JSON Connection Name: Oracle Utilities OCI Streaming for Notif Hub |
CCB REST IWS (REST Adapter) | Web Service Name: C1-NotificationPreferencesForAccounts Computed URL: https://{host}:{port}/{tenant}/{domain}/ccs/rest/apis/customer/v-model/notificationPreferencesForAccounts Method: POST URI: / Connection Name: • Oracle Utilities REST CCB for Notif Hub • CCBDirectRESTNotifPref |
OIC Lookup | OUTL-BRT-NOTIFHUB_ConfigProps OUTL-BRT-NOTIFHUB_Email_ID OUTL-BRT-NOTIFHUB_DeliveryRouting |
PropertyName | Value |
---|---|
nms.datafield.propertylist | OUTAGETIME,CUSTOMERSOUT,CAUSE,ESTRESTTIME,CREWETA,COMPLETIONTIME |
Artifacts | Value |
---|---|
Integration Process Name | Oracle Utilities NMS OCI Stream Notif Upload |
Integration Package Name | outl.ba.notifications_hub.1.22.1000 |
Identifier | OUTL-BA-NMS_STREAM_NOTIF_UPLOAD |
DB Adapter | DB Poller to consume NMS DB record Operation: select/update Polling Frequence: 60 s Message format: XML Connection Name: Oracle Utilities DB NMS for Notif Hub |
OCI Streaming Adapter | Publish message to source OCI stream Operation: Publish messages to Stream Stream: Source Notification Stream Partition: Default Message Structure: JSON Connection Name: Oracle Utilities OCI Streaming for Notif Hub |
OIC Lookup | OUTL-BRT-NOTIFHUB_ConfigProps OUTL-BRT-NOTIFHUB_Email_ID OUTL-BRT-NMS_STREAM_TROUBLE_CODE |
Integration Properties | Description | Initial Value |
---|---|---|
responsysInstance | This is the responsysInstance representing an Oracle Responsys instance. It is used to sort the messages read from the Target Notification Stream, belonging to the Oracle Responsys instance linked to this particular OIC instance. The lookup table OUTL-BRT-NOTIFHUB_DeliveryInstance is used to translate responsysInstance to a value that is populated in the email notifications to identify the Oracle Responsys instance. |
Artifacts | Value |
---|---|
Integration Process Name | Oracle Utilities OCI Stream Responsys Notif Send |
Integration Package Name | outl.ba.notifications_hub.1.22.1000 |
OCI Streaming Adapter | • Poller to Consume Message • Operation: Consume messages from Stream • Stream: TargetNotificationStream • Consumer Group: NotificationGroup • Partition: Default • Polling Frequence: 60 s • Maximum Number of records to Fetch: 200 • Message Structure: JSON • Publish to Stream • Operation: Publish messages to Stream • Stream: TargetNotificationStream • Partition: Default • Message Structure: JSON • Connection Name: Oracle Utilities OCI Streaming for Notif Hub |
Responsys Web Service | WebService: /rest/api/v1.3/campaigns/{notificationTemplate}/email /rest/api/v1.3/campaigns/{notificationTemplate}/sms Method: POST Connection Name: Oracle Utilities REST Responsys for Notif Hub |
OIC Lookup | OUTL-BRT-NOTIFHUB_ConfigProps OUTL-BRT-NOTIFHUB_Email_ID OUTL-BRT-NOTIFHUB_DeliveryChannel OUTL-BRT-NOTIFHUB_DeliverynInstance |
Artifacts | Value |
---|---|
Integration Process Name | Oracle Utilities CCB OCI Stream Notif Upload |
Identifier | OUTL-BA-CCB_STREAM_NOTIF_UPLOAD |
Integration Package Name | outl.ba.notifications_hub.1.22.1000.par |
CCB BO | C1-TMPLNTFRQ |
Oracle Utilities Adapter Connection | Oracle Utilities REST CCB for Notif Hub |
Oracle Streams Adapter | OUTL-BRT-STREAM-NOTIF_HUB • Publish to Stream • Operation: Publish messages to Stream • Stream: Target Notification Stream • Partition: Default • Message Structure: JSON |
OIC Lookup | OUTL-BRT-NOTIFHUB_ConfigProps OUTL-BRT-NOTIFHUB_Email_ID OUTL-BRT-NOTIFHUB_DeliveryInstance OUTL-BRT-NOTIFHUB_Priority |
Integration Properties | Description | Initial Value |
---|---|---|
fileNamePattern | This is the filename pattern to use to read the unsubscribe files from the Oracle Responsys SFTP location. File name pattern may satisfy a single file or multiple files. | Unsubscribe* |
Integration Properties | Description | Initial Value |
---|---|---|
ResponsysInstanceId | This is the ResponsysInstanceId representing a Responsys instance. The lookup table OUTL-BRT-NOTIFHUB_DeliveryInstance is used to translate the ResponsysInstanceId to a value that is populated in the email notifications to identify the Responsys Instance which is generating errors. | RESP1 |
Artifacts | Value |
---|---|
Integration Process Name | Oracle Utilities Responsys CCB Pref Unsubscribe |
Integration Package Name | outl.ba.notifications_hub.1.22.2000 |
CCB BO | C1-TMPLNTFRQ |
Oracle FTP Adapter | • Operation: List Files • Input Directory: / • File Name Pattern: * • Max Files: 100 • Minimum Age: 0 seconds • List Files Recursively • Operation: Read File • Operation: Download File • Operation: Move File (Rename to PROCESSED”_fileName) • Connection Name: Oracle Utilities SFTP for Notifican Hub |
CCB REST IWS (Utilities Adapter) | Web Service Name: C1- UnsubscribeNotifications Computed URL: https://{host}:{port}/{tenant}/{domain}/ccs/rest/apis/customer/v-model/C1UnsubscribeNotifications |
OIC Lookup | Method: POST URI: / Connection Name: Oracle Utilities REST CCB for Notif Hub OUTL-BRT-NOTIFHUB_ConfigProps OUTL-BRT-NOTIFHUB_Email_ID OUTL-BRT-NOTIFHUB_DeliveryChannel OUTL-BRT-NOTIFHUB_DeliveryInstance |
Schedule Parameters | Description | Initial Value |
---|---|---|
EmailFilePattern | Email CED file pattern to be processed | “SENT,FAIL,SKIPPED” |
SMSFilePattern | SMS CED file pattern to be processed | “SMS_SENT, SMS_FAIL, SMS_SKIPPED” |
Artifacts | Value |
---|---|
Integration Process Name | Oracle Utilities Responsys CED Process |
Integration Package Name | outl.ba.notifications_hub.1.22.2000 |
Identifier | OUTL-BA-RESP_CED_PROCESS |
Local OIC Integration (Invoking PENDING status file) | • OIC integration name: Oracle Utilities Responsys CCB Cust Contact Create • API path: oicinstance/ic/api/integration/v1/flows/rest/ • OUTL-BA-RESP_CCB_CC_CREATE /1.0/metadata • Resource path: /CEDPending/{statusFile} • Response media type: application/json • Operation: processPendingFile • Http Method: POST • Connection Name: Oracle Utilities SFTP for Notif Hub |
Local OIC Integration (Invoking EMAIL status file) | • OIC integration name: Oracle Utilities Responsys CCB Cust Contact Create • API path: oicinstance/ic/api/integration/v1/flows/rest/ • OUTL-BA-RESP_CCB_CC_CREATE /1.0/metadata • Resource path: /CED/{statusFile} • Response media type: application/json • Operation: processCEDFile • Http Method: POST. • Connection Name: Oracle Utilities SFTP for Notif Hub |
Local OIC Integration (Invoking SMS status file) | • OIC integration name: Oracle Utilities Responsys CCB Cust Contact Create • API path: oicinstance/ic/api/integration/v1/flows/rest/ • OUTL-BA-RESP_CCB_CC_CREATE /1.0/metadata • Resource path: /CED/{statusFile} • Response media type: application/json • Operation: processCEDFile • Http Method: POST • Connection Name: Oracle Utilities SFTP for Notif Hub |
OIC Lookup | OUTL-BRT-NOTIFHUB_ConfigProps OUTL-BRT-NOTIFHUB_Email_ID |
Integration Parameters | Description | Initial Value |
---|---|---|
pendingTargetDirectory | SFTP Directory location where the pending files should be created and placed. | download/pending |
pendingSourceDirectory | SFTP Directory location where the pending files needs to be picked for file processing. | download/pending |
ResponsysAcctId | Responsys account ID | 81290 |
sourceDirectory | Responsys CED file's SFTP folder location. From this location, the integration process will pick the files and process further. | download/ced |
targetDirectory | CED processed file's SFTP folder location. The integration will place the processed files in the target directory and will mark as processed by prefixing the file name with “PROCESSED”. | download/ced |
ResponsysInstanceId | Responsys instance ID | RESP1 |
Artifacts | Value |
---|---|
Integration Process Name | Oracle Utilities Responsys CCB Cust Contact Create |
Integration Package Name | outl.ba.notifications_hub.1.22.2000 |
Identifier | OUTL-BA-RESP_CCB_CC_CREATE |
Oracle Utilities Adapter | • Business Object: C1-CustomerContactNotification • Operation: syncCustomerContact • Request Payload Type: JSON • Response Payload type: JSON • API type: REST • API url: https://{domain}:port/ouaf/rest/ouaf/openapi/iws/catalog • Http Method: POST. • Connection Name: Oracle Utilities REST CCB for Notif Hub |
Oracle FTP Adapter | • Endpoint name: GetAllTheCountFile • Endpoint description: Get the list of count files. • Operation: List File • Input Directory: /tmp • File Name Pattern: *.cnt • Max Files: 100 • Minimum Age: 0 seconds • List Files Recursively: Checked • Ignore File Permissions: Unchecked • Connection Name: Oracle Utilities REST CCB for Notif Hub |
Oracle FTP Adapter | • Endpoint name: ReadCountFile • Endpoint description: Read the count file • Operation: Read a file • Input Directory: Directory name from Oracle FTP Adapter (GetAllTheCountFile) • File Name: File name from Oracle FTP Adapter (GetAllTheCountFile) • Select the transfer mode: ASCII • Do you want to specify the structure for the content of file: No • Connection Name: Oracle Utilities SFTP for Notif Hub |
Oracle FTP Adapter | • Endpoint name: DownloadActualFile • Endpoint description: Download file with file pattern in scheduler parameters. • Operation: Download File • Input Directory: Directory name from Oracle FTP Adapter (GetAllTheCountFile) • File Name: File name from Oracle FTP Adapter (GetAllTheCountFile) • Select the transfer mode: Binary • Download Directory: /temp/resp • Perform unzip on compressed file downloaded from external FTP server: Checked • Connection Name: Oracle Utilities SFTP for Notif Hub |
Oracle FTP Adapter | • Endpoint name: MarkCountFileAsProcess • Endpoint description: Rename the count file as processed • Operation: Move a File • Input Directory: Directory name from Oracle FTP Adapter (GetAllTheCountFile) • Input Filename: Prefixed with “PROCESSED” and current timestamp • Connection Name: Oracle Utilities SFTP for Notif Hub |
Oracle FTP Adapter | • Endpoint name: MarkZipFileProcess • Endpoint description: Rename the CED compressed file as processed. • Operation: Move a File • Input Directory: Directory name from Oracle FTP Adapter (GetAllTheCountFile) • Input Filename: Prefixed with “PROCESSED” to the existing processed filename. • Connection Name: Oracle Utilities SFTP for Notif Hub |
Oracle FTP Adapter | • Endpoint name: ListPendingFile • Endpoint description: List the pending xml file • Operation: List File • Input Directory: /tmp • File Name Pattern: PENDING*.xml • Max Files: 100 • Minimum Age: 0 seconds • List Files Recursively: Checked • Ignore File Permissions: Unchecked • Connection Name: Oracle Utilities SFTP for Notif Hub |
Oracle FTP Adapter | • Endpoint name: DownloadPendingFile • Endpoint description: Get all the pending files. • Operation: Download File • Select the transfer mode: ASCII • Input Directory: Directory name from Oracle FTP Adapter (ListPendingFile) • File Name: File name from Oracle FTP Adapter (ListPendingFile) • Download directory: /tmp/resp • Connection Name: Oracle Utilities SFTP for Notif Hub |
Oracle FTP Adapter | • Endpoint name: RenamePendingFile • Endpoint description: Rename the processed pending files • Operation: Move a File • Directory path: / • File Name: * • Target Directory path: / • Target File Name: * • Overwrite File: Unchecked • Connection Name: Oracle Utilities SFTP for Notif Hub |
OIC Lookup | OUTL-BRT-NOTIFHUB_ConfigProps OUTL-BRT-NOTIFHUB_Email_ID OUTL-BRT-NOTIFHUB_CustContactStatus OUTL-BRT-NOTIFHUB_OriginSystem OUTL-BRT-NOTIFHUB_DeliveryInstance |
Schedule Parameters | Description | Initial Value |
---|---|---|
maxRecords | Maximum records to be fetched from the OCI Stream | 300 |
Integration Parameters | Description | Initial Value |
---|---|---|
targetDirectory | Oracle Responsys SFTP directory location where the Pending files will be written/created. | SFTP location where Oracle Responsys is installed |
Artifacts | Value |
---|---|
Integration Process Name | Oracle Utilities Responsys SFTP File Create |
Integration Package Name | outl.ba.notifications_hub.1.22.2000 |
Identifier | OUTL-BA-RESP_SFTP_FILE_CREATE |
Oracle FTP Adapter Identifier | OUTL-BRT-SFTP_NOTIF_HUB • Operation: Write Files • Output Directory: / • Select a Transfer Mode: Ascii • File Name Pattern: * • Append to Existing File: Unchecked • PGP encryption/description: No PGP Encryption/Decryption on the file to be sent to external FTP server • Connection Name: Oracle Utilities SFTP for Notif Hub |
Oracle Streams Adapter Identifier | OUTL-BRT-STREAM-NOTIF_HUB • Operation: Consume message from stream • Stream Selected: TargetNotificationStream • Partition: Default • Consumer Group: CustomerContactGroup • Max No of records to be fetched: 400 • Specify the option for consuming message: Read Latest • Connection Name: Oracle Utilities OCI Streaming for Notif Hub |
OIC Lookup | OUTL-BRT-NOTIFHUB_ConfigProps OUTL-BRT-NOTIFHUB_EmailSubject OUTL-BRT-NOTIFHUB_Email_ID |