Contents

Title and Copyright Information

Preface

• Audience
• Downloading Oracle Communications Documentation
• Documentation Accessibility
• Related Documents
• Document Revision History

Part I Billing and Revenue Management Application Adapter

1 About the BRM Adapter for Oracle Communications Data Model

• About the BRM Adapter
  • Components of the BRM Adapter
    • Database Schemas Used by the BRM Adapter
    • Oracle Data Integrator
    • Oracle GoldenGate
• BRM Adapter Execution Flows
  • Execution Flow Using the BRM Adapter with Only Oracle Data Integrator
  • Execution Flow Using the BRM Adapter with Oracle Data Integrator and Oracle GoldenGate

2 Using the BRM Adapter

• About Populating a Warehouse Using the BRM Adapter
  • About the BRM Adapter Data Load Packages
  • About the BRM Adapter Data Load Parameters
  • About BRM Adapter Configuration
    • Using Email Alert Notifications with the BRM Adapter
    • Using Intermediate Commits for Huge Batch Updates
    • Using Parallel Loading to Speed Up the Data Loads
• Performing an Initial Load of the Foundation Layer of the Oracle Communications Data Model Warehouse
• Refreshing the Foundation Layer of the Oracle Communications Data Model Warehouse
  • Refreshing the Foundation Layer on a Scheduled Basis
    • Scheduling Data Loads with the Oracle Data Integrator Built-In Scheduler from a Command Line
    • Scheduling Data Loads with the Oracle Data Integrator Built-In Scheduler from a Web Service
  • Refreshing the Foundation Layer with Real-Time Data Using Oracle GoldenGate
  • Manually Refreshing the Foundation Layer
• Administering BRM Adapter Data Load Processes
  • Configuring the BRM Adapter for Populating Oracle Communications Data Model Warehouse
    • Updating the Data Load Parameters
    • Setting the Intermediate Commit Interval
    • Configuring the BRM Adapter to Send Email Alert Notifications
      • Updating the Email Alert Notification Configurations
    • Configuring Parallel Loading
  • Managing and Monitoring BRM Adapter Data Load Processes
    • Using Oracle Data Integrator Web Console to Manage and Monitor Data Load Process
    • Displaying Your Brand Logo on the User Interface
    • Monitoring a Huge Batch Update
    • Using Oracle Database In-Memory Column Store to Improve Database Operations Performance
    • Restarting a Data Load Process After a Package Execution Fails
    • BRM Adapter Exception Handling
    • Exception Handler Configuration
    • Drop Error Tables (E$_)
    • Moving Data into History Tables

3 BRM Adapter Reference

• BRM Source and Oracle Communications Data Model Target Tables
• Oracle Data Integrator BRM_OCDM Project
  • Objects in SRC_STG_NONGG Folder of the BRM_OCDM Project
  • Objects in the STG_OCDM Folder of the BRM_OCDM Project
• Schema Definitions Added by the BRM Adapter
  • BRM_STG Schema Objects
  • OCDM_SYS Objects for the BRM Adapter

Part II Network Charging and Control Application Adapter

4 About NCC Adapter for Oracle Communications Data Model

• What Are Oracle Communications Prepaid Charging and Network Charging and Control
• Overview of NCC Adapter
  • Components of the NCC Adapter
    • Database Schemas Used by the NCC Adapter
    • Oracle Data Integrator
    • Oracle GoldenGate
• NCC Adapter Execution Flows
  • Execution Flow Using the NCC Adapter with Oracle GoldenGate and Oracle Data Integrator
  • Execution Flow Using the NCC Adapter with Only Oracle Data Integrator

5 Using the NCC Adapter

• About Populating a Warehouse Using the NCC Adapter
• Initial Loading Using the NCC Adapter
• Refreshing the Data Using the NCC Adapter
  • Refreshing the Foundation Layer on a Scheduled Basis
  • Refreshing the Foundation Layer with Real-Time Data

6 NCC Adapter Reference

• NCC Adapter Source and Target Tables
• Oracle Data Integrator NCC_OCDM Project
  • SRC_STG_NONAGG
    • SRC_STG_LOAD_NON_OGG_PKG Package
    • SRC_STG_EDR_LOAD_INCREMENTAL_PKG Package
    • SRC_STG_EDR_LOAD_INITIAL_PKG Package
  • STG_OCDM
    • STG_OCDM_INITIAL_LOAD_PKG Package
    • STG_OCDM_EDR_PKG Package
    • STG_OCDM_OGG_CDC_LOAD_SCENARIO_PKG Package
• NCC_STG Schema Objects
• NCC Source Schema Objects
• Schema Definitions Added by the NCC Adapter
  • NCC_STG Schema Objects
  • Definitions Added to the ocdm_sys Schema

Part III Social Network Analytics for Oracle Communications Data Model

7 Social Network Analytics

• Overview of the Social Network Analytics Add-On Adapter
  • About Social Network Analytics Features
  • Social Network Analytics Opt-Out Features
  • Social Network Analytics Concepts and Terms
• Social Network Analytics Process Flow
• About Social Network Analytics Roles
  • Social Network Analytics Subscriber Roles Leaders and Role Strength

8 Social Network Analytics Reports

• SNA Home Page
• SNA Analysis Report
• SNA Analysis Runs Report
  • Scheduler Jobs Overview: Polling Analysis Job Report
  • Scheduler Jobs Overview: Update Analysis Job Run Log Details Report
• SNA Network Report
• SNA Communities Report
• SNA Churn Report
• SNA Influence Report
• SNA Subscribers Report

Part IV Billing Analytics for Oracle Communications Data Model

9 Billing Analytics Overview and Reports

• Overview of Oracle Communications Data Model Billing Analytics
• Overview of Billing Analytics Process Flow
• Billing Analytics Reports
  • Billed Revenue Reports
    • Billed Revenue Overview
    • Revenue Detail
    • ARPU
    • Discounts
    • Payments and Collections
    • Adjustments
    • Maps
  • Billing Efficiency Reports
    • Billing Calculations
    • Billing Collection and Receivables Management
    • Billing Inquiries, Disputes, and Adjustments
  • Customer Metrics Reports
    • Acquisition
    • Churn
  • Prepaid Metrics Reports
    • Recharges Reports
    • Prepaid Customer Base Reports
    • Account Recharge
    • Disturbed Recharge
  • Usage Revenue Reports
    • Voice Usage
    • Voice Usage Revenue
    • Data Usage
    • SMS Usage
    • MMS Usage

10 Billing Analytics Reference

• Billing Analytics Physical Objects
• Billing Analytics Relationships and Measures
  • DWB_INVC_ITEM Analytics
  • DWD_ACCT_BAL_MO Analytics
  • DWD_ACCT_DEPT_MO Analytics
  • DWD_ACCT_PYMT_DAY Analytics
  • DWD_CNT_DAY Analytics
  • DWD_DATA_USG_DAY Analytics
  • DWD_INVC_DAY Analytics
  • DWD_PRPD_ACCT_STTSTC_DAY Analytics
  • DWD_RVN_DAY Analytics
  • DWD_TMF_KPI Analytics
  • DWD_VAS_USG_DAY Analytics
  • DWD_VOI_CALL_DAY Analytics
  • DWV_PRPD_CUST_STAT View Analytics

A TMF KPI Business Metrics

• Percentage of Payment Transactions by Payment Method (B-CE-1B)
• Percentage of Electronic Bills Issued (B-CE-1C)
• Mean Time to Prepare and Dispatch Bills (B-CE-4B)
• Percentage of Inaccurate Bills (B-CE-4C)
• Determine Percentage of Bills Adjusted (B-CE-4D)
• Percentage of Billing-Related Queries (B-CE-4E)
• Time to Prepare Bills for Display and Dispatch (B-OE-2A)
• Collections Efficiency Against Credit Terms (B-OE-3E)
• Percentage of E-payments Received (B-CE-1D)
• Percentage of Bills Adjusted Internally (B-CE-4F)
• Mean Time from Service Activation to Bill Dispatch (B_OE_2C)
• Percentage Collectible Debt Written Off (B_OE_3D)
• Volume of Customer Requests (CM_CE_3A)