What is the password to enable diagnostics?

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
roy
Posts: 73
Joined: Mon Aug 28, 2006 12:46 pm
Location: USA

What is the password to enable diagnostics?

Post by roy »

In the doccument Application v-4 page 104 section 3.1.4.

When I try to open the diagnostic feature to view the propery value it is asking for password. I tried [sysadmin vision1] not valed. Window opens with " this feature is not available for this responsiliby".

Next page 105
Using SQL
Login as apps user from SQL Plus?
How? Not documented.

Request assistance with the above 2 questions.
Thanks
roy
Posts: 73
Joined: Mon Aug 28, 2006 12:46 pm
Location: USA

Post by roy »

Oops !! Adding one more issue to the same context,

Same section : - 15. Interface.

The document does not show the steps to access the GL_Interface structure - page 100 section 1 and page 103 section 2.

Thanks
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

The password is the apps password which by default is apps. thanks
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

To view the structure of any table just login with the authorized user using sqlplus and on prompt user describe command (you can use 1st 4 character) ,

SQL > desc gl_interface

Oops !! Adding one more issue to the same context,

Same section : - 15. Interface.

The document does not show the steps to access the GL_Interface structure - page 100 section 1 and page 103 section 2.

Thanks


<i><div align="right">Originally posted by roy - Dec 06 2007 : 06:22:59 AM</div id="right"></i>
nomi
Posts: 29
Joined: Mon Dec 03, 2007 3:50 am
Location: Pakistan

Post by nomi »

Admin said the right thing it needs the Apps password ; however you can also disable it as described below

Go to Profile/System and enter %util% in the Profile box. Click Find and a
new window appears.

Look at Utilities:Diagnostics. and set its value to 'Yes'

If it is set to 'Yes', you do not need to
enter a password when trying to go into Help/ Tools/ Examine. If it is set
to 'No', then a password is required to view Examine.
roy
Posts: 73
Joined: Mon Aug 28, 2006 12:46 pm
Location: USA

Post by roy »

Thanks to each one of you for responding. The apps password worked so ONE from the ABOVE three questions solved. Two remain.

I know that Oracle database 9.2.0 is part of the installed software ON THE SERVER ......... NOT ON LOACL MACHINE.

Sorry for presenting myself so nieve. ( for possible Documention )

Following the documentation.
1> Oracle 11i is installed on Machine 'A' and Linux as OS
2> Machine 'B' client machine is setup by cables to acces the server.
3> We use the browser to access the EBS : http://vision.****.com:8000
4> We get the EBS LOGIN SCREEN
5> Not ACCESS screen to database? or SQL PLUS.

MY question as a person following the document :-
ON page 100 GL_Interface table is shown Using SQL

Loged as apps user from SQL Plus?

Question is : from where does SQL PLUS appear?


Sorry for presenting myself so nieve. ( for possible Documention )

I know if database is installed on the local machine then if i use scott/tiger I can use SQL PLUS to work on the database,

but in the setup as per what is mentioned above and in the document. IT IS NOT DOCUMENTED HOW TO GET SQL PLUS ENVIRONMENT.

Sorry AGAIN for presenting myself nieve. ( for possible Documention )

Looking forward for assistance. Thanks
nomi
Posts: 29
Joined: Mon Dec 03, 2007 3:50 am
Location: Pakistan

Post by nomi »

FOr sql plus you should have Oracle Client insatelled on ur PC, then just make a TNS entry of server in your local PC(add with esisting TNs entry), and use that tns entry as database/SID to logon to server.
roy
Posts: 73
Joined: Mon Aug 28, 2006 12:46 pm
Location: USA

Post by roy »

Thanks Naveed for your response.

Your answer to my question gives rise the need to include these steps into the document to practice chapter 15.
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests