0 Replies Latest reply on May 18, 2016 3:07 PM by 2895294

    Issue with the PLL reference custom programs

    2895294

      Dear All,

       

      Our Oracle R12 system is recently upgraded with CPU upgrade patches.

      After CPU patches, All the Custom concurrent programs (RDF based reports) registered with Custom Top which is attached with the PLL (any standard PLL) are failing. Following is the sample for fadolif.pll, similarly I have found another report with inv.pll also fails.

       

      Enter Password:

      REP-0756: Warning: Unable to find PL/SQL library 'FARSV'.

      REP-0756: Warning: Unable to find PL/SQL library 'fadolif'.

      REP-0736: There exist uncompiled program unit(s).

      REP-0736: There exist uncompiled program unit(s).

      REP-1247: Report contains uncompiled PL/SQL.

      REP-0069: Internal error

      REP-57054: In-process job terminated:Terminated with error:

      REP-1247: There exist uncompiled program unit(s).

      REP-1247: Report contains uncompiled PL/SQL.

       

      This is happening for the reports registered with Custom Top, irrespective of it's executable type. Because few of the custom reports executables are still refers to standard top executables, Still they are also failing. But this issue is not happening with any standard top registered concurrent programs (either Standard reports or custom reports registered with (any) Standard Top).

       

      Thanks,

      MJ.