Concurrent Program - Quick Queries

 Trace enable program details:

SELECT A.CONCURRENT_PROGRAM_NAME "Program Name",

SUBSTR(A.USER_CONCURRENT_PROGRAM_NAME,1,40) "User Program Name",

SUBSTR(B.USER_NAME,1,15) "Last Updated By",

SUBSTR(B.DESCRIPTION,1,25) DESCRIPTION

FROM APPS.FND_CONCURRENT_PROGRAMS_VL A, APPLSYS.FND_USER B

WHERE A.ENABLE_TRACE='Y'

AND A.LAST_UPDATED_BY=B.USER_ID;

ALTER SESSION SET nls_date_format = 'DD-MON-YYYY HH24:MI:SS';

SELECT
USER_CONCURRENT_PROGRAM_NAME,
RESPONSIBILITY_NAME,
REQUEST_DATE,
ACTUAL_START_DATE,
ACTUAL_COMPLETION_DATE,
ARGUMENT_TEXT,
REQUEST_ID,
PHASE_CODE,
STATUS_CODE,
LOGFILE_NAME,
OUTFILE_NAME,
OUTPUT_FILE_TYPE
FROM
FND_CONCURRENT_REQUESTS FCR,
FND_CONCURRENT_PROGRAMS_TL FCP,
FND_RESPONSIBILITY_TL FR,
FND_USER FU
WHERE
FCR.CONCURRENT_PROGRAM_ID = FCP.CONCURRENT_PROGRAM_ID
AND FCR.RESPONSIBILITY_ID = FR.RESPONSIBILITY_ID
AND FCR.REQUESTED_BY = FU.USER_ID and ACTUAL_START_DATE='05-OCT-2024 10:10:10'
ORDER BY REQUEST_DATE DESC;

SELECT distinct t.user_concurrent_program_name,

r.REQUEST_ID,u.USER_NAME,

to_char(r.ACTUAL_START_DATE,'dd-mm-yy hh24:mi:ss') "Started at",

to_char(r.ACTUAL_COMPLETION_DATE,'dd-mm-yy hh24:mi:ss') "Completed at",round(((nvl(v.actual_completion_date,sysdate)-v.actual_start_date)*24*60)) Etime,

decode(r.PHASE_CODE,'C','Completed','I','Inactive','P ','Pending','R','Running','NA') phasecode,

decode(r.STATUS_CODE, 'A','Waiting', 'B','Resuming', 'C','Normal', 'D','Cancelled', 'E','Error', 'F','Scheduled', 'G','Warning', 'H','On Hold', 'I','Normal', 'M',

'No Manager', 'Q','Standby', 'R','Normal', 'S','Suspended', 'T','Terminating', 'U','Disabled', 'W','Paused', 'X','Terminated', 'Z','Waiting') "Status",r.argument_text "Parameters"

FROM

apps.fnd_concurrent_requests r ,

apps.fnd_concurrent_programs p ,

apps.fnd_concurrent_programs_tl t,

apps.fnd_user u, apps.fnd_conc_req_summary_v v

WHERE 

r.CONCURRENT_PROGRAM_ID = p.CONCURRENT_PROGRAM_ID

AND r.actual_start_date >= (sysdate-103)

--AND r.requested_by=22378

AND   r.PROGRAM_APPLICATION_ID = p.APPLICATION_ID

AND t.concurrent_program_id=r.concurrent_program_id

AND r.REQUESTED_BY=u.user_id

AND v.request_id=r.request_id

--AND r.request_id ='2260046' in ('13829387','13850423')

and t.user_concurrent_program_name like '%Purge%'

order by to_char(r.ACTUAL_COMPLETION_DATE,'dd-mm-yy hh24:mi:ss');

Kill all processes of FNDLIBR.

ps -ef |grep FNDLIBR | grep -v grep | awk '{print $2}' | xargs kill -9











Patch

 Pre Patch Analysis:

SELECT   a.bug_no,
          app.application_name,
           a.DIRECTORY,
           a.filename,
           a.old_version,
           a.new_version,
           DECODE (a.typeid,
                   'not applied',
                   'Unchanged File',
                   'upgrade',
                   'Changed File',
                   'new',
                   'New')
              change_type
    FROM   apps.fnd_imp_psmaster_vl a, apps.fnd_application_vl app
   WHERE   a.bug_no in ('35865350','36033961','36178678','36211820','36247239','36328493','36349505','36370240','36397384','36548655','36564407','36592636','36606890','36214033','36591466')
           AND app.application_short_name = a.app_short_name
ORDER BY   DECODE (a.typeid,
                   'not applied',
                   'Unchanged File',
                   'upgrade',
                   'Changed File',
                   'new',
                   'New') ASC;

 srvctl commands:

srvctl status database -d $ORACLE_UNQNAME

srvctl stop database -d $ORACLE_UNQNAME

srvctl start database -d $ORACLE_UNQNAME

The Online Patching Readiness report has identified XXX tables in the YYY schemas that should have editioned views.

 The Online Patching Readiness report has identified XXX tables in the YYY schemas that should have editioned views.

How should these be handled?

How To Check External Dependencies On Possible Obsolete Schemas With E-Business Suite (Doc ID 1995384.1)

The following SQL script can be used to output a list of Obsolete products. 

select a.application_id, a.application_short_name, at.application_name
from apps.fnd_application a
, apps.fnd_application_tl at
where a.APPLICATION_ID = at.APPLICATION_ID
and language='US'
and application_name like '%(_bsolete)%'
order by APPLICATION_NAME;

-- show external dependencies on possibly obsolete schema

set pagesize 1000
set linesize 200
column owner format a15
column name format a30
column type format a18
column referenced_name format a30
column referenced_type format a18

select owner, name, type, referenced_name, referenced_type
from dba_dependencies
where referenced_owner = '<OBSOLETE_SCHEMA_NAME>'
 and owner <> referenced_owner
order by 1,2,3
/

select owner, name, type
from dba_dependencies
where referenced_owner = '<TARGET_OWNER>'
  and referenced_name  = '<TARGET_NAME>'
  and referenced_type   = '<TARGET_TYPE>'
order by 1,2,3
/