Forms :: Where To Set Auto Refresh On Custom Form
Dec 14, 2010How and where to set Auto Refresh on Custom Form ...?
View 1 Replies
ADVERTISEMENT
Forms :: Want To Call Web Form For Uploading Image From Custom Form
Apr 16, 2013I want to call a Web form which should upload the image from my local machine.For that I have created a form which will take necessary data about employee now I want to Insert Image for that employee into table as I am new I struct on the Image uploading form. Latter I have seen the Enter & Maintain form which have Picture button.Pressing this button we get one new web form open & we can upload our image from there.
View 1 Replies View RelatedForms :: Auto Refresh When Data Updated
Apr 19, 2010i need a code to auto refresh or after 1 minute in form & report when the data is updated. basically i am deploying the plasma tv in hall so executive can see the status report where they need its going to be like a stock system multiple forms or reports sticky dynamically change .
View 2 Replies View RelatedForms :: FRM-47023 - No Such Parameter Exists In Custom Form XYZ
Mar 6, 2012Getting error FRM-47023: No such parameter named CHART_OF_ACCOUNTS_ID exists in our custom form XYZ
View 5 Replies View RelatedForms :: Develop A Custom Form Which Is Not Related To Oracle Apps
Oct 15, 2010I wanted to develop a custom form which is not related to oracle apps. I don't want to login to oracle and use the form. I wanted it to be like standalone form (use it as a tool) where I can automate the process of migrating the code from one instance to another, on click of button. Can I create standalone form and run without logging to oracle?
View 1 Replies View RelatedApplication Express :: Auto-Close Modal Page When Nothing Is Changed In The Form
Jul 15, 2012I am using Skilllbuilders modal page 2.0 to edit the form. Sometimes, the end user clicks on the edit link to trigger the modal page and sees the form , but he/she could not do any changes. Thus, when clicking Apply Changes button, we will be redirected to the page 102 ( the empty page ). How can I get around and make the page 102 to close automatically in case I am redirected to it ?
I put this in a JavaScript a dynamic action to be fired as page loads:
$(document).apex_modal_page('close');but nothing happen.
Application Express :: Auto Populate Phone Number Based On Select List In Tabular Form
Dec 27, 2012Ive a requirement which ive overlooked for a while now as below,
On my tabular form i have fields: Empid as Select List and when the value is picked from this Select List EmpID i want the associated/corresponding phone# displayed in its TEXT FIELD in that same row,
apex 4.1.1/Oracle 11gR2,
also i tried the below as a workaround but it doesnt fulfill my requirement, [URL]....
Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW
Apr 17, 2012I cann't commit form when new instance form with form status is "NEW".
And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"
And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.
Forms :: Insert Record Into Lov Through Oracle Custom Forms?
Oct 8, 2013I have a LOV in a custom oracle forms.this lov is linked to a record group.
Presently the column on which lov is created does not contain any value.
I want to insert value into the lov through the forms.
I am not able to insert data into it through forms
Forms :: Add Some Custom Image On A Button?
Dec 7, 2010Is it possible to add some custom image on a button?
If so, How to do it?
Forms :: Navigation Between Forms Via Custom-menu?
May 23, 2011what is the basic workaround to provide to switch from one form to another form via custom-menu at runtime?
I attached a menu-item to every of my forms and I can call them seperately from the forms builder. But I am not able to switch between the forms then. If I am clicking on a menu-item, I get frm-40010.
P.S. I'd prefer to close the current form, if the new form has been opened. Do I have to control this seperately or is the closing of the last form default?
Forms :: Change Block Status In Custom.pll?
Mar 9, 2010I have a requirement to get decrypted value of national_identifier from database and display in Social Security number, when user queries for employee in employee form of HRMS. Also, National_identifier should be in encrypted format in database table always.
To meet above requirement, I am using custom.pll. In WHEN-NEW-BLOCK-INSTANCE I am getting decrypted value of national_identifer from database and assigning it to :person.national_identifier(database block) by using COPY function, so far it is working as expected.
When user query for employee, he/she able to decrypted value. but if user closes the form it is asking 'Do you want to save changes you made' as there is a change in :person.national_identifier.
Do we have any property to reset record/block status to something like unchanged, so we will not get 'Do you want to save changes you made message'.
Forms :: Compare Value Which Is Taken In Custom Block By User
May 26, 2010i have created one custom block in that i am taking one value in text_item and on 2nd form i have data block on that block i want filter by using WHERE clause
in that where clause i want to compare value which is taken in custom block by user..what need to write in where clause?
Forms :: Test Custom Jar Files With 6i From Desktop?
Dec 18, 2010I want to test custom Jar files with Forms 6i from my desktop, but I cannot get the Run Form->Web to work. Is it possible for the run time to load the just jars for PJC when you do Run Form -> Client/Server? So far, when I have done this, it does not execute any PJC.
View 2 Replies View RelatedForms :: How To Implement Custom Lov Button Without The Standard Template.fmb
Jul 4, 2010i am developing a application using oracle forms 10g. i can't use the standard template.fmb because my application does not run in ebs. there comes the problem: i want to implement the lov button function like the template does, such as :
1. when the text item get focus, lov button display.
2. when the text item lost focus, lov button disappear.
3. when scrollbar scrolls, the position of lov button adjust accordingly.
4. there is only one lov button in one form and the lov button was created dynamically.
Forms :: Using PIPELINED Return Inside Custom Library
Jun 5, 2013I would like to know if it's possible to use PIPELINED return inside a custom library with Oracle Forms Builder? For now, i try to use it, but i get error about client side.
my code.
PACKAGE TEST IS
TYPE measure_record IS RECORD(
l4_id VARCHAR2(50),
l6_id VARCHAR2(50),
[code].......
the body compile, but not the other part. I would like after call the select * from test.get_ups(0); with a cursor into another function.
Forms :: Custom ORDER BY In Multi-record Data Block
Jun 15, 2011I have data block that has hundreds of records. On a screen I display 20 records at a time. On that same screen I have "find badge" function where user types badge/employee id and presses a button to find the record in a data block. I have no problem finding the records in a list and pointing the curser to appropriate record. My question is (which is a user request) if the badge/employee id is found to make that record to be the first record in a list.
View 2 Replies View RelatedForms :: LOV / Auto Select Values
Apr 13, 2012I have an LOV on my form which holds a list of course units for a student to select and insert. However some units on the LOV must be COMPULSORY(not optional).... so i was wondering is there a way to have these auto selected from the LOV?
View 4 Replies View RelatedForms :: Opening Form Has Attached Libraries Caused Form Close
Jul 19, 2010If I open a form has attached libraries in form builder on windows7 it closed and give this message :
Problem signature:
Problem Event Name:APPCRASH
Application Name:frmbld.exe
Application Version:10.1.2.0
Application Timestamp:42d63632
Fault Module Name:KERNELBASE.dll
[code]......
Forms :: How To Reload Calling Form After Closing Called Form
Jul 15, 2007I have FORM_A calling FORM_B: Call_form('FORM_B',...). On form_B I am updating a Record and when I close Form_B and the focus goes back to Form_A, I need to Automatically Reload Form_A to reflect the changes that were made on Form_B.
How can I reload the Calling Form (FORM_A) when I closed the called form (FORM_B)?
Forms :: Auto Stretch Functionality In Oracle?
Oct 6, 2013Is it possible to have auto stretch functionality (similar to Oracle ADF) in Oracle Forms?
The requirement is to adjust the data blocks/ canvases according to the window size automatically.
I know it is possible in Oracle ADF. But I want to achieve the similar kind of functionality in Oracle Forms.
Replication :: Cannot Fast Refresh Truncated MV Even After Complete Refresh
Aug 14, 2010I am getting ORA -32320 when I tried to fast fresh MVs that were truncated.I am able to complete refresh all MVs. However, some MVs are still giving me ORA-32320 when I try to do fast refresh even after complete refresh.
DBMS_MVIEW.EXPLAIN_PLAN says the MVIEW can be fast refreshed.
ERROR at line 1:
ORA-32320: REFRESH FAST of "dev"."Claim_line" unsupported after cointainer table
PMOPs
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 841
ORA-06512: at line 1
Quote:ORA-32320:
REFRESH FAST of "string"."string" unsupported after container table PMOPs Cause: A Partition Maintenance Operation (PMOP) has been performed on the materialized view, and no materialized view supports fast refersh after container table PMOPs. Action: Use REFRESH COMPLETE. Note: you can determine why your materialized view does not support fast refresh after PMOPs using the DBMS_MVIEW.EXPLAIN_MVIEW() API.
how to again make the MVs fast refreshable?
Forms :: 2 Different Form To Pass Values From One Form To Another
Mar 11, 2010is there any type of veriable used in declate statement whith could be used in 2 different form to pass values from one form to another.
View 1 Replies View RelatedForms :: Auto Populating Records In Other Fields Based On Inventory Number Field
Jul 13, 2011I am having a problem with auto populating different fields based on inventory no. field.. This is a bug giving to me to work on and i not able to figure out how to populate the other fields.
How to set any triggers for the items to auto populate and i am suppose to finish this work today.
Forms :: Refresh Datablock After DML Operation
May 19, 2010How do you refresh a datablock after DML operation(s) - INSERT, UPDATE or DELETE? I know "EXECUTE_QUERY" retrieves records, but what trigger do I use to automatically refresh the datablock after these operations - my form only has 1 datablock.
View 3 Replies View RelatedForms :: Refresh Tree After DML Operation
Jan 24, 2012I have created the 5 Level Hierarchy Tree using the Tree example
[URL]........
how-to-s/ forms- how- to- create - a- hierarchical - tree-form".
My requirement are
1. I wish to refresh the Hierarchy Tree after DML Operation.
2. I wish to Query the Record when i will select the node.
I have 5 Master Detail Record as:
Master - Detail
Detail Master -- Detail
Detail Master -- Detail
Detail Master -- Detail
Detail Master -- Detail
3. Is there any way to find out which Hierarchy Level currently selected
4. Is there any way to find out which value is for what block.
Forms :: Any Way To Load A Form Within A Form
May 21, 2010I have a requirement, is there any way i can achieve the following User Interface using oracle forms
Left Pane: Navigation (Tree Menu)
Right Pane: Based on the node clicked in the Tree Menu, a specific form will be loaded on the right.
The tricky part, is there any way i could load a form within a form ? If i make use of OPEN_FORM, it will open a form in its own window.
Forms :: How To Open Another Form Within A Form
Dec 20, 2012I want to convert my forms6i application into forms9i therefore I initially converted my login and explorer form.
In my login form, I am using NEW_FORM to close my login form and wants to activate my explorer form but every time a pop-up raised and asked "DO YOU WANT TO CALL THE NEW FORM?", if I pressed YES then pointer moved to explorer form.
This form is working perfectly in 6i and didn't asked anything and moved to successfully to explorer form.
Forms :: Pre-form And When-new-form-instance?
Mar 1, 2010What is the difference and significance of
1) Pre-form and When-new-form-instance?
2) Post-text-item and When-validate-item?
Forms :: Refresh Detail Lines When Header Changes?
Oct 21, 2010My issues is when I changes the data in Header block the detail block should corresponding data immediately related to header on the detail lines.
The form is based on master detail relationship.