Bill Summary Bulk Insert APIs | Sonic Alert B31540-02 manual

B

APIs in Telecommunications Billing Integrator

This appendix provides information on the APIs in TBI.

This appendix covers the following topics:

•Bill Summary Bulk Insert APIs

•Procedure: INSERT_ROW_BATCH

•Procedure: UPDATE_ROW_BATCH

•Bill Summary Public Table Type: BILL_SUMMARIES_TABLE

•Bill Summary Public Record Type: BILL_SUMMARIES_REC

Bill Summary Bulk Insert APIs

The summary data in the Bill Summary UI is fetched from the XNB_BILL_SUMMARIES table in Oracle E-Business Suite. The XNB_BILL_SUMMARIES_PKG public package provides the API to do a bulk insert in the XNB Bill Summary tables.

Procedure: INSERT_ROW_BATCH

The INSERT_ROW_BATCH procedure is used to insert new bill summary records from external billing applications into Oracle E-Business Suite.

Syntax: XNB_BILL_SUMMARIES_PKG.Insert_Row_Batch(p_api_version, bill_summaries, x_return_status, x_msg_data);

The following table lists the parameters for the procedure.

APIs in Telecommunications Billing Integrator B-1

Image 55

Sonic Alert B31540-02 manual APIs in Telecommunications Billing Integrator, Bill Summary Bulk Insert APIs

Contents

Part No. B31540-02 Oracle Telecommunications Billing Integrator Government Rights Contents Configuring Oracle Applications InterConnect Message Maps and DTDs for XML Gateway Page Part No. B31540-02 Send Us Your CommentsVii Page Preface TTY Access to Oracle Support ServicesIntended Audience Accessibility of Code Examples in Documentation Documentation AccessibilityStructure Guides Related to This Product Related Information SourcesIntegration Repository Guides Related to All Products Xii Installation and System Administration Xiii Other Implementation Documentation Xiv Telecommunications Billing Integrator Overview Introduction to Telecommunications Billing Integrator Telecommunications Billing Integrator Features Publishing Information to the Billing Applications Publishing Account Update DetailsPublishing New Account Details Publishing Sales Order Details Publishing Item/Product Details Enhancements Products Used in TBIPublishing Group Sales Order Message Details Grouped Sales Order Message Additional TCA Events for Account Update MessagePublish Bill To Accounts for a Sales Order Obsoleted Billing Preference Information Enhancements to Account MessageEnhancements to Sales Order Message Obsoleted Billing Preference Events Uptake of JMS Compliant Queues in XML Gateway Implementation Considerations Implementing Telecommunications Billing IntegratorTBI with TSO External Billing Applications Middleware in TBIPage Implementation Tasks Setting up Profile Values Defining XML Gateway Profile Values Setting Up XML GatewayDefining Utlfiledir Parameters Standard Type Enter XML Defining XML StandardsDefining a Hub Defining Hub Users Internal and External Transactions in XML Gateway Defining TransactionsStandard Code Select OAG External Transactions for Account Outbound Account Outbound Internal TransactionInternal Transaction for Sales Order Outbound Internal Transacations for Inventory Item Outbound External Transactions for Sales Order OutboundInternal Transactions for Group Sales Order Outbound External Transactions for Group Sales Order Outbound Internal Transaction for Confirm BOD Inbound External Transactions for Inventory Item OutboundExternal Transactions for Confirm BOD Inbound Transactions Enabled for TBI Transactions Enabled for TBIExternal Transactions for Confirm BOD Inbound Defining Trading Partners Setting Up Oracle Collaboration History Lookup Types Lookup Type Lookup Code Description EnableDefining Collaboration History Profile Values Defining Lookup Values for Collaboration Setting up the Final Collaboration Event Setting Up Collaboration Events Checking Status of Agent Listeners Setting Up Bill Summary UIDefining Bill Summary UI Profile Options Bill Summary UI Profiles Values Providing Access and Enabling the Bill Summary UIProfile Option Value Personalizing Oracle Contact Center for TBI Loading Bill Summary Data Accessing the Bill Summary UI from Oracle Contact CenterIntegration with Order Management Workflow Processes Workflow Process for Publishing Account Information Workflow Process for Publishing Sales Order Information Defining Sales Order Line Profile Option Creating the Workflow Function Setting Up and Running the Item Publish Concurrent Program Name Value Item Batch Export Profile ValuesItem Batch Export Profile Values Seeded Values for Item Batch Export Concurrent Program Submitting the Item Publish Request Subscribing to Account Update Events Event Name Event Display Name Description Supported Events Configuring the Middleware Page Oracle Applications InterConnect Overview Configuring Oracle Applications InterConnect To stop the repository service, use the following command Setting Up OAI Hub Setting up OAI Adapter for Advanced Queues Dropping the Hub Schema Importing OAI Maps to the Repository Page APIs in Telecommunications Billing Integrator Procedure InsertrowbatchBill Summary Bulk Insert APIs Procedure Insertrowbatch Procedure UpdaterowbatchParameter Name /Out Data Type Description Bill Summary Public Record Type Billsummariesrec Procedure UpdaterowbatchSpecifications for Billsummariestable Bill Summary Public Table Type Billsummariestable Attribute Name Data Type Description Mandatory attributes Specifications for BillsummariesrecOptional Attributes Attribute Name Data Type Description Page Maps in XML Gateway Message Maps and DTDs for XML GatewayMaps and DTDs Overview Maps in XML Gateway Root Element DTDs in XML GatewayOpen Applications Group OAG Conforming DTDs DTDs in XML Gateway Loading and Deleting DTDs Loading and Deleting MapsPage XML Message Overview XML Messages in TBI JMS Message Structure Outbound and Inbound BODXML Message Format Outbound Messages JMS Message Structure JMS Message Header Properties for Cbod Fields in the Advanced Queue Message Inbound MessagesField Value XML Messages in TBI D-5 Cntrolarea BSR Structure of the Cbod XML Message Message Specifications for Account Message Specifications for Account InformationSeeded XML Messages 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 Line Topmodelline 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/Item Message Specifications for Product Message Specifications for Group Sales Order Line Message Specifications For Group Sales Order Line Soldtoaccoun 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 XML Payload TransactionWorkflow Function XML Gateway Index-1 Index