Log In Issue

[anu_uma]

Hi All,

How to restore System Profile 'MO: Operating Unit' when it has been set to blank (NULL), since this prevents users access to the system?


TIA

[anu_uma]

Hi All,

Removed the MO:Operating unit profile option at site level.

How to restore System Profile 'MO: Operating Unit' when it has been set to blank (NULL), since this prevents users access to the system?

[hbabhu]

Hi All,

How to restore System Profile 'MO: Operating Unit' when it has been set to blank (NULL), since this prevents users access to the system?


TIA


<i><div align="right">Originally posted by anu_uma - 16/03/2007 : 01:30:25 AM</div id="right"></i>

Hi uma,

basically profile option is set of changeable options and global variable in application.if u assign to the different levels then only user can do the operation.

[anu_uma]

Hi All,

Because of this Changing Profile option to null at Site Level, is not allowing me to log in with any of the responsiblities, including SYSADMIN login.

Pls suggest any valuable solution.

TIA

[ahmadbilal]

try it by using

http://Nodename.pk:8000/dev60cgi/f60cgi

This wil help to skip the Web\Navigator - List of Menus and access the forms directly

[ahmadbilal]

Login to SQL*PLus as APPS.

Select ORGANIZATION_ID from HR_ALL_ORGANIZATION_UNITS;

UPDATE fnd_profile_option_values
SET profile_option_value = '2'
WHERE application_id = 0 and profile_option_id = 1991 AND level_id = 10001;

4. Commit;

5. Login to Applications.

6. Set the MO: Operating Unit profile to the correct default value for your instance,


to restore the profile options

[anu_uma]

Hi,
I Tried with the your solution no rows updated

[ahmadbilal]

this solution is documented on metalink in note id Note:387581.1
but recomanded is apply this by get assistnace from metalink itar.

but i m sure there nothing else then to update at backend.

[quote]
Hi,
I Tried with the your solution no rows updated

<i><div align="right">Originally posted by anu_uma

[anu_uma]

Hi Ahamed,

How to update it at back end ? can u pls post the same in the forum, as its very much needed for me. Struck in half the way of my work.


TIA

[anu_uma]

HI Ahamed,
I need to do this in Vision instance only.

Working on Vision Instance , for some R&D Work

Thanks

[ahmadbilal]

first of all
AHMAD not Ahamed [V]

i have already post sql queries


[quote]Hi Ahamed,

How to update it at back end ? can u pls post the same in the forum, as its very much needed for me. Struck in half the way of my work.


TIA


<i><div align="right">Originally posted by anu_uma

[admin]

Here is a metalink note,

Subject: How to Set a System Profile Value Without Logging in to the Applications
Doc ID: Note:364503.1 Type: HOWTO
Last Revision Date: 21-NOV-2006 Status: PUBLISHED

In this Document
Goal
Solution
References

Applies to:
Oracle Application Object Library - Version: 11.5.7 to 11.5.10
Information in this document applies to any platform.
Goal
How can one set a profile option value without accessing the applications?
Solution

To set a profile option without accessing the applications, you need to use the SAVE function from FND_PROFILE package. It is NOT supported to update in the tables directly using the "update" statement.

As a test case, below is the detailed procedure of changing the "Guest User Password" profile option value to be profile option value to be GUEST/ORACLE.

This function takes the internal name of the profile option, while the name that appears in the Applications is the user friendly name, thus the internal name should be obtained first.

1. Obtain the internal name of the profile option using the following select statement as APPS:
SQL> select profile_option_name from fnd_profile_options_tl where user_profile_option_name like '<Your Profile Option User Name or Part of it>';

e.g. For the "Guest User Password" profile option that has the internal name GUEST_USER_PWD


SQL> select profile_option_name from fnd_profile_options_tl where user_profile_option_name like 'Guest%';

PROFILE_OPTION_NAME
--------------------
GUEST_USER_PWD



Note that the user profile option name is case sensitive.

2. Use the following sample code to set the profile option to the required value:
===========
Sample Code
===========
DECLARE
stat boolean;
BEGIN
dbms_output.disable;
dbms_output.enable(100000);
stat := FND_PROFILE.SAVE('GUEST_USER_PWD', 'GUEST/ORACLE', 'SITE');
IF stat THEN
dbms_output.put_line( 'Stat = TRUE - profile updated' );
ELSE
dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
END IF;
commit;
END;
===============
End of Sample Code
===============

For a description of the SAVE function parameters, use the specification below:

Function SAVE(
X_NAME in varchar2,
/* Profile name you are setting */
X_VALUE in varchar2,
/* Profile value you are setting */
X_LEVEL_NAME in varchar2,
/* Level that you're setting at: 'SITE','APPL','RESP','USER', etc. */
X_LEVEL_VALUE in varchar2 default NULL,
/* Level value that you are setting at, e.g. user id for 'USER' level.
X_LEVEL_VALUE is not used at site level. */
X_LEVEL_VALUE_APP_ID in varchar2 default NULL,
/* Used for 'RESP' and 'SERVRESP' level; Resp Application_Id. */
X_LEVEL_VALUE2 in varchar2 default NULL
/* 2nd Level value that you are setting at. This is for the 'SERVRESP'
hierarchy. */
) return boolean;