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
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??
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]....
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 RelatedI 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.
.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.
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]....
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 RelatedI 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....
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
I prepared a report in Oracle reports and trying to run the report through command line by creating a batch file. but i am getting the following error message when i run the batch file
REP-0069: Internal error
REP-57054: In-process job terminated:Executed successfully but there were some errors when distribute the output
REP-50159: Executed successfully but there were some errors when distribute the output
the batch file is as follows
D:DevSuiteHome_1BINRWRUN p:spannawazeitspanna_wa_zeit.Rep userid=alrayatec/alrayatecprod@alraya.world
DESFORMAT=HTMLCSS DESTYPE='mail' DESNAME='sarfraz_it@hnd.com'
while trying to generate a PDF or HTML file from a report previewer, I came upon a REP-0999 error message and the previewer was closed!
View 8 Replies View Relatedwhen I am trying to send report for prints then I received this error.
"
REP-57054: In-Process Job terminated: The report generated successfully but distribution to destination failed.
REP-50159:The report generated Successfully but distribution to destination failed.
REP-50151: Destination ID Currency failed with error An error occured while sending the file to the printer :HPofficejetpro7700Series- Cannot run program "COrcaleMiddlewareasinst_5Config
eportsin
wlpr":
create process error=2, The system cannot fine the file specified."
How can i print a report name with full path at left bottom on report.
View 3 Replies View RelatedI am trying to open report in parameter form in drill down report.
View 7 Replies View RelatedI had report A which drill down to report B. While drilling down to report B, The parameter form of report B should be displayed which accept parameter code and then open the report B. My parameter form is displayed but not accepting the input. i am using the hyperlink to display the second report. Is there any cgimap.bat file to be configured for the parameter report? If yes then how to configure this file?
View 1 Replies View RelatedWhen I try to manage the report the Discoverer application frozen.
View 5 Replies View RelatedIs there any way of stopping the report from executing in Before-Report Trigger.
Actually what i am doing is to see whether some records are present there in the table in Before-Report Trigger on which the report is going to print. Because I am doing some updates in After-Report trigger. I want to stop if there is no records present in the table in Before-Report Trigger so the report will not go forward to After-Trigger of the report.
how to stop and by using which statement.the other way so that if report has no data then After-Report Trigger should not fired.
[Message #1] how to get a unapplied receipts for ageing report? and RMA(credit and debit note)columns ?
Which tables should be refered for Ageing reports.
[Message #2] How to create an ageing report in discoverer?
Which tables should be refered for a Ageing reports.
Ageing report colums customer name, customer id,location,segment, credit note and debit note in different column,unapplied amount and applied amount in a different colum.Already i got a due remaning date and total amount I want a linked table names.
How to merge multiple reports in one report in reports 6i.
View 1 Replies View RelatedI created two reports separately.
1.pub.jsp
2.serc.jsp
what i need is i want to call the report serc.jsp from pub.jsp .
How to Call a Report from a Report?
Not from a form but a Report from a Report?
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].......
I am facing problem while printing from the Oracle Report.. Web.show_document does not print the output of RDF file directly on the printer.
View 1 Replies View RelatedThe code works great for few reports and for few reports it gives an error saying Unable to run the reports in 10g, When i checked the job status it says Terminated with error: <br>REP-163: Invalid value for keyword DESTYPE. Valid options are FILE, PRINTER, MAIL, INTEROFFICE, or CACHE.
I have kept the DESTYPE as CACHE. It is failing at Run_Report_Object(ReportId, Pl_Id)
How can I run my report in my main menu or fort page for example I want to run my report when user click a button. What will process?
View 5 Replies View Related We Implemented Unicode facility in our application, in forms its working fine. But, while running report in pdf arabicCharacters are not displaying Properly.
we did the following settings in uifont.ali
[ PDF:Subset ]
Arial..Italic.Bold.. = "Arialbi.ttf"
Arial...Bold.. = "Arialbd.ttf"
Arial..Italic... = "Ariali.ttf"
[code]...
I want to create report using this query, is there any option?
declare
cursor c2 is
select epi_id, epi_code, epi_name
[Code].....
Have there any limitation on report key(Number of report key) on cgicmd.dat file?
REP-52005: The specified key mrr does not exist in key map file.
But this key 'mrr' exists on cgicmd.dat.
i'd like to fit two pages in one report. i.e i'd like to divide A4 paper into 2 pages. How to do that in report 10g . like in the PS
View 2 Replies View Related