Exporting Pricing Data in a Batch

47 Exporting Pricing Data in a Batch

You can export pricing data in a batch from the Oracle Communications Billing and Revenue Management (BRM) database to your external customer relationship management (CRM) applications.

Topics in this document:

About Exporting Pricing Data in Batches

You can export pricing data (charge offers, discount offers, chargeshare offers, bundles, packages, and package lists) from the BRM database to external CRM applications in a batch. You might do this to:

Start a CRM integration by sending your existing pricing data to the external CRM.
Supplement real-time synchronization of pricing data with the external CRM.

You export pricing data in a batch using the "pin_export_price" utility. This utility retrieves data from the BRM database and uses the Oracle DM to publish data to an Oracle Advanced Queuing (AQ) database queue. The external CRM can then retrieve the data from the AQ database queue using processes implemented using Oracle Fusion Middleware and Oracle Application Integration Architecture. See "Using BRM with Oracle Application Integration Architecture" in BRM Developer's Guide.

About pin_export_price

The pin_export_price utility is a standalone multithreaded application (MTA) that synchronizes pricing data between BRM and an external CRM in a batch. The utility performs the following operations:

Searches for /product, /discount, /sponsorship, /deal, /plan, and /group/plan_list objects meeting the criteria set in the utility's parameters.
Retrieves the data for those objects.
Generates the following notification events, which detail the pricing objects being exported:
- /event/notification/price/discounts/modify
- /event/notification/price/products/modify
- /event/notification/price/sponsorships/modify

Then, the EAI Manager framework and Oracle Data Manager (DM) work together to publish business events to an Oracle AQ database queue.

You configure pin_export_price to export pricing data in batches by editing the BRM_home/apps/pin_export_price/pin.conf file. This configuration file has the standard Connection Manager (CM) and MTA entries. See the following for more information:

"About Configuration Files" in BRM System Administrator's Guide
"Configuring Your Multithreaded Application" in BRM Developer's Guide

Using pin_export_price to Export Pricing Data

You can use the pin_export_price utility to export the following data in batches:

All pricing data. See "Exporting All Pricing Data".
Pricing data based on the object type. See "Exporting Pricing Data Based on the Object Type".
Pricing data based on the modification time. See "Exporting Pricing Data Based on the Modification Time".
Pricing data based on the service type. See "Exporting Pricing Data Based on the Service Type".

For a list of the utility's parameters and syntax, see "pin_export_price".

Exporting All Pricing Data

To export all pricing data from the BRM database as a batch, go to the BRM_home/apps/pin_export_price directory and enter the following command:

pin_export_price

Exporting Pricing Data Based on the Object Type

To export pricing data based on the object type, go to the BRM_home/apps/pin_export_price directory and enter one of these commands:

To export only charge offers (/product objects):
```
pin_export_price -product
```
To export only discount offers (/discount objects):
```
pin_export_price -discount
```
To export only chargeshares (/sponsorship objects):
```
pin_export_price -sponsorship
```
To export only bundles (/deal objects):
```
pin_export_price -deal
```
To export only packages (/plan objects):
```
pin_export_price -plan
```
To export only package lists (/group/plan_list objects):
```
pin_export_price -planlist
```

Exporting Pricing Data Based on the Modification Time

To export all or a subset of the pricing data based on the modification time, go to the BRM_home/apps/pin_export_price directory and enter the following command:

pin_export_price [-product | -discount] -t modifiedTimestamp

where modifiedTimestamp specifies to retrieve only pricing data that was modified on or after the specified timestamp. Specify the timestamp in the YYYY-MM-DDThh:mm:ssTZ format. Replace TZ with the time zone. If you do not specify the time zone, the utility defaults to the server's local time zone.

Note:

You must specify the time zone if your server and database are in different time zones.

For example, the following command exports all charge offers that were modified on or after noon on April 15, 2030, in the UTC-9 time zone:

pin_export_price -product -t 2030-04-15T12:00:00+09:00

Exporting Pricing Data Based on the Service Type

To export /product or /discount objects based on the service type, go to the BRM_home/apps/pin_export_price directory and enter the following command:

pin_export_price [-product | -discount] -S ServiceType1 [, ServiceType2 ...]

where ServiceTypeN specifies the service's storable class name, such as /service/telco/gsm/data. You can specify multiple service types by using a comma (,) as a delimiter.

Note:

The utility does not validate the name of the service type passed in with the -S parameter. If an invalid service type name is passed, the application does not return anything or report an error.

For example, the following command exports all charge offers that are associated with the /service/telco/gsm/telephony and /service/telco/gsm/data service types:

pin_export_price -product -S /service/telco/gsm/telephony, /service/telco/gsm/data