Showing posts with label 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. Show all posts
Showing posts with label 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. Show all posts

Sunday, 12 July 2015

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

----- 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 ---

How to Call a Seeded Oracle Form from a Custom Form (Step-by-Step Guide)

  How to Call a Seeded Oracle Form from a Custom Form (Step-by-Step Guide) Introduction In Oracle E-Business Suite, it is a common requirem...