Monday, April 11, 2011
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 =
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, December 3, 2009
Saturday, August 1, 2009
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
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=""
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
KFF download
--------------
FNDLOAD apps/apps_pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
P_SEGMENT_NAME="
Subscribe to:
Posts (Atom)