Analytics Publisher
Oracle Utilities Analytics Visualization is included in the cloud service subscription, available via a separate URL for each environment.
Analytics Publisher is available and included in the service as a reporting/query tool only.
Note: Analytics Publisher and Oracle Utilities Analytics Visualization extract and display data from the primary database only.
Oracle Database Actions is also available and included in the service for querying the database (see Chapter 21: Oracle Database Actions for more information).
Data extraction is supported via the Generalized Data Extract and Specialized Data Extract functionality, and/or DataConnect (CCS & MSCS only) may be a starting point for extraction of data for a BI/reporting tool such as Cognos.
Analytics Publisher can only access the primary database that is provisioned with the associated cloud service (such as CCS, MSCS, WACS, BCS, and so on). External data sources (such as xml data models, and so on) are currently NOT supported.
Analytics Publisher, as part of your cloud service, is not intended to be used directly as a bill/letter print system, however, it can be used to create reports based on extracted data. Billing/letter data can be extracted from Customer Cloud Service, Customer Care and Billing Cloud Service, and Billing Cloud Service via batch processing with target output files to be stored in Cloud Object Storage. The output file can then be uploaded into Analytics Publisher via an API for bill/letter data reporting.
Analytics Publisher can be configured to write output files to Cloud Object Storage (via Analytics Delivery Channel). This requires configuration of a value for the File Storage Configuration (F1-FileStorage) extendable lookup with the following settings:
• File Adapter: Oracle Cloud Object Storage
• User: The user Oracle Cloud ID (ODIC) for the object storage location
• Tenancy: The tenancy Oracle Cloud ID (ODIC) for the object storage location
• Compartment: The compartment Oracle Cloud ID (ODIC) for the object storage location
• Namespace: The namespace for the object storage location
• Key Ring: The API signature key used to connect your cloud service to Object Storage.
• Region: The region of the object storage tenancy for the connection (Values for this field are defined in the F1_REGION_FLG lookup.
• Bucket Name Prefix: Prefix used by Object Storage Bucket configuration
• Reporting Configuration: Enabled (checked)
Note: This applies to prior releases provided they are up to date with the latest maintenance pack and hot fix releases.
The following diagram outlines this process:
Note: The RTTYPOST batch control is not supported for bill generation using Oracle Utilities cloud services. Instead, customers should use batch-based extracts (such as the Customer Cloud Service bill extract functionality POSTROUT) in conjunction with 3rd party tools/services such as Documaker to ensure smooth, scalable, and successful implementation/operation of their services.
Refer to the following Knowledge Base articles on My Oracle Support for additional information about using Analytics Publisher for generating bills.
• Using Analytics Publisher for bill generation (Doc ID 2875527.1)
• Enabling Online Display Bill And Online Display Letter - Oracle Analytics (Doc ID 2942974.1)