1 Reply Latest reply on Apr 9, 2013 11:15 AM by mdsirajoddin

    Oracle Apps R12 backend Table for .RDF file

    Titas
      Hi,

      Can anyone tell me which table in oracle apps database stores .RDF file information like name, location etc?

      Thanks
        • 1. Re: Oracle Apps R12 backend Table for .RDF file
          mdsirajoddin
          Dear Titas,

          Here I find the table which contains the data of all the objects where you need only Reports, so I used the Execution_Method_Code='P' which indicates Reports.

          I cross checked with most of the names then confirmed that 'P' indicates EXECUTION_METHOD_CODE as it is Reports.

          Here you can get the Application Name , According to that you need to go through the Address of the File.


          SELECT * FROM FND_EXECUTABLES_FORM_V WHERE EXECUTION_METHOD_CODE='P';


          Thanks and Regards