How to terminate instance number in Install Base
Using below script we can terminate instance number in Install Base. UPDATE csi_item_instances SET active_end_date = SYSDATE WHERE instance_id = l_instance_id;
Read MoreJava script validation in OAF
By using below java script in OAF. we can validate based on field value and can throw error. var colspt2 = ‘quoteValidate’.split(\”^\”); for (var k = 0; k < colspt2.length…
Read MoreHow to set default value for Message Text Input
By using below command in controller, we can able to set default value to message Text Input. import oracle.apps.fnd.framework.webui.beans.message.OAMessageTextInputBean; public void processRequest(OssAPageContext pageContext, OAWebBean webBean) { super.processRequest(pageContext, webBean); String…
Read MoreSubmission of Concurrent request from OAF
Consider a scenario like we need to submit a concurrent request when submit button in clicked. Code to submit concurrent request should be added in AM so that it can…
Read MoreStale Data Error in OAF
Sometimes when we perform multiple transactions to EO, we may get error like below. Solution: Open the EO of the table. Navigate Attribute property of the primary key of the…
Read MoreHow to add Jar files to JDeveloper
In this post we are going to discuss how to add jar files to JDeveloper. First we need to download required jar file, after that you need to follow the…
Read MoreMessage Component Layout in OAF
If we have an requirement to fix the number of the Columns displays for a single row in in the OAF region then we can use Message component layout. In…
Read MoreVO Extension Error — Attribute set for comments in View Object VO failed
Once we did VO Extension & migrated those files into server. Post that we may face this type of error Attribute set for comments in View Object VO failed. Solution:…
Read MoreHow to raise bundle exception in OAF
If we want to display multiple error messages in OAF page. We need to use the code as follows: arraylist errmsg = new ArrayList(); if(pageContext.getParameter(“Type”).equals(“”)) { errMsg.add(new OAException(“Type cannot be…
Read MoreSetting NLS language in SQL developer
Sometimes we will observe HR Operating units table will not show any data in database. For this we need to do the set up in SQL Developer. Preferences –> NLS…
Read More