Blog / Category
OAF
33 articles in this category
Display the multiple errors in OAF
import com.sun.java.util.collections.ArrayList; import oracle.apps.fnd.framework.OAException; import oracle.apps.fnd.common.MessageToken; ArrayList errorMsg= ne…
How to change the column header dynamically in advance table.
To change the column of a header dynamically use the following code in your controller. import oracle.apps.fnd.framework.webui.beans.table.OAAdvancedTableBean;…
How to write DDL statement in OAF
By using below script we can perform ddl statement in Application Module. public void OTCancel() { OnetimeVOImpl delvo = getOnetimeVO1(); Row row[] = delvo.getA…
Invalid Column Type error in OAF
This error occurred in OAF when I added the new export button to table layout region. For this error just right click on our VO (View Object) and select Edit. T…
How to disable field based on parameter value
By using following script we can get parameter value in page level. Based on value we can set rendered property for the fields as follows: public void processRe…
OAF Error – Unable to set binding parameter that does not exist
Introduction: This blog discusses on one of the causes for the issue “Unable to set binding parameter that does not exist ” Cause of the Issue: In OAF , our eBS…
How 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 below st…
Message 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 this layo…
VO 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. Solut…
OAF Date Converter, Formatter and Validation – Reusable Methods
Various Date Converter, Formatter and Validations Reusable Methods in OAF /**=============================================== * Methods related to Date Operation…
How to call Workflow from OAF
We can call Workflow in 2 ways from the OAF 1) Using PL SQL Procedure, call procedure from OAF page using callable statement. CREATE OR REPLACE PROCEDURE start_…
How 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(“…
How to display the columns based on select query dynamically
package xxdynmcdata.oracle.apps.pos.project.webu; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.s…
How to Convert to Base64formate
package XXBlob.oracle.apps.pos.xxit.webui; import java.io.File; import java.io.FileOutputStream; import java.io.InputStream; import oracle.apps.fnd.common.Versi…
How to Call Prepared Statement in OAF
import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; try { Connection conn = pageContext.getApplicationModule(webBean).getO…
How to call external URL from OAF
public void processRequest(OAPageContext pageContext, OAWebBean webBean) { super.processRequest(pageContext, webBean); String ExternalUrl = pageContext.getParam…
How to assign Database sequence to VO
Assign DB sequence value to VO OAViewObject ASNvo = (OAViewObject)findViewObject(“XXASNDetailsVO”); OARow row = (OARow)ASNvo.first(); row.setAttribute(“ASNId”,…
Special characters validation
For any field if you want throw any exception when entered any special characters. We need to use following pattern to find. Pattern p = Pattern.compile(“[^a-zA…
500 Internal error in OAF
Once any environment get refreshed in EBS, a new dbc file will be generated. Some times we will receive 500 internal error. To over come this we need to replace…
Calling External URL in new Tab
When we calling any external URL from OAF page, we need to add destination URI as below. So URL will open in new tab with same browser. javascript:var a = windo…
Displaying Number of characters entered in text field
In OAF page, if user want to know how many characters entered in message text input field. Below is the code we need to use in process request. String cu…
Customall.jar file for OAF
After deploy the code to server we need to generate “customall.jar” file from $JAVA_TOP by using “adcgnjar customall.jar” from the R12.2
Adding new row at bottom of the where have clicked Through OAF
public void processFormRequest(OAPageContext pageContext, OAWebBean webBean) { super.processFormRequest(pageContext, webBean); OAApplicationModule am=(OAApplica…
Deleting Lines based on conditions through OAF
if (“DeleteEvent”.equals(oapagecontext.getParameter(“event”))) { String rowReference = oapagecontext.getParameter(EVENT_SOURCE_ROW_REFERENCE); OARow currRow = (…
Calling Concurrent Program in OAF
public void submitRequestPKS(OAPageContext oapagecontext, OAWebBean oawebbean, String s, String s1) { OAApplicationModule oaapplicationmodule = oapagecontext.ge…
Invoice Details by using Netting tables
SELECT AI .INVOICE_ID, AI.INVOICE_NUM, TO_CHAR ( AI.INVOICE_AMOUNT + (SELECT NVL (SUM (amount), 0) FROM ap_invoice_lines_All WHERE invoice_id = AI.INVOICE_ID AN…
Delete Empty Customization
Same Page is working for one user and is not working for another user. In this case sometimes due to some empty customization this issue will occur. You can run…
OAF Personalization for IFSC Code in Supplier Screen
Below is the document you can download for IFSC Code. oaf-pesonalization-for-ifsc-code-in-supplier-screen
Finding Source Code for Java Class Files
JAD is one of the tool for getting source code the java classes.
How to find out correct version of Jdeveloper
You can find correct jdeveloper version using following link. https://support.oracle.com/portal/ Search as Jdev with OA Extension.
OAMessageChoiceBean
Based on the condition we need to disable message choice in CO. OAMessageChoiceBean DispButtonValue = (OAMessageChoiceBean)webBean.findChildRecursive(“Dispositi…
JPX Import Error
When we do import, sometimes we are facing error as Exception in thread “main” java.lang.NoClassDefFoundError: Then you need to change jpximport.bat and import.…
iExpenses – change the lable name in template
From Sysadmin Responsibility: 1. Navigate to the Functional Administrator responsibility à Personalization. 2. &n…