Disable Forms Personalization in oracle

Two Way to Disable,

Step 1:-

(i)   Log in EBz
(ii)  Go to the particular form

(iii)  Open form personalization  





Using the Enabled check box, We can Enable / Disable

Step 2:

Update back-end.

 

Based on this Role id we select the Action is

select * from fnd_form_custom_actions where RULE_ID = 761 

 
 
Sometimes when you are developing a Forms Personalization it will error out before the form is opened. When this happens you cannot disable custom code to get the form to open and fix the problem.

The easiest way to fix this is to disable it directly in the core table.

Write Update Condition :-
 
/* Formatted on 7/11/2014 8:52:42 AM (QP5 v5.115.810.9015) */
UPDATE fnd_form_custom_actions
SET enabled    = 'N'
WHERE action_id = :action_id;

Now your form will open and you can fix the problem.