Sonic Alert B31540-02 - page 5

 v

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............................................ B-3

Bill Summary Public Record Type:BILL_SUMMARIES_REC ...............................................B-3

C Message Maps and DTDs for XML Gateway

Maps and DTDs Overview.......................................................................................................C-1

Loading and Deleting Maps.....................................................................................................C-3

Loading and Deleting DTDs.................................................................................................... C-3

D XML Messages in TBI

XML Message Overview ..........................................................................................................D-1

Outbound and Inbound BOD.................................................................................................. D-2

XML Message Format............................................................................................................... D-2

Outbound Messages ................................................................................................................ D-2

Inbound Messages ...................................................................................................................D-4

Seeded XML Messages............................................................................................................. D-7

Message Specifications for Account Information....................................................................D-7

Message Specifications for Sales Order Line.........................................................................D-20

Message Specifications for Product/Item...............................................................................D-30

Message Specifications For Group Sales Order Line ........................................................... D-32

Glossary

Index

Contents

Main Page Contents A Configuring Oracle Applications InterConnect Page Page Send Us Your Comments Page Preface Intended Audience TTY Access to Oracle Support Services Documentation Accessibility Accessibility of Code Examples in Documentation Accessibility of Links to External Web Sites in Documentation Structure Related Information Sources Integration Repository Guides Related to All Products Guides Related to This Product Installation and System Administration Other Implementation Documentation Do Not Use Database Tools to Modify Oracle Applications Data Page Introduction to Telecommunications Billing Telecommunications Billing Integrator Overview Telecommunications Billing Integrator Features Publishing Information to the Billing Applications Page 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 Account Message Obsoleted Billing Preference Events Obsoleted Billing Preference Information Enhancements to Sales Order Message Uptake of JMS Compliant Queues in XML Gateway Implementing Telecommunications Billing Integrator Implementation Considerations TBI with TSO Page Implementation Tasks for Oracle Telecommunications Billing Integrator Implementation Tasks Setting up Profile Values Setting Up XML Gateway Defining XML Gateway Profile Values Defining UTL_FILE_DIR Parameters Defining XML Standards Defining a Hub Defining Hub Users Defining Transactions Internal and External Transactions in XML Gateway Page External Transactions for Sales Order Outbound Internal Transactions for Group Sales Order Outbound Internal Transacations for Inventory Item Outbound External Transactions for Group Sales Order Outbound External Transactions for Inventory Item Outbound Internal Transaction for Confirm BOD Inbound External Transactions for Confirm BOD Inbound Transactions Enabled for TBI Defining Trading Partners Setting Up Oracle Collaboration History Defining Collaboration History Profile Values Defining Lookup Values for Collaboration Setting Up Collaboration Events Setting up the Final Collaboration Event Checking Status of Agent Listeners Setting Up Bill Summary UI Defining Bill Summary UI Profile Options Providing Access and Enabling the Bill Summary UI Steps: Personalizing Oracle Contact Center for TBI Accessing the Bill Summary UI from Oracle Contact Center Loading Bill Summary Data Integration with Order Management Workflow Processes Integrating Workflow Process for Publishing Account Information Integrating Workflow Process for Publishing Sales Order Information Defining Sales Order Line Profile Option Page Item Batch Export Profile Values Submitting the Item Publish Request Subscribing to Account Update Events Navigation: TBI Setup > Subscribe to Events > Account Update Events. Supported Events The following table lists the supported events. Configuring the Middleware Page A Configuring Oracle Applications InterConnect Oracle Applications InterConnect Overview Setting Up OAI Hub Setting up OAI Adapter for Advanced Queues Dropping the Hub Schema Importing OAI Maps to the Repository Page B APIs in Telecommunications Billing Integrator Bill Summary Bulk Insert APIs Procedure: INSERT_ROW_BATCH Procedure: UPDATE_ROW_BATCH The following table lists the specifications for BILL_SUMMARIES_REC. Bill Summary Public Table Type: BILL_SUMMARIES_TABLE The following table lists the specifications for the BILL_SUMMARIES_TABLE. Bill Summary Public Record Type: BILL_SUMMARIES_REC Page Page Page C Message Maps and DTDs for XML Gateway Maps and DTDs Overview Maps in XML Gateway Note: The names of message maps are based on the internal names of DTDs in XML Gateway Open Applications Group (OAG) Conforming DTDs TBI provides the following OAG conforming DTDs: oagis_domains.dtd Loading and Deleting Maps Loading and Deleting DTDs Page D XML Messages in TBI XML Message Overview Outbound and Inbound BOD XML Message Format Outbound Messages JMS Message Structure JMS Message Header Properties for CBOD Inbound Messages Page Structure of the CBOD XML Message Seeded XML Messages Message Specifications for Account Information The following table lists the message specifications for account information. Page Page Page Page Page Page Page Page Page Page Page Page Message Specifications for Sales Order Line The following table lists the specifications for sales order line information. Page Page Page Page Page Page Page Page Page Message Specifications for Product/Item The following table lists the specifications for product. Page Message Specifications For Group Sales Order Line The following table lists the message specifications for Group Sales Order Line. Page Page Page Page Page Page Page Page Page Page Glossary Page Index