Concat Function

The CONCAT function in Oracle Revenue Management and Billing (ORMB) is used to concatenate multiple TRANSFORMATION FIELD values or LITERAL values. Literal values must be enclosed in single quotes (' '). The function allows concatenation across different sections of DATA TRANSFORMATION, including:

• HEADER

• FOOTER

• FIELD TRANSFORMATION

Function Syntax:

CONCAT(FLD_NAME1||FLD_NAME2||'LITERAL_VALUE')

Delimiter:

The double pipe (||) is the delimiter used to separate multiple input values within the CONCAT function.

Parameters:

• FLD_​NAME1, FLD_​NAME2 – Any FIELD names from the DATA TRANSFORMATION section.

• 'LITERAL_​VALUE' – A fixed string enclosed in single quotes.

Return Value:

The CONCAT function returns a string representing the concatenated value of the input fields or literals.

Example:

If the transformation field TXNDTTM has the value '2020-04-30', the following function:

CONCAT(TXNDTTM || '-00.00.00')  

Returns:

'2020-04-30-00.00.00'

Field Transformation Configuration

The following configuration example demonstrates the usage of the CONCAT function in ORMB’s Field Transformation section:

Field Transformation - TXNDTTM

The image illustrates the Field Transformation configuration in ORMB, where the TXNDTTM field is mapped to C1-TranDtlStageUpload/0/tranDtl/txnDttm. The Default Value column demonstrates an example usage of the CONCAT function, concatenating TXNDTTM with '-00.00.00' to standardize the date-time format.