Posts by Brahmaiah kolla

How to call external URL from OAF

public void processRequest(OAPageContext pageContext, OAWebBean webBean) { super.processRequest(pageContext, webBean); String ExternalUrl = pageContext.getParameter(“ExternalUrl”); if ((ExternalUrl != null) || (!””.equals(ExternalUrl))) { String extrnlurl = “function externalurlfunc(){document.location='”+ExternalUrl+”‘;}”; OABodyBean bodyBean = (OABodyBean)pageContext.getRootWebBean(); pageContext.putJavaScriptFunction(“externalurlfunc”,…

Read More

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”, getOADBTransaction().getSequenceValue(“XXASN_HEADER_SEQ”).toString());

Read More

VO Row Iterator in OAF

OAApplicationModule am = oapagecontext.getApplicationModule(oawebbean); OADBTransaction oadbtransaction = am.getOADBTransaction(); OAViewObject XXDraftASNLineEOVO = (OAViewObject)am.findViewObject(“XXDraftASNLineEOVO1”); if (XXDraftASNLineEOVO!= null) XXDraftASNLineEOVO.reset(); while (XXDraftASNLineEOVO.hasNext()) { OARow XXDraftASNLineEOVORow = (OARow)XXDraftASNLineEOVO. next (); XXDraftASNLineEOVORow.setAttributes String XXAsn=(String)XXDraftASNLineEOVORow.getAttribute(“XXASN”); XXDraftASNLineEOVORow.setAttribute(“XXASN”,”ASN”); }

Read More

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

Read More

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=(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 More

Deleting 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 More

Calling 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 More

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 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 More

Query For PO Acceptance Details

SELECT DISTINCT pha.vendor_id, hou.name “Organization”, pha.segment1 “po number”, pla.line_num “po line num”, (TRUNC (pha.creation_date – TO_DATE (’01-01-1900′, ‘DD/MM/YYYY’)) + 2) as “PO creation Date”, aps.vendor_name “Supplier Name”, apss.vendor_site_code “Supplier site”,…

Read More

Eligible Po Details for Supplier Wise

SELECT * FROM (SELECT POH.SEGMENT1 PO_NUMBER, PRL.RELEASE_NUM RELEASE_NUM, DECODE ( PRL.PO_RELEASE_ID, NULL, POH.clm_document_number, POH.clm_document_number || ‘-‘ || TO_CHAR (PRL.RELEASE_NUM) ) DISPLAY_PO_NUMBER, POL.LINE_NUM LINE_NUM, POL.ITEM_ID ITEM_ID, POL.ITEM_REVISION ITEM_REVISION, POL.ITEM_DESCRIPTION ITEM_DESCRIPTION, POL.VENDOR_PRODUCT_NUM…

Read More