Forms memory consumption
The Following query is to get the memory consuming forms sessions. #!/bin/sh ALLPROCS=`ps -ef|grep “f60webmx webfile=” | grep -v grep | tr -s ” ” | cut -f3 -d” “`…
Read MoreMandatory checklist – post clone of EBS
The following query will give the values of some important parameters to be considered post clone. SELECT e.profile_option_name Profile, e.profile_option_id, f.user_profile_option_name User_Profile_Name, c.application_short_name, decode(a.level_id,10001,’Site’,10002,’Application’,10003,’Resp’,10004,’User’) LevelSet_At, decode(a.level_id,10001,’Site’,10002,c.application_short_name, 10003,b.responsibility_name,10004,d.user_name) LValue, nvl(a.profile_option_value,’Is Null’)…
Read MoreHow to get supplier ID and supplier site ID for the Isupplier login.
BEGIN SELECT DISTINCT assa.vendor_id,LISTAGG(assa.vendor_site_id, ‘,’) WITHIN GROUP (ORDER BY assa.vendor_id) INTO v_vendor_id,v_vendor_site_id FROM ak_web_user_sec_attr_values aw, ap_supplier_sites_all assa WHERE aw.web_user_id = FND_GLOBAL.USER_ID AND aw.attribute_code = ‘ICX_SUPPLIER_ORG_ID’ AND assa.vendor_id = aw.number_value AND…
Read MoreHow 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.sql.Connection; import java.sql.SQLException; import java.sql.Statement; import oracle.apps.fnd.common.VersionInfo; import oracle.apps.fnd.framework.OAApplicationModule; import oracle.apps.fnd.framework.OAViewObject; import oracle.apps.fnd.framework.server.OADBTransaction; import oracle.apps.fnd.framework.server.OAViewDef; import oracle.apps.fnd.framework.webui.OAControllerImpl; import oracle.apps.fnd.framework.webui.OAPageContext; import oracle.apps.fnd.framework.webui.beans.OAWebBean;…
Read MoreHow 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.VersionInfo; import oracle.apps.fnd.framework.OAException; import oracle.apps.fnd.framework.webui.OAControllerImpl; import oracle.apps.fnd.framework.webui.OAPageContext; import oracle.apps.fnd.framework.webui.beans.OAWebBean; import oracle.cabo.ui.data.DataObject; import oracle.jbo.domain.BlobDomain; import java.sql.PreparedStatement; import java.sql.Connection; import javax.xml.bind.DatatypeConverter; /** *…
Read MoreHow to Call Prepared Statement in OAF
import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; try { Connection conn = pageContext.getApplicationModule(webBean).getOADBTransaction().getJdbcConnection(); String Query = “SELECT count(*) count from RCV_HEADERS_INTERFACE where INTERFACE_HEADER_ID=:1 and ASN_TYPE=’DARFT_ASN'”; PreparedStatement stmt = conn.prepareStatement(Query); stmt.setString(1, project_id);…
Read MoreHow 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 MoreHow 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 MoreReceivables Party Site details Extract script in R12
receivables_party_site_details_along_with_location This script useful to extract all the AR party site details with location and account details as well as address details that will deliver invoice payment to customer
Read MorePurchase Order meta data details extract in R12
meta_data_po_deatils_on_specific_dates This script is useful to get all the details of purchase order with requisition details item details item category along with buyer details on specific dates
Read More