1
Mar

Query to find the location of .RDF file

Find the RDF name from Program name:

Navigate to:
System Administrator > Concurrent > Program > Define > Query the program name
Copy the executable name

Navigate to:
System Administrator > Concurrent > Program > Executable
Query the copied executable name
Executable File Name is the name of the RDF

The following query helps to find the location of a particular rdf by providing the file name.

SELECT APPLICATION_NAME,'$'||BASEPATH||'/'||'reports/US' Reports_Path,EXECUTION_FILE_NAME FROM APPS.FND_EXECUTABLES_VL A, APPS.FND_APPLICATION_VL B WHERE EXECUTION_METHOD_CODE='P' AND A.APPLICATION_ID=B.APPLICATION_ID AND EXECUTION_FILE_NAME like '%&RDF_NAME%';

Enter value for rdf_name: GLXCAR

Output:-


APPLICATION_NAME: General Ledger
REPORTS_PATH: $GL_TOP/reports/US
EXECUTION_FILE_NAME: GLXCAR

Back to Top