Sonic Alert B31540-02 manual Dropping the Hub Schema

Page 52

aq_bridge_username: The username to connect to the Spoke DB.

encrypted_aq_bridge_password: The encrypted password of the aq_bridge_username. To encrypt a password, use the OAI_HOME/oai/9.0.4/bin/encrypt utility from the console. This utility generates cipher text and prints it on the console, which can be copied to the adapter.ini file.

aq_bridge_owner: The name of the schema to which the AQs in the spoke database belongs. This value should be set to a valid schema name before the adapter is started.

4.Optionally, you can configure the following parameters to improve the performance of the adapter:

agent_pipeline_to_hub = false

agent_pipeline_from_hub = false

agent_log_level = 0

5.Copy the DTDs from APPL_TOP at the following location: $XNB_TOP/xml/oag72, and place them in the home folder of the adapter on the host file system, i.e. <OAI_HOME>/oai/9.0.4/adapters/<ADAPTER_NAME>. The AQ Adapter requires the DTDs of the XML messages that it reads and writes into the AQs.

6.To start an adapter service, run the following script from the console:

<OAI_HOME>/oai/9.0.4/adapters/<ADAPTER_NAME>/start

7.To stop an adapter service, run the following script from the console:

<OAI_HOME>/oai/9.0.4/adapters/<ADAPTER_NAME>/stop

Note: The following file contains the log of adapter activities:

<OAI_HOME>/oai/9.0.4/adapters/<ADAPTER_NAME>/logs/<latest_ti mestamp>/oailog.txt

Dropping the Hub Schema

To drop the hub schema, you must stop the adapters and the repository service. The steps are:

1.Run the following script from the console to stop the adapters:

<OAI_HOME>/oai/9.0.4/adapters/<ADAPTER_NAME>/stop

A-4Oracle Telecommunications Billing Integrator Implementation Guide

Image 52
Contents Oracle Telecommunications Billing Integrator Part No. B31540-02Government 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 Related Information Sources Integration RepositoryGuides Related to All Products Guides Related to This ProductInstallation and System Administration XiiOther Implementation Documentation XiiiXiv Introduction to Telecommunications Billing Integrator Telecommunications Billing Integrator OverviewTelecommunications Billing Integrator Features Publishing Information to the Billing Applications Publishing Account Update DetailsPublishing New Account Details Publishing Item/Product Details Publishing Sales Order DetailsEnhancements 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 Enhancements to Account Message Enhancements to Sales Order MessageObsoleted Billing Preference Events Obsoleted Billing Preference InformationUptake of JMS Compliant Queues in XML Gateway Implementation Considerations Implementing Telecommunications Billing IntegratorTBI with TSO Middleware in TBI External Billing ApplicationsPage Setting up Profile Values Implementation TasksDefining XML Gateway Profile Values Setting Up XML GatewayDefining Utlfiledir Parameters Defining XML Standards Defining a HubDefining Hub Users Standard Type Enter XMLInternal 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 External Transactions for Sales Order Outbound Internal Transactions for Group Sales Order OutboundExternal Transactions for Group Sales Order Outbound Internal Transacations for Inventory Item OutboundInternal 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 Setting Up Oracle Collaboration History Defining Trading PartnersLookup Type Lookup Code Description Enable Defining Collaboration History Profile ValuesDefining Lookup Values for Collaboration Lookup TypesSetting Up Collaboration Events Setting up the Final Collaboration EventChecking 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 Defining Sales Order Line Profile Option Workflow Process for Publishing Sales Order InformationSetting Up and Running the Item Publish Concurrent Program Creating the Workflow FunctionItem Batch Export Profile Values Item Batch Export Profile ValuesSeeded Values for Item Batch Export Concurrent Program Name ValueSubscribing to Account Update Events Submitting the Item Publish RequestSupported Events Event Name Event Display Name DescriptionConfiguring the Middleware Page Configuring Oracle Applications InterConnect Oracle Applications InterConnect OverviewSetting Up OAI Hub To stop the repository service, use the following commandSetting 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 Procedure Updaterowbatch Specifications for BillsummariestableBill Summary Public Table Type Billsummariestable Bill Summary Public Record Type BillsummariesrecAttribute Name Data Type Description Mandatory attributes Specifications for BillsummariesrecOptional Attributes Attribute Name Data Type Description Page Message Maps and DTDs for XML Gateway Maps and DTDs OverviewMaps in XML Gateway Maps in XML GatewayDTDs in XML Gateway Open Applications Group OAG Conforming DTDsDTDs in XML Gateway Root ElementLoading and Deleting Maps Loading and Deleting DTDsPage XML Messages in TBI XML Message OverviewOutbound and Inbound BOD XML Message FormatOutbound Messages JMS Message StructureJMS Message Header Properties for Cbod JMS Message StructureFields in the Advanced Queue Message Inbound MessagesField Value XML Messages in TBI D-5 Structure of the Cbod XML Message Cntrolarea BSRMessage 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 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 Message Specifications for Product/Item Following table lists the specifications for productMessage 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 Transaction Workflow FunctionXML Gateway XML PayloadIndex Index-1