2 Creating and Configuring the Oracle CDR Format Cartridge Node

This chapter describes how to create and configure the Oracle Communications Offline Mediation Controller Oracle CDR Format Collection Cartridge (CC) cartridge node to process the call detail record (CDR) data conforming to the Oracle CDR format.

Before reading this chapter, you should be familiar with Offline Mediation Controller cartridge concepts and Node Programming Language (NPL).

Creating an Oracle CDR Format CC Node

To create an Oracle CDR Format CC node:

Log on to Offline Mediation Controller Administration Client.

The Node Hosts & Nodes (logical view) screen appears.
In the Mediation Hosts table, select a host.
In the Nodes on Mediation Host section, click New.

The Create a Node dialog box appears.
Select Cartridge Kit and click Next.
Select Collection Cartridge (CC) and click Next.
Select Oracle CDR Format File Collection Cartridge and click Finish.

The New Node dialog box appears.
In the Name field, enter a name for the node.
From the Rule File list, select the rule file that matches the type of input file processed by the CC node.

To edit the rule file, see "Configuring the NPL Rule File for Oracle CDR Format".
Click the General tab and do the following:
1. From the Debug list, select one of the following:
  
  To log the informational messages in the node log file, select OFF.
  
  To log detailed debug messages in the node log file, select ON.
2. In the Max Log File Size field, enter the maximum size in bytes for the log file. When the log file reaches its limit, the node closes the file and opens a new file. The minimum value is 50000 and the maximum value is 2000000000.
3. To enable node statistics, select the Enable Statistics check box.
4. To enable the node to read or write files in bulk, select the Enable bulk read/write check box.
5. In the NARs Per File field, enter the maximum number of network accounting records (NARs) allowed in an output file. The minimum value is 1 and the maximum value is 10000.
6. In the Idle Write Time field, enter the number of seconds the node waits before moving the NAR output file to the output directory of the processing node, whether or not it has reached its maximum size. The minimum value is 1 and the maximum value is 3600.
Click the File Location tab and do one of the following:
- To collect files using File Transport Protocol (FTP), select Files are pulled (via FTP), and do the following:
  
  In the Local Directory field, enter the path and name of the directory where the CDR input files after collection are stored.
  
  In the Prefix of Files after Collection field, enter the prefix to rename the CDR input file after collection.
  
  In the Suffix of Files after Collection field, enter the suffix to rename the CDR input file after collection. The default is .done.
  
  To delete the CDR files after processing, select the Delete Files After Processing check box.
- To collect files from a directory, select Files are pushed to this node, and do the following:
  
  In the Check for New Files Period field, enter the duration of time that the node waits before checking for new files in the input directory. You also select the time unit: Seconds, Minutes, or Hours.
  
  In the Local Directory field, enter the path and name of the directory that contains the input files to process.
  
  Configure a file pattern: To configure a file pattern for the input files, select Prefix and enter the prefix in the Prefix field and suffix in the Suffix field. The default for Suffix is .complete; to configure a regular expression file pattern, select Reg.Expr and enter a file name pattern. To test the regular expression, click Test.
  
  In the Prefix of Files after Collection field, enter the prefix to rename the CDR input file after collection.
  
  In the Suffix of Files after Collection field, enter the suffix to rename the CDR input file after collection. The default is .done.
  
  To delete the CDR files after processing, select the Delete Files After Processing check box.
If you selected Files are pulled (via FTP), click the FTP Settings tab and do the following:
1. From the FTP Interval list, select the interval in minutes or hours the node waits before checking for incoming data.
2. From the Interrupt Timer Delay list, select the default timeout for the FTP client when opening a socket.
3. To delete the CDR files from the remote location after the files are collected, select the Delete remote files check box.
4. To rename the CDR files in the remote location after the files are collected, select the Rename remote files check box.
5. Click Add.
  
  The FTP Configuration dialog box appears.
6. From the FTP Type list, select one of the following:
  
  If the client initiates the control connection with the server and the server initiates the data connection with the client, select Regular.
  
  If both the data and the commands are transferred in specially formatted packets through a single connection, select Secure (SFTP). When using SFTP, all data sent between the client and the server is encrypted using an encryption cipher.
  
  If the client initiates all connections with the server, select Passive. The server informs the client about the port to be used for the data connection.
7. In the Host field, enter the IP address of the FTP server.
8. In the Username field, enter a valid user name for accessing the FTP server.
9. In the Password field, enter the password for the user name.
10. In the Verify Password field, re-enter the password used in the Password field.
11. In the Directory field, enter the name of the remote directory that contains the input files to process.
12. Configure a file pattern: To configure a file pattern for the input files, select Prefix and enter the prefix in the Prefix field and suffix in the Suffix field; to configure a regular expression file pattern, select Reg.Expr and enter a file name pattern. To test the regular expression, click Test.
13. Click OK.
  
  The FTP configuration is saved and the FTP Configuration dialog box closes.
Click the Advanced tab and do the following:
1. To enable file-level transactions, select the File Level Transaction check box.
2. To enable validating the name of the input file for duplicate file names, select the Reject Files With Duplicate File Name check box.
  
  The Expiry Time to Reject Duplicate Files field is enabled.
3. In the Expiry Time to Reject Duplicate Files field, enter the time in minutes after which the file names are flushed from memory. The minimum value is 1, and the maximum value is 129600. The default is 1.
4. Do one of the following:
  
  To enable validating the order of the sequence number in the input file, select the Sequence Ordering by File Name check box.
  
  To enable multithreading to process multiple files in parallel, select the Multi Threaded check box and enter the number of processing threads you require in the Processing Threads field. The maximum value is 20. If you require the order of the output data across all threads to be processed in the same order as the input data, select the Enable Ordering check box.
Click the Schema File tab and do the following:
1. From the Schema file list, select the schema file that is used to parse the Oracle CDR format data files.
Click the Destination tab and do the following:
1. Select the Enable check box, which enables the connection between the CC node and any destination cartridge node.
2. From the Routing list, select one of the following:
  
  If the Enable check box is not selected, select None.
  
  To enable multicast routing between the CC node and the destination cartridge node, select Multicast.
  
  To enable round-robin routing between the CC node and the destination cartridge node, select Round Robin.
Click Save.

Configuring the NPL Rule File for Oracle CDR Format

To configure the NPL rule file for Oracle CDR format:

Log on to Offline Mediation Controller Administration Client.

The Node Hosts & Nodes (logical view) screen appears.
In the Mediation Hosts table, select the mediation host that contains the Oracle CDR Format CC node.
In the Nodes on Mediation Host section, select the Oracle CDR format CC node that you want to configure, and click Edit.

The Node dialog box appears.
From the Rule File list, select one of the sample NPL rule files.
Click Edit for the selected rule file.

The NPL Editor dialog box appears.

In the configuration block, do the following:

Add the following entry, which defines the Oracle CDR format header record fields written to the NAR output file:
```
AddHeaderFields "headerFieldName1, headerFieldName2,...";
```
where headerFieldNameX is the name of the field in the Oracle CDR format header record.

If you want all the fields in the header record to be part of every NAR written by the Oracle CDR format CC node, specify ALL.

For example:
```
AddHeaderFields "RECORD_TYPE, RECORD_NUMBER";
```
Add the following entry, which defines the Oracle CDR format trailer record fields written to the NAR output file:
```
AddTrailerFields " trailerFieldName1, trailerFieldName2,...";
```
where trailerFieldNameX is the name of the field in the Oracle CDR format trailer record.

For example:
```
AddTrailerFields "RECORD_TYPE";
```

Add the following entry, which defines the order of the records:

RecordOrder "HEADER,DETAIL*,TRAILER";

For the DETAIL* record field, define the associated type of records and sub-records. For example:

RecordOrder "HEADER,DETAIL*,TRAILER";
DETAIL "ASSOCIATED_CHARGE*,ASSOCIATED_ZONE,ASSOCIATED_INFRANET*,ASSOCIATED_GPRS,ASSOCIATED_WAP,ASSOCIATED_GSMW*,ASSOCIATED_CAMEL,ASSOCIATED_MESSAGE,ASSOCIATED_SMS,ASSOCIATED_MMS,ASSOCIATED_SUSPENSE,ASSOCIATED_ROAMING,ASSOCIATED_CIBER";
ASSOCIATED_CHARGE "RUM_MAP*,CHARGE_PACKET*,DISCOUNT_PACKET*,TAX_PACKET*";
DISCOUNT_PACKET "DISCOUNT_SUBBALANCE*";
ASSOCIATED_ZONE "ZONE_PACKET*";
ASSOCIATED_INFRANET "BALANCE_PACKET*,SUB_BAL_IMPACT*,MONITOR_
PACKET*,MONITOR_SUB_BAL_IMPACT*";
SUB_BAL_IMPACT "SUB_BAL*";
MONITOR_SUB_BAL_IMPACT "MONITOR_SUB_BAL*";
ASSOCIATED_GSMW "SS_EVENT_PACKET*";

Compile and save the file.
Close the NPL Editor dialog box.
Click Save.

The configuration is saved.

Configuring a New Oracle CDR Format Schema for the Oracle CDR Format CC Node

The Oracle CDR Format CC node uses the schema information in a schema file to parse the CDR files conforming to the Oracle CDR format into NARs. If the CDR files you process include information that has no corresponding fields in the default schema file, you can configure a custom schema file to accommodate the custom data.

To configure a new Oracle CDR format schema for the Oracle CDR Format CC node:

Log on to Offline Mediation Controller Administration Client.

The Node Hosts & Nodes (logical view) screen appears.
In the Mediation Hosts table, select the mediation host that contains the Oracle CDR Format CC node.
Stop the Oracle CDR Format CC node.
Copy your new schema file into the OMC_Home/config/sol42/schema directory.
In the Offline Mediation Controller Administration Client Mediation Hosts table, select the mediation host that contains the Oracle CDR Format CC node.
In the Nodes on Mediation Host section, select the Oracle CDR Format CC node for which you want to change the schema file, and click Edit.

The Node dialog box appears.
In the Node Configuration section, click the Schema File tab.
From the Schema file list, select the new schema file, which contains the schema information used to parse the Oracle CDR format data files.
Click Save.

The configuration is saved.
Start the Oracle CDR Format CC node.