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 SourceSy...
3 comments
Read more

Do you know how to fetch Oracle Cloud HCM Performance Questionnaire data using SQL

In this session, we are going to see how to how to fetch Oracle Cloud HCM Performance Questionnaire data using SQL SQL Text: with response_view as ( select ep . evaluation_id , ep . person_id , ep . role_type_code , pq . qstnr_question_id , pq . question_type , pq . question_text question , coalesce ( qr . answer_text , qa . long_text ) answer from hra_eval_participants ep , hrq_qstnr_participants qp , hrq_eval_ptcpnt_questions_v epq , hrq_ptcpnt_questions_v pq , hrq_qstnr_latest_resps_v qnlr , hrq_qstn_responses qr , hrq_all_qstn_answers_v qa where 1 = 1 and qp . participant_id = to_char ( ep . eval_participant_id ) and epq . participant_id = qp . participant_id and epq . subject_id = qp . subject_id and pq . qstnr_section_id = epq . qstnr_section_id and pq . qstnr_question_id = epq . qstnr_question_id and qnlr . subject_id = to_char...
Post a Comment
Read more