1)How to check if the partitions of a table are set to LOGGING<\/p>\n
select partition_name, logging
\nfrom dba_tab_partitions
\nwhere table_name=’WF_LOCAL_ROLES’;<\/p>\n
2)How to Correct Session Cookie Name.
\na)select session_cookie_name from icx_parameters;<\/p>\n
b)update icx_parameters set session_cookie_name = ‘<hostname_sid>’;<\/p>\n
c)select session_cookie_name from icx_parameters;<\/p>\n
3) How to find database SID from a Concurrent request.<\/p>\n
column process heading “FNDLIBR PID”
\nSELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
\nFROM apps.fnd_concurrent_requests a,
\napps.fnd_concurrent_processes b,
\nv$process c,
\nv$session d
\nWHERE a.controlling_manager = b.concurrent_process_id
\nAND c.pid = b.oracle_process_id
\nAND b.session_id=d.audsid
\nAND a.request_id = &Request_ID
\nAND a.phase_code = ‘R’;
\nYou need your concurrent request ID as an input.
\nc.SPID= is the operating system process id
\nd.sid= is the Oracle process id<\/p>\n
4) How to check which object is corrupted.<\/p>\n
SELECT tablespace_name, segment_type, owner, segment_name
\nFROM dba_extents
\nWHERE file_id = 64 and 1 between block_id AND block_id + blocks-1;<\/p>\n
5) How to check whether the product is install,shared and Not installed in Apps.<\/p>\n
select t.application_name
\n, t.application_id
\n, i.patch_level
\n, decode(i.status,’I’,’Fully Installed’,
\n‘N’,’Not Installed’,’S’,’Shared’,’Undetermined’) status
\nfrom fnd_product_installations i
\n, fnd_application_vl t
\nwhere i.application_id = t.application_id
\norder by t.application_id;<\/p>\n
6) How to check access level when label security feature is installed.<\/p>\n
col\u00a0 USER_NAME format a15
\ncol POLICY_NAME format a15
\ncol USER_PRIVILEGES format a15
\ncol USER_LABELS format a20
\nselect USER_NAME,POLICY_NAME,USER_PRIVILEGES,USER_LABELS from dba_sa_users
\n\u00a0where USER_NAME=’APPS’;<\/p>\n
7) How to find out Summary of Concurrent requests.<\/p>\n
SELECT
\nrequest_id, SUBSTR(requestor,1,25), SUBSTR(program,1,50), SUBSTR(user_concurrent_program_name,1,100),
\nTO_CHAR(actual_start_date,’dd\/mm\/yy :hh24:mi’) start_date,
\nTO_CHAR(actual_completion_date,’dd\/mm\/yy :hh24:mi’) completion_date,
\nFLOOR((ACTUAL_COMPLETION_DATE- ACTUAL_START_DATE)*24) “in Hours”,
\n(((ACTUAL_COMPLETION_DATE- ACTUAL_START_DATE)*24)-(FLOOR((ACTUAL_COMPLETION_DATE- ACTUAL_START_DATE)*24)))*60 “In_Min”
\n–requestor, program, user_concurrent_program_name
\nFROM fnd_conc_req_summary_v
\nWHERE (ACTUAL_COMPLETION_DATE- ACTUAL_START_DATE)*24*60 >10<\/p>\n
8 ) How to find out Package Header.<\/p>\n
select name,text from dba_source where text like ‘%Header: %’
\nand owner = ‘APPS’ and name = ‘INVALID_OBJECT_NAME’;<\/p>\n
9) How to find out version of a package.<\/p>\n
select text from dba_source
\nwhere line=2
\nand name=’AP_IMPORT_INVOICES_PKG’;<\/p>\n
10) How to find out which request is handle by which concurrent queue.<\/p>\n
a) First find out short_name of a program and then pass it as parameter to below query.<\/p>\n
b) The below query will give you output
\n\u00a0I – Included\u00a0 – Included in new concurrent queue
\n\u00a0E – excluded from Standard Manager\u00a0<\/p>\n
This way you know now this running program (concurrent request) is handled by new manager and not part of standard manager.<\/p>\n
SELECT A.INCLUDE_FLAG, A.QUEUE_APPLICATION_ID, C.USER_CONCURRENT_QUEUE_NAME,
\n\u00a0B.CONCURRENT_PROGRAM_NAME
\nFROM APPLSYS.FND_CONCURRENT_QUEUE_CONTENT A, APPLSYS.FND_CONCURRENT_PROGRAMS B, APPS.FND_CONCURRENT_QUEUES_VL C
\nWHERE type_id = b.concurrent_program_id and b.concurrent_program_name = ‘&SHORT_NAME’ and c.concurrent_queue_id = a.concurrent_queue_id
\n\/<\/p>\n
11) How to backup the defination of a View before droping a view.<\/p>\n
\u00a0select dbms_metadata.get_ddl(‘VIEW’,’RG_View’,’APPS’) from dual;<\/p>\n
I will update some more scripts in my next post.<\/p>\n","protected":false},"excerpt":{"rendered":"
1)How to check if the partitions of a table are set to LOGGING select partition_name, logging from dba_tab_partitions where table_name=’WF_LOCAL_ROLES’; […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[172],"tags":[],"class_list":["post-296","post","type-post","status-publish","format-standard","hentry","category-scripts"],"yoast_head":"\n