Forms :: Frm-41214 - Unable To Run Report

Sep 26, 2008

i tried to run the report from form in oracle forms 10g, its raising the below errors:-

frm-41214: unable to run report.

on the same time, i have successfully run the report, which one is developed newly.

problem raising report is migrated from 6i to 10g.

my os xp, db is 10g, forms and reports is 10g

View 12 Replies


ADVERTISEMENT

Forms :: FRM-41214 Unable To Run The Report?

Dec 18, 2012

We have a integration with rightfax to send fax from our application. We have recently upgraded from oracle 6i to 10g.

When we try to click on the send fax button, we are getting an error FRM-41214 Unable to run the report When send fax button is clicked, desired report opens up in a new tab with the correct data but I am not sure why this error is occuring.

Also,I went through the forum based on the above error, and have made most of the changes suggested by users but still the error exists.

Below is the code we are using
---Called on click of button
PROCEDURE REPORT_PROC IS
pl_id paramlist;

[Code].....

View 1 Replies View Related

Reports & Discoverer :: Frm-41214 - Unable To Run Report

Jul 22, 2013

I tried to run the report from form in oracle forms 10g,

The following error is coming when I click on Report Button. frm-41214: unable to run report.

View 5 Replies View Related

Forms :: FRM-41213 / Unable To Connect To Report Server

Jul 5, 2013

I'm trying to catch the FRM-41213 ERROR (Unable to connect to the report server), so I can switch the generation to another report server. At runtime the message FRM-41213 appers but I'm unable to catch it using 'exception' or 'error_code'.

Here's my

begin
v_rep := run_report_object (repid, pl_id);
if err_type = 'FRM' and (err_code = '41213' or err_code = '41214') then
message('ss error catch');
end if;
exception
when others then
message('ss error to handle');
end;

View 1 Replies View Related

Forms :: FRM- 41213 / Unable To Connect To Report Server

May 18, 2010

"FRM- 41213: Unable to connect to the report server error"

View 17 Replies View Related

Reports & Discoverer :: Unable To Run The Report In 10g

Dec 6, 2012

The 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)

View 3 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

SQL & PL/SQL :: SP2-0310 - Unable To Open File When Running AWR Report?

Dec 1, 2011

When i run the awr report from sqlplus , i get below error message.

Quote:
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production

[code]////

Also i dont find the awrrpt.sql in the following path.

Quote:
$ pwd
/usr/local/oracle/product/9.2.0/rdbms/admin
$
$ ls -alrt awrrpt.sql
awrrpt.sql: No such file or directory
$

Is it something related to permissions on file ?

View 4 Replies View Related

Client Tools :: Unable To Get All Views In Crystal Report

Nov 11, 2008

One of my developer creating views in his own schema,we are able to see that views from sqlplusw. But we are unable view them from crystal report tool(CRW32) ,Except this schema all are visible...

View 3 Replies View Related

Application Express :: Bug Report 4.2 (.1) - Unable To Find Item ID For P3500

Feb 28, 2013

1. On the Home Page, click the "Settings" wheel in the header of the Team Development region on the right side.
2. On the Home Page Preferences popup set "Show" to something else as "All" and click [Apply Changes]
3. Back on the Home Page, in the Team Development region on the right side, click the number next to "Bugs"
4. ERR-1002 Unable to find item ID for item "P3500_RELEASE" in application "4800".

View 0 Replies View Related

Application Express :: 4.2 Upgrade - Unable To Test Report Queries?

Apr 5, 2013

After upgrading to Apex 4.2 I'm now unable to test Report Queries. Each time I click on the Test Report button via Shared Components|Report Queries I recieve the following error message:

ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified.

I still have Apex version 4.1 installed on a different server and it appears to be working fine.

View 1 Replies View Related

Reports & Discoverer :: REP-0002 Unable To Retrieve String From Report Builder

Nov 25, 2010

My own created software is running since last 4 years but now when I am trying to run a report then I got a message "REP-0002 unable to retrieve a string from the report builder" and as a result my report don't run. Please note that some other reports are working properly, this problem is happens only with some of them reports.

View 3 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 :: Unable To Open Report In Microsoft Office Excel Format

Jul 6, 2010

I m trying to open Report in Microsoft Office Excel format with below code.

declare
v_report_nameVARCHAR2(100) := 'F:IrfanNewReportsCurrency.rdf';
v_formatVARCHAR2(12):= 'SPREADSHEET';
begin

Web.Show_Document([URL]......);

end;

when my report run I received one message window File download after that this below error window appear & data can't show in proper format.

View 2 Replies View Related

Reports & Discoverer :: Unable To Print Report On Thermal Printer Model (PRP-085III)

Feb 3, 2013

I have developed a bitmap report on report 6i, But I am not able to print report on printer (Thermal Printer Model PRP-085III, A baylan POS printer).

I tried to convert the same report to Character mode and it print fine.

why it is not printing or what I need to set ?

View 4 Replies View Related

Forms :: Unable To Navigate Between LOVs

Aug 30, 2010

I have 2 datablocks(non database) 1-Header & 2-Detail. In Header there are 3 Text Item with 3 LOV attached with them. When all the 3 Fields are filled (with their respective LOVs) then Detail records are populated.

However if I am choosing LOV for the 1st Item and then clicking the 2nd Item, Again if I wish to go back to the 1st Item LOV I am unable to do so. That means my issue is I am not able to navigate to the 1st item in Header to call its LOV if control is in in the 2nd Item.

Both the Header n Detail have the following property:

Navigation Style : Change Datablock
Previus Navigation DataBlock : Null
Next Navigation DataBlock : Null

View 12 Replies View Related

Forms :: Unable To See A Canvas On Screen?

Aug 6, 2010

I have an form with a few canvases already in it. The problem is that I want to see a particular canvas which shows the toolbar at the top of the window but it dosent show up on the form. I checked the property palette and the canvas is visible. There is also an other canvas right at the top of the form. How do I move the other canvas down if this is covering the toolbar canvas. How do i move the canvas down as it dosent show any X position in its property palette.

View 1 Replies View Related

Forms :: Unable To Save Record

Oct 21, 2010

the data not save the record the item CMPID not generate a number or id to press button NEW

secondly to click the button SAVE they not save the partcular transaction.

View 12 Replies View Related

Forms :: Unable To Delete Record?

Feb 2, 2012

when i tried to delete the record by clicking the delete button which has the trigger code as

delete from emp where employee_id=:e_id; commit;

it wasn't. and showed the message as
---FRM-40508: ORACLE ERROR: Unable to INSERT record.

if i change the EMP ID item property "database item" to "NO"..then i can able to delete the record..but, now i am unable to insert the record form the same form...

View 12 Replies View Related

Forms :: Unable To Get Whole Form On Screen

Mar 22, 2011

i am not able to get whole form on the screen. some part of the part is missing and even there is no scroll bar to slide the form. I have also change the form applet parameter..my screen size is 1024 x 768 and this is same as of the size of form applet.

View 1 Replies View Related

Forms :: Unable To Connect To Destination

Oct 2, 2007

I m using Oracle Forms 6i and Oracle 10g Express Edition. I am having the following error message when I am trying to connect to the database from client.I have dont following configuration in my client's FORM's TNSNAMES.ORA file.

0001 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bankvigil)(PORT = 1521))
(CONNECT_DATA = (SID = XE))
)

In the above configuration

0001 = my connect string.
BankVigil = My Oracle database server hostname.

View 9 Replies View Related

Forms :: Unable To Put A Check For A Form?

Jul 5, 2010

I have a leave form where I need to put a check which prevents the user from entering 'sick leave' if the employee hasn't completed 3 months in the company.This is the code I've written:

SELECT ABS(MONTHS_BETWEEN(t.start_date,sysdate)) INTO l_date
FROM hrp_per_all_people_f t
WHERE t.company_id = :parameter.p_company_id
AND t.employee_number = :parameter.p_employee_number

[code]...

The absence_type_id = 21 is for 'sick leave'. I can't figure out why this is not working. When I do enter 'sick leave' for a new employee I do not get any checks and neither am I able to save the changes.

View 6 Replies View Related

Forms :: Unable To Generate Reports

Jan 25, 2011

I am using the following code to generate my report

pat:= :global.path||'us01127p4';
run_report('heboracle1.pace.internal:7778',
'r1',pat,'c:','c:','pdf','pacerep',pl_id,'yes',
'&co_code='||:global.co_code||'&type_sl='||mtype_sl||'&prog_sl='||:global.prog_sl||'&mode='||'default'||'&desname ='||:global.user_fname||'&destype='||'cache'||
'&to_no='||:to_doc_no||'&year='||myear||'&from_no='||:from_doc_no,'no','no','','wide180');

When i set my param form variable as 'Yes' the report parameters window pops up and when i press submit query the report gets generated. But if i set param form to 'No' then i get a msg saying

TERMINATED_WITH_ERROR-Report output aborted ORA-0000
if i put an exception i am getting a same msg.

The same code is working fine for other forms.

View 6 Replies View Related

Forms :: Unable To Insert Records

Oct 7, 2012

I am getting this error FRM 40508 in inserting data to any table through forms 11g.

eg:

my test table having two columns : id and name

i wrote a simple insert statement insert into test values (:id, :name);
commit;

when i run the application and insert the values, it shows the above error.

when I use the display errors , it shows that there is a violation : ora - 00001 (duplicate values)

however, there is no such value in the database.

The same scenario is repeating with every table I have.

I thing more, when I use the commit_form only without using any manual insert statement, then everything goes well. But with manual insert it all fails.

View 3 Replies View Related

Forms :: Unable To Update Record

May 10, 2010

I have modified an existing form which is from 4 tables. I altered one of the table to suit my requirement and have compiled the form . It is compiled with out any errors. But when i enter any data it shows an error "frm-40509 --Unable to update record" and does not gets saved.

View 10 Replies View Related

Forms :: Unable To View Icons?

Feb 20, 2010

When form is run through developer icons are viewed.

when calling same form through URL enable to view icons.

View 1 Replies View Related

Forms :: ORA-12203 - TNS - Unable To Connect To Destination?

Sep 18, 2012

I am having trouble connecting to oracle forms 4.5, I keep getting an "Ora-12203:TNS:unable to connect to destination" eror message. I am able to connect using sql plus or other similar application so there is no problem with my tnsnames.ora file.

View 4 Replies View Related

Forms :: Frm-18108 / Unable To Load The Objects

May 3, 2010

I use a form (ex. a.fmb) as a reference for another form (ex. b.fmb) . after I subclass the a.fmb into b.fmb and generate it,it works will. but next time I want to open b.fmb I get this error :

frm-18108 unable to load the following objects

source module: A.FMB
SOURCE OBJECT:STD_OBJECT_GROUP
source module: A
SOURCE OBJECT: BUTTON

View 2 Replies View Related

Forms :: Unable To Save Record In Database

Jun 4, 2010

I developed one form having 3 blocks(query_find,Summary and detail). If i do some changes in the 3rd block then press F4 key it's prompting "Do u want to save the Changes?[YES/NO/CANCEL].

If i press "YES" it displays message "1 Records applied and Saved. But the record is not saved in the database.

View 5 Replies View Related

Forms :: Unable To Use PARAMETRIC CURSOR In Oracle

Sep 21, 2011

Need PARAMETRIC CURSOR EXAMPLE with fmb i am unable to use PARAMETRIC CURSOR in oracle forms.

View 1 Replies View Related







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