Testing eText Template (Offline)

We can test the eText template (offline) in local system without uploading the template to the oracle instance.

In order to test offline we need to install Oracle BI Publisher Desktop.

Steps:

1.Open Template Viewer .

2.Select the desired working directory where you have placed the RTF and xml files and select the output format as eText and select the RTF and the xml file.We can query the table iby_trxn_documents to get Outbound Payment Instruction xml.

Code:

SELECT document FROM iby_trxn_documents  WHERE DOCTYPE=100;

Then click on start processing button.

3.The eText  file will be generated as below.