Oracle Applications E-Learning Lab

Inspect MDS Contents button that shows on OAF web forms (refer below screenshot)after upgrade to 12.2.7 can be hidden through below steps Inspect MDS Contents button will be shown when Diagnostics is enabled. You can hide this  button by setting the following system profile option: FND: Diagnostics = No

Displaying information on ADF is quite simple, You just need to include below code in Managebean class. The below code will display a message when you click on submit button     public String SubmitBtnevt() {         // Add event code here...         // Add event code here...                String inputText1Value =                    (String)resolveExpression("#{bindings.BusinessTransient.inputValue}");                String inputText2Value =                    (String)resolveExpression("#{bindings.PracticeTransient.inputValue}");                System.out.println("inputText1Value" + inputText1Value);                System.out.println("inputText2Value" + inputText2Value); FacesMessage Message = new FacesMessage("Record Selected--"+ inputText1Value+"-"+inputText2Value);              Message.setSeverity(FacesMessage.SEVERITY_INFO);              FacesContext fc = FacesContext.getCurrentInstance();         

I have seen many developers use fnd_request.submit_request to call the concurrent program from the OAF page, which is not only bad practice also makes controller code cumbersome.  Calling Concurrent request is very much simple , you just need to import the relevant classes and pass the program name and Parameters. //Classes to be imported  import oracle.apps.fnd.cp.request.ConcurrentRequest; import oracle.apps.fnd.cp.request.RequestSubmissionException; OADBTransaction tx=  am.getOADBTransaction();        // Initialize the ConcurrentRequest Class java.sql.Connection con = tx.getJdbcConnection();  ConcurrentRequest requestObject = new ConcurrentRequest(con);       //Application Short name under which the calling concurrent program is registered   String applShortName = "XX";       // Calling Concurrent program Short name     String cpName = "XXCONCSHORTNAME";        // Calling Concurrent program Description           String cpDesc = "Progra

When you open any MSCA Page whether seeded or Custom Page, an Organization page gets prompted like shown in below screenshot. To display the Org Access Page we need to import classes in FunctionListener.java and also needs to extend with WMAMenuItemBean ,  For more clarity look into below code Class to be imported in FunctionListener.java import oracle.apps.wip.wma.bean.WMAMenuItemBean; Extending Function class with  " WMAMenuItemBean  " public class XXFunction extends WMAMenuItemBean implements MWAAppListener {    public XXFunction (){     if(UtilFns.isTraceOn) {       UtilFns.trace("Concurrent Program Application constructed successfully"); } setFirstPageName("xx.oracle.apps.aa.xx.concprgm.server.XXPG");      //register first page to be displayed addListener(this); }    public void appEntered(MWAEvent mwaevent){       try{ if(UtilFns.isTraceOn) {       UtilFns.trace("Concurrent Program Application Ente

There is a common requirement in OAF to call PLSQL package from controller class, I'm sharing this code snippet which will help developers to build their logic.  Classes to Import import java.sql.CallableStatement; import java.sql.Types;  Write below code either in processRequest or processFormRequest method  OAApplicationModule am = pageContext.getApplicationModule(webBean); String sql = "BEGIN XX_ORA_PKG.TEST_PRC (:1,:2,:3,:4); END;";  CallableStatement cs =am.getOADBTransaction().createCallableStatement(sql,OADBTransaction.DEFAULT);  try  {  cs.registerOutParameter(1, Types.VARCHAR);  cs.registerOutParameter(2, Types.VARCHAR);  cs.setString(3, SupplierName);  cs. setString (4, SupplierCode);  cs.execute();  String output = cs.getString(1);  cs.close();  }  catch (Exception ex)  {  throw new OAException("Exception: ", ex.toString());  }

“ Cloud Compute Services -Oracle Cloud Infrastructure ” nothing but “IaaS” (Infrastructure as a Service). Currently, Oracle provides three different options which I have described briefly Option One: Single Node on Oracle Compute Cloud Service (IaaS) The single node on a IaaS option consists of an all-in-one Oracle E-Business Suite Release 12.2.X machine image that includes both the application tier and database tier. This is available on Oracle Cloud Marketplace along with its updated features, so you can quickly provision the latest image to explore new features. This feature also enables you to deploy a Standalone database, WebLogic servers etc. on IaaS. Suitable for Small Organization Option Two: Multiple Nodes on Oracle Compute Cloud Service (IaaS) With Option Two, we can provide multiple application tiers plus a separate database tier on the Oracle Compute Cloud Service. Through Multiple Nodes, we can leverage the application tier as needed and it

This is the most requirement for OAF developers to display newly added record as first in result set. Sharing the code snippet, retrofit as per the requirement Below code will be add number rows based on the parameter provided " noOfRowsAdd " in below method  public void addRows(OAPageContext pageContext, OAWebBean webBean , String noOfRowsAdd)     {         OAApplicationModule am = pageContext.getApplicationModule(webBean);        XXVOImpl  TabResultVO =( XXVOImpl  )am.findViewObject("XXVO1");       TabResultVO.setMaxFetchSize(0);       for (int i = 0; i < Integer.parseInt(noOfRowsAdd); i++)       {         Row row1 = TabResultVO.createRow();         TabResultVO.setCurrentRow(TabResultVO.first());         TabResultVO.insertRow(row1);         row1.setNewRowState(Row.STATUS_INITIALIZED);          row1.setNewRowState((byte)-1);          row1.setNewRowState((byte)-1);       }     } Use this method in ProcessForm Request m