Banner
+ Reply to Thread
Results 1 to 4 of 4

Thread: report error
                  
    Bookmark and Share    
   

  1. #1
    Junior Member Allen is on a distinguished road
    Join Date
    Oct 2012
    Posts
    27
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    report error

    Hi All,

    i create a report via dynamic para, but i got an error:


    oracle.apps.xdo.XDOException: ORA-06550: line 2, column 1: PLS-00201: identifier 'PKG_SAMPLE_REPORT.P_GID' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 1: PLS-00201: identifier 'PKG_SAMPLE_REPORT.P_GL_USER' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored

    is there anybody who met this error before? i do declare the paras in reportowner schema:

    create or replace
    PACKAGE PKG_SAMPLE_REPORT AS
    P_GID VARCHAR2(32766) := '1=1';
    P_GID_PARAM VARCHAR2(32766) := '1=1';
    P_GL_USER VARCHAR2(32766) := '1=1';
    FUNCTION AFTER_PFORM RETURN BOOLEAN;
    FUNCTION BEFOREREPORT RETURN BOOLEAN;
    FUNCTION AFTERREPORT RETURN BOOLEAN;
    FUNCTION BEFOREPFORM RETURN BOOLEAN;
    END PKG_SAMPLE_REPORT;

    if anybody knows how to reslove this error, pls help me.
    thank you!

  2. #2
    Senior Member DarkCloud67 is on a distinguished road
    Join Date
    Nov 2006
    Posts
    233
    Thanks
    4
    Thanked 16 Times in 15 Posts
    Rep Power
    8

    Re: report error

    Allen,

    Did you add the package name to the header of your query template?

    Did you run the reportowner_grants.sql and create_public_synonyms.sql after loading your package?

    If you don't have it get the Report Developers Guide for OTM 6.2 it has a lot of good information on creating custom reports.

    Rick

  3. The Following User Says Thank You to DarkCloud67 For This Useful Post:

    Allen (November 30th, 2012)

  4. #3
    Junior Member Allen is on a distinguished road
    Join Date
    Oct 2012
    Posts
    27
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: report error

    Quote Originally Posted by DarkCloud67 View Post
    Allen,

    Did you add the package name to the header of your query template?

    Did you run the reportowner_grants.sql and create_public_synonyms.sql after loading your package?

    If you don't have it get the Report Developers Guide for OTM 6.2 it has a lot of good information on creating custom reports.

    Rick
    Hi Rick,


    <dataTemplate name="SIMPLE_SHIPMENT_TEST" defaultPackage="PKG_SAMPLE_REPORT" version="1.0">

    see, i added the package name to my query template header...

    but abt the second point you mentioned, i didn't do that. you meant if i create any new package
    in OTM DB, i must run these 2 scripts ?

    thanks

    Allen

  5. #4
    Senior Member DarkCloud67 is on a distinguished road
    Join Date
    Nov 2006
    Posts
    233
    Thanks
    4
    Thanked 16 Times in 15 Posts
    Rep Power
    8

    Re: report error

    Yes, you must run those two packages.

    Here is a link to the Report Designers Guide for OTM.

    http://docs.oracle.com/cd/E20111_01/...t_designer.pdf

    Rick


 

Similar Threads

  1. Error in BI publisher report
    By satish_swayam in forum Architecture
    Replies: 1
    Last Post: December 13th, 2011, 07:20
  2. Getting Error in executing BI report
    By Rajyamp in forum Reports / BI / FTI and Other Analytics
    Replies: 2
    Last Post: July 26th, 2011, 08:51
  3. Custom Report error
    By dhivya.enjoy in forum Reports / BI / FTI and Other Analytics
    Replies: 0
    Last Post: June 10th, 2011, 14:02
  4. Report Error
    By Pinkesh Jain in forum Reports / BI / FTI and Other Analytics
    Replies: 0
    Last Post: June 10th, 2011, 04:28
  5. Error while generating the Report
    By prakashshiremath in forum Reports / BI / FTI and Other Analytics
    Replies: 3
    Last Post: December 2nd, 2010, 17:43

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56