Tuesday 23 September 2014

EBS : Adding SYSADMIN responsibility at backend

BEGIN
FND_USER_PKG.AddResp('<username>', 'SYSADMIN', 'SYSTEM_ADMINISTRATOR','STANDARD', 'Auto Assignment by Daily Refresh Script', sysdate, SYSDATE + 100);
commit;
END;
/

No comments:

Post a Comment

Oracle : Database Startup Time

 Oracle Instance Startup Time SET LINES 2000 SET PAGES 9999 COLUMN INSTANCE_NAME FOR A20 SELECT     instance_name,     to_char(startup_time,...