Summary of the content on the page No. 1
Oracle® Telecommunications Billing Integrator
Implementation Guide
Release 12
Part No. B31540-02
December 2006
Summary of the content on the page No. 2
Oracle Telecommunications Billing Integrator Implementation Guide, Release 12 Part No. B31540-02 Copyright © 2005, 2006, Oracle. All rights reserved. Primary Author: Nuzhath Shereen The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disa
Summary of the content on the page No. 3
Contents Send Us Your Comments Preface 1 Introduction to Telecommunications Billing Integrator Telecommunications Billing Integrator Overview...................................................................1-1 Telecommunications Billing Integrator Features..................................................................... 1-2 Publishing Information to the Billing Applications................................................................ 1-3 Products Used in TBI...........................
Summary of the content on the page No. 4
Defining XML Gateway Profile Values....................................................................................3-3 Defining UTL_FILE_DIR Parameters....................................................................................... 3-3 Defining XML Standards.......................................................................................................... 3-4 Defining a Hub..........................................................................................................
Summary of the content on the page No. 5
B APIs in Telecommunications Billing Integrator Bill Summary Bulk Insert APIs................................................................................................ B-1 Procedure: INSERT_ROW_BATCH ........................................................................................ B-1 Procedure: UPDATE_ROW_BATCH........................................................................................B-2 Bill Summary Public Table Type: BILL_SUMMARIES_TABLE.............................
Summary of the content on the page No. 6
Summary of the content on the page No. 7
Send Us Your Comments Oracle Telecommunications Billing Integrator Implementation Guide, Release 12 Part No. B31540-02 Oracle welcomes customers' comments and suggestions on the quality and usefulness of this document. Your feedback is important, and helps us to best meet your needs as a user of our products. For example: • Are the implementation steps correct and complete? • Did you understand the context of the procedures? • Did you find any errors in the information? • Does the structu
Summary of the content on the page No. 8
Summary of the content on the page No. 9
Preface Intended Audience Welcome to Release 12 of the Oracle Telecommunications Billing Integrator Implementation Guide. This guide is intended for implementers and administrators of the Telecommunications Billing Integrator application. This guide assumes you have a working knowledge of the following: • The principles and customary practices of your business area. • Oracle Telecommunications Billing Integrator • Oracle XML Gateway To learn more about Oracle XML Gateway, see the Oracle XML
Summary of the content on the page No. 10
Documentation Accessibility Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other
Summary of the content on the page No. 11
This appendix provides information on the XML messages in TBI. Glossary Related Information Sources Oracle Telecommunications Billing Integrator shares business and setup information with other Oracle Applications products. Refer to other guides when you set up and use Oracle Telecommunications Billing Integrator. You can read the guides online by choosing Library from the expandable menu on your HTML help window, by reading from the Oracle Applications Document Library CD included in your me
Summary of the content on the page No. 12
Oracle Workflow Developer's Guide This guide explains how to define new workflow business processes and customize existing Oracle Applications-embedded workflow processes. It also describes how to define and customize business events and event subscriptions. Installation and System Administration Oracle Applications Concepts This book is intended for all those planning to deploy Oracle E-Business Suite Release 12, or contemplating significant changes to a configuration. After describing the O
Summary of the content on the page No. 13
function security, auditing, and security configurations. Oracle Alert User's Guide This guide explains how to define periodic and event alerts to monitor the status of your Oracle Applications data. Oracle Applications Developer's Guide This guide contains the coding standards followed by the Oracle Applications development staff and describes the Oracle Application Object Library components that are needed to implement the Oracle Applications user interface described in the Oracle Applicat
Summary of the content on the page No. 14
otherwise instructed. Oracle provides powerful tools you can use to create, store, change, retrieve, and maintain information in an Oracle database. But if you use Oracle tools such as SQL*Plus to modify Oracle Applications data, you risk destroying the integrity of your data and you lose the ability to audit changes to your data. Because Oracle Applications tables are interrelated, any change you make using an Oracle Applications form can update many tables at once. But when you modify Or
Summary of the content on the page No. 15
1 Introduction to Telecommunications Billing Integrator This chapter provides a brief introduction to the features in TBI. This chapter covers the following topics: • Telecommunications Billing Integrator Overview • Telecommunications Billing Integrator Features • Publishing Information to the Billing Applications • Products Used in TBI • Enhancements • Grouped Sales Order Message • Publish Bill To Accounts for a Sales Order • Additional TCA Events for Account Update Message • Enhancements to A
Summary of the content on the page No. 16
is made available to the external billing application. TBI depends on the Oracle Telecommunications Service Ordering (TSO) solution. The TSO solution leverages multiple components in the Oracle E-Business Suite (EBS) to enable telecommunications service providers to add, change, move or disconnect telecommunication services. Telecommunications service providers also use Oracle EBS to conduct post-sale interactions with customers, such as processing service requests and billing inquiries. Or
Summary of the content on the page No. 17
For more information, see Setting Up Collaboration History, page 3-10. • Middleware independent: TBI requires a middleware as an integration point to billing applications for messaging, transforming, and routing the XML messages. TBI can integrate with any middleware that has a native AQ or JMS adapter. TBI has been tested and certified using Oracle Applications InterConnect (OAI 9.0.4). For information on configuring Oracle Applications InterConnect (OAI 9.0.4), see Configuring Oracle Appl
Summary of the content on the page No. 18
TBI subscribes to a set of TCA events related to account updates. TBI generates and publishes an account message to the billing system when changes relevant to the billing system are made to accounts in TCA. The updated information is marked in the message. For example: If the credit classification information of an account (relevant to the billing system) is changed in TCA, TBI publishes the account message with the Credit Classification section marked as "U" (Updated). If multiple changes
Summary of the content on the page No. 19
The sales order is published after confirming that the account that created the sales order is also published. If the account is published, the sales order flow continues to publish the sales order message. If the account is not published, the account is published before publishing the sales order message. For more information, see Integrating Workflow Process for Publishing Sales Order Information., page 3-17 Publishing Group Sales Order Message Details A Group Sales Order message is a con
Summary of the content on the page No. 20
Grouped Sales Order Message This feature provides a single XML message that includes all the lines of an order. This enables the billing system to initiate the billing process for the entire order at the same time. The complete sales order message is grouped by order number and published to the billing application. A single message per order ensures that the dependencies and relationships across order lines are maintained when the message is delivered to the billing system and the billing s
