Forms :: How To Disable Function Key F4 In 6i
Feb 22, 2012How to Disable Function key F4 in forms 6i for example in forms i want that no body copy full row with F4 Key pls guide me where to apply key F4 trigger in forms.
View 1 Replies
ADVERTISEMENT
Forms :: Disable Function Keys In 6i?
Apr 3, 2006how to disable function keys in forms6i(i.e., i want to deactivate the default function keys when running a form)
View 5 Replies View RelatedForms :: Radio Box Disable
Dec 1, 2010I have a Radio Box Item field in Form, It contain Three Radio Buttons.
During the User Login Some of the users Not Require to Touch Any of the Three Radio. Thus i Require to Disable that Radio Button to That User. How to Disable the Particular Radio Button.
Forms :: How To Disable Shift+ Tab
Jul 22, 2010I wanna disable shift+tab key function not to be able to go to previous item. What should I do?
View 1 Replies View RelatedForms :: Disable The Commutation Tab?
May 11, 2011the software i use in oracle 10g is for calculating the pensionary benefits. Those who retire voluntary or on superannuation gets pension, commutation and gratuity.
for those death cases only family pension and gratuity is eligible.
my problem is when i give the pension case as family pension the commutation tab also gets visible and it allows the users to enter values for commutation even though they are not eligible.
i would like to know if i can disable the commutation tab once i enter the pension case as family pension.
Forms :: Disable Save Button In 6i
Jul 22, 2011I am working on form 6i. I want to disable the 'SAVE' button which can be seen in the menu (front end).
View 2 Replies View RelatedForms :: Disable Fields Using Personalization
Oct 2, 2010I am working on Oracle Apps 11i. Need Forms Personalization.
Client requirement: Selected user should only see Office Phone Number for all the people in the organization when he enters the Phones form.
Means, the client is having around 10 Lookup values for Phones (Like Mobile (Office), Mobile (Personal), Office (fax), Office No. etc). Now, they want to give access to admin, only to update the Phone numbers related to Office. So, when the admin logs-in to the phone form of a employee, that admin should not be able to see other phone numbers of that Employee.
Is it possible using Forms Personalisation?
Forms :: How To Disable Radio Button
Jul 16, 2013I have some doubts about Radio buttons,
1) how to validate radio buttons in WHEN-RADIO-CHANGED?
2) how to disable a radio button?
3) how to disable a text item when a radio button is un-checked.
4) how to assign default value to radio button like(1,2,3...) or(A,B,CD,...)
Forms :: Disable SAVE Button
Apr 20, 2010I have created a form using data block wizard and lay out wizard. I want to disable the SAVE button, I gave the following in Triggers WHEN-NEW-FORM-INSTANCE
set_item_property('SAVE',visible,property_false);
but when I run the form it displays this message at the bottom of the screen
Frm 41045:Cannot find item invalidID.
Forms :: Disable Menu - Code Not Working?
Nov 19, 2011i tried to disable menu but the code didnt work.My
Procedure Pu_Check_Open_Form_Prc(Pv_Menu_Code Varchar2) Is
vn_open_pvg Number(1) := 0;
vm_menu_id MenuItem;
Begin
Begin
[code]...
and my menu in the attached pic.
Forms :: Enable Or Disable Current Item In Block?
Feb 1, 2011I have one tabular block on the canvas and there is one check box on this block. I want that when I uncheck this checkbox, one item on the current record gets disabled.
i manage to turn all the records enabled or disabled.
I am attaching a dummy form in which I have tried. Checkbox is acting on field :ecc_no.
The DB table for the same is:
CREATE TABLE ECC_MASTER
(
PARTY_TYPE CHAR(1 BYTE) NOT NULL,
PARTY_CODE CHAR(5 BYTE) NOT NULL,
ECC_NO VARCHAR2(25 BYTE) NOT NULL,
RANGE_DIVISION VARCHAR2(30 BYTE),
EMP_NO NUMBER(4) NOT NULL,
[code]....
Forms :: Enable / Disable Menu Items For Different Users?
May 14, 2011Enable / Disable menu items for different users.
how to create different users give in demo files i am using 10gforms.
Forms :: How To ENABLE / DISABLE Item Dynamically During 6i Runtime
Mar 24, 2012I have a master-detail form showing multiple records (tabular) in data-block. Now my problem is, based on certain column's value of a particular item in a particular row on the data-block to ENABLE/DISABLE during run-time .
For example, in a detail-block of 5 rows, if 3rd row's 'detail-block.item1' is equal to lets say, "X", then 'detail-block.item2' of that particular row ONLY must be 'disabled'. otherwise, it must 'enable' the 'detail-block.item2' of that particular item in that particular row on the data-block.
Even when, I query the form, it must enable/disable that particular item of that particular row from the data-block based on item1's value.
Forms :: Disable Save Button After The Sequence In Generated?
Feb 2, 2013i have master-detail form in which i am generating sequence number as my bill no. on save button.
i want to disable save button after the sequence in generated.
Forms :: How To Use ALTER TABLE Command To Disable / Enable Constraints
Aug 11, 2010can you use alter table command to disable/enable constraints in a form if you can how, if you cant why
View 4 Replies View RelatedForms :: How To Disable Single Record In Multi Non-database Block
Mar 28, 2011The main qn is in the subject line.
I have used the following code
GO_BLOCK('CHILD_BLK');
FIRST_RECORD;
LOOP
IF NVL(:CHILD_BLK.SELECT_FLAG,'N')='Y' THEN
V_REC_NO := GET_BLOCK_PROPERTY('CHILD_BLK',CURRENT_RECORD);
SET_ITEM_INSTANCE_PROPERTY('CHILD_BLK.ASSET_DESC',
V_REC_NO,
[code]....
Forms :: How To Enable / Disable Keyboard Shortcuts In Oracle Apps
May 12, 2010How do we need to enable or disable the keyboard shortcuts in Oracle Apps like Shift+F6 for duplicate record, also how do I change the functionality, I mean suppose I want Key-M to do the same function as shift+F6.
View 2 Replies View RelatedForms :: Disable Mouse Navigation On Data Block Or Text Item?
Jul 15, 2011I am trying to disable mouse navigation on data block or text item,. What i want is to my text items in specified block be keyboard navigable only.
The problem is that i don't have that option on text_items or data block (my conclusion: probably because it is not possible to change mouse navigate option for text item or data block).
I have also tried in WHEN-NEW-BLOCK-INSTANCE trigger
set_item_property('block.item', mouse_navigate, property_false)
and
set_block_property('block', mouse_navigate, property_false)
and of course it did not work.
Forms :: How To Use AS_TO_CLIENT Webutil Function
Nov 3, 2009how to use the AS_TO_CLIENT webutil function? The WebUtil User's Guide doesn't give examples. It just gives a description of what the function does:
Quote:AS_To_Client Transfers a file from the application server to the client. The webutil.cfg parameter transfer.appsrv.enabled must be set to true to use this function, and if the transfer.appsrv.accessControl parameter is also set to true, the upload target directory must be listed in the transfer.appsrv.read. list. It is sensible to call the WebUtil_File_Transfer_IsASReadable function with the target filename before starting the download to ensure that you will be able to read from this location on the application server.
Forms :: Frm-41009 Function Key Not Allowed
May 1, 2012i create form,when i press F11, it displays this error:Frm-41009 function key not allowed ,press ctrl+k for list of valid values.And i can't enter value into fields to query records.
View 11 Replies View RelatedForms :: Practical Explanation About Function
Jan 10, 2011Can u explain me these function with practical example..so i get it...
1) FORMS_DDL
2)POST-QUERY
3)POST-BLOCK
Forms :: 6i (FORMS_DDL Used To Create A Function)
Sep 8, 2011I am using a form which create function to calculate value using form_ddl. When I used this program from superuser it will calculate correct value but in other user it calculate wrong value. I gave 'Create Procedure ' privilege to user too.But still problem exist.
View 3 Replies View RelatedForms :: Why Function Keys Are Not Working In 9i
Dec 27, 2012why function keys are not working in forms9i?
Like whenever I press F7 for query or F8 to fetch records or F10 to save records they are not functioning.
Dba_Jobs Disable Script
Aug 2, 2010I am trying to get a working script that could just go and mark all dba_jobs to BROKEN ==> TRUE
"execute dbms_job.broken(jobno,true)" using a pl/sql script
I have the working structure of the script except for the fact that the goal is not achieved. I came to know that the ALTER SESSION SET CURRENT_SCHEMA does not take effect when used with the DBMS_JOB API.
Is there an alternative I can get this working.
CODE<--------- part of the script : START
FOR l_job_users IN job_users LOOP
execute immediate 'alter session set current_schema='||l_job_users.LOG_USER;
DBMS_OUTPUT.PUT_LINE(current_user);
FOR l_jobs IN jobs(l_job_users.LOG_USER) LOOP
[code].....
Enable / Disable Auditing From PHP
Dec 15, 2010In PL/SQL Plus, i can enable/disable auditing when i connect as sysdba by using these command:
SQL> ALTER SYSTEM SET audit_trail=db SCOPE=SPFILE
SQL> shutdown
SQL> startup
I've done it successfully with PL/SQL Plus command line. But in PHP, how can i do that?How to execute "shutdown" and "startup" from PHP?
I've found this code for connect to oracle as sysdba:
oci_connect("/", "", null, null, OCI_SYSDBA);
From the following link:
[URL]......
But, i still can't execute "shutdown", "startup";
Security :: How To Disable Sql Login
May 28, 2012How to disable a user's sql login? To ellaborate, I want a user to login through a certain application only with his userid on database level & not through "sqlplus username@dbname".
Is it possible? If no, then what can be done to achieve below.
I have a userid which has all the update, delete privileges on it. That id needs to be configured in the application alongwith the password. So in order to avoid misuse of that id I want to block its sql access.
I am not sure whether this can be achieved or not.
SQL & PL/SQL :: Disable Oracle 11 Audit (AUD)
May 31, 2012is it possible to disable audit logging (audit_file)? (Ora 11)
View 27 Replies View RelatedHow To Disable FlashcacheMode - Writeback
Nov 1, 2012I'm trying to disable the new write flash cache feature that came with the latest Exadata patch on our Quarter RAC X2-2
The procedure i'm trying to follow is as described below:
1. CellCLI> alter cell flashcache all flush
2. CellCLI> drop flashcache
3. CellCLI> alter cell shutdown services cellsrv
4. CellCLI> alter cell flashCacheMode=Writethrough
5. CellCLI> alter cell startup services cellsrv
My problem is that when i'm running 1. i receive a syntax error.The only doc i could find describing how to go back from WriteBack mode is[URL]...
SQL & PL/SQL :: How To Disable Procedure On Oracle
Oct 18, 2010how to disable procedure on oracle
View 3 Replies View RelatedDrop Or Disable A Scheduled Job
Oct 11, 2012I have a job running under HUMADM user and would like disable or drop it.I do not have the login credentials of HUMADM user but can log into the database as system/sys user.
When I run the below commands as sys/system user it says humadmjob must be a job or it is not running.This is because it is looking for the job under sys/system user.
exec DBMS_SCHEDULER.drop_job (job_name => 'humadmjob');
exec DBMS_SCHEDULER.stop_job (job_name => 'humadmjob');
SELECT owner, job_name, job_class, enabled FROM dba_scheduler_jobs;
OWNER JOB_NAME JOB_CLASS ENABLED
====== ========= ======= ======
HUMADM HUMADMJOB DEFAULT_JOB_CLASS TRUE
how to stop/disable this job? My oracle version is Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi