----- How to find the .rdf file or Oracle Report Location or Path in Server using EXECUTION_FILE_NAME or Report Short Name in Oracle Apps EBS R12 using Script ----
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 = 'XX_PROJ_WISE_STK_LEDGER'--'QPXPRQFS'
-- Pass your .rdf 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 = 'XX_PROJ_WISE_STK_LEDGER'--'QPXPRQFS'
-- Pass your .rdf file name ---
No comments:
Post a Comment