2 hari bersama Metalink Oracle

Posted: 26 February 2008 in Database & SQL Related
Tags: , , ,

Sudah 2 hari ini aku kerja di kantor cuman email dan post update di Metalink Oracle, ya mau gimana lagi soalnya ada masalah di Oracle Discoverer untuk konek di Oracle Aplikasi dengan user udah ada. Bingung gak tuh? Begini ceritanya, pertamanya adalah berkembangnya kebutuhan user yang bisa menganalisa dengan mengambil data secara summary bisa dikatakan dalam bentuk data warehouse. Kan sudah ada RDBMS Oracle lalu dilihat perlu adanya data Business Intelegent yang Oracle sudah punya yaitu Oracle BI Discoverer. Nah dengan adanya aplikasi ini user dengan mudahnya menganalisa data, dengan report yang dibuat secara customize.

Langsung aku ngoprek yang namanya Oracle Discoverer ini. Mulai dari instalnya sampai koneksinya, sampai akhirnya mentok untuk mengkoneksikan user account yang sudah ada di aplikasi dengan discoverer ini. Karena pas pertama login ini bisa juga pake user database (APPS recomended). Yah kalau dipake buat user bisa kacau data dilihat-lihat datanya kalo pake APPS DB user. Kan lebih tepat lagi kalau login dengan username yang sudah di bagi masing-masing. Tapi pas nyobain gak berhasil, makanya googling dan nanya2 ke Metalink Oracle. Yah alhasil sampe posting ini digelar lum ada solusi yang menggembirakan. Berikut aku sertakan SR (Service Request)nya :

R Number 6737***.993 Open Date 25-FEB-08 04:16:01
Support Identifier 14422222 Name Ali M****s
Severity 4 Last Update 25-FEB-08 19:33:37
Product Oracle Discoverer Product Version 4.1.37
Platform Microsoft Windows Server 2003 Detailed Status Modified via MetaLink
SR Reference n/a BUG Reference n/a

Abstract

HOW TO CONNECT DISCOVERER AND USER ACCOUNT ORACLE E-BUSINESS SUITE

     
Resolution History
25-FEB-08 04:16:02 GMT### Detailed Problem Statement ###
How to connect Discoverer and user account on Oracle E-Business Suite?

### Steps to Reproduce ###
N/A

### Instance Name and Type of System ###
DEVELOPMENT & TEST

### Recent Changes ###
N/A

### Workaround ###
N/A

### Impact on Business ###
Management issue reporting

### Issue with Regular or an Apps mode EUL? ###
Regular EUL

### What is your complete EBS 11i version number? ###
RDBMS : 10.2.0.1.0
Oracle Applications : 11.5.10.2

### Integrating with EBS 11i, have you read the integration Note:316463.1? ###
No

### Issue relates to Oracle provided BIS Business Areas & Workbooks (provide details)? ###
Does Not Apply

### Was this environment cloned? ###
No

### Can you access/login to Discoverer Plus/Viewer standalone? ###
No
No, My Discoverer version is 4

### Issue relates to no data returned with Oracle provided BIS and/or custom Workbooks?
###
Does Not Apply

Can you easily recover from, bypass or work around the problem?
Yes

Does your system or application continue normally after the problem occurs?
Yes

Are the standard features of the system or application still available; is the loss of service minor?
Yes

Contact me via :
E-mail
-> ali.m****s@***.**

25-FEB-08 04:24:48 GMT

UPDATE
======
Hi Ali,

Thank you for using MetaLink. We are currently reviewing/researching the situation and will update the Service Request (SR) or call you a
s soon as we have relevant information. Thank you for your patience.

Best Regards,
Vignesh
Global Customer Services

STATUS
=======

@WIP — Work In Progress

25-FEB-08 04:34:06 GMT

.
QUESTION
=========
How to connect to Discoverer using Oracle E-Business Suite Applications User?

RESEARCH
=========
Following documentation was referred to resolve the request:

http://download.oracle.com/docs/html/A86731_01/appendia.htm#967766

25-FEB-08 04:34:43 GMT

ANSWER
=======
Hi Ali,

Please find the below link which mentions the detailed steps on how to connect to Discoverer as Oracle E-Business Suite Applications Use
r:

http://download.oracle.com/docs/html/A86731_01/appendia.htm#967766

Kindly follow the mentioned steps to connect to Discoverer as Applications user.

Best Regards,
Vignesh

25-FEB-08 04:34:51 GMT

Email Update button has been pressed: Sending email to ali.m****s@***.**.

25-FEB-08 04:52:01 GMT

The customer : ali.m****s@***.** : has uploaded the following file via MetaLink:
DISCOVERER.JPG

25-FEB-08 04:58:05 GMT

.
UPDATE
=======
Hi Ali,

1. Go to Tools->Options
2. Select “Connect to both standard and applications EULs” option

Then try reconnecting and let me know for any issues.

Best Regards,
Vignesh

25-FEB-08 04:58:14 GMT

Email Update button has been pressed: Sending email to ali.m****s@***.**.

25-FEB-08 04:59:10 GMT

New info : ali.m****s@***.**
Hi Vignesh,

Thanks for your update, Here with uploaded screen login my discoverer 4 version. On that screen I have not seen
optional login for application user. I have login Discoverer for user database
APPS to connect the database.
Regards,
Ali

25-FEB-08 05:00:34 GMT

.
UPDATE
=======
Hi Ali,

1. Go to Tools->Options
2. Select “Connect to both standard and applications EULs” option

Then try reconnecting and let me know for any issues.

Best Regards,
Vignesh

25-FEB-08 05:00:43 GMT

Email Update button has been pressed: Sending email to ali.m****s@***.**.

25-FEB-08 05:07:01 GMT

New info : ali.m****s@***.**
Hi Vignesh,

Thanks for your update, I have some problem for Foundation Name. Can you explain what is foundation name
for?
Regards,
Ali

25-FEB-08 05:12:26 GMT

.
UPDATE
=======
Hi Ali,

Foundation Name (FNDNAM)
=========================
Use this field to specify the FND schema that owns the core Oracle Applications tab
les and views.

Default value is APPS

Gateway User ID (GWYUID) / password
================================
Specify the user name and password of the public Gateway (i.e. identified by the Gateway User ID/password) that Discoverer Administ
rator is to use when logging in to an Oracle Applications EUL. Use the forward s
lash (/) character to separate the user name and password.

Default value is APPLSYSPUB/PUB

Best Regards,
Vignesh

25-FEB-08 05:12:36 GMT

Email Update button has been pressed: Sending email to ali.m****s@***.**.

25-FEB-08 05:38:08 GMT

New info : ali.m****s@***.**
Hi Vignesh,

Thanks for your update, I have done your suggestion to me, but it still not connected, the error is, Failed to
connect to database, ORA-01017 : invalid username/pasword; logon denied.
That user and password is the user oracle application. Is oracle discoverer 4 need
oracle application server to connect oracle application EBS? Because I did not
installed oracle application server yet.

Regards,
Ali

25-FEB-08 07:37:22 GMT

.
UPDATE
=======
Hi Ali,

You are currently on discoverer version – 4.1.37.00.0, but the minimum required version for E-Business Suite 11i is Discoverer 4.1.46.
Oracle recommends that you upgrade to Discoverer 4.1.48.06. Please find the at
tached Note: 139516.1 which explains the detailed steps required. Kindly request
you to follow the steps for upgradation and then try connecting to discoverer.

And also Application server is not required to connect to oracle application EBS using Discoverer Administrator/Desktop. But it is required if you are accessin
g through Plus/Viewer which are web versions of Discoverer.

Thanks and Regards,
Vignesh

25-FEB-08 07:39:40 GMT

Email Update button has been pressed: Sending email to ali.m****s@***.**.

26-FEB-08 02:54:01 GMT

New info : ali.m****s@***.**
Hi Vignesh,

As your recommended, I have downloaded installer to upgrade my Oracle Discoverer 4.1.37.00.0 to be version
4.1.48.06. The installer cannot be upgrade because error message says “you need
to install Oracle Discoverer Server 4.1.37 or later before installing this
patch”.

I have installed Oracle BI Discoverer 10g DVD package too. With any optional product, development tools for oracle (report, form oracle builder).
And I have checked that application to login with oracle application user
account. Same of oracle discoverer previous version, I configure option
Application EUL Setting to connect my application users. It cannot connect
login to Discoverer yet, the messages is “Failed to connect to database, Unable
to connect to Oracle application database: invalid user name/password”.

Thank you,
Ali

25-FEB-08 19:33:37 : CHANGES MADE VIA MetaLink
NOT YET FORWARDED TO OUR INTERNAL SYSTEMS :

New info : ali.m****s@***.**
Hi Vignesh,

With any oracle product I have, I used my application E-Business Suite 11i and Database Oracle 10g on Linux RHEL. Oracle BI Discoverer 10g on Windows 2003 and I want to install Oracle BI with viewer on user client to view my report. I want to install Oracle BI Publisher product on Windows 2003, because I am don’t want to change configuration application E-Business Suite on Linux.

So what your suggestion to me, with no Oracle Application Server and Oracle BI Publisher product yet. You can inform to me link which I can download that product or you can send that product to my office at PT. C**** T** – Jl.Pintu II ****, Jakarta 13810 Indonesia. Because on CD/DVD Oracle Development Package, Oracle Application Server and Oracle BI Publisher product isn’t on that.

Big Thank you,
Ali

 
About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s