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…
Read MoreCustomall.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
Read MoreAdding new row at bottom of the where have clicked Through OAF
public void processFormRequest(OAPageContext pageContext, OAWebBean webBean) { super.processFormRequest(pageContext, webBean); OAApplicationModule am=(OAApplicationModule)pageContext.getApplicationModule(webBean); OAViewObject vo = (OAViewObject)am.findViewObject(“XXAddRowVO1″); String refpono=””; if(“AddRowEvent”.equals(pageContext.getParameter(“event”))) { int rs=0; String rowRef1 = pageContext.getParameter(“evtSrcRowRef”); OARow Porowref = (OARow)am.findRowByRef(rowRef1); refpono=Porowref.getAttribute(“Segment1”).toString();…
Read MoreDeleting Lines based on conditions through OAF
if (“DeleteEvent”.equals(oapagecontext.getParameter(“event”))) { String rowReference = oapagecontext.getParameter(EVENT_SOURCE_ROW_REFERENCE); OARow currRow = (OARow)oaapplicationmodule.findRowByRef(rowReference); String QuantityShipped =(new StringBuilder()).append(currRow.getAttribute(“QuantityShipped”)).append(“”).toString(); System.out.println(“QuantityShipped in DeleteEvent”+QuantityShipped); if(QuantityShipped.equals(“null”)) { currRow.remove(); oadbtransaction.commit(); throw new OAException(“Record Sucessfully Deleted”, OAException.CONFIRMATION); } else…
Read MoreCalling Concurrent Program in OAF
public void submitRequestPKS(OAPageContext oapagecontext, OAWebBean oawebbean, String s, String s1) { OAApplicationModule oaapplicationmodule = oapagecontext.getApplicationModule(oawebbean); OAException oaexception; try { OADBTransaction oadbtransaction = oaapplicationmodule.getOADBTransaction(); Connection connection = oadbtransaction.getJdbcConnection(); ConcurrentRequest concurrentrequest =…
Read MoreInvoice 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 AND LINE_TYPE_LOOKUP_CODE = ‘AWT’), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30) ) invoice_amount, AI.INVOICE_DATE, TO_CHAR…
Read MoreDelete 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…
Read MoreOAF 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
Read MoreFinding Source Code for Java Class Files
JAD is one of the tool for getting source code the java classes.
Read MoreHow 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.
Read More