AppsTech

AppsTech

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

Locks on the EBS object(s) and how to remove locks

by

Some times you get the error message as “The record cannot be reserved for update. It has already been reserved by another user” or “Could not reserve record(2 tries). Keep trying?” While querying/updating the Purchase Order/Sales Order/any other transaction/setup screen in the Oracle EBS or Oracle DB related custom applications. Generally you get this message … Read more

Installing Oracle Developer Suite 10g on Windows 10 64 bit for EBS R12 Custom Forms & Reports Development

by

When installing the certified version of Oracle Developer Suite 10g (10.1.2.0.2) for custom forms/reports development in E-Business Release 12 on windows 10+64 bit client desktop, The command prompt shows up, then gracefully exists; the Oracle Universal Installer never shows up. You have tried changing the compatibility of the setup.exe to Windows XP and running as … Read more

Copying a concurrent program

by

We have common business requirement to customize the seeded reports/programs like Sales Order Acknowledgement, Invoice Print New Invoices, Invoice Print Selected Invoices, Autoinvoice Import Program etc., In this case, We don’t modify the existing concurrent program’s definition/concurrent program’s source PL/SQL procedure or report, but we will create a copy of the source procedure or report … Read more