FND and WF Stuffs


Enabling FND Debug log:

1. Enable the fnd debug log by the setting the fnd debug profile as follows:
Set the following profiles(at both user and responsibility level)
FND: Debug Log Enabled   : Yes
FND: Debug Log Filename  : leave it as null
FND: Debug Log Level     : Statement
FND: Debug Log Module    : po.plsql%
2. Truncate the table APPLSYS.FND_LOG_MESSAGES
3. Run your test case and capture the logs from APPLSYS.FND_LOG_MESSAGES table. 



Configure to see all users workflow script:

update wf_resources set text = '*' 
where name = 'WF_ADMIN_ROLE';


Responsibilities for the concurrent Program:

SELECT DISTINCT
FCPL.USER_CONCURRENT_PROGRAM_NAME
, FCP.CONCURRENT_PROGRAM_NAME
, FAPP.APPLICATION_NAME
, FRG.REQUEST_GROUP_NAME
, FNRTL.RESPONSIBILITY_NAME
FROM
APPS.FND_REQUEST_GROUPS FRG
, APPS.FND_APPLICATION_TL FAPP
, APPS.FND_REQUEST_GROUP_UNITS FRGU
, APPS.FND_CONCURRENT_PROGRAMS FCP
, APPS.FND_CONCURRENT_PROGRAMS_TL FCPL
, APPS.FND_RESPONSIBILITY FNR
, APPS.FND_RESPONSIBILITY_TL FNRTL
WHERE
FRG.APPLICATION_ID =FAPP.APPLICATION_ID
AND FRG.APPLICATION_ID = FRGU.APPLICATION_ID
AND FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
AND FRG.REQUEST_GROUP_ID = FNR.REQUEST_GROUP_ID
AND FRG.APPLICATION_ID = FNR.APPLICATION_ID
AND FNR.RESPONSIBILITY_ID = FNRTL.RESPONSIBILITY_ID
AND FRGU.REQUEST_UNIT_ID = FCP.CONCURRENT_PROGRAM_ID
AND FRGU.UNIT_APPLICATION_ID = FCP.APPLICATION_ID
AND FCP.CONCURRENT_PROGRAM_ID = FCPL.CONCURRENT_PROGRAM_ID
AND FCPL.USER_CONCURRENT_PROGRAM_NAME='Create Accounting'
AND FNRTL.LANGUAGE = 'US'
AND FAPP.LANGUAGE = 'US';

No comments:

Post a Comment