Tuesday, April 5, 2016

Query to Find Concurrent Program Responsibility,Query To Find Responsibility to submit Concurrent Program

Query To Find  Responsibility to submit Concurrent Program 


Query to Find Concurrent Program Responsibility

In oracle apps it often happens that we want to run a concurrent request but we don't know that from which responsibility we have to run it.

The following query takes the concurrent program name as input and gives the responsibility name from which it can be run



To find the concurrent program name 

select * from apps.fnd_concurrent_programs_tl where
user_concurrent_program_name like '%AP and PO Accrual Reconciliation Report%';


To find  Responsibility we can run the concurrent Request 


SELECT FCP.CONCURRENT_PROGRAM_NAME,
  USER_CONCURRENT_PROGRAM_NAME,
  REQUEST_GROUP_NAME,
  FR.responsibility_name
FROM apps.FND_REQUEST_GROUPS FRG,
  apps.FND_REQUEST_GROUP_UNITS FRGU,
  apps.FND_CONCURRENT_PROGRAMS_VL FCP,
  apps.fnd_responsibility_vl FR
WHERE FRG.REQUEST_GROUP_ID    = FRGU.REQUEST_GROUP_ID
AND FRG.APPLICATION_ID        = FRGU.APPLICATION_ID
AND FCP.CONCURRENT_PROGRAM_ID = FRGU.REQUEST_UNIT_ID
AND FRG.request_group_id      =FR.request_group_id
AND FCP.USER_CONCURRENT_PROGRAM_NAME LIKE 'AP and PO Accrual Reconciliation Report';

No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...