Monday, April 11, 2011

SELECT a.requestor,a.* FROM apps.FND_CONC_REQ_SUMMARY_V a WHERE trunc(request_Date) >=TRUNC(SYSDATE-7) --AND and USER_CONCURRENT_PROGRAM_NAME like '%EDI%' --and argument_text like '%43020005%' ORDER BY request_date DESC

Thursday, May 6, 2010

Apps Admin SQL

SELECT b.responsibility_name NAME,u.user_name,employee_id
FROM apps.fnd_user_resp_groups a,
apps.fnd_responsibility_vl b,
apps.fnd_user u
WHERE a.user_id = u.user_id
AND a.responsibility_id = b.responsibility_id
AND a.responsibility_application_id = b.application_id
and b.RESPONSIBILITY_NAME=

To get employee details


select * from per_people_f where person_id =

Thursday, February 19, 2009

To_find_responisibiltiy_the_discoverer_rpt_assigned

SELECT --'Shared with --->',
EUL4_DOCUMENTS.DOC_LENGTH/1024 "Size",
EUL4_DOCUMENTS.DOC_CREATED_DATE "Created Date",
DECODE(RFGEUL4_US.EUL4_GET_ISITAPPS_EUL,1,RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_DOCUMENTS.DOC_CREATED_BY),EUL4_DOCUMENTS.DOC_CREATED_BY) "Created By",
EUL4_DOCUMENTS.DOC_NAME "Document Name",
EUL4_ACCESS_PRIVS.AP_CREATED_DATE "Shared Date",
DECODE(DECODE(RFGEUL4_US.EUL4_GET_ISITAPPS_EUL,1,DECODE(EUL4_EUL_USERS.EU_ROLE_FLAG,1,RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_EUL_USERS.EU_USERNAME,'R'),RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_EUL_USERS.EU_USERNAME)),EUL4_EUL_USERS.EU_USERNAME),'*** Undefined Error 2 ***','Document Not Shared',DECODE(RFGEUL4_US.EUL4_GET_ISITAPPS_EUL,1,DECODE(EUL4_EUL_USERS.EU_ROLE_FLAG,1,RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_EUL_USERS.EU_USERNAME,'R'),RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_EUL_USERS.EU_USERNAME)),EUL4_EUL_USERS.EU_USERNAME)) "Responsibility Name"
FROM RFGEUL4_US.EUL4_ACCESS_PRIVS EUL4_ACCESS_PRIVS, RFGEUL4_US.EUL4_DOCUMENTS EUL4_DOCUMENTS, RFGEUL4_US.EUL4_EUL_USERS EUL4_EUL_USERS
WHERE ( EUL4_DOCUMENTS.DOC_ID = EUL4_ACCESS_PRIVS.GD_DOC_ID(+) )
AND ( EUL4_EUL_USERS.EU_ID(+) = EUL4_ACCESS_PRIVS.AP_EU_ID )
AND ( EUL4_DOCUMENTS.DOC_CONTENT_TYPE = 'application/vnd.oracle-disco.wb' )
AND EUL4_DOCUMENTS.DOC_NAME LIKE '%Report name%'
ORDER BY EUL4_DOCUMENTS.DOC_NAME ASC,
EUL4_DOCUMENTS.DOC_CREATED_DATE ASC,
'Shared with --->' ASC,
DECODE(DECODE(RFGEUL4_US.EUL4_GET_ISITAPPS_EUL,1,DECODE(EUL4_EUL_USERS.EU_ROLE_FLAG,1,RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_EUL_USERS.EU_USERNAME,'R'),RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_EUL_USERS.EU_USERNAME)),EUL4_EUL_USERS.EU_USERNAME),'*** Undefined Error 2 ***','Document Not Shared',DECODE(RFGEUL4_US.EUL4_GET_ISITAPPS_EUL,1,DECODE(EUL4_EUL_USERS.EU_ROLE_FLAG,1,RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_EUL_USERS.EU_USERNAME,'R'),RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_EUL_USERS.EU_USERNAME)),EUL4_EUL_USERS.EU_USERNAME)) ASC

Thursday, January 29, 2009

How to download partial DFF or KFF setup using FNDLOAD

If we just added one segment to a huge DFF or KFF and want to migrate that to other instance is risky if you download the complete structure into ldt file,because,we don't know who has changed what in development instance so it is always good to download only what you added.

Below command is to download partial values of DFF and KFF

DFF dowload
-------------

FNDLOAD apps/apps_pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct .ldt DESC_FLEX P_LEVEL='COL_ALL:REF_ALL:CTX_ONE:SEG_ONE' APPLICATION_SHORT_NAME=""DESCRIPTIVE_FLEXFIELD_NAME="" P_CONTEXT_CODE="" P_SEGMENT_NAME=""

KFF download
--------------


FNDLOAD apps/apps_pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct .ldt KEY_FLEX P_LEVEL='COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ONE' APPLICATION_SHORT_NAME="FND" ID_FLEX_CODE="" P_STRUCTURE_CODE= ""
P_SEGMENT_NAME=""
My Zimbio
Top Stories