1 Reply Latest reply: Apr 9, 2013 6:15 AM by mdsirajoddin RSS

    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