Hello ,

Check the below Query:

[code]
SELECT *
FROM apps.fnd_concurrent_programs_vl p, apps.fnd_concurrent_requests r
WHERE r.concurrent_program_id = p.concurrent_program_id
AND r.program_application_id = p.application_id
AND p.user_concurrent_program_name IN (‘Gather Statistics for NonApps
Schema’)
AND ( r.phase_code = ‘C’
AND r.status_code = ‘C’
AND r.actual_start_date >= SYSDATE)
[/code]

Regards

Mahmoud Morsy

You can use this SQL statement to get the SID, SERIAL# of the current session:

SELECT s.sid,
s.serial#,
spid,
TRIM (s.machine) machine,
TRIM (s.module) module,
status
FROM v$session s, v$process p
WHERE paddr = addr AND module IS NOT NULL
ORDER BY 1, 2

Then with sqlplus Run

ALTER SYSTEM KILL SESSION 'sid,serial#';

Or by shell commnad:

kill -9 spid.

Regards,

Mahmoud Morsy.

Hi Jihad,

• Stop Application services then * Connect as APPS user and run the SQL commands:
• $ sqlplus apps/apps

[code]
SQL>set head off
SQL> set newpage none
SQL> set pagesize 9999
SQL> spool changepassword.sh
SQL> select ‘FNDCPASS apps/apps 0 Y system/manager USER ‘||user_name||’ ‘||’tech@321’ from fnd_user ;
SQL> spool off

[/code]

• Then run script changepassword.sh
• Start Application services.

Regards,

Mahmoud Morsy.

Hello Arika,

Solution:
1. Go to SYSADMIN >
System Administrator >
Profile >
System
check profile option for “ICX Forms Launcher” and Make sure Site and User leave has been
checked.
2. Set the value following values at user level only according to the version
3. For R12, http://url:/OA_HTML/frmservlet?record=collect
For 11i, http://url:/dev60cgi/f60cgi?&record=collect&log=<&gt;
4. Get the FRD trace from $FORMS_TRACE_DIR path at OS Level

Regards,

Mahmoud Morsy,