Extraction Templates

Oracle Revenue Management and Billing enables you to create the extraction templates using which you can extract the data from the required fields of the dataset. You can specify the file formats in which you can extract the data using the template. While executing the C1-GENEX batch, you need to specify the template and the file format supported by the template. The system will then extract the data from the predefined dataset in the required file format.

The extraction template enables the system to determine the following:

  • The dataset and their fields from where you want to extract the data.

  • The file formats in which you can extract the data.

  • The date and time format that you want to use for all the fields with the Date Time data type.

  • Whether you want to encrypt the extracted file to secure its contents.

  • Whether the data should be enclosed in double quotes when you extract it in the CSV, PSV, or TILD format.

  • Whether the column headers should be included when you extract the data in the CSV, PSV, or TILD format.

  • The XSL file using which you want to extract the data in the XML or JSON format.

  • Whether you want to derive the default value for a field using a bind variable. If you use a bind variable, the system will retrieve the value of the bind variable while extracting data for the respective field. You can use the following supported bind variables in an extraction template:

    Bind Variable Description
    :BUS_​DATE Used to fetch the business date from the installation options.
    :STD_​DATE Used to fetch the standard date from the installation options.
    :SYSDATE Used to fetch the system date from the installation options.
    :BUS_​DTTM Used to fetch the business date and time from the installation options.
    :STD_​DTTM Used to fetch the standard date and time from the installation options.
    :SYS_​DTTM Used to fetch the system date and time from the installation options.

  • Whether you want to edit the field value using a string function. If you use a string function, the system will apply the function to modify the data during extraction. You can use the following supported string functions in an extraction template:

    Function Description
    UPPERCASE() Used to convert the string in uppercase during extraction.
    LOWERCASE() Used to convert the string in lowercase during extraction.
    RTRIM() Used to remove trailing spaces (blanks) from the right side of the string during extraction.
    LTRIM() Used to remove trailing spaces (blanks) from the left side of the string during extraction.
    TRIM() Used to remove the trailing spaces (blanks) from both the left and right sides of the string during extraction.
    PARAM() Used to indicate that the corresponding field should be used to filter the data during extraction.
    Note: If the PARAM() function is used corresponding to a field in an extraction template, then query in the data explorer zone should have the respective field in the select list of the SQL statement. For example, if the PARAM() function is used for the ACCT_​ID field in an extraction template, then query in the data explorer zone should have ACCT_​ID as one of the field in the select list (i.e., SELECT ACCT_​ID FROM CI_​ACCT).
    PARAM_​RANGE() Used to indicate that the corresponding field should be used to filter the data based on the range during extraction.
    Note: If the PARAM_​RANGE() function is used corresponding to a field in an extraction template, then query in the data explorer zone should have the respective field to specify the range in the select list of the SQL statement. For example, if the PARAM_​RANGE() function is used for the ACCT_​ID field in an extraction template, then query in the data explorer zone should have ACCT_​ID as one of the field to specify the range in the select list.