52 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.
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.
Note:
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.
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.
Note:
You must restart Suspense Management Center to make new editable fields available.
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.
Note:
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.
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.
Note:
You must restart Suspense Management Center to enable it to use the new suspense override reasons.
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".
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.
Note:
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.
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.
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".
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.
Note:
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.
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.
Note:
You must restart Pipeline Manager to make the new suspense reason codes available.
Note:
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 "Installing and 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.
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.
Note:
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.
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.
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.
Note:
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.
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 0
0 PIN_FLD_CREATED_T TSTAMP [0] (1153474255) 21/07/2006 15:00:55:000 PM
0 PIN_FLD_MOD_T TSTAMP [0] (1153474255) 21/07/2006 15:00:55:000 PM
0 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 0
0 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 1
1 PIN_FLD_SUSPENSE_REASON ENUM [0] 0
0 PIN_FLD_SUSPENSE_REASONS ARRAY [471] allocated 1, used 1
1 PIN_FLD_SUSPENSE_REASON ENUM [0] 1
0 PIN_FLD_SUSPENSE_REASONS ARRAY [119] allocated 1, used 1
1 PIN_FLD_SUSPENSE_REASON ENUM [0] 2
0 PIN_FLD_SUSPENSE_REASONS ARRAY [120] allocated 1, used 1
1 PIN_FLD_SUSPENSE_REASON ENUM [0] 2
0 PIN_FLD_SUSPENSE_REASONS ARRAY [126] allocated 1, used 1
1 PIN_FLD_SUSPENSE_REASON ENUM [0] 2
0 PIN_FLD_SUSPENSE_REASONS ARRAY [127] allocated 1, used 1|
1 PIN_FLD_SUSPENSE_REASON ENUM [0] 2
0 PIN_FLD_SUSPENSE_REASONS ARRAY [147] allocated 1, used 1
1 PIN_FLD_SUSPENSE_REASON ENUM [0] 2
0 PIN_FLD_SUSPENSE_REASONS ARRAY [148] allocated 1, used 1
1 PIN_FLD_SUSPENSE_REASON ENUM [0] 2