Reports & Discoverer :: 11g Compilation Error

Aug 22, 2013

I am doing report migration from 10g report to 11g version 11gR2(11.1.2.0.0). It is not converting into REP when I check the logs . I got compilation error, then I convert 10g RDF to 11g RDF and try to compile it in 11g report builder developer tool, It is giving me compilation error.

It is not allowing me any sql in that proc but if i comment it it get successfully compiled and if the same report i open with oracle report 10g it get successfully compile.

Command using for Conversion:
rwconverter userid=<schema_name>/<schema_name>@tns batch=yes source=<source RDF path> stype=rdffile DTYPE=REPFILE dest =<Dest RDF/REP Path> OVERWRITE=yes

View 1 Replies


ADVERTISEMENT

Reports & Discoverer :: ORA-00920 Error In Discoverer

Jun 17, 2008

While executing the query i got an error saying "ORA-0092 - invalid sql query"

SELECT
S.user_je_source_nameSource,
B.nameBatch_Name,
B.default_effective_dateBatch_Eff_date,
B.posted_dateBatch_Posted_Date,
B.default_period_nameBatch_Period,
[code].......

View 2 Replies View Related

Reports & Discoverer :: Runtime Error On Reports 6i

Aug 15, 2012

I am using windows 7 and running report from report builder 6i. I got this message error report builder has stopped working. And when i press on show problem details i got this info

Problem signature:
Problem Event Name:APPCRASH
Application Name:RWBLD60.EXE
Application Version:3.0.0.0
Application Timestamp:39c93f24
Fault Module Name:UIW60.DLL
[code].......

Read our privacy statement online:

[URL]........

If the online privacy statement is not available, please read our privacy statement offline:

C:Windowssystem32en-USerofflps.txt

View 3 Replies View Related

Reports & Discoverer :: Report End With Error

Jan 4, 2012

We are using APPS 11i, Yesterday some Report are end with Error. Error Details Given Below.

X Error of failed request: BadWindow (invalid Window parameter)
Major opcode of failed request: 15 (X_QueryTree)
Resource id in failed request: 0x2600001
Serial number of failed request: 614
Current serial number in output stream: 614

View 1 Replies View Related

Reports & Discoverer :: 10g Parameter Form Error?

Sep 26, 2012

While calling a report I am getting the following error.

REP-546: Warning: The value of restricted LOV parameter TOPROFIT is not among the selectable values.

When I call the same report through another PC it displays parameter form.

I am using Report Builder 10g.

View 3 Replies View Related

Reports & Discoverer :: Getting Error While Printing User Name

Apr 6, 2011

following is my code written in formula column

function CF_1FORMULA0006 return Char is
v_user_id number;
u_name varchar2(100);
begin
fnd_profile.get('user_id',v_user_id);

select user_name into u_name from fnd_user
where user_id =v_user_id;
return u_name;
end;

getting no data found error.

View 2 Replies View Related

Reports & Discoverer :: Report Server Error?

Aug 25, 2010

I was having report server running well on my oracle database db1.

Now, I created new database :When trying to run the old report server it gives me error.

How could I uninstall the report server and install it again??

View 1 Replies View Related

Reports & Discoverer :: Error / Unable To Run A Report?

Sep 26, 2012

every time user run the report they have got an error like unable to run report.

select b.branchdesc ,
c.description ,
d.groupgldesc ,
a.loanno,f.agreementno,
e.customername ,
(sum(a.dramt) - sum(a.cramt) ) diffamt ,
a.groupglid

[code]....

View 4 Replies View Related

Reports & Discoverer :: Error On Creating PDF File From A Form?

Oct 14, 2010

When a creating a pdf report in reports 6, under oracle 10g, the error message displayed is: The file is damaged and could not be repaired. If I change the report definition from a pdf to a txt file, the error does not display, but the output has the margings distorted.. It only happens when using reports 6

View 2 Replies View Related

Reports & Discoverer :: REP-0066 Error Executing CA Utility

Jul 17, 2010

I have an Report .My report worked correct . But Now this Error :

REP-0066 Error executing CA utility
REP-3335 Unhandled Internal CA Error

View 3 Replies View Related

Reports & Discoverer :: Oracle Report Engine Error

Jul 4, 2013

I m trying to run reports from my application developed using Oracle FORMS6i but the report engine does not show any job. Platform Information: Microsoft Windows Server 2012 Version 6.2 (64 bit).

View 2 Replies View Related

Reports & Discoverer :: Terminated With Error / REP-300 - Invalid Identifier

Nov 4, 2013

I've modified a report and I am able to run the SQL from toad and executed with no errors and output the results as expected. The SQL from the report is calling a function from DB. I granted execute permisiion to public. when I run the report, it has o errors, the result were fine. However, when another user run the report, it get the the following error.

Terminated with error:
REP-300: "GET_NSCL_TOT": invalid identifier
to_char ==> (get_NSCL_Tot('NFL',to_date(:period_end_date,'DD-MON-RRRR'),'1'),'999999.99')||','col2

View 3 Replies View Related

Reports & Discoverer :: REP-0066 / Error Executing CA Utility

Jul 6, 2010

I have An Application with 30 reports. these report run without error but Now when I want to Run Reports , I see this error :

Quote:

REP-0066: Error Executing CA utility .

REP-3335:Unhandled Internal CA error calaa 1

View 1 Replies View Related

Reports & Discoverer :: Error Messages Handling In Report

Jan 18, 2011

I am generating a report with parameter form.

I do not want users to leave a parameter value null . so I applied after parameter form trigger

function AfterPForm return boolean is
begin
IF ( :my_no IS NULL ) THEN
srw.message(101, 'Please enter proper No.');
return (FALSE);
END IF;
return (TRUE);
end;

it is working fine, it displays proper message but after my message, a default message is displayed

REP-0771: After Form Trigger Failed.

I want to avoid this message. if i comment out return(false) then it displays message and runs the report. I want to avoid default oracle message and stop running report also.

View 7 Replies View Related

Reports & Discoverer :: REP-1800 - Formatter Error VGS-1701 - Not Enough Memory?

Dec 14, 2007

While running large report to screen the error is:

"REP-1800: Formatter error. VGS-1701: Not enough memory"

My Observation:When running report to screen, report builder creates 3 temporary files to REPORTS60TEMP folder. When one of the file size reaches to exactly 2GB it gives the above mentioned error and report crashes.

I have visited metalink and get the following:

****************************************************
Problem Description
-------------------
You are running a very large report to screen or preview and you get the following errors:

rep-1800 formatter error
vgs-1701 not enough memory

Solution Description

Increase the size of the buffer for the report.

i've tried following solutions but problem still there:

1) increase and decrease the size of the buffers
2) Removing total number of pages filed so all pages not formated at once.
3) increase the size of the virtual memory of OS
4) increase the size of the PC to 1 GB

I am using report builder 6i, Oracle 10g and windows XP

View 1 Replies View Related

Reports & Discoverer :: Error In Event Driven Report Procedure?

Mar 30, 2011

.I created the following procedure to implement Event Driven Reporting:

CREATE OR REPLACE procedure ABC.eve_drv_rep as
myPlist system.SRW_PARAMLIST;
myIdent system.SRW.Job_Ident;
BEGIN
myPlist := system.SRW_PARAMLIST(system.SRW_PARAMETER('',''));
system.srw.add_parameter(myPlist,'GATEWAY','apsIP/reports/rwservlet');

[code]...

Procedure is created successfully but when I execute this procedure, I get the following error:

ORA-20001'Error sending email.Error: ORA-20999
ORA-06512: at "Nml.Eve_Drv_Rep", line 17
ORA-06512: at line 1

2ndly I want to know that whether I should give IP address or Application Server Machine Name in GATEWAY parameter?
And in SERVER parameter either I should give the Application Server Machine Name or Report Server name installed on Application Server Machine?Lastly from where I can get the complete list of Parameters to be added in SRW.Add_Parameter like SERVER, GATEWAY etc.

note that we r using Database 10g Rel.2 and Forms and Reports services on Application Server and the report being called was developed in Reports 10g.

View 6 Replies View Related

Reports & Discoverer :: Error On Pressing Hyperlink Of Object In Report

Apr 27, 2012

I have a report where the Shipments list will appear.The shipment_id appears as hyperlink and when it is pressed it should be redirected to another report which displays the cost details on the respective shipments

But we get an error message as in the attachment when i press the hyperlink. what would be the issue and where should i check for the error to resolve? Also the query used to extract data is

/*select
decode(cost_type,
'B','Base',
'A','Accessorial',
'D','Discount',
[code]....

View 12 Replies View Related

Reports & Discoverer :: Error Font Unicode When Report Use &TotalPages?

Aug 8, 2011

I have a report that use &totalpages. output PDF, font unicode is error (Mã) but two last page's font is OK (Mã).

View 2 Replies View Related

Reports & Discoverer :: REP3335 - Unhandled Internal CA Error Depep 2

Aug 28, 2004

I work with Developer 2000/Report Builder Oracle 8i...When I try to save a report in any format whether RTF or HTML it says:PDE-PER001 Internal error (REP3335: Unhandled Internal CA Error depep 2) ...Some reports can be saved,some not,especially those reports that have a PARAMETER FORM

View 3 Replies View Related

Reports & Discoverer :: ORA-0999 - Unimplemented Error Patches Enquiry

Aug 25, 2010

Recently, my client side report runtime experience the following bug:

--> ORA-0999:UnImplemented Error

When user attempts to convert the generated report into PDF format.

I had found out from the net that by applying the following:
Patch 18 for Windows Client/Server Forms 6i.

The Ora-0999 bug will be resolved. True enough the bug has been resolved.

However, I had chanced a post recently and this raised my concern on whether I had done the patching correctly.

From the post it stated that,

Quote:Forms 6i ( stand alone ) is currently desupported/extended support. So patch 17 is the last one.

2. Forms 6i is still supported for Ebusiness Suite. Hence patche 18 is the latest patch for form 6i with fixes specific to ebusiness suite. There might be an another patch for forms6i later but specific to ebusiness suite. This is because Forms 6i is supported for EB.

If you are not using Forms along with EB then I dont think the new patches are useful. So remaining at patch 17 is recommended.

Link: [URL]

FYI, I had only selected the custom installation with only the Report Runtime to be patch over the previous version.

View 4 Replies View Related

Reports & Discoverer :: REP-1401 / Afterpform / Fatal PL/SQL Error Occurred

Mar 6, 2013

i am getting below error while running Aging report.

Enter Password:

MSG-01001: inside beforepform
MSG-00100: p_reporting_level = p_reporting_entity_id =
MSG-00100: Get_Predicate calls complete
REP-1401: 'afterpform': Fatal PL/SQL error occurred.

this is my code in After parameter.

srw.message('100','Get_Predicate calls complete');
:p_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
srw.message('100','p_reporting_entity_name'||:p_reporting_entity_name);
:p_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
srw.message('100','p_reporting_entity_name'||:p_reporting_level_name);

[code]....

View 3 Replies View Related

Reports & Discoverer :: Clob In 6i - Error Function Return Must Char

Jun 23, 2011

I having issue when i try to use CLOB as varchar2 is not enough in my case. I'm developing function column in oracle report. I'm using developer 6i. I get error function return must char?

How I can use CLOB in oracle report?

function CF_RnoFormula return Char is
--v_release_num CLOB;
v_release_num varchar2(32767);
begin
FOR rec IN
[code]........

View 3 Replies View Related

SQL & PL/SQL :: Compilation Error In 11.2.0.3

Jun 6, 2011

In oracle 11.2.0.3 I am getting, PL/SQL:ORA-00904 TR_STATE_NAME invalid identifier

but the same code compiled without any compilation error (though column name specified was wrong).I corrected the column name and its working fine in 11.2.0.3 now. Is there any enhancement in Oracle Version 11.2.0.3 in terms of compilation error?

View 6 Replies View Related

Reports & Discoverer :: Error Code ORA-00918 Column Ambiguously Defined

Jul 18, 2013

I have written this code below in Disco Admin 10g but get Ora-00918 column ambiguously defined error even though I have used alias in the table name.

Select

porh.segment1
,Porh.creation_date
,Porh.last_update_date
,porh.closed_code
,porh.authorization_status
,porh.description
,porh.note_to_authorizer
,porh.cancel_flag
,porh.enabled_flag
,porl.line_num
[code]....

View 4 Replies View Related

Reports & Discoverer :: Set Path - Error Occurred While Opening Or Saving Document

Jun 29, 2010

When I give the report Full path like 'C:FolderNameCurrency2.rdf. Successfully report run.

after changing the registry path like Reports_Path='C:FolderName'

When I click a button to run the report,I received the following errors.

declare
v_report_nameVARCHAR2(100) := 'Currency2.rdf';
begin
Web.Show_Document('http://hoitvoltes5:9002/reports/rwservlet?usr'||'&report='||v_report_name,'_blank');
end ;
"
REP-110: File Currency2.rdf cannot be opened.
REP-1070: An error occurred while opening or saving a document.
REP-0110: File Currency2.rdf cannot be opened."

View 2 Replies View Related

Reports & Discoverer :: REP-1222 Invalid Body Size Error In Oracle?

Oct 20, 2010

I'm working on an RDF report. This report runs as a part of Payment Process in Oracle Payables. This report has the printer style as BACS. The layout has only main section. The body of the main section of the report has only one repeating frame and the body field inside the frame. The body field gives concatenated values from the select query. I have to modify the SQL query(where clause) of the report. After I change the query and save it, the report compiles sucessfully on report builder.

However after following payment process and submitting request, the report fails with error:

'REP-1222 Invalid Body Size.'

View 2 Replies View Related

Reports & Discoverer :: FRM-41213 - Unable To Connect To Report Server Error

Feb 27, 2011

I am getting the error FRM-41213: Unable to connect to the report server error when trying to run report by calling from form.

Im not able to access even
with the urls.....rwservlet/showjobs
and /reports/conf/showjobs.

Is there any configuration need to be made in order to run report from form.

I use my report server name as rep_dpaoscit211 .

I havent added any line to any config file for reporting....

View 1 Replies View Related

Reports & Discoverer :: Developed Tabular Report In Builder 6i - Rep-1213 Error?

Dec 23, 2011

I have developed a tabular report in report builder 6i. Total columns in report 28 in all. Now its throwing following error.

REP-1213: Field 'F_orpahn_Code'references column 'orphan_code'at a frequence below its group

View 1 Replies View Related

SQL & PL/SQL :: Compilation Error In Procedure

May 5, 2013

SQL> create or replace procedure procedure_test(id in number, city in varchar2(20) , name in varcha

r2(20) ) as
2 begin
3 insert into procedure_name(vid,vcity,vname) values(id,city,name);
4 end;
5 /

Warning: Procedure created with compilation errors.

There is a table named procedure_name with these columns exactly in database. what this Compilation Error is?

View 5 Replies View Related

SQL & PL/SQL :: Compilation Error In Procedure?

Apr 25, 2013

I am having 3 procedures a,b,c. Procedure a is calling b,procedure b is calling c, and procedure c is calling procedure a.There is compilation error in procedure a but while compiling it is saying dependent procedure is uncompiled.

How to compile all the 3 procedures..

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved