Sonic Alert B31540-02 manual Publishing Information to the Billing Applications

Page 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 Applications InterConnect, page A-1.

•Display bill summary and bill image: TBI provides access to the bill summary data through Oracle Contact Center. The Bill Summary UI displays the bill summary for a single account number. The customer service agents can view the bill summary from the 'Bill Summary' option in Oracle Contact Center. The bill number provided in the bill summary UI is linked to the image data supplied by the billing application. To enable the 'Bill Summary' option in Oracle Contact Center, see Setting up Bill Summary UI, page 3-13.

•Business Event Enabled: Business Event System is a real-time notification system. The Business Event System notifies TBI when an account or sales order is created or updated. For account update, the TBI users can choose the TCA events they wish to subscribe to. For more information, see Subscribing to Account Update Events, page 3-21.

Publishing Information to the Billing Applications

TBI publishes information on the following EBS entities to the external billing applications:

•New Account

•Account Update

•Item/Product

•Sales Order

•Grouped Sales Order

Publishing New Account Details

Account information is maintained in Oracle Trading Community Architecture (TCA) and is published to the external billing application only when an order is booked for the first time for an account.

For more information, see Integrating Workflow Process for Publishing Account Information, page 3-16and Message Specifications for Account, page D-7.

Publishing Account Update Details

Introduction to Telecommunications Billing Integrator 1-3

Image 17

Contents Part No. B31540-02 Oracle Telecommunications Billing IntegratorGovernment Rights Contents Configuring Oracle Applications InterConnect Message Maps and DTDs for XML Gateway Page Vii Send Us Your CommentsPart No. B31540-02 Page Intended Audience TTY Access to Oracle Support ServicesPreface Structure Documentation AccessibilityAccessibility of Code Examples in Documentation Integration Repository Related Information SourcesGuides Related to All Products Guides Related to This ProductXii Installation and System AdministrationXiii Other Implementation DocumentationXiv Telecommunications Billing Integrator Overview Introduction to Telecommunications Billing IntegratorTelecommunications Billing Integrator Features Publishing New Account Details Publishing Account Update DetailsPublishing Information to the Billing Applications Publishing Sales Order Details Publishing Item/Product DetailsPublishing Group Sales Order Message Details Products Used in TBIEnhancements Publish Bill To Accounts for a Sales Order Additional TCA Events for Account Update MessageGrouped Sales Order Message Enhancements to Sales Order Message Enhancements to Account MessageObsoleted Billing Preference Events Obsoleted Billing Preference InformationUptake of JMS Compliant Queues in XML Gateway TBI with TSO Implementing Telecommunications Billing IntegratorImplementation Considerations External Billing Applications Middleware in TBIPage Implementation Tasks Setting up Profile ValuesDefining Utlfiledir Parameters Setting Up XML GatewayDefining XML Gateway Profile Values Defining a Hub Defining XML StandardsDefining Hub Users Standard Type Enter XMLStandard Code Select OAG Defining TransactionsInternal and External Transactions in XML Gateway Internal Transaction for Sales Order Outbound Account Outbound Internal TransactionExternal Transactions for Account Outbound Internal Transactions for Group Sales Order Outbound External Transactions for Sales Order OutboundExternal Transactions for Group Sales Order Outbound Internal Transacations for Inventory Item OutboundExternal Transactions for Confirm BOD Inbound External Transactions for Inventory Item OutboundInternal Transaction for Confirm BOD Inbound External Transactions for Confirm BOD Inbound Transactions Enabled for TBITransactions Enabled for TBI Defining Trading Partners Setting Up Oracle Collaboration HistoryDefining Collaboration History Profile Values Lookup Type Lookup Code Description EnableDefining Lookup Values for Collaboration Lookup TypesSetting up the Final Collaboration Event Setting Up Collaboration EventsDefining Bill Summary UI Profile Options Setting Up Bill Summary UIChecking Status of Agent Listeners Profile Option Value Providing Access and Enabling the Bill Summary UIBill Summary UI Profiles Values Personalizing Oracle Contact Center for TBI Integration with Order Management Workflow Processes Accessing the Bill Summary UI from Oracle Contact CenterLoading Bill Summary Data Workflow Process for Publishing Account Information Workflow Process for Publishing Sales Order Information Defining Sales Order Line Profile OptionCreating the Workflow Function Setting Up and Running the Item Publish Concurrent ProgramItem Batch Export Profile Values Item Batch Export Profile ValuesSeeded Values for Item Batch Export Concurrent Program Name ValueSubmitting the Item Publish Request Subscribing to Account Update EventsEvent Name Event Display Name Description Supported EventsConfiguring the Middleware Page Oracle Applications InterConnect Overview Configuring Oracle Applications InterConnectTo stop the repository service, use the following command Setting Up OAI HubSetting up OAI Adapter for Advanced Queues Dropping the Hub Schema Importing OAI Maps to the Repository Page Bill Summary Bulk Insert APIs Procedure InsertrowbatchAPIs in Telecommunications Billing Integrator Parameter Name /Out Data Type Description Procedure UpdaterowbatchProcedure Insertrowbatch Specifications for Billsummariestable Procedure UpdaterowbatchBill Summary Public Table Type Billsummariestable Bill Summary Public Record Type BillsummariesrecOptional Attributes Specifications for BillsummariesrecAttribute Name Data Type Description Mandatory attributes Attribute Name Data Type Description Page Maps and DTDs Overview Message Maps and DTDs for XML GatewayMaps in XML Gateway Maps in XML GatewayOpen Applications Group OAG Conforming DTDs DTDs in XML GatewayDTDs in XML Gateway Root ElementLoading and Deleting DTDs Loading and Deleting MapsPage XML Message Overview XML Messages in TBIXML Message Format Outbound and Inbound BODOutbound Messages JMS Message StructureJMS Message Structure JMS Message Header Properties for CbodField Value Inbound MessagesFields in the Advanced Queue Message XML Messages in TBI D-5 Cntrolarea BSR Structure of the Cbod XML MessageSeeded XML Messages Message Specifications for Account InformationMessage Specifications for Account Accountname Accountinfo Hzcustaccoun Relationshipty Relatedaccoun Hzcustacctre Datetime Taxexemptions Rataxexemptio Receiptmethod Receiptmethods Arreceiptmeth Emailaddress Customerinfo HZPARTIES.EMAIL Addrline Address Contact Parentrelatio Relationshipinf Hzrelationship Edipaymentfor Customercont MAT ACT Partygroup Customercont HZLOCATIONS.AD Amount Custprofileam Hzcustprofile Datetime Custprofileam Hzcustprofile Message Specifications for Sales Order Line Message Specifications for Sales Order LineTopmodelline Orderlineinfo Oeorderlines Inventoryitem Orderlineinfo Mtlsystemitem Shiptoorgid Orderlineinfo Oeorderlines Stateprovn Address HZLOCATIONS.ST Extattributes Oeorderlines Lastoeorderl Installbaseinf Csiiteminstanc Attributename Attributeinfo Csiiextendeda Billtoownerf Billtopartyin HZPARTIES.BILLT Postalcode Partyextattri Billtopartyin Following table lists the specifications for product Message Specifications for Product/ItemMessage Specifications for Product Message Specifications for Group Sales Order Line Message Specifications For Group Sales Order LineSoldtoaccoun Orderheaderi Hzcustaccoun ALL Inventoryitem Inventoryitem Orderlineinfo Mtlsystemitem Invoicetoorgi Shiptoorgid Orderlineinfo Oeorderlines County Address HZLOCATIONS.CO ATTRIBUTE1 Lastoeorderl Installbaseinf Csiiteminstanc XML Messages in TBI D-39 Billtoownerf Billtopartyin HZPARTIES.BILLT ATTRIBUTE15 Shiptocontact Orderline Personnamesu Contactname HZPARTIES.PERSO Glossary Workflow Function TransactionXML Gateway XML PayloadIndex-1 Index