Go to main content
1/16
Contents
List of Figures
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Introduction to BI Publisher for JD Edwards EnterpriseOne
1.1
BI Publisher for JD Edwards EnterpriseOne Overview
1.1.1
Creating Embedded BI Publisher Reports
1.1.2
Creating BI Publisher Reports with JD Edwards Data Access Driver
1.2
BI Publisher for JD Edwards EnterpriseOne Implementation
2
Understanding BI Publisher for JD Edwards EnterpriseOne
2.1
Introduction to BI Publisher for JD Edwards EnterpriseOne
2.1.1
Benefits of BI Publisher for JD Edwards EnterpriseOne
2.2
Reporting with BI Publisher
2.2.1
Embedded BI Publisher Reporting
2.2.2
BI Publisher Reporting with JD Edwards Data Access Driver
2.2.3
BI Publisher Reporting Comparison
2.3
JD Edwards EnterpriseOne Embedded BI Publisher Process Overview
2.4
BI Publisher Reporting with JD Edwards Data Access Driver Overview
3
Creating JD Edwards EnterpriseOne Embedded BI Publisher Objects
3.1
Understanding the BI Publisher Object Repository
3.1.1
Templates
3.1.2
Transformations
3.1.3
Translations and Localizations
3.2
Uploading, Updating, and Deleting JD Edwards BI Publisher Objects
3.2.1
Understanding BI Publisher Objects
3.2.1.1
Effective Dates
3.2.2
Updating BI Publisher Objects
3.2.3
Deleting BI Publisher Objects
3.2.4
Prerequisite
3.2.5
Forms Used to Upload, Update and Delete BI Publisher Objects
3.2.6
Creating BI Publisher Objects
3.2.7
Uploading BI Publisher Objects
3.2.8
Adding Translations and Localizations
3.2.9
Modifying BI Publisher Object Properties
3.2.10
Modifying Effective Dates
3.2.11
Modifying BI Publisher Objects
3.2.11.1
Revising BI Publisher Objects
4
Creating JD Edwards EnterpriseOne BI Publisher Report Definitions
4.1
Understanding JD Edwards EnterpriseOne BI Publisher Report Definitions
4.2
Creating BI Publisher Report Definitions
4.2.1
Understanding the Report Definition Process
4.2.2
Forms Used to Create BI Publisher Report Definitions
4.2.3
Report Definition Naming Conventions
4.2.4
Defining Source of Data, Template Names, and Transformations
4.2.5
Defining Languages and Output Types
4.2.6
Defining Bursting and Delivery Options
4.2.7
Data Driven Delivery
4.2.7.1
Data Driven Email
4.2.7.1.1
Defining Data Driven Email Recipients
4.2.7.2
Data Driven Printers (Release 9.1 Update 3)
4.2.7.2.1
Forms Used to Define Printer Mappings
4.2.7.2.2
Defining a Data Driven Printer Mapping Record
4.2.7.2.3
Revising a Printer Mapping Record
4.2.7.2.4
Deleting a Printer Mapping Record
4.2.7.3
Combined Data Driven Email and Data Driven Printing (Release 9.1 Update 3)
4.2.8
Delivery Email Subject and Body
4.2.8.1
Report Definition Data Item for Subject and Body
4.2.8.1.1
Dynamic Text-Substitution
4.2.8.2
Defining a Data Structure
4.2.8.3
Defining a Glossary Data Item
4.2.9
Configuring Report Definition Jobs (9.1 Update 4)
4.2.9.1
Configuring the Embedded BI Publisher Server Load
4.2.9.2
Overriding Report Definition Load Configuration
4.2.9.3
Configuring Embedded BI Publisher Server Group
4.2.9.4
Configuring the Enterprise Server jde.ini File
4.2.9.4.1
XMLP Large Jobs VM options
4.2.10
Defining Report Definition Output (9.1 Update 4)
4.2.10.1
Customizing Report Definition Output File Name
4.2.10.2
Defining Report Definition Output Path
4.2.10.3
Creating Hierarchy for the Report Definition Output
4.3
Modifying BI Publisher Report Definitions
4.4
Copying BI Publisher Report Definitions
4.5
Managing BI Publisher Objects in Object Management Workbench
4.5.1
Searching for BI Publisher Objects
4.6
Configuring BI Publisher Objects for Object Management Workbench
5
Submitting JD Edwards EnterpriseOne Report Definitions to BI Publisher
5.1
Understanding the Report Definition Submission Process
5.2
Submitting Report Definitions from BI Publisher Report Definitions (P95620)
5.2.1
Submitting from BI Publisher Report Definitions
5.3
Submitting Report Definitions from Batch Versions (P95305)
5.3.1
Associating Report Definitions with Batch Versions
5.3.2
Forms Used to Submit Report Definitions from Batch Versions
5.3.3
Submitting Batch Versions
5.3.4
Accessing Batch Version Advanced Option Overrides
5.4
Reviewing Report Definition Submission Details
5.4.1
Understanding Report Definition Jobs
5.4.2
Forms Used to View Report Definition Submission Details
5.4.3
Viewing Submission Details from Report Definition Jobs
5.4.4
Viewing Submission Details from Work With Submitted Jobs (P986110B)
6
Managing JD Edwards EnterpriseOne Report Definition Output
6.1
Understanding Report Definition Output
6.2
Viewing Report Definition Output, Source, and Delivery Details
6.2.1
Example of Report Definition Output
6.2.2
Forms Used to View Report Definition Output
6.2.3
Viewing Report Definition Source
6.2.3.1
Example: Report Definition Source
6.2.4
Viewing Report Definition Output Details
6.2.5
Viewing Report Definition Output
6.2.6
Viewing Report Definition Output Delivery Details
6.2.7
Printing Report Definition Output
6.3
Setting Up Security for Report Definition Jobs and Output
6.3.1
Securing Report Definition Jobs
6.3.2
Securing Report Definition Output
6.4
Republishing Report Definition Output
6.5
Redelivering Report Definition Output
6.6
Archiving BI Publisher Report Output
6.6.1
Configuring the Enterprise Server jde.ini File
6.6.1.1
[UBE]
6.6.1.2
Configuring UBE Settings with Server Manager
6.6.2
BI Publisher Archived Report Files
6.7
Deleting UBE and Report Definition Output
6.7.1
Deleting Report Definition Jobs
6.7.2
Deleting UBE Records
6.7.3
Purging Report Definition Output
6.7.4
Forms Used to Submit Job Master Deletion by Days Old Report
6.7.5
Setting Processing Options for Job Master Deletion by Days Old Report (R9861101)
6.7.5.1
Defaults
6.7.5.2
Versions
7
Understanding the XML Output
7.1
Designing Batch Applications for BI Publisher
7.1.1
Page Headers and Page Footers
7.2
Interpreting XML Output
7.2.1
Section Tags
7.2.2
Item Tags
7.2.3
Special Characters
7.2.4
Formatted Numbers
7.2.5
Formatted Dates
7.2.6
Page Headers and Page Footers
7.2.7
Conditional Sections
7.2.8
Level Break Sections
7.2.9
Child Sections
7.2.10
Report Properties
7.3
Comparing XML Output Formats
7.3.1
Supported Object Types
7.3.2
General XML Format Differences
7.3.3
Properties Node
7.3.4
Column Headings Node
7.3.5
Page Headers Node
7.3.6
Report Details Node
8
Creating Oracle BI Publisher Reports with JD Edwards Data Access Driver
8.1
JD Edwards Data Access Reporting with Oracle BI Publisher 11g Overview
8.2
Installing Oracle BI Publisher
8.2.1
Prerequisites
8.2.2
Installing Oracle BI Publisher
8.3
Installing the JD Edwards EnterpriseOne Data Access Driver
8.3.1
Replacing the Delivered xerces.jar and xalan.jar Files
8.3.2
Updating the Oracle WebLogic PRE_CLASSPATH
8.3.3
Migrating WebLogic Users to a New Version of Oracle BI Publisher
8.4
Registering the JD Edwards EnterpriseOne Data Access Driver
8.5
Configuring the JD Edwards EnterpriseOne Data Access Driver
8.5.1
Understanding JD Edwards EnterpriseOne Data Access
8.5.1.1
JDBC Connection String
8.5.1.1.1
Specifying the JD Edwards EnterpriseOne Role
8.5.1.1.2
Retrieving Table Descriptions
8.5.1.1.3
Retrieving Column Descriptions
8.5.1.1.4
Retrieving UDC Descriptions
8.5.1.2
Oracle BI Publisher and JD Edwards EnterpriseOne Security
8.5.2
Configuring the JDBC Driver in Oracle Business Intelligence Publisher
8.5.3
Testing the JDBC Driver Connection
A
JD Edwards EnterpriseOne BI Publisher Releases
A.1
JD Edwards XML Publisher 8.96 Templates
A.2
Migrating from 8.96 XML Publisher
B
Data Access Driver Troubleshooting
B.1
SQL Exceptions and Error Messages
B.1.1
No Suitable Driver
B.1.2
Data Source for F0010, TBLE Not Found
B.1.3
Receiving "[SECURITY_ERROR] A Security Error Occurred"
B.1.4
Invalid SQL Queries Cause Database or Query Timeout Errors in BI Publisher Enterprise
B.1.5
Query Builder Does Not Load JD Edwards EnterpriseOne Tables
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.