Contents

Title and Copyright Information

Preface

• Audience
• Downloading Oracle Communications Documentation
• Documentation Accessibility
• Document Revision History

1 Understanding the Synchronization Queue Data Manager

• About Synchronizing Pricing Data
  • About Simple Discount Models
• About the Data Synchronization Process
  • About BRM Event Notification
  • About the Payload Generator EM
  • About the Synchronization Queue DM
  • About the Oracle AQ Database Queue
    • About the Structure of Queued Messages
    • About Event Status Flags
    • About Retrieving Specific Events from the Oracle AQ Database Queue

2 Installing and Configuring the Synchronization Queue DM

• About Installing the Synchronization Queue DM
  • System Requirements
    • Software Requirements
    • Information Requirements
• Installing and Configuring the Synchronization Queue DM
  • Configuring the Database for Advanced Queuing
  • Installing the Synchronization Queue DM
  • Linking Oracle Databases
  • Configuring the EAI Payload for the Synchronization Queue DM
    • Checking for Conflicts in EAI payload Configuration Files
    • Specifying the Default Payload Configuration File
    • Specifying the Synchronization Queue DM Database Number
    • Revising the Payload Configuration File when Uninstalling the Synchronization Queue DM
  • Configuring Event Notification for the Synchronization Queue DM
  • Configuring the Synchronization Queue DM
    • Configuring the CM for Synchronization Queuing
    • Specifying which Business Events to Send to the Database Queue
    • Configuring the Synchronization Queue DM Configuration File
    • Excluding Events Triggered by External Applications
• Starting and Stopping the Synchronization Queue DM
• Monitoring and Maintaining the Synchronization Queues
  • Manually Creating a Database Queue on an Oracle Database
  • Generating Queue Reports
    • Generating Oracle AQ reports
  • Dropping the Queue and Queue Tables
  • Configuring the Queue Location
    • Specifying Default Storage Settings by Using the create_sync_queue.conf File
    • Specifying Storage Settings by Using the pin_portal_sync_oracle Utility
  • Configuring How Often Processed Events are Removed from the Queue
    • Specifying Default Retention Times by Using the create_sync_queue.conf File
    • Specifying Retention Times by Using the pin_portal_sync_oracle Utility
  • Configuring the Synchronization Queue DM Database Connection Attempts
  • Disconnecting and Reconnecting the Synchronization Queue DM to the Queue
• Troubleshooting the Synchronization Queue DM
  • Database Queue Creation Error

3 Exporting Pricing Data in a Batch

• About Exporting Pricing Data to External CRMs
• About pin_export_price
• Setting Up BRM to Export Pricing Data
• Using pin_export_price to Export Pricing Data
  • Exporting All Pricing Data
  • Exporting Pricing Data Based on the Object Type
  • Exporting Pricing Data Based on the Modification Time
  • Exporting Pricing Data Based on the Service Type

4 Synchronization Queue Data Manager Utilities

• pin_export_price
• pin_portal_sync_oracle