Friday 11 July 2014

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. 

1 comment:

  1. Oracle Forms Management Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/oracle-forms-management-online-training-126.html The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, IT Support, Corporate Training institute in India - +919000444287 - +917386622889 - Visakhapatnam,Hyderabad Oracle Forms Management Online Training, Oracle Forms Management Training, Oracle Forms Management, Oracle Forms Management Online Training| Oracle Forms Management Training| Oracle Forms Management| "Courses at 21st Century Software Solutions
    Talend Online Training -Hyperion Online Training - IBM Unica Online Training - Siteminder Online Training - SharePoint Online Training - Informatica Online Training - SalesForce Online Training - Many more… | Call Us +917386622889 - +919000444287 - contact@21cssindia.com
    Visit: http://www.21cssindia.com/courses.html"

    ReplyDelete