Understanding BI Publisher Objects
You must upload BI Publisher objects to JD Edwards EnterpriseOne before you can create report definitions for the desired output types. You use BI Publisher Object Repository (P95600) on either the web client or the Microsoft Windows client to upload templates, translations, localizations, and transformations into JD Edwards EnterpriseOne.
To upload BI Publisher objects, you must add a new BI Publisher object to JD Edwards EnterpriseOne. Name the object according to the following recommended naming conventions.
The template name can be a maximum of 100 characters and should be formatted as TPwwwxxxxyyzz, such as TP743005TR1 where:
TP = Template for JD Edwards EnterpriseOne Embedded BI Publisher
www = System code
xxxx = Three to four characters to identify the associated UBE. For example, use 3005 if the source UBE is R743005
yy = Template type, such as TR for a .rtf template
zz = A sequentially assigned number to identify the different outputs associated with the same UBE. For example, TP743005TR1 and TP743005TR2 could produce different .rtf outputs, whereas TP74.005TS1 could produce .xsl output.
Enter a brief but meaningful description of the object. This description should include the purpose of the object.
Identify the BI Publisher object as a specific object type. The following object types are available:
eText.
PDF.
Rich text format (RTF).
Extensible stylesheet language (XSL).
Transformation.
Translation.
After creating a new object in JD Edwards EnterpriseOne, you can search for and select the BI Publisher object that you need to upload. BI Publisher objects are stored in the JD Edwards EnterpriseOne database in the F95600 table.
The file types that you can upload for each BI Publisher object type are shown in this table:
BI Publisher Object |
BI Publisher Object Type |
File Type |
|---|---|---|
Templates |
TE |
.rtf |
- |
TL |
.xls |
- |
TP |
|
- |
TR |
.rtf |
- |
TS |
.xsl |
Translations |
XL |
.xml or .xlf |
Transformations |
XF |
.xsl |
The recommended maximum default BI Publisher object size is 50MB. You can modify the BI Publisher object size on the Windows client by changing the object size in the INTERACTIVE RUNTIME section of the jde.ini using the following definition:
[INTERACTIVE RUNTIME] MaxFileUploadSize = 50
Oracle recommends that you use the Windows client to upload BI Publisher objects. However, if the web client is used to upload objects, you can modify the BI Publisher object size in the OWWEB section of the jas.ini using the following definition:
[OWWEB] MaxFileUploadSize = 50