Sample Templates for eText BI Publisher Reports (Delimiter & Fixed Position)
Introduction to eText BI Publisher Reports
Oracle BI Publisher (BIP) provides eText report templates to generate text-based output files such as .txt, .dat, or interface files required for integrations with external systems.
Unlike PDF or Excel outputs, eText reports are mainly used when:
-
Data must follow a specific layout
-
Files are consumed by external payroll, banking, or legacy systems
-
Strict formatting rules (delimiter or fixed length) are required
In this blog, we’ll cover:
-
What eText BI Publisher reports are
how to create eText report in BI Publisher
-
Differences between Delimiter-Based and Fixed Position-Based eText
-
BI Publisher eText report example
how to create fixed position eText report
-
common errors in BI Publisher eText report
Difference Between Delimiter & Fixed Position eText
 |
| Delimiter VS Fixed Position eText |
You can see step by step video to develop eText BIP Report using this Link
🔹 Sample 1: Delimiter-Based eText Template
This template generates output with values separated by a delimiter (for example, |).
You can see step by step video to develop eText BIP Report using this Link
|
<TEMPLATE
TYPE> |
DELIMITER_BASED |
|
<OUTPUT CHARACTER SET> |
iso-8859-1 |
|
<CASE CONVERSION> |
UPPER |
|
<NEW RECORD CHARACTER> |
Carriage Return |
|
<LEVEL> |
DATA_DS |
||
|
<MAXIMUMLENGTH> |
<FORMAT> |
<DATA> |
<COMMENTS> |
|
<NEW RECORD> |
TableHeader |
||
|
20 |
Alpha |
'Person Id' |
|
|
1 |
Alpha |
'|' |
|
|
20 |
Alpha |
'Title' |
|
|
1 |
Alpha |
'|' |
|
|
20 |
Alpha |
'First Name' |
|
|
1 |
Alpha |
'|' |
|
|
20 |
Alpha |
'Last Name' |
|
|
<LEVEL> |
G_1 |
||
|
<MAXIMUMLENGTH> |
<FORMAT> |
<DATA> |
<COMMENTS> |
|
<NEW RECORD> |
CLRDAta |
||
|
20 |
Alpha |
PERSON_ID |
|
|
1 |
Alpha |
'|' |
|
|
20 |
Alpha |
TITLE |
|
|
1 |
Alpha |
'|' |
|
|
20 |
Alpha |
FIRST_NAME |
|
|
1 |
|
'|' |
|
|
20 |
Alpha |
LAST_NAME |
|
|
<END LEVEL> |
G_1 |
||
|
<END LEVEL> |
DATA_DS |
