Month: June 2021

ODTUG Kscope21 Virtual Event – June’21 to July’1

by

The ODTUG Kscope21 Virtual Event features presentations across a variety of technical content topics, including Oracle Database, Oracle Application Express, Oracle EPM-Hyperion, Oracle Analytics and Emerging Technologies, just to name a few. I will be presenting “Emerging Technologies – Overview of Robotics Process Automation and it’s use case in Oracle EBS” virtual session on Thursday … Read more

Oracle EBS – Application User Maintenance SQL Scripts

by

Here are the SQL Scripts to create application user, reset application user’s password and adding responsibility thru SQL Plus / Toad / SQL Developer. Connect as APPS to execute the scripts. Creating application user — creating application userDECLAREl_user_name VARCHAR2(100) := UPPER(‘VMITTAKANTI‘); — Usernamel_password VARCHAR2(30) := ‘Welcome1‘; — Passwordl_session_id INTEGER := USERENV(‘sessionid’);BEGINfnd_user_pkg.createuser (x_user_name => l_user_name,x_owner => … Read more