Implementation Guide for Oracle Self-Service E-Billing


What's New in This Release


Back to top


Customizing Oracle Self-Service E-Billing

Overview of Oracle Self-Service E-Billing Architecture

About the Billing and Payment Application

About the Command Center Application

About the Customer Service Representative Application

Guidelines for Customizing Oracle Self-Service E-Billing

Customizing the User Interface Files

Localizing the User Interface

Changing the Frequency of Automatic Resource File Updates

Debugging Oracle Self-Service E-Billing

Accessing Oracle Self-Service E-Billing Javadoc


Back to top


Customizing User Management

Customizing User Management and Security

Customizing User Enrollment

Customizing User and Customer Service Representative CSR User Passwords

Customizing the Administrator User Password

Customizing the CSR User Password Configuration

Deactivating and Reactivating the Bootstrap Administrator ID in the CSR Application

Customizing Enrollment Validation

Customizing Account Lockout

Customizing User Security Questions

Customizing Reactivate Account Lockout

Customizing Profile Management

Updating User Profile Information in an External Customer Relationship Management System

About Deleting Users

Customizing Spring Security

Configuring Oracle Self-Service E-Billing to use a Single Sign-on System

Customizing User Management for External Authentication Systems

Configuring Oracle Self-Service E-Billing to use an LDAP System

Synchronizing Single Sign-On or LDAP Users with Oracle Self-Service E-Billing

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

Input File Format for Canceling Payments for Consumer Users in Batch


Back to top


Customizing Billing Statements

About Statement Presentment APIs

About Split Billing Rules Management APIs

Transaction Dispute APIs

Updating Disputes in an External Customer Relationship Management System

Unbilled Usage APIs

Contact APIs

Defining Billing Periods in the OLAP Database

Integrating Oracle Self-Service E-Billing With Oracle WebCenter Content

Integrating Oracle Self-Service E-Billing With Other Content Management Systems


Back to top


Using and Customizing Email Notifications

Configuring Messaging Properties

Customizing the Content of Notifications

Customizing the Default Display Patterns Used in Email Notifications

Email Notification Template Content in the Business Edition

Email Notification Template Content in the Consumer Edition

Adding a Custom Message Provider

About Email Notification Processing

Configuring the Secure Bill-Ready Notification Password


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

Reporting on User Audit Data

Reporting on System Administrator Audit Data

Changing the Local Storage Location for the HTML Report Formatting Files


Back to top


Payment Processing

Architecture of Oracle Self-Service E-Billing Payment

About Check Processing

Example of Adding a Check Account at Enrollment

Check Account Enrollment Status Workflow

Check Payment Transaction Workflow

Credit Reversals

Automated Clearing House (ACH)

About Credit Card Processing

Credit Card Payment Status

Credit Card Payment Transactions

Instant Credit Card Payments

Scheduled Credit Card Payments

Credit Reversals

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

Functions of the Recurring Payment User Interface

Recurring Payment Job

Rebill Feature

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 the pmtRecurringPayment Job

About Payment Auditing

Viewing Payment Logs

Using Payment Debug


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 Self-Service E-Billing Payment Template Files

Generating Accounts Receivables (A/R Files)

Customizing the Payment Amount Format

Packaging Oracle Self-Service E-Billing Payment Custom Code

About the APIs for Implementing Custom Payment Cassette Cartridges

Implementing Custom Payment Cassette Cartridges

Avoiding Paying a Bill More Than Once

Handling Multiple Payee ACH Accounts

Using Payment APIs

Configuring International Bank Routing

Customizing Anonymous Payment Validation


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 Customer Service Representative Application

CSR Customization APIs

About CSR Functionality

CSR Application Files

Integrating CSR With Siebel CRM or Other CRM Applications

Using Impersonation with a Customer Service Application External to Oracle Self-Service E-Billing

About Impersonation Auditing


Back to top


ETL Input File Specifications and Data Mapping

Preprocessor Tasks

Data File Loading Tasks

About ETL File 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

Internationalization Support Settings

Back to top

Implementation Guide for Oracle Self-Service E-Billing Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.