26 Suspense Management Utilities

This chapter provides reference information for Oracle Communications Billing and Revenue Management (BRM) Suspense Management utilities.

load_edr_field_mapping

Use this utility to load EDR field mapping into the /edr_field_mapping object in the BRM database.

Location

BRM_Home/bin

Syntax

load_edr_field_mapping [-d] [-v] [-t] [-h] XML_file
  

Parameters

-d

Creates a log file for debugging purposes. Use this parameter for debugging when the utility appears to have run with no errors but the data has not been loaded into the database.

-v

Displays detailed information as the utility runs.

-t

Validates the XML file. Your EDR field mapping XML file must conform to the XML schema rules in the BRM_Home/xsd/edr_field_mapping.xsd file.

-h

Shows the help on the utility.

XML_file

The name and location of the EDR field mapping configuration file, which maps the EDR field name to an ID number. The default edr_field_mapping.xml file is in BRM_Home/sys/data/config directory.

If you copy the edr_field_mapping.xml file to the same directory from which you run the load_edr_field_mapping utility, you do not have to specify either the path or the file name.

If you run the command in a different directory from where the edr_field_mapping.xml file is located, you must include the entire path for the file.

load_pin_suspense_editable_flds

Use this utility to load editable fields into the /config/suspense_editable_flds object in the BRM database. You define editable fields in the pin_suspense_editable_flds file in BRM_Home/sys/data/config.

For more information, see "Loading Editable Fields into the Database" and "Mapping EDR Fields to Brand Information".

Note:

You cannot load separate /config/suspense_editable_flds objects for each brand. All brands use the same object.

Caution:

The load_pin_suspense_editable_flds utility overwrites existing /config/suspense_editable_flds objects. If you are updating editable fields, you cannot load new editable fields only. You must load complete sets of editable fields each time you run the utility.

Important:

To connect to the BRM database, the load_pin_suspense_editable_flds utility needs a configuration file in the directory from which you run the utility. See "Creating Configuration Files for BRM Utilities" in BRM System Administrator's Guide.

Location

BRM_Home/bin

Syntax

load_pin_suspense_editable_flds [-d] [-v] [pin_suspense_editable_flds_file] 

Parameters

-d

Creates a log file for debugging purposes. Use this parameter for debugging when the utility appears to have run with no errors but the data has not been loaded into the database.

-v

Displays detailed information as the utility runs.

pin_suspense_editable_flds_file

The name and location of the file that defines the list of editable fields used by Suspense Management Center. The default pin_suspense_editable_flds file is in BRM_Home/sys/data/config.

If you copy the pin_suspense_editable_flds file to the same directory from which you run the load_pin_suspense_editable_flds utility, you do not have to specify either the path or the file name.

If you run the command in a different directory from where the pin_suspense_editable_flds file is located, you must include the entire path for the file.

Results

The load_pin_suspense_editable_flds utility notifies you when it successfully creates the /config/suspense_editable_flds object. Otherwise, look in the default.pinlog file for errors. This file is either in the directory from which the utility was started or in a directory specified in the utility configuration file.

To verify that the network elements were loaded, display the /config/suspense_editable_flds object by using Object Browser or the robj command with the testnap utility. See "Reading Objects by Using Object Browser" and "Using testnap" in BRM Developer's Guide.

Important:

You must restart Suspense Management Center to make new editable fields available. See "Starting and Stopping the BRM System" in BRM System Administrator's Guide.

load_pin_suspense_edr_fld_map

Use this utility to load brand-to-brand-ID mapping into the /config/suspense_edr_fld_map object in the BRM database. You define the brand ID mapping in the pin_suspense_edr_fld_map file in BRM_Home/sys/data/config.

For more information, see "Mapping EDR Fields to Brand Information".

Note:

You cannot load separate /config/suspense_edr_fld_map objects for each brand. All brands use the same object.

Caution:

The load_pin_suspense_edr_fld_map utility overwrites existing brand ID mapping. If you are updating brand ID mapping, you cannot load new brand IDs only. You must load complete sets of brand mapping relationships each time you run the utility.

Important:

To connect to the BRM database, the load_pin_suspense_edr_fld_map utility needs a configuration file in the directory from which you run the utility. See "Creating Configuration Files for BRM Utilities" in BRM System Administrator's Guide.

Location

BRM_Home/bin

Syntax

load_pin_suspense_edr_fld_map [-d] [-v] pin_suspense_edr_fld_map_file

Parameters

-d

Creates a log file for debugging purposes. Use this parameter for debugging when the utility appears to have run with no errors but the data has not been loaded into the database.

-v

Displays detailed information as the utility runs.

pin_suspense_edr_fld_map_file

The name and location of the file that defines the brand-to-brand ID mapping. The default pin_suspense_edr_fld_map file is in BRM_Home/sys/data/config.

If you copy the pin_suspense_edr_fld_map file to the same directory from which you run the load_pin_suspense_edr_fld_map utility, you do not have to specify either the path or the file name.

If you run the command in a different directory from where the pin_suspense_edr_fld_map file is located, you must include the entire path for the file.

Results

The load_pin_suspense_edr_fld_map utility notifies you when it successfully creates the /config/edr_field_map object. Otherwise, look in the default.pinlog file for errors. This file is either in the directory from which the utility was started or in a directory specified in the utility configuration file.

To verify that the network elements were loaded, display the /config/edr_field_map object by using Object Browser or the robj command with the testnap utility. See "Reading Objects by Using Object Browser" and "Using testnap" in BRM Developer's Guide.

Important:

You must restart the rating pipeline to make the new brand mapping available. See "Starting and Stopping the BRM System" in BRM System Administrator's Guide.

load_pin_suspense_override_reason

Use this utility to load Pipeline Manager override reasons into the /config/suspense_override_codes object in the BRM database. You define Pipeline Manager override reasons in the pin_suspense_override_reason file in BRM_Home/sys/data/config.

For more information, see "Overriding Pipeline Suspense Handling Rules".

Caution:

The load_pin_suspense_override_reason utility overwrites existing suspense override reasons. You must load complete sets of override reasons each time you run the utility.

Important:

To connect to the BRM database, the load_pin_suspense_override_reason utility needs a configuration file in the directory from which you run the utility. See "Creating Configuration Files for BRM Utilities" in BRM System Administrator's Guide.

Location

BRM_Home/bin

Syntax

load_pin_suspense_override_reason [-d] [-v] pin_suspense_override_reason_file

Parameters

-d

Creates a log file for debugging purposes. Use this parameter for debugging when the utility appears to have run with no errors but the data has not been loaded into the database.

-v

Displays detailed information as the utility runs.

pin_suspense_override_reason_file

The name and location of the file that defines the override reasons. The default pin_suspense_override_reason file is in BRM_Home/sys/data/config.

If you copy the pin_suspense_override_reason file to the same directory from which you run the load_pin_suspense_override_reason utility, you do not have to specify either the path or the file name.

If you run the command in a different directory from where the pin_suspense_override_reason file is located, you must include the entire path for the file.

Results

The load_pin_suspense_override_reason utility notifies you when it successfully creates the /config/suspense_override_codes object. Otherwise, look in the default.pinlog file for errors. This file is either in the directory from which the utility was started or in a directory specified in the utility configuration file.

To verify that the network elements were loaded, display the /config/suspense_override_codes object by using Object Browser or the robj command with the testnap utility. See "Reading Objects by Using Object Browser" and "Using testnap" in BRM Developer's Guide.

Important:

You must restart Suspense Management Center to enable it to use the new suspense override reasons. See "Starting and Stopping the BRM System" in BRM System Administrator's Guide.

load_pin_suspense_params

Use this utility to load system-level configuration information for Suspense Manager into the /config/suspense_params object in the BRM database. You define the system parameters for Suspense Manager, such as the number of records to process in each opcode call, in the pin_suspense_params file in the BRM_Home/sys/data/config directory.

For more information, see "Configuring the Number of Suspended Records to Process in a Transaction" and "Processing Suspended Records in Multiple Steps".

Note:

You cannot load separate /config/suspense_params objects for each brand. All brands use the same object.

Caution:

The load_pin_suspense_params utility overwrites existing Suspense Manager system parameters. You must load complete sets of parameters each time you run the utility.

Important:

To connect to the BRM database, the load_pin_suspense_params utility needs a configuration file in the directory from which you run the utility. See "Creating Configuration Files for BRM Utilities" in BRM System Administrator's Guide.

Location

BRM_Home/bin

Syntax

load_pin_suspense_params [-d] [-v] filename

Parameters

-d

Creates a log file for debugging purposes. Use this parameter for debugging when the utility appears to have run with no errors but the data has not been loaded into the database.

-v

Displays detailed information as the utility runs.

filename

The name of the text file containing the configuration parameters for suspense management. The default file name is pin_suspense_params.

Results

The load_pin_suspense_params utility notifies you when it successfully creates the /config/suspense_params object. Otherwise, look in the default.pinlog file for errors. This file is either in the directory from which the utility was started or in a directory specified in the utility configuration file.

To verify that the data was loaded, display the /config/suspense_params object by using Object Browser or the robj command with the testnap utility. See "Reading Objects by Using Object Browser" and "Using testnap" in BRM Developer's Guide.

load_pin_suspense_reason_code

Use this utility to load suspense reasons and subreasons into the /config/suspense_reason_code object in the BRM database. You define suspense reasons and subreasons in the pin_suspense_reason_code file in BRM_Home/sys/data/config/suspense_reason_code.

For more information, see "Changing the List of Suspense Reasons and Subreasons".

Note:

You cannot load separate /config/suspense_reason_code objects for each brand. All brands use the same object.

Caution:

The load_pin_suspense_reason_code utility overwrites existing suspense reason and subreason codes. If you are updating suspense reason and subreason codes, you cannot load new codes only. You must load complete sets of codes each time you run the utility.

Important:

To connect to the BRM database, the load_pin_suspense_reason_code utility needs a configuration file in the directory from which you run the utility. See "Creating Configuration Files for BRM Utilities" in BRM System Administrator's Guide.

Location

BRM_Home/bin

Syntax

load_pin_suspense_reason_code [-d] [-v] pin_suspense_reason_code_file

Parameters

-d

Creates a log file for debugging purposes. Use this parameter for debugging when the utility appears to have run with no errors but the data has not been loaded into the database.

-v

Displays detailed information as the utility runs.

pin_suspense_reason_code_file

The name and location of the file that defines suspense reasons and subreasons. The default pin_suspense_reason_code file is in BRM_Home/sys/data/config.

If you copy the pin_suspense_reason_code file to the same directory from which you run the load_pin_suspense_reason_code utility, you do not have to specify either the path or the file name.

If you run the command in a different directory from where the pin_suspense_reason_code file is located, you must include the entire path for the file.

Results

The load_pin_suspense_reason_code utility notifies you when it successfully creates the /config/suspense_reason_code object. Otherwise, look in the default.pinlog file for errors. This file is either in the directory from which the utility was started or in a directory specified in the utility configuration file.

To verify that the network elements were loaded, display the /config/suspense_reason_code object by using Object Browser or the robj command with the testnap utility. See "Reading Objects by Using Object Browser" and "Using testnap" in BRM Developer's Guide.

Important:

You must restart Pipeline Manager to make the new suspense reason codes available. See "Starting and Stopping the BRM System" in BRM System Administrator's Guide.

Important:

If you are changing the suspense reason or subreason codes, you must also modify the suspense_reason_code.en_US file and run the load_localized_strings utility. See "Configuring Suspense Manager".

load_pin_batch_suspense_override_reason

Use the load_pin_batch_suspense_override_reason utility to load batch suspense override-able reason codes into the /config/batch_suspense_override_reason object in the BRM database. You define batch suspense override reason codes in the pin_batch_suspense_override_reason file in BRM_Home/sys/data/config. By default, no reason can be overridden, so the file is a placeholder.

Note:

You cannot load separate /config/batch_suspense_override_reason objects for each brand. All brands use the same object.

Caution:

The load_pin_batch_suspense_override_reason utility overwrites the existing /config/batch_suspense_override_reason object in the BRM database. If you are updating the /config/batch_suspense_override_reason object, you must load complete sets of batch suspense override-able reasons each time.

Important:

To connect to the BRM database, the utility needs the Connection Manager (CM) to be up and running.

Location

BRM_Home/bin

Syntax

load_pin_batch_suspense_override_reason [-d] [-v] pin_batch_suspense_override_reason_file

Parameters

-d

Creates a log file for debugging purposes. Use this parameter for debugging when the utility appears to have run with no errors but the data has not been loaded into the database.

-v

Displays information about successful or failed processing as the utility runs.

Note:

This parameter is always used in conjunction with other parameters and commands. It is not position dependent. For example, you can enter -v at the beginning or end of a command to initiate the verbose parameter. To redirect the output to a log file, use the following syntax with the verbose parameter. Replace filename.log with the name of the log file:

load_pin_batch_suspense_override_reason any_other_parameter -v > filename.log

pin_batch_suspense_override_reason_file

The name and location of the file that defines batch suspense override-able reason codes. The default pin_batch_suspense_override_reason file is in BRM_Home/sys/data/config.

If you do not run the utility from the directory in which the file is located, you must include the complete path to the file.

Tip:

If you copy the pin_batch_suspense_override_reason file to the directory from which you run the load_pin_batch_suspense_override_reason utility, you don't have to specify the path or file name. The file must be named pin_batch_suspense_override_reason.

Results

If the utility does not notify you that it was successful, look in the default.pinlog file to find any errors. This file is either in the directory from which the utility was started or in a directory specified in the utility configuration file.

To verify that the override reason codes were loaded, display the /config/batch_suspense_override_reason object by using Object Browser or the robj command with the testnap utility. See "Reading Objects by Using Object Browser" and "Using testnap" in BRM Developer's Guide.

The following is an example of a pin_batch_suspense_override_reason file, which would be an input for this utility and could be compared to the output:

# Override Suspense Reason000010000200003

load_pin_batch_suspense_reason_code

Use the load_pin_batch_suspense_reason_code utility to load batch suspense reason codes into the /config/batch_suspense_reason_code object in the BRM database. You define batch suspense reasons in the pin_batch_suspense_reason_code file in BRM_Home/sys/data/config. BRM uses suspense reason codes to load suspense reasons into a batch suspense record when a call details record (CDR) file is suspended.

Note:

You cannot load separate /config/batch_suspense_reason_code objects for each brand. All brands use the same object.

Caution:

The load_pin_batch_suspense_reason_code utility overwrites the existing /config/batch_suspense_reason_code object in the BRM database. If you are updating load batch suspense reason codes, you cannot load new batch suspense reason codes only. Therefore, you must load a complete set of load batch suspense reason codes each time you run the utility.

Important:

The load_pin_batch_suspense_reason_code utility must be connected to a running CM to load batch suspense reason codes into the Infranet database.

Location

BRM_Home/bin

Syntax

load_pin_batch_suspense_reason_code [-d] [-v] pin_batch_suspense_reason_code_file

Parameters

-d

Creates a log file for debugging purposes. Use this parameter for debugging when the utility appears to have run with no errors but the data has not been loaded into the database.

-v

Displays information about successful or failed processing as the utility runs.

Note:

This parameter is always used in conjunction with other parameters and commands. It is not position dependent. For example, you can enter -v at the beginning or end of a command to initiate the verbose parameter. To redirect the output to a log file, use the following syntax with the verbose parameter. Replace filename.log with the name of the log file:

load_pin_batch_suspense_reason_code any_other_parameter -v > filename.log

pin_batch_suspense_reason_code_file

The name and location of the file that defines the batch suspense reason codes. The default pin_batch_suspense_reason_code file is in BRM_Home/sys/data/config.

If you do not run the utility from the directory in which the file is located, you must include the complete path to the file.

Tip:

If you copy the pin_batch_suspense_reason_code file to the directory from which you run the load_pin_batch_suspense_reason_code utility, you do not have to specify the path or file name. The file must be named pin_batch_suspense_reason_code.

Results

The load_pin_batch_suspense_reason_code utility notifies you when it successfully creates the /config/batch_suspense_reason_code object. Otherwise, look in the default.pinlog file for errors. This file is either in the directory from which the utility was started or in a directory specified in the utility configuration file.

To verify that the elements were loaded, display the /config/batch_suspense_reason_code object by using Object Browser or the robj command with the testnap utility. See "Reading Objects by Using Object Browser" and "Using testnap" in BRM Developer's Guide.

The following example shows sample entries from the /config/batch_suspense_reason_code object:

PIN_FLD_POID                      POID [0] 0.0.0.1 /config/batch_suspense_reason_code 93712 00 PIN_FLD_CREATED_T               TSTAMP [0] (1153474255) 21/07/2006 15:00:55:000 PM0 PIN_FLD_MOD_T                   TSTAMP [0] (1153474255) 21/07/2006 15:00:55:000 PM0 PIN_FLD_READ_ACCESS                STR [0] "G"0 PIN_FLD_WRITE_ACCESS               STR [0] "S"0 PIN_FLD_ACCOUNT_OBJ               POID [0] 0.0.0.1 /account 1 00 PIN_FLD_DESCR                      STR [0] ""0 PIN_FLD_HOSTNAME                   STR [0] "-"0 PIN_FLD_NAME                       STR [0] "batch_suspense_reason_code"0 PIN_FLD_OP_CORRELATION_ID          STR [0] "2:CT1255:UnknownProgramName:0:AWT-EventQueue-0:3:1153836497:0:root.0.0.0.1::user1:123456789"0 PIN_FLD_PROGRAM_NAME               STR [0] "load_pin_batch_suspense_reason_code"0 PIN_FLD_VALUE                      STR [0] ""0 PIN_FLD_VERSION                    STR [0] "1"0 PIN_FLD_SUSPENSE_REASONS         ARRAY [0] allocated 1, used 11     PIN_FLD_SUSPENSE_REASON       ENUM [0] 00 PIN_FLD_SUSPENSE_REASONS         ARRAY [471] allocated 1, used 11     PIN_FLD_SUSPENSE_REASON       ENUM [0] 10 PIN_FLD_SUSPENSE_REASONS         ARRAY [119] allocated 1, used 11     PIN_FLD_SUSPENSE_REASON       ENUM [0] 20 PIN_FLD_SUSPENSE_REASONS         ARRAY [120] allocated 1, used 11     PIN_FLD_SUSPENSE_REASON       ENUM [0] 20 PIN_FLD_SUSPENSE_REASONS         ARRAY [126] allocated 1, used 11     PIN_FLD_SUSPENSE_REASON       ENUM [0] 20 PIN_FLD_SUSPENSE_REASONS         ARRAY [127] allocated 1, used 1|1     PIN_FLD_SUSPENSE_REASON       ENUM [0] 20 PIN_FLD_SUSPENSE_REASONS         ARRAY [147] allocated 1, used 11     PIN_FLD_SUSPENSE_REASON       ENUM [0] 20 PIN_FLD_SUSPENSE_REASONS         ARRAY [148] allocated 1, used 11     PIN_FLD_SUSPENSE_REASON       ENUM [0] 2