who is connected – username
select distinct d.user_name, b.SID,b.SERIAL# from apps.fnd_logins a, v$session b, v$process c, apps.fnd_user d where b.paddr…
select distinct d.user_name, b.SID,b.SERIAL# from apps.fnd_logins a, v$session b, v$process c, apps.fnd_user d where b.paddr…
Location of _pages directory in 12.2 is $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/_pages If any page needs to be compiled navigate…
If we don’t remember weblogic admin password, we can get it as below. [applmgr@ebs1213 ~]$…
While changing the apps password Working… Oracle error -29548: ORA-29548: Java system class reported:…
Database Startup Fails with ORA-27300: OS system dependent operation:semget failed with status: 28 (Doc ID…
ouicli.pl inste8_apply 1 dbtier Error: Seen the issue during the execution of adcfgclone. perl adcfgclone.pl…
It is often experienced in Oracle Applications R12 that user has been assigned a responsibility…
1. Go to View All Concurrent Requests form System Administrator: (N) Requests > View 2.…
–Set the override address to ‘xyz@abc.com’ , using the following script: –Login to the application…
select fl.meaning,fcp.process_status_code, decode(fcq.concurrent_queue_name,’WFMLRSVC’,’maile r container’,’WFALSNRSVC’,’listener container’,fcq.concurrent_queue_name), fcp.concurrent_process_id,os_process_id, fcp.logfile_name from fnd_concurrent_queues fcq, fnd_concurrent_processes fcp , fnd_lookups…