Using Oracle Bi Publisher To Create Jd Edwards Enterprise One Reports

  • April 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Using Oracle Bi Publisher To Create Jd Edwards Enterprise One Reports as PDF for free.

More details

  • Words: 973
  • Pages: 32
Using Oracle BI Publisher to Create JD Edwards EnterpriseOne Reports Day, Date, 2004 timeDecember p.m. ET 18, Thursday, 2008 1:00 PM MDT Teleconference Access: North America: xxxx International: xxxx

Teleconference Access: Password: Advisor Toll Free – (888) 259-4812

Upcoming live webcasts and recent recordings: December 16, 2008: Preparing for Canadian T4 & Releve Reporting: Year-End Processes December 17, 2008: JD Edwards EnterpriseOne Human Capital Management 9.0 December 18, 2008: Using Oracle BI Publisher to Create JD Edwards EnterpriseOne Reports January 8, 2009: JD Edwards EnterpriseOne integration to Oracle CRM On Demand January 13, 2009: Oracle ST: Moving from Transparent Gateway for DB2400 to Database Gateway for DRDA

Toll – (706) 679-4880

January 15, 2009: JD Edwards World: A91 Enhancements to the Inventory Management System

Conf. ID – 71889760

January 20, 2009: Oracle Rdb Proactive Debugging Option January 20, 2009: JD Edwards World: Using the Job Status Inquiry Screen January 21, 2009: Communication Apps: Introduction to Re-Rating January 27, 2009: Communication Apps: Performing Network Processor Upgrades on IPSA January 27, 2009: PeopleSoft Enterprise Campus Solutions 2009-2010 Financial Aid US Regulatory 2 January 29, 2009: Communication Apps: Mapping PSR Service Orders to an ASR Service Request

Agenda • •

Presentation and Demo – approximately 45 minutes Q&A Session – approximately 15 minutes •

Please hold all questions to the end of the session.



To ask a question, move your cursor to the top of the screen and select the ‘bubble’ icon next to the moderator’s name.



A dialog box will open. Enter your question and select “Send.”



During the Q&A session your question will be read and an answer will follow.

ATTENTION – AUDIO INFORMATION

If you encounter any audio issues, please call InterCall (Audio Conferencing) and mute your phone. 1-888-259-4812 +1-706-679-4880 Passcode: 71889760 We would like to encourage attendees with sufficient Internet bandwidth to listen through VoiceStreaming to continue to use this audio source. Thank you.

Safe Harbor Statement The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.



BI Publisher for JD Edwards EnterpriseOne Jeff Erickson Principal Product Manager ƒ JD Edwards EnterpriseOne

Agenda • Embedded BI Publisher • JDBC Driver Overview • Architecture • Configuration

• Usage with BI Publisher Enterprise • Q&A



Embedded BI Publisher – 8.97 Combine existing UBEs with powerful Publish & Distribute capabilities of BI Publisher Extract

Transform

Publish

Distribute

PDF RTF

BI Publisher

HTML Excel

UBE XSL

Report Definition

XML EDI EFT

XML Repository

Email

Printer

Report Definition - Setup

Report Definition - Setup

Report Definition - Setup

This report will burst on address

- A full set will be sent to Max - A full set will be sent to Curtis - An individual section will be sent to each email found



JDBC Driver Overview

JDBC Driver Capabilities • Read Only • Enforces JD Edwards Security • Applies JD Edward EnterpriseOne Data Formats • Date fields • Math Numeric fields

JD Edwards EnterpriseOne Data Access Server Java Applications Oracle SOA Suite BPEL PM

B 2 B

B A M

Third Party

Other read only JDBC compliant app

Oracle BI Publisher

Enterprise Service Bus (ESB)

Browser

Thin JDE E1 JDBC interface

HTML / javascript

HTML Server

Web Services

JMS

Business Services

Business Events

Tools 8.98

JDBC

Data Access Server New in

J2EE

Tools 8.98

Business Functions

Database Batch Enterprise Server

JDE E1

14

Security Server

Non JDE E1 Component Industry Standard JDE E1 Component

Data Access Server - DAS • Separate download from MetaLink 3 • Managed via Server Manager • Installed • Configured • JDBJ • Managed Server • Start • Stop

DAS via Server Manager - Install

DAS via Server Manager - JDBJ



JDBC Driver with BI Publisher

Interactive BI Publisher Empower users to create their own reports Extract

Transform

Publish

Distribute

Via JDBC

PDF RTF

JDE EnterpriseOne

Email

HTML Excel

Printer

XML EDI EFT

Fax

BI Publisher Enterprise Edition

BI Publisher – Interactive Reports

BI Publisher – Interactive Reports

BI Publisher – Interactive Reports

BI Publisher – Interactive Reports

BI Publisher – Interactive Reports

Single Solution with BI Publisher Transform

Extract JDE EnterpriseOne

Publish

Distribute

BI Publisher

PDF RTF

Email

HTML Excel

Printer

XML EDI EFT

UBE XSL

Report Definition

Fax

BI Publisher High-Fidelity Reporting One Solution for All Document Needs 9Purchase Orders 9Labels / Bar Codes 9Collateral 9Employee Forms 9Government Forms 9Order Forms 9Invoices 9Operational Reports 9Correspondence 9Financial Statements 9Checks

When to use Embedded or Interactive Reports?? EMBEDDED • An event in JDE E1 triggers the report. • Need to update data in the database. • Data manipulation. • No user action.

INTERACTIVE • An event outside of JDE E1 triggers the report. • Read only data. • Minimal data manipulation. • Ad-hoc or on-demand.

Other Consideration • An ESU is required for embedded solution • 8.11 SP1 and above

• JDBC Driver/BI Publisher is 8.11 SP1 and above • Need to conduct performance testing • Impact to DB

Additional information • JDBC Driver Use Cases • Integrations • Third party products

• Documentation • Install and configuration of JDBC Driver • JD EnterpriseOne BI Publisher Guide • JD EnterpriseOne Server Manager Guide • Redpaper • How to create BI Publisher Reports • Oracle BI Publisher guides • Customer Connection Page

Questions •

To ask a question, move your cursor to the top of the screen and select the ‘bubble’ icon next to the moderator’s name.



A dialog box will open. Enter your question and select “Send.”

THANK YOU

Related Documents