Implementation Guide for Oracle Billing Insight


What's New in This Release


Back to top


Overview of Oracle Billing Insight

About Oracle Billing Insight

About the Self-Service Application

About the Assisted Service Application

About the Command Center Application

About the RESTFul Web Services

About Oracle Billing Insight Architecture

About the Oracle Billing Insight Database

About Oracle Billing Insight Installation Directories

About Application EAR Files

Debugging Oracle Billing Insight

Accessing Oracle Billing Insight Data Dictionary and Javadoc

Identifying the Installed Version of Oracle Billing Insight


Back to top


About Customizing Oracle Billing Insight

Best Practices for Customizing Oracle Billing Insight

About User Interface Files

About Repackaging EAR Files

Customizing the Default UI CSS

About Custom JSP Pages and Action Classes

About Velocity Templates

About Customizing Reports

Customizing the User Interface for Multiple Branding

Localizing the User Interface


Back to top


Customizing User Management

Deactivating and Reactivating the Bootstrap User

Customizing the Assisted Service User Password Update Requirements

Customizing the Administrator User Password Validation Rule

Customizing End User and Agent Password Validation Rules

Customizing User Enrollment

Customizing the Validation Code Generator

Customizing Account Lockout

Customizing User Authentication and Authorization With Spring Security

About Authentication Request Processing

Customizing Authentication URLs

About Resource Authorization

Adding a New User Role

Adding a New Permission Set

About Deleted Users

Input File Format for the DefUsrAcctRelationship Job

Input File Format for Migrating Consumer Users in Batch

Input File Format for Deleting Consumer Users in Batch


Back to top


Customizing Billing Statements

About Split Billing Rules Management

Updating Disputes in an External Customer Relationship Management System

Defining Billing Periods


Back to top


Using and Customizing Email and SMS Notifications

About Batch Email Notification Processing

Notification Methods: Instant and Batch

Email Notification Template Content for Business Users

Email Notification Template Content for Consumer Users

SMS Notification Template Content

Customizing the Content of Notifications

Customizing the Default Display Patterns Used in Notifications

Configuring Messaging Properties

Adding a Custom Message Provider

Configuring the Secure Bill-Ready Notification Password

Disabling SMS Notifications


Back to top


Using the Reporting Engine

Reporting Engine Features

Reporting Engine Architecture

Reporting Engine Object Model

Components Used by the Reporting Engine

Using the Report List Properties File

Configuring Batch Reporting

Report XML

Creating a PDF Template for Reporting

Predefined Context Variables

Integration with Struts and Tiles

Reporting API

Core Reporting Features

Sorting Feature of the Reporting Engine

Paging Feature of the Reporting Engine

Dynamic SQL

Internationalization and Localization of Reporting

Object Data Source

DSV Data Source

Drilldown and Breadcrumb Link

Customizing the Reporting Engine

Write Your Own Report XML

Customize the Report Template

Write Your Own Action Classes and ReportBean

Packaging

Hiding Report Columns and Manipulating IReport

Unlimited Paging

Reloading Report XML and Templates without Restarting the Server

Customizing Threshold Values for Batch Reporting

Customizing Charts

Configurable Chart Properties

Customizing the Statement Summary Chart

Changing the Local Storage Location for the HTML Report Formatting Files


Back to top


Payment Processing

About Check Processing

Example of Adding a Check Account at Enrollment

Check Account Enrollment Status Workflow

Check Payment Transaction Workflow

Automated Clearing House (ACH) Return Codes

About Credit and Debit Card Processing

Paymentech Authorization Transactions

Credit Card and Debit Card Payment Status

Credit and Debit Card Payment Transactions

Instant Credit or Debit Card Payments

Scheduled Credit and Debit Card Payments

User Options

Using PayPal Payflow Pro as a Payment Gateway

Using Chase Paymentech Orbital Payment Gateway

Address Verification Service

About Recurring Payment Processing

Tables Updated by Recurring Payments

Recurring Payment Transaction Cycle

User Interface Updates to the Recurring Payments Table

Recurring Payment Job

Example of Scheduling the Amount Due Before the Due Date

Example of Scheduling the Amount Due on a Fixed Pay Date

Example of Scheduling a Fixed Amount Before the Due Date

Example of Scheduling Fixed Amount and Fixed Pay Date

About Payment Auditing

Using Payment Debug

Input File Format for Canceling Payments for Consumer Users in Batch


Back to top


Customizing Payment

About Payment Plug-Ins

Creating an ACH Plug-In

Creating a Credit Card Plug-In

Creating a Payment Reminder Plug-In

Creating a Recurring Payment Plug-In

Customizing Oracle Billing Insight Payment Template Files

Generating Accounts Receivables (A/R Files)

Customizing the Payment Amount Format

Packaging Oracle Billing Insight Payment Custom Code

About the APIs for Implementing Custom Payment Cassette Cartridges

Implementing Custom Payment Cassette Cartridges

Configuring Convenience Fee Payments

Handling Multiple Payee ACH Accounts

Using Payment APIs

Configuring International Bank Routing

Customizing Anonymous Payment Validation

Updating the Back-End Billing System With a Top-Up Payment


Back to top


Customizing the Payment Consolidator Integration Module

Overview of Processing with a Payment Consolidator

Payment Consolidation Jobs

Payment Consolidation Input and Output Files

The Payment Consolidation Template Engine

Process of Implementing a Payment Consolidator

Creating Customized Payment Consolidation Templates

Sample Payment Consolidation Template Files

The File Structure XML Template

The Record XML Templates

Template Attributes

Template Variables

Logic Operators

Accessing an Object's Public Fields and Methods

Adding a New Java Object Instance or Static Class

Adding Cartridge Property Keys

Setting Payment Consolidation Configuration Parameters

Customizing the Bill Detail URL

Implementing Payment Consolidator Plug-Ins

Payment Consolidator Java APIs

Default File Formats for Payment Consolidation

Account Enrollment Input File Format

Enrollment Acknowledgement Output File Format

Bill Summary Output File Format

Bill Summary Acknowledgement Input File Format

Data Element Mappings - Example A

Data Element Mappings - Example B

Payment Consolidation Database Tables


Back to top


Customizing the Assisted Service Application

About the Assisted Service Application Functionality

Assisted Service Application Files

Integrating the Assisted Service Application With CRM or Other Back Office Systems

About Impersonation Auditing


Back to top


Reporting on Audit Data

Reporting on User Audit Data

Reporting on System Administrator Audit Data


Back to top


Load Input File Specifications and Data Mapping

Preprocessor Tasks

Data File Loading Tasks

About Data Load Processing

File Record and Dimension Table Mapping

File Record and Fact Table Mapping

File Formats for Dimension-Level Information

File Formats for Statement-Level Information

File Formats for Account-Level Information

File Formats for Service-Level Information

File Formats for Service Detail-Level Information

File Formats for Unbilled Detail-Level Information

File Formats for Prepaid Information

File Formats for Batch Provisioning Data

Internationalization Support Settings

Back to top

Implementation Guide for Oracle Billing Insight Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.