Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This action creates a new NRDBMessageType object based on the provided code. The action currently support NRDB Message Types of codes 111Out (GODK), 115OUT (FERD), 125Out (FBES), 127Out (FEND) and 141Out (KABES) as needed by the Export process. This logic should be expanded as necessary.

When creating an NrdbMessageType object of type NRDBMessageType111Out, it will check if the subscription has the SECRET_NUMBER option assigned. If this option is found, the COORDINATE_PORTING column on the NRDB_MESSAGE_TYPE table is set to 2. The SECRET_NUMBER option is found by option key which has a default value of “SECRET_NUMBER“ but can be configured in parameter value NPSYSTEM.SECRET_NUMBER_OPTION_KEY.

full name

properties

execution arguments

result

com.CDRator.billing.np.no.action.CreateNRDBMessageTypeObject

messageType

NpExportFlowNO

NRDBMessageType

...

Parameter

Parameter type

Description

NPSYSTEM.MIN_EXPORT_DATE_FBES

N

Minimum days to receive a BEST

NPSYSTEM.MIN_EXPORT_DATE_FEND

N

Minimum days to receive ENDR

NPSYSTEM.SECRET_NUMBER_OPTION_KEY

S

The option key of the secret number option

Status Types

Code Block
languagesql
--insert status types
INSERT INTO STATUS_TYPES (ID, NAME, DESCRIPTION, CODE)
VALUES (202311090630000001,'NRDB Message Type','Status type for nrdb message types','NRDB_MESSAGE_TYPE');

--insert status
INSERT INTO STATUS (ID, TYPE_ID, ACTIVE, STAT, DESCRIPTION, PARENT_ID)
VALUES (0, 202311090630000001, 1, 'UNHANDLED', 'Unhandled', NULL);

INSERT INTO STATUS (ID, TYPE_ID, ACTIVE, STAT, DESCRIPTION, PARENT_ID)
VALUES (1, 202311090630000001, 1, 'HANDLED', 'Handled', NULL);

INSERT INTO STATUS (ID, TYPE_ID, ACTIVE, STAT, DESCRIPTION, PARENT_ID)
VALUES (2, 202311090630000001, 1, 'ERROR', 'Error', NULL);

INSERT INTO STATUS (ID, TYPE_ID, ACTIVE, STAT, DESCRIPTION, PARENT_ID)
VALUES (3, 202311090630000001, 1, 'REMOVED', 'Removed', NULL);

INSERT INTO STATUS (ID, TYPE_ID, ACTIVE, STAT, DESCRIPTION, PARENT_ID)
VALUES (4, 202311090630000001, 1, 'OUTPORT', 'Outport', NULL);

INSERT INTO STATUS (ID, TYPE_ID, ACTIVE, STAT, DESCRIPTION, PARENT_ID)
VALUES (9, 202311090630000001, 1, 'RETRY_ERROR', 'Retry error', NULL);

...