Currently i use Oracle Forms & Reports 6i on an Oracle Enterprise Edition 10G. Now there is a requirement to change the technology and WEBify the application.
Say something like .NET, ASP etc... Some links from where i can understand the different option i have.
I have a Materialized View that gets refreshed everyday.While the DB running on oracle 9.2.0.7,It was taking around 50mins to refresh.I was using the following codes
dbms_mview.refresh('mvname','c');
After 10g upgradation the refresh process ran for more than 2 hr.So I used the following codes
dbms_mview.refresh('mvname','atomic_refresh=>false')
It took 50mins to refresh. But what I found that the number of record count is same after each day refresh.Is there any problem with the option atomic_ refresh=>false.Why I used it -In Oracle 9.2.7.0 the 'c' option truncate the MVIEW then insert.But in Oracle 10.2.0.4.0 the 'c' option deletes the records and then insert .The option atomic_refresh=>false truncates.
would there be any code change for spatial data after migration from 10g to 11g? In case of upgradation from 10R1 to 10R2, there were lot of issues regarding the spatial data code.
know beforehand so that it should not affect the service.I have already done the migration from 10g to 11g by 2 ways succesfully.
i upgraded oracle db from 11.2.0.2.0 11.2.0.3.0 on linux using dbua. after completion of the up gradation what are the post upgradation steps. does i need to run any scripts.
View 4 Replies View RelatedHow to set Path environment variable if we want to use OPatch utility for patch upgradation.
View 2 Replies View RelatedWe have recently upgraded to apex 4.2.1 from 4.1. After this, we get a strange stopping issue that the rich text editors clear all their values once the page is submitted. This happens only in Firefox and Chrome, but works just fine in IE. Have you ever noticed and had a solution for this?
View 1 Replies View RelatedHow to Install Oracle Forms and Reports 11g Send me Link or Document.
View 4 Replies View Relatedi want some information about the oracle developer 11g ( froms & reports) . if oracle developer 11g and oracle is both are similar ?.
View 5 Replies View RelatedI'm using the following piece of code to run reports from Oracle Forms 11g.
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
BEGIN
repid := FIND_REPORT_OBJECT('REP_TEST_R');
v_rep := RUN_REPORT_OBJECT(repid);
END;
On execution, the screen does not respond.Do I need to use WEB.SHOW_DOCUMENT along with RUN_ REPORT_OBJECT?
We are facing a problem when calling the reports from oracle forms 10g. following error message appears during report generation
Rep-52266: The In-Process reports server IT_BHARAT failed to start.oracle.reports.RWException:IDL:Oracle/reports/RWException:1.0
Why this error message is appearing and how to solve. Please find attached the image file showing the problem details.
i am trying to upgrade my existing system (6i) to 11g. I have installed Weblogic 10.3.5 with forms and reports 11.1.2.1.0 on windows 7 32 bit. I can connect to my database (10g) from Form builder.
But when I try to open a form/pll of 10g or 6i, it says PDE-PLI018 could not find library and it shows the path of my earlier folder, which now does not exist.
I have made changes in registry FORMS_PATH, FORMS_BUILDER_PATH, UI_ICON And in default.env file FORMS_PATH and CLASSPATH
I have added entry to tnsnames.ora, through which I can connect to DB. And have followed below site to configure weblogic and FM forms and reports;
[URL]
1) Do we have to connect (create a bridge) to DB from weblogic except tnsnames.ora.
2) For library error I think I am missing some settings to be done.
3) If I am able to rectify above error then can I directly use [URL] and access the system from another pc, or still there are some modifications needed.
from where I can free download Oracle 9i Forms And Reports.
View 2 Replies View RelatedWe have oracle application built in Oracle D2k forms and reports and run in client server mode. We want to run our application in touch screen kiosk to view reports and forms.is possible or any changes to be done in our existing application to run on kiosk.
View 1 Replies View RelatedCan I install Forms 10g on WIN 2003 64 bit server? From ORACLE site, I downloaded forms 10g, but it is not sepcified that it s for 32 bit or 64 bit.
View 1 Replies View RelatedI am using Oracle Forms Builder 6i. When you open it, in the navigator tree:
- Forms - MODULE - Reports
I want to know what is the purpose of REPORT section in the Forms Builder.
While i'm installing the oracle reports.I got the dialog box saying to stop ALL the ORACLE SERVICES...
---I have stoped all the services which are relates to oracel.(services.msc)
Still i'm getting the same...
I want to run a report developed by crystal reports by click on a button in oracle developer 6i.
Is it possible. If yes then how can i do this.
My user would like to have a way to attach files to database records. For simplicity, we'll say that each employee in the database could have 0-many file attachments associated with them. I know how to make this part work using Oracle Forms.
So that's the easy part for me. The tough part is that they want to be able to run an Oracle Report on our application server (displays as a PDF, also downloadable as a PDF) and have links on this report to the attachments that they uploaded using the forms process above.
For the idea of storing the files on a folder somewhere, I simply created a text object on the report that had it's hyperlink property pointing to the file location. Done.. opens fine.
However, I want to be able to have the option of storing these files in the database instead, just in case we can't go with the shared folder idea. I'm not sure how to make this work. I can store a blob in the database.. but how do I link to that blob on the report for them to be able to download it? Is this even possible?
how to create a download link on the Oracle Report that let's them download a file out of the database.
I have a doubt; can we format a particular word in oracle reports at runtime..?
Ex:-
A text filed contains data Quote:We request #BANK# to finance the same Bill as per agreed interest rate and other terms and conditions agreed on the above addendum and immediately remit the proceeds to our account A/c no. #ACCOUNTNO#, held with your Bank.
We need to make #BANK#, #ACCOUNTNO# are bold at runtime, Is there any method to format characters at runtime..?
Currently some jobs created in WBT scripting need to converted into oracle,plsql.There is one job in WBT scripting, which will invoke the oracle reports inside and generate the PDF files in the destination path as follows:
a = runhide("c:Program FilesInternet Exploreriexplore.exe", "http://pscm9722:7778/reports/rwservlet?USERID=%LOGONINFO%+server=rep_pscm9722+destype=file+desname=D:ORACLE10G\%CCALLRptName%+desformat=PDF+PARAMFORM=no+report=PCCALL.RDF")
a = runhide("c:Program FilesInternet Exploreriexplore.exe", "http://pscm9722:7778/reports/rwservlet?
[code]...
Now, i want to convert this into oracle,plsql? Is it possible or not?
I need the below output in oracle reports 6i.
this is a testing string retrieved from database.
now what i need is that to make bold the specific words in a string came from database.
I migrated a Oracle 6i Report to Oracle Report 9i so I'm trying to execute a this report in the Run Web Layout, but this doesn't bring me any information, how can i run this reports in the Web layout?
When i run this report en the Paper Layout it's bring me data. When a run the report just bring me a blank web page.
how to create Oracle Reports with Java Barcodes.
View 8 Replies View RelatedI'm using Report Builder 9.0.4.0.33.
I am creating a report which generates the data to a PDF/CSV based on users Input.When I create the report using Report Builder and execute the report,Delimited data appears in a PDF layout.
But if I add the below code in After Parameter Form trigger,the column headers keeps repeating with the data.
function AfterPForm return boolean is
begin
IF :P_DESTYPE = 'CSV' THEN
:MODE :='DEFAULT';
:DESFORMAT:='DELIMITED';
Elsif :P_DESTYPE = 'PDF' THEN
:DESTYPE := 'CACHE';
:DESFORMAT:='PDF';
END IF;
return (TRUE);
end;
[code]....
But the PDF output seems fine where the header is shown only once.I could see many posts regarding this in Oracle reports 6i wherein delimited_hdr=no is used in Command Line but I would like to know the work around in Oracle reports 10g.
I am part of a upgradation and migration proj where an Oracle 9i db on a HP-UX OS is going to be upgraded and migrated as 10g db on a solaris OS environment.I am from the application team(Data warehouse team) and we are yet to allocate a specific DBA for taking care of this activity.
We are still in the requirements stage...different requirements and challenges that should be taken care and would occur in the roadmap of this project from a DBA perspective.All your inputs would be very valuable to me.
Any way to automate a job to execute several Oracle Reports to run at the end of every month and either email them to a list of people or possibly save them to a location on a network drive.
At first, I started out with 2 avenues of thought:
1) The following link raised the option of an Oracle Scheduler, but from my research, the scheduler only runs database jobs, shell scripts, batch files, etc.:
[URL]......
2) I was thinking about possibly creating a database job of some sort to call the reports, but from the following link, I've determined that one cannot create+call a stored/database procedure to run Oracle Report files. So there goes my second hope.
[URL].......
So, it appears that the scheduler won't meet my requirements and now I think I'm almost out of options.
My last resort is creating a database job that queries required information and spooling the data + various formatting "stuff" into a txt file. Then, that txt file would be my report. This seems a little savage and I would like to think that there's a ay to automatically run an .REP against a database and save an electronic copy of the report somewhere.
Is it possible to automate the execution of Oracle Reports and then saving the report in a particular format (xls/pdf/rtf/etc.)?
In my requirement i have to move a field from bottom to the first page of report. I try to drag the field but i think it's in multiple frame .i am very new to oracle how can i work with multiple frame in layout wizard.
View 2 Replies View RelatedI am unable to properly align two objects in the layout editor in Oracle Reports. The form report I am trying to design must be perfect and I need to highlight a particular report object (data item) by adding a narrow box (boilerplate) next to it on the left hand side, which is filled with a contrasting colour and contains an asterisk.
The problem is this: I cannot seem to align them properly (horizontal stack, align top). Even if I use the 'size objects' option to make them exactly the same vertical size, the align option stated above does the horizontal stack, but vertically they are not aligned - nor can I manoeuvrings the boilerplate box into place manually.
The environment of my company consist of an ERP system developed using Oracle Forms 4.5 and Reports 2.5. Now, due to increase in business activities, there is a lot of requests from users for reports in Excel sheet.
Our company is planning for Oracle ERP Rel 12....and it is under process of analysis..due to which there is no chance of upgrade to latest Developer Suite.
As of now, to fulfill user requirements of Excel based reports...what do you think is best and permanent solution? Is there any plug-in or Business Process or Business Intelligence application llike ORACLE BI Spreadsheet plug-in..which meets our demand.
As of now provide users with options to run the report and generate output in HTML format, from there, they copy it to Excel..but this process is not at all user friendly and feasible.
For a requirement, i need to call an Oracle Report from a PL/SQL Package or Procedure. Explain on how this can done. Mine is an Oracle Reports 6i version.
View 1 Replies View Related