I'm new to 10g developer suite, I designed an application in 6i. Now I compiled this application in 10g DS but there is an error of global variables and also icons are not visible. It displays in designer but not at runtime in browser.
View 24 RepliesI have one form that is migrated from oracle forms 6i to 11g. I opened that form by 11g form builder and it has 3 text items. Then i run the form from 11g builder...here is my problem, only 2 text items are displayed in my browser(IE). another one is invisible... i checked the property pallet for that particular text item.
i checked the following properties and its value in my form:
enabled=yes
visible=yes
but the text item is not visible.
I am unable to hide or make visible a menu item dynamically. I want to show a menu to a bunch of employees only.
I have tried:
On the menu properties, I have done:
Physical-> visible : No
functional -> visible in Menu: No
(Have tried different combinations too)
On the form where this menu is attached, I have written trigger new form instance:
SET_MENU_ITEM_PROPERTY('mymenu.menu_name',visible,PROPERTY_TRUE);
Its working fine when I am trying to enable or disable the same but I have to do it the desired way.
I want to show or hide some items on my form by using the SET_ITEM_PROPERTY to enable or disable VISIBLE. i have a button NEW, my need is when i click on this NEW button it should be hide and some other items should be show. but when i click on this its only showing other items but not hiding the NEW button. my NEW button is like this:
[b]set_item_property('select.new',visible,property_false);
set_item_property('select.new',enabled,property_false);
set_item_property('select.new',navigable,property_false);[/b]
------------------------------------------------------------------
set_item_property('control.section',visible,property_true);
set_item_property('control.section',enabled,property_true);
set_item_property('control.section',navigable,property_true);
set_item_property('control.year',visible,property_true);
set_item_property('control.year',enabled,property_true);
set_item_property('control.year',navigable,property_true);
I have problem in displaying icons in the push button during run time. Actually from few days i m trying to display icons at run time but with out any success.
i had made a simple push button and in its properties i had made the following changes
iconic=yes
icon filename=c:tempsave
the file save.GIF is saved under c:temp directory.
i had tried all the changes in registry.dat,orion file through the doc 203846.1 from metalink. Give me sample code step to step for showing a
push button with icon during run time. Also I tried the steps mentioned in the pdf document of
[URL].....
But it did not solve my problem. My icon file name is save.GIF , I wanted to know whether save.GIF file name convention is valid or not. Give the path from where I can get the icons used for web.
I set the path in formsweb.confg and registry.dat in my 2003 server m/c. The icons are displaying but the icons displayed is blurred and the icons are only 2kb's in size. When we view the icons in picture viewer there is no issue.
Also when i do the same settings in win xp and win7 the icons are not at all displayed
I have Forms 11g in Unix environment.
I can't see icons in buttons. I have a custom smartbar and some custom icons on it, and it get displayed, but when it comes to buttons, nothing. Not even the default buttons that comes inside frmall.jar are displayed. What i don't understand is how do they get displayed on the smartbar and not on buttons?
As you can see, i already have the necessary changes to display icons, such as all small case, changes in formsweb.cfg, registry.dat... I get the icons to be displayed in browser. If i put them on a jar file, the jar file is downloaded as i can see in java cache, but never shows. I already tried several different GIF's, different image sizes, different button sizes, colors, names, etc.
We are using ERP based on Oracle 10g forms, there is icons on the buttons those icons are displaying when we uses the ERP in Windows based client and browser Internet Explorer.But when we uses Opera browser we are getting ERP but icons are not displaying.
Same way when we uses Linux client machine using Mozilla Firefox there also the icons are not displaying.
When form is run through developer icons are viewed.
when calling same form through URL enable to view icons.
i have problems to display icons in a task bar in an application that is being migrated from oracle 4.5 to 10g in windows xp.The task bar shows all the icons in the original aplication but when the application runs in 10g, just some of the icons are shown, not all of them.All the icons are in the same file direction "C:fileiconos" and they're all gif files.
I have added the file locatoin to the configuration of the registry.dat,forms, in the registry of the computer, in the orion and orion-web files and in the default file following advice given to other threads here but the problem stays in the application.I have added also the variables to the registry of the coputer for UI_ICON and UI_ICON_EXTENSION with their values.
I develop a form using Devloper9i AS, oracle 9i, Winxp. The problem is: I used icon button at design view ".fmb" but at run time this icon disappears in the file ".fmx" After reading some topics covered this problem in this forum; The following steps are executed:
1-In regedit I put UI_ICON = c:icon --where my gif icon file is located
2-At command prompts i type: C:>jar -cvf icons.jar c:icons Then "ICONS.JAR" file is created on D:Dev9ijdkin
3- I Copy the file "ICONS.JAR" and past into D:Dev9iforms90java
4- I modify the "FORMSWEB.CFG" as follow:
archive_jini=icons.jar,f90all_jinit.jar;
imageBase=codeBase
4- In "Registry.dat" I added the flowing line:
default.icons.iconpath= c:icons
5- I modify the "orion-web.xml" .as follow:
<virtual-directory virtual-path="/html"
real-path="D:Dev9i/tools/web90/html" />
is modified to :
<virtual-directory virtual-path="/ICONS"
real-path="C:ICONS" />
6- In the property palette for the icon item and in the Icon Filename I put just the icon name called "w_prev" Without any extension , any path...
I want to open word document on client machine and to do this I have configured webutil and Its working fine. before configure the webutil icons are appearing on forms and after webutil icons are disappeared I have found that when I comment
baseHTMLjinitiator=webutiljpi.htm
icons appears but word document not open and the following error shows
oracle.forms.webutil.ole. Ole functions beans not found
CLIENT_OLE2.Create_Obj will not work.
i want to put icons on buttons in oracle form developer 10g. and make some different style.
View 2 Replies View Related Tree node icons. I created a table named TEMP_USER_MENU and contains the following structure
USER_IDVARCHAR2(15)N
MENU_IDNUMBER(15)N
MENU_DESCVARCHAR2(150)N
FILE_NAMEVARCHAR2(100)N
[code]...
Now all i wanted is to change each node icon. This query just make the parent nodes icon to OPEN folder like icon and the leaf node to FILE. You can see the decode query up there. It just chose the icons from the File_Name field when it founds 0 then it shows it's a parent node it makes it icon to OPEN else it make it to NEW.
Fist thing i want to know that from where the form builder is fetching these icons? i.e. from which path and what format it looks like a .png file ? .ico or a .jpeg file. I have searched a lot online but all in vain.
Second thing if i want to add unique icons in my menu tree on each node. Is there any possibility ? if yes. Then where should i keep my icons files and in which format?
I have a page (16) and a tabular form when the user select the check box I update the zero page item
$x('P0_REPORT_REFNO').value=l_value;
this works fine till this point now i have a button will calls page 8 and pass the parameter to page 8 P0_REPORT_REFNO is displaying the selected value but passing null to page 8.I am running the application on apex.oracle.com
I'm looking for a way to store an encypted numeric value in one field in a table (so that it appears encrypted even to a DBA) and to display the unencypted value in Apex forms and interactive reports for some users but not others.
View 4 Replies View RelatedI'm using 11gr2 DB, APEX 4.2 and connected using pl/sql gateway.
I see several sample APEX app like the checklist manager where the tab screen heading (home/checklist/reports) has 3 icons on the right corner for Administration, Mobile. I want to use the same concept but this app is locked so I cannot see how it was done.
I also see some application where the breadcrumb has an icon for home and not the standard Home text.!
im working with apex 4.2.1 and when i try to define a Dynamic action on any item, if the action type is "Set Value" or execute SQL/Javascript code it should appear a text field that let me define the action taking place. However this wont do..
this is what happens:
And this is what should happen:
I know that patch 4.2.2 solves some issues regarding dynamic actions but in the bug report there's no reference to such a problem.
I want to export forms data into Excel sheetfor that i am using Client_Ole2.I have attached Webutil object library and Pl/Sql libraryStill I can not export data from Form to Excel sheet
View 7 Replies View RelatedQuery :"how to send mail to lotus notes with attachment from oracle forms"?
View 2 Replies View RelatedI have u na forms developer application in 6.0 that generates a Word document. This application runs successfully on Windows XP operating system. We now have PC's new operating system Windows 7 and officce 2010. My procedure reads a specific route where a template in Word which is used to generate the document. In the user's PC application that does not generate the document even shows me an error message. But when I enter my network user with the user's PC and the document genre generates me perfectly. I checked if the user has access to the server path specifies where the template encuntra wish to open and if you have them.
View 1 Replies View RelatedI created a new form for Oracle Apps, At first when I ran the form from the application all the fields backgrounds were black, so I changed the background in the property palette to white and foreground to black.
Now it shows fine but when I close this form and open another those fields are now blacked out. What should I do, I know the problem comes from the new form.
I have a requirement to read a file from windows m/c and write into Unix Server. How can i do that in Oracle forms.
I tried TEXT_IO package.But that is not allowing to access Unix path.
when a user change or delete any record or row in forms data automatically move to other table because i want to compare old and new record.
View 8 Replies View RelatedI have task. I am using oracle forms 6i. I want to import excel data to oracle forms(its common task using ole2 package). But this time I want to map the columns i.e my database table having 5 columns. and the excel file is having 2 or 3 columns then i suppose to map those columns and accordingly insert it to my table.
So far i have import column heading of excel to oracle forms, then i've provide list item for mapping each column. so that user can map excel column to database columns. Now I am confuse how to write the code so that selected columns should get inserted into database.
-more details
I have table with columns id, name, location, address, plan. in those columns i need to insert records form excel. user having a excel with 3 columns col1, col2, col3. on the form i've fetch column headers of excel and in front of that i've provide database column list , so user can match excel column with database column. e.g.
COL1 --> list value of database column
COL2 -->list value of database column
COL3 -->list value of database column
Once user map those column i want to insert those values into my database table (table with columns id, name, location, address, plan). and i am confuse about this code.
i'm using db and forms 10g. i want the output of the form to be embedded within a simple html page. lets say i want the html page to be divided into three frames. the uppermost horizontal frame will hold a banner (say). the left vertical frame will hold some advertisement (say).
(1) now the rest of the page will be covered by the third frame in which the fmx's will run.
(2) i want the login.fmx (startup form) to show up first instead of the servlet. infact the servlet should not show up at all.
I am working on a simple form which will get the user to fetch required columns of employee master.
For that i have created a form which will display the column names and select option. When user clicks on query, the form will display the selected columns in a block. After going thru if required the user can download it to excel.
As of now I do not have filtering option. For this I thought of creating view based on the selection and then fetch records from the view and display it in form.
To achieve this I would like to know How I create or replace a view dynamically based on values selected. I remember doing this sort of thing long back, but could not recollect it.
Any utility that will take in a string and then search through multiple Oracle Forms and Reports modules (.fmb, .rdf, .mmb, .plx, etc). simultaneously to find which modules have strings that match the search criteria ?
To do this on an individual form is easy enough using the Oracle Forms Developer editor however I have over 100 Forms and reports.
I would like need a utility that will search all Oracle Forms in a given directory without having to actually open a Form(s) in the Oracle Forms Developer editor and then report which Forms may contained the sought after string.
How to Know Operating System Current Path in oracle 10g forms ?
View 4 Replies View RelatedI would like to Center Align application login page(Syslogin) oracle froms 11gr2. The below code is not working in forms 11g2, it's working in Forms 6i
PROCEDURE CenterWindow (win_name VARCHAR2) IS
w_mdi NUMBER;
h_mdi NUMBER;
w_win NUMBER;
h_win NUMBER;
[code]...