Query to find Responsibility for the Concurrent Program

SELECT frt.responsibility_name,

frg.request_group_name,

frg.description

FROM fnd_request_groups frg

,fnd_request_group_units frgu

,fnd_concurrent_programs fcp

,fnd_concurrent_programs_tl fcpt

,fnd_responsibility_tl frt

,fnd_responsibility frs

WHERE frgu.unit_application_id = fcp.application_id

AND frgu.request_unit_id = fcp.concurrent_program_id

AND frg.request_group_id = frgu.request_group_id

AND frg.application_id = frgu.application_id

AND fcpt.source_lang = USERENV('LANG')

AND fcp.application_id = fcpt.application_id

AND fcp.concurrent_program_id = fcpt.concurrent_program_id

AND frs.application_id = frt.application_id

AND frs.responsibility_id = frt.responsibility_id

AND frt.source_lang = USERENV('LANG')

AND frs.request_group_id = frg.request_group_id

AND frs.application_id = frg.application_id

-- AND fcp.concurrent_program_name = <shortname>

AND fcpt.user_concurrent_program_name LIKE '%XXXX%'--<XXXX --User concurrent program>

How to Transfer the files from local machine to Oracle EBS server

Download and Install Winscp software ,its an freeware you can download from below link ,

https://winscp.net/eng/download.php

Goto > Winscp > give Connection Details along with Servver details.
you can get this details along with username and password from your apps DBA.

now to goto exact file location , for this you should know the oracle apps file structure .

few examples of files types with there server location

forms (.fmb) > $CUSTOM_TOP/forms/US

reports > $CUSTOM_TOP/reports

to find out the exact custom top from putty exlained in below post or using table " applsys.FND_ENV_CONTEXT"

for file transfer you need to select appropriate transfer setting ,in binary mode or text or else if you dont know which mode to select you can use automatic default mode.

for transferring file from local machine to server ,
in left window >goto file in local path > right click choose upload.
for transferring file from server to local machine ,
in right window >goto file in server path > right click choose download.

How to login to putty and find out custom_top path in oracle APPS

Putty is freeware , you can download it from below link
https://www.putty.org

Give username and password..

YOU need to run the command for setting environment EBSapps.env

Give choice :R

Then type command

Ø Cd $CUSTOM_TOP

Now give command >pwd

It will give the custom path foor your environment ..

Copy this path and paste it into winscp