Disco_Apps by aashu4uiit

VIEWS: 64 PAGES: 27

									Discoverer with Oracle Applications

1

Topics
 

   

Discoverer Components Oracle Applications & Discoverer Version Compatibilities Creating the Data Model Discoverer Setup for Oracle Applications Security & Access Q&A - Discussion
2

Topics
   

Versions and Compatibility Setup For Applications Tips On Creating Data Models Q&A and Discussion

3

Discoverer Components
Client Tools
Discoverer Desktop Discoverer Administrator

Discoverer Plus

Discoverer Viewer

4.1.48.06 10g (Drake)

Browser

Browser

Oracle Database

Oracle Application Server
Discoverer Middle Tier Services

1.0.2.2.2 10g (9.0.4)
4

11i Integration with OracleAS 10g


Release 11i instance runs Oracle9i Application Server 1.0.2.2.2 11i is integrated with a stand-alone Oracle Application Server 10g instance The existing Release 11i application-tier server nodes continue to run on Oracle9i Application Server 1.0.2.2.2





5

Simple Architecture with AS 10g
DMZ Firewall Intranet Firewall

OracleAS 10g Server (9.0.4)
• Portal • Single Sign-On • Oracle Internet Directory • Directory Integration & Provisioning Internal • Delegated Administration Services Users • Discoverer • OracleAS Certificate Authority • OracleAS 10g Metadata Repository

External Users

Internet

Router Release 11i Database

E-Business Suite 11i Application Server
• • • • • Oracle9i Application Server 1.0.2.2.2 Oracle HTTP Server Application Server Forms Server Reports Server

6

Discoverer 4i

7

Discoverer 4.1.48.06 Client

8

Discoverer Integration
User Discoverer 9.0.4 E-Business Suite End-User Layer

 



Discoverer 10g End-User Layer resides in 11i database Using APPS_MODE option when creating EUL enforces Applications security for all Discoverer users Easy migration from Discoverer 4i
  

Upgrade utility makes a copy of 4i End-User Layer and upgrades the copy to 10g format Users can run 4i and 10g side-by-side for User Acceptance Tests TIP: Run Discoverer 4i and 10g on different physical servers to avoid Visibroker conflicts
9

Creating the Data Model
    

The Most Difficult Task Which Tables are Used? Which Fields are Needed? How are the Tables Joined? Use Toad to Create the SQL

10

Oracle Applications - Help

11

Help – Diagnostics / Examine

12

Help – Record History

13

Oracle Metalink http://metalink.oracle.com

14

eTRM Technical Reference

15

Metalink Selection

16

17

Applications Data Model

. .

18

Discoverer in Application Mode

19

Discoverer Application Mode

20

Discoverer Application Mode

21

Discoverer Application Mode

22

23

Admin - Security and Access

24

Admin - Security and Access

25

User – Security and Access

26

Oracle Discoverer
  

Q&A Discussion Tips & Techniques

27


								
To top