EBS Customizations (MOSC)

MOSC Banner

FND_PROFILE.save

Hello All

I'm am trying to update all RESP to have a null/blank value using this:

DECLARE

l_success BOOLEAN;

BEGIN

DBMS_OUTPUT.ENABLE (buffer_size => NULL);

FOR i IN

(SELECT RESPONSIBILITY_ID from FND_RESPONSIBILITY)

LOOP

l_success := FND_PROFILE.save

  (x_name        => 'ICX_SESSION_TIMEOUT',

  x_value       => '',

  x_level_name     => 'RESP',

  x_level_value    => i.responsibility_id,

  x_level_value_app_id => NULL

  );

IF l_success

THEN

 commit;

 DBMS_OUTPUT.put_line('---');

 DBMS_OUTPUT.put_line(i.responsibility_id||' ' ||'Profile Updated successfully ');

 DBMS_OUTPUT.put_line('---');

ELSE

 DBMS_OUTPUT.put_line('---');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center