Skip to main content

Do you know how to generate output using eText Template in Oracle Cloud BI Publisher?


In this blog, we are going to see how to generate output using eText Template in Fusion BI Publisher

I am going to show this using sample data. This is my sample data
Click "Export" button to download the XML file.
This is my XML File
Open a blank Word Document and save it as type "Rich Text Format"
Add a format setup which is given below

<TEMPLATE TYPE>
FIXED_POSITION_BASED
<OUTPUT CHARACTER SET>
UTF-8
<NEW RECORD CHARACTER>
Carriage Return

Add a Header table which is given below. For headers, give the header name within quotes ex: 'Emplid'.
For headers, use the level DATA_DS which is the top level and appears only once in the XML

<LEVEL>
DATA_DS
<POSITION>
<LENGTH>
<FORMAT>
<PAD>
<DATA>
<COMMENTS>
<NEW RECORD>
DATA_DS


Alpha

‘Emplid’



Alpha

‘|’



Alpha

‘Employee Name’



Alpha

‘|’



Alpha

‘Department’



Alpha

‘|’



Alpha

‘Position’



Alpha

‘|’



Alpha

‘Grade’

<END LEVEL>
DATA_DS










Add a Data table which is given below. For Data use the XML tags without quotes.
For Data, use the level G_1 which is repeating for each and every employee

<LEVEL>
G_1
<POSITION>
<LENGTH>
<FORMAT>
<PAD>
<DATA>
<COMMENTS>
<NEW RECORD>
G_1


Alpha

EMPLID



Alpha

‘|’



Alpha

NAME



Alpha

‘|’



Alpha

DEPARTMENT



Alpha

‘|’



Alpha

POSITION



Alpha

‘|’



Alpha

GRADE

<END LEVEL>
G_1










Save the template and upload it to the BI Report as eText Template as shown below
Once uploaded, save the report.
Open the report to see the output. This is my output.
If you take a closer look at the output, the "Position" column instead of pulling the Position data, it is displaying some numbers (position of the data) because position is a key word.
To overcome this, use below

Alpha

./POSITION



Now save the Template, Upload it to the BI Report and save the report.
Open the Report to see the Output. This is the new output.
I hope this blog explains how to generate Output using eText Template. If you have any questions, please post it in the comments section.
Labels:

Comments

  1. Anonymous10 March 2019 at 23:31

    fusion bi eText Template output generation

    ReplyDelete
  2. Aaron M29 October 2019 at 10:06

    Great examples, thanks!

    ReplyDelete
    Replies
    1. Hassan30 November 2019 at 19:22

      Thanks for your feedback. If you have any questions or doubts, please let me know

      Delete
  3. Rajya Lakshmi26 November 2019 at 01:43

    such a clean explaination...I was able to follow the above steps and created an eText Template. Thank You!!!!

    ReplyDelete
    Replies
    1. Hassan30 November 2019 at 19:22

      Thanks for your feedback. If you have any questions or doubts, please let me know

      Delete
  4. Unknown7 January 2020 at 21:30

    Great Explanation.. what are the other types of carriage return we can use in E-text template?? Also explain how to create PDF report using E-text template??

    ReplyDelete
    Replies
    1. Hassan19 February 2020 at 19:37

      Thanks for your feedback. Please use RTF template to create PDF report output. Refer to blog https://e-learning-ever.blogspot.com/2019/03/fusion-bi-rtf-template-output.html

      Delete
  5. Unknown7 January 2020 at 21:34

    Let me know what are the pros & cons of E-text templates??

    ReplyDelete
    Replies
    1. Hassan19 February 2020 at 19:40

      Using E-Text template, you can create pipe or comma delimited text files seamlessly. You cannot create PDF or Excel files using E-Text template.
      But you can create a comma delimited text file and while doing FTP or e-mail you can rename it to CSV. The out put will be a CSV output.

      Delete
  6. Anonymous6 February 2020 at 00:09

    Hi,
    Great Explanation. Additionally I have a question on the structure of eText Template. Can we transpose rows to columns in eText Template? I mean as of now this output is showing in Horizontal Way but can we design the template to show the same in vertical way? Please let me know.

    Thanks in Advance

    ReplyDelete
    Replies
    1. Hassan19 February 2020 at 19:42

      Thanks for your feedback. I am not sure about the transpose functionality in E-text templates. I will research and update you.

      Delete
  7. Unknown20 February 2020 at 03:35

    When should i use e text template and when should i use rtf template

    ReplyDelete
    Replies
    1. Hassan29 February 2020 at 21:06

      eText templates are used to generate text output. RTF templates are used to generate PDF and Excel output.
      One trick is you can generate a comma separated text file using eText template and while transmitting the file through FTP or mail you can rename the file to csv.

      Delete
  8. Anonymous5 May 2020 at 13:24

    Thank you for posting this. Do you know what needs to be added in order to incorporate looping of specific levels in the template?

    ReplyDelete
  9. Dakota Buck15 December 2020 at 20:53

    This comment has been removed by a blog administrator.

    ReplyDelete
  10. Unknown6 February 2021 at 04:34

    This comment has been removed by a blog administrator.

    ReplyDelete
  11. Joe8 February 2021 at 23:12

    This comment has been removed by a blog administrator.

    ReplyDelete
  12. ram.apps27 February 2021 at 03:31

    it is very simple and clear explanation Blogs should be like this to get a quick solutions

    ReplyDelete
  13. Unknown19 March 2021 at 06:46

    Hi there,

    Is it possible to print a column value with single quotes?eg 'Job Name'. I am able to do the same with double quotes. Please let me know if its possible.

    ReplyDelete
  14. Anonymous25 April 2021 at 01:40

    Hi ,
    I used above steps and created one E-Text template and loaded in report. But when i am running report i am not able to see any data. Can you please help me out why it is happening.

    Thanks & Regards,
    Ashish

    ReplyDelete

Post a Comment

Popular posts from this blog

Do you know how to cancel the Work Relationship using HDL in Oracle Cloud HCM?

In this blog, we are going to see how to cancel the Work Relationship using HDL (HCM Data Loader) Please make sure you have taken the back up of all the necessary data before cancelling the Work Relationship To cancel the Work Relationship, we use HDL Source Key method. Use the below sample template for reference SET PURGE_FUTURE_CHANGES N METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|PersonNumber|DateStart|WorkerType|CancelWorkRelationshipFlag DELETE|WorkRelationship|FUSION|1234|WRK_1234|Legal_Employer|1234|2018/02/01|E|Y In the above template, we do not know the values of the source keys SourceSystemOwner SourceSystemId PersonId(SourceSystemId) Use below query to fetch the SourceSystemOwner Query: select source_system_owner from hrc_integration_key_map where surrogate_id = period_of_service_id   -- pass period_of_service_id corresponding to Work Relationship Use below query to fetch the SourceSystemId Q
3 comments
Read more

Do you know how to generate output using Excel Template in Oracle Cloud BI Publisher?

In this blog, we are going to see how to generate output using Excel Templates in Fusion BI Publisher I am going to show this using sample data. This is my sample data Click "Export" button to download the XML file. This is my XML File Open a blank Excel file and save it as type "Excel 97-2003 Workbook" (.xls) I have created 3 tabs "Summary", "Detail" and "XDO_METADATA" XDO_METADATA tab is mandatory. Place the below text in XDO_METADATA tab Version ARU-dbdrv Extractor Version Template Code Template Type TYPE_EXCEL_TEMPLATE Preprocess XSLT File Last Modified Date Last Modified By Data Constraints: In the "Detail" tab create Header row as shown below Now add the XDO tags Select the blank &quo
2 comments
Read more