End Date all users in EBS 11i after cloning select count(*) from fnd_user;create table fnd_user_bkp as select * from fnd_user;DECLARECURSOR cur1ISSELECT user_nameFROM fnd_userWHERE user_name NOT IN ('SYSADMIN', 'GUEST')AND (end_date IS NULL OR TRUNC(end_date) > TRUNC (SYSDATE));BEGINFOR all_user IN cur1LOOPfnd_user_pkg.updateuser (x_user_name =>...
Thursday, October 30, 2014
Tuesday, October 28, 2014
Tips & Tricks for Navigating Oracle Applications
Tips & Tricks for Navigating Oracle Applications Help : Keyboard Help or – Lists Hot KeysTools : Close Other Forms – check box to auto close forms when a new form is openedQuery Tips and Tricks to enter query by example to recall the last query parameters to Execute...
Oracle E-Business Suite R12 – System Profile Options
Profile Options in Oracle Application Object LibraryThis section lists each profile option in Oracle Application Object Library. These profile options are grouped into categories based on their functional area and are available to every product in Oracle Applications. For each...
