Extract Template

Oracle Revenue Management and Billing enables you to extract any data from the system to a file in the predefined format using the Extract Template feature. An extract template helps the system to determine the following:

  • Date Time Format - The standard format in which the date and time should be extracted to a file.

  • File Formats - You can extract the data in the following supported file formats:

    • Comma Separated Values (CSV)

    • Extensible Markup Language (XML)

    • Fixed Position (PRN)

    • JavaScript Object Notation (JSON)

    • Pipe Separated Values (PSV)

    • Tilde Separated Values (TSV)

    Here, you can specify the following:

    • Whether the root tag should be used in the XML or JSON file format

    • Whether the data should be enclosed within quotes in the CSV, PSV, or TSV file format

    • Whether the column header should displayed in the CSV, PSV, or TSV file format

    • Whether the source XML structure should be used in the XML or JSON file format

  • Services - Here, you can specify a list of business objects or business services using which you want to extract the data from the system.

  • Extract Record List

    - Here, you can specify the XPath of list for which sequence or positions should be reserved based on given record count. This is applicable for the CSV, PRN, PSV, and TSV file formats.

  • Field Mapping - Here, you can specify the following information:

    • Field or node name that you want to appear in the output file

    • XPath of the source field from where you want to extract the data

    • XPath of the target field in which the data should be extracted (applicable for the XML and JSON file formats)

    • Start and end positions of a particular field (applicable for the PRN file format)

    • Whether you want to extract the data in this field

    • Whether you want to edit the extracted data using the supported functions

    • Whether you want to override the date and time format of a field

A new screen named Extract Template is introduced in this release. It enables you to define, edit, copy, and delete an extract template.

We have shipped one extract template named INVOICE_​EXTRACT_​TEMP which helps to extract the bill data in different formats. A new algorithm type named C1-BLEXTTMPL and algorithm named C1-BLEXTTMPL are shipped with product. If you want to extract the bill data using the INVOICE_​EXTRACT_​TEMP extract template, you need to accordingly set the Extract Template Code parameter in the C1-BLEXTTMPL algorithm and then attach the C1-BLEXTTMPL algorithm to the Extract Algorithm system event of the required bill route type.

Parent Topic: Oracle Revenue Management and Billing Generic Business Processes