Sonic Alert B31540-02 manual Configuring the Middleware

Page 47

Sl.

Event Name

Event Display Name

Description

No

 

 

 

 

 

 

 

10

oracle.apps.ar.hz.CustomerProfile.

Customer Profile

Triggered when

 

update

Update

Customer Profile

 

 

 

details are updated.

11

oracle.apps.ar.hz.ContactPoint.up

Contact Points Update

Triggered when

 

date

 

Contact Point details

 

 

 

are updated.

 

 

 

 

Configuring the Middleware

Oracle TBI uses generic XML gateway compatible Advance Queues (AQ) for all outgoing and incoming messages. They are:

1.WF_JMS_IN: This inbound queue is used for all inbound messages that are sent to TBI. Once the billing application receives the message, it sends a Confirmation Business Object Document (CBOD) with appropriate status to the Middleware, which queues it onto the WF_JMS_IN. The Workflow Agent configured on the WF_JMS_IN queue picks up the message and calls the workflow handlers to process the message.

2.WF_JMS_OUT: This is the JMS Outbound queue that processes outbound transactions. The Account XML message generated in JMS Format is published to the JMS Outbound queue (WF_JMS_OUT). The Collaboration history is updated to reflect the account message publish status.

Note: If Oracle Applications Interconnect (OAI 9.0.4) is used as the middleware, refer Appendix A for details on configuring OAI 9.0.4. If a non-OAI middleware is used, refer to the respective documentation for the configuration details.

Implementation Tasks for Oracle Telecommunications Billing Integrator 3-23

Image 47
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 Guides Related to This Product Related Information SourcesIntegration Repository Guides Related to All ProductsXii 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 Obsoleted Billing Preference Information Enhancements to Account MessageEnhancements to Sales Order Message Obsoleted Billing Preference EventsUptake 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 Standard Type Enter XML Defining XML StandardsDefining a Hub Defining Hub UsersStandard 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 Transacations for Inventory Item Outbound External Transactions for Sales Order OutboundInternal Transactions for Group Sales Order Outbound External Transactions for Group Sales Order 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 HistoryLookup Types Lookup Type Lookup Code Description EnableDefining Collaboration History Profile Values Defining Lookup Values for CollaborationSetting 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 ProgramName Value Item Batch Export Profile ValuesItem Batch Export Profile Values Seeded Values for Item Batch Export Concurrent ProgramSubmitting 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 Bill Summary Public Record Type Billsummariesrec Procedure UpdaterowbatchSpecifications for Billsummariestable Bill Summary Public Table Type BillsummariestableOptional Attributes Specifications for BillsummariesrecAttribute Name Data Type Description Mandatory attributes Attribute Name Data Type Description Page Maps in XML Gateway Message Maps and DTDs for XML GatewayMaps and DTDs Overview Maps in XML GatewayRoot Element DTDs in XML GatewayOpen Applications Group OAG Conforming DTDs DTDs in XML GatewayLoading and Deleting DTDs Loading and Deleting MapsPage XML Message Overview XML Messages in TBIJMS Message Structure Outbound and Inbound BODXML Message Format Outbound MessagesJMS 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 XML Payload TransactionWorkflow Function XML GatewayIndex-1 Index