This chapter provides reference information for the Oracle Communications Offline Mediation Controller suspense handling.
Table 6-1 lists the event and batch CDR fields that are used for Offline Mediation Controller suspense handling.
| Field Name | Data Type | Suspense Type | Description |
|---|---|---|---|
|
DETAIL:ASS_SUSPENSE_EXT:ACCOUNT_POID |
String |
event |
The field is provided by the calling cartridge or the Oracle Communications Billing and Revenue Management (BRM) default root poid 0.0.0.1 /account 1 0. |
|
DETAIL:ASS_SUSPENSE_EXT:ERROR_CODE |
Long |
both |
The error code. This is a required field and is provided by the calling cartridge. |
|
DETAIL:ASS_SUSPENSE_EXT:ERROR_FILENAME |
String |
batch |
(Optional) The field is provided by the calling cartridge. |
|
DETAIL:ASS_SUSPENSE_EXT:ERROR_PATH |
String |
batch |
The field is provided by the calling cartridge. |
|
DETAIL:ASS_SUSPENSE_EXT:OVERRIDE_REASONS |
String |
both |
(Optional) The field is provided by the calling cartridge. |
|
DETAIL:ASS_SUSPENSE_EXT:PIPELINE_CATEGORY |
String |
both |
(Optional) Identifies that the cartridge is a member of a group of cartridges. If the Suspense DC cannot find the category name, the name entered in the Default Category field of the Mode configuration tab, is used. The field is provided by the calling cartridge. |
|
DETAIL:ASS_SUSPENSE_EXT:PIPELINE_NAME |
String |
both |
The name of the cartridge that suspended the CDR. If the Suspense DC node cannot find the cartridge name, the name entered in the Default Source Node field of the Mode configuration tab is used. The field is provided by the calling cartridge. |
|
DETAIL:ASS_SUSPENSE_EXT:RECYCLE_KEY |
String |
event |
(Optional) The field is provided by the calling cartridge. |
|
DETAIL:ASS_SUSPENSE_EXT:RECYCLE_MODE |
Integer |
event |
System generated based on the recycling mode selected by the user. |
|
DETAIL:ASS_SUSPENSE_EXT:SERVICE_CODE |
String |
event |
(Optional) The field is provided by the calling cartridge. |
|
DETAIL:ASS_SUSPENSE_EXT:SOURCE_FILENAME |
String |
both |
This is a required field for batch CDRs. This field is part of the batch key, which queries the SUSPENDED_BATCH_T table for information on the batch CDR file. This is an optional field for event CDRs. |
|
DETAIL:ASS_SUSPENSE_EXT:SUSPENDED_FROM_BATCH_ID |
String |
event |
(Optional) The field is provided by the calling cartridge |
|
DETAIL:ASS_SUSPENSE_EXT:SUSPENSE_ID |
Long |
both |
It is used by Suspended Event (SE) Loader for updating suspended usage records. This is a required field. |
|
DETAIL:ASS_SUSPENSE_EXT:SUSPENSE_REASON |
Long |
both |
Mapped from the error code. |
|
DETAIL:ASS_SUSPENSE_EXT:SUSPENSE_SUBREASON |
Long |
event |
Mapped from the error code. |
|
DETAIL:ASS_SUSPENSE_EXT.:SUSPENSE_STATUS |
Integer |
both |
Indicates whether the CDR is suspended, recycled or successful (Succeeded). This is a required field and is system generated. |
|
DETAIL:ORIGINAL_BATCH_ID |
String |
event |
(Optional) The field is provided by the calling cartridge. |
|
HEADER:BATCH_ID |
String |
batch |
The field is provided by the calling cartridge. |
|
HEADER:TAP_PROCESSING_INFO |
String |
batch |
The field is provided by the calling cartridge. |
|
HEADER:SENDER |
String |
batch |
Name of the service provider. The field is provided by the calling cartridge. |
|
HEADER:SEQUENCE_NUMBER |
String |
batch |
The field is provided by the calling cartridge. |
For suspended event CDRs, the Suspense Distribution Cartridge (DC) node generates Create or Update files in a format that is understood by Suspended Event (SE) Loader, which is a component of BRM.
Table 6-2 lists the Create event output fields.
Table 6-2 Create Event Output Fields
| Field | Value |
|---|---|
|
RECORD_TYPE |
"010" |
|
RECORD_NUMBER |
"1" |
|
SENDER |
"" |
|
RECIPIENT |
"" |
|
SEQUENCE_NUMBER |
"1" |
|
ORIGIN_SEQUENCE_NUMBER |
"1" |
|
CREATION_TIMESTAMP |
UNIX EPOC time in seconds. |
|
TRANSMISSION_DATE |
UNIX EPOC time in seconds. |
|
TRANSFER_CUTOFF_TIMESTAMP |
UNIX EPOC time in seconds. |
|
UTC_TIME_OFFSET |
"" |
|
SPECIFICATION_VERSION_NUMBER |
"0" |
|
RELEASE_VERSION |
"0" |
|
ORIGIN_COUNTRY_CODE |
"" |
|
SENDER_COUNTRY_CODE |
"" |
|
DATA_TYPE_INDICATOR |
"" |
|
IAC_LIST |
"" |
|
CC_LIST |
"" |
|
CREATION_PROCESS |
"SUSPENSE_CREATE" |
|
SCHEMA_VERSION |
"10000" |
|
EVENT_TYPE |
"/suspended_usage" The value entered in the Create Event Type field in the Mode configuration tab of the Suspense DC node. For more information, see "Configuring the Create File Output Settings for the Suspense DC Node". |
|
QUERYABLE_FIELDS_MAPPING |
List of editable table names and corresponding column names and types. For more information, see "Configuring the NPL Rule File for the Suspense DC Node". |
|
RECORD_TYPE |
"020" |
|
SUSPENSE_REASON |
Mapped from the error code. |
|
SUSPENSE_SUBREASON |
Mapped from the error code. |
|
RECYCLE_KEY |
DETAIL:ASS_SUSPENSE_EXT:RECYCLE_KEY |
|
ERROR_CODE |
DETAIL:ASS_SUSPENSE_EXT:ERROR_CODE If the value is not found, the value is set to "0". |
|
PIPELINE_NAME |
DETAIL:ASS_SUSPENSE_EXT:PIPELINE_NAME |
|
SOURCE_FILENAME |
DETAIL:ASS_SUSPENSE_EXT:SOURCE_FILENAME |
|
SERVICE_CODE |
DETAIL:ASS_SUSPENSE_EXT:SERVICE_CODE |
|
EDR_RECORD_TYPE |
"20" |
|
EDR_SIZE |
Calculated. The size of the serialized CDR. |
|
ACCOUNT_POID |
DETAIL:ASS_SUSPENSE_EXT:ACCOUNT_POID If the value is not found, the value is set to "1 /account 1 0". |
|
BATCH_ID |
DETAIL:ASS_SUSPENSE_EXT:ORIGINAL_BATCH_ID |
|
SUSPENDED_FROM_BATCH_ID |
DETAIL:ASS_SUSPENSE_EXT:SUSPENDED_FROM_BATCH_ID |
|
UTC_OFFSET_SECONDS |
Calculated. |
|
PIPELINE_CATEGORY |
DETAIL:ASS_SUSPENSE_EXT:PIPELINE_CATEGORY |
|
RECORD_TYPE |
"030" |
|
EDR_BUF |
Contains the serialized CDR in XML format. |
|
RECORD_TYPE |
"040" |
|
QUERYABLE_FIELDS |
List of tab delimited CDR field values corresponding to each column listed in the QUERYABLE_FIELDS_MAPPING field. For more information, see "About Queryable Fields". |
Table 6-3 lists the Update event output field values.
Table 6-3 Update Event Output Fields
| Field | Value |
|---|---|
|
RECORD_TYPE |
"010" |
|
RECORD_NUMBER |
"1" |
|
SENDER |
"" |
|
RECIPIENT |
"" |
|
SEQUENCE_NUMBER |
"1" |
|
ORIGIN_SEQUENCE_NUMBER |
"1" |
|
CREATION_TIMESTAMP |
UNIX EPOC time in seconds. |
|
TRANSMISSION_DATE |
UNIX EPOC time in seconds. |
|
TRANSFER_CUTOFF_TIMESTAMP |
UNIX EPOC time in seconds. |
|
UTC_TIME_OFFSET |
"" |
|
SPECIFICATION_VERSION_NUMBER |
"0" |
|
RELEASE_VERSION |
"0" |
|
ORIGIN_COUNTRY_CODE |
"" |
|
SENDER_COUNTRY_CODE |
"" |
|
DATA_TYPE_INDICATOR |
"" |
|
IAC_LIST |
"" |
|
CC_LIST |
"" |
|
CREATION_PROCESS |
SUSPENSE_UPDATE |
|
SCHEMA_VERSION |
"10000" |
|
EVENT_TYPE |
"/tmp_suspended_usage" The value entered in the Update Event Type field in the Mode configuration tab of the Suspense DC node. For more information, see "Configuring the Update File Output Settings for the Suspense DC Node". |
|
RECORD_TYPE |
"020" |
|
SUSPENSE_ID |
DETAIL:ASS_SUSPENSE_EXT:SUSPENSE_ID |
|
STATUS |
If the error code is 0 or not found, the status is set to "2" (Succeeded). If the error code is not 0 or is found, the status is set to "0" (Suspended). |
|
SUSPENSE_REASON |
Mapped from the error code. |
|
SUSPENSE_SUBREASON |
Mapped from the error code. |
|
ERROR_CODE |
DETAIL:ASS_SUSPENSE_EXT:ERROR_CODE If the value is not found, the value is set to "0". |
|
RECYCLE_MODE |
DETAIL:ASS_SUSPENSE_EXT:RECYCLE_MODE |
|
RECYCLE_KEY |
DETAIL:ASS_SUSPENSE_EXT:RECYCLE_KEY |
For suspended batch CDRs, the Suspense DC node generates Create or Update files in a format that is understood by Suspended Batch (SB) Loader, which is a component of BRM.
Table 6-4 lists the Create batch output fields.
Table 6-4 Create Batch Output Fields
| Field | Value |
|---|---|
|
RECORD_TYPE |
"010" |
|
STORABLE_CLASS |
The value entered in the Storable Class field in the Mode configuration tab of the Suspense DC node. |
|
RECORD_TYPE |
"020" |
|
SENDER |
HEADER:SENDER |
|
BATCH_ID |
HEADER:BATCH_ID |
|
SEQUENCE_NUMBER |
HEADER:SEQUENCE_NUMBER |
|
BATCH_NAME |
DETAIL:ASS_SUSPENSE_EXT:SOURCE_FILENAME |
|
ERROR_DIRECTORY |
DETAIL:ASS_SUSPENSE_EXT:ERROR_PATH |
|
ERROR_FILENAME |
DETAIL:ASS_SUSPENSE_EXT:ERROR_FILENAME |
|
PIPELINE_NAME |
DETAIL:ASS_SUSPENSE_EXT:PIPELINE_NAME |
|
PIPELINE_CATEGORY |
DETAIL:ASS_SUSPENSE_EXT:PIPELINE_CATEGORY |
|
ERROR_CODE |
DETAIL:ASS_SUSPENSE_EXT:ERROR_CODE If the value is not found, the value is set to "0". |
|
SUSPENSE_REASON |
Mapped from the error code. |
|
SUSPENSE_T |
Calculated. UTC in seconds. |
|
TAP_INFO |
HEADER:TAP_PROCESSING_INFO |
Table 6-5 lists the Update batch output fields.
Table 6-5 Update Batch Output Fields
| Field | Value |
|---|---|
|
RECORD_TYPE |
"010" |
|
STORABLE_CLASS |
The value entered in the Storable Class field in the Mode configuration tab of the Suspense DC node. |
|
RECORD_TYPE |
"030" |
|
BATCH_NAME |
DETAIL:ASS_SUSPENSE_EXT:SOURCE_FILENAME |
|
PIPELINE_NAME |
DETAIL:ASS_SUSPENSE_EXT:PIPELINE_NAME |
|
ERROR_CODE |
DETAIL:ASS_SUSPENSE_EXT:ERROR_CODE If the value is not found, the value is set to "0". |
|
SUSPENSE_STATUS |
If the error code is 0 or not found, the status is set to "2" (Succeeded). If the error code is not 0 or is found, the status is set to "0" (Suspended). |
|
SUSPENSE_REASON |
Mapped from the error code. |