3 Replies Latest reply: Dec 5, 2012 10:50 PM by Pk RSS

    Re: REP-1247: Report contains uncompiled PL/SQL

    976639
      Hi All,


      I have complied(ctrl+shift+k) one report through the Report Builder successfully.


      If i run this Report,i am getting error like below:

      "Re: REP-1247: Report contains uncompiled PL/SQL ".

      Could you please tell me the solutions to solve this and in which cases this report will give such type of error.

      Thanks,
      shekhar yadav.
        • 1. Re: REP-1247: Report contains uncompiled PL/SQL
          Hussein Sawwan-Oracle
          973636 wrote:
          Hi All,


          I have complied(ctrl+shift+k) one report through the Report Builder successfully.


          If i run this Report,i am getting error like below:

          "Re: REP-1247: Report contains uncompiled PL/SQL ".

          Could you please tell me the solutions to solve this and in which cases this report will give such type of error.

          Thanks,
          shekhar yadav.
          Please post the details of the applicationr release, database version and OS along with your reports builder version.

          Please see these docs/links.

          OERR: REP 1247 Report contains uncompiled PL/SQL. [ID 25423.1]
          A Custom Report Fails with REP-0736: There exist uncompiled program unit(s). [ID 369627.1]

          https://forums.oracle.com/forums/search.jspa?threadID=&q=REP-1247&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

          Thanks,
          Hussein
          • 2. Re: REP-1247: Report contains uncompiled PL/SQL
            976976
            Hi Sekar ,

            Are you using formula column or any function inside of your RDF , Please check and compile individual formula columns or if any


            Thanks

            Shagul
            • 3. Re: REP-1247: Report contains uncompiled PL/SQL
              Pk
              Please check if all the DB objects used in the report are valid.