Category: OAF
Get Current Date and time We usually need to get current date and time in java class. It is easy to get current date for java.util.Date class. java.util.Date date = new java.util.Date(); This date object gives current date and time. To use this date and time this can be formatted in needed date format as […]
Source Data Type Target Data Type Conversion Sample oracle.jbo.domain.Number int Number Id = row.getId(); int idIntValue = Id.intValue(); oracle.jbo.domain.Date String Date dobDomainDate = row.getDob(); String dobStr = dobDomainDate.toString(); 1. Conversion of java String to java.sql.date private java.sql.Date stringToDate(String dateS) { ///String into […]
1. Use the below script to load PG.xml / RN.xml to MDS C:\jdev\jdevbin\oaext\bin import C:\sridhar\jdev\jdevhome\jdev\myprojects\myprojects\moto\oracle\apps\fnd\webui\ComponentListPG.xml -username apps -password apps -dbconnection “(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=glo.dev.com)(PORT=1521))(CONNECT_DATA=(SID=VIS)))” -rootDir C:\sridhar\jdev\jdevhome\jdev\myprojects 2. List of DB Components(Tables,PLSQL-API’s) In-Respect to OAF Table Name Description JDR_PATHS Stores document paths, packages and there parent child relationship. Primary Key: PATH_DOCID JDR_COMPONENTS Stores components on documents and OA Framework […]
Message Single Exception throw new OAException(“FND”,”XXCUS_CPL_SUCC_MSG”,null,OAException.INFORMATION,null) ; Bundled Exception if (pageContext.getParameter(“bundledExc”)!=null) { ArrayList excArrayList = new ArrayList(); OAException exp1 = new OAException(“FND”,”XXCUS_CPL_FIRST_MSG”, null, OAException.INFORMATION,null); OAException exp2 = new OAException(“FND”,”XXCUS_CPL_SCND_MSG”, null, OAException.INFORMATION,null); excArrayList.add(exp1) ; excArrayList.add(exp2) ; OAException.raiseBundledOAException(excArrayList); } Lookup Valueset DFF KFF
1. Basic InvokeMethod without params OAApplicationModule am = pageContext.getApplicationModule(webBean); am.invokeMethod(“initEmployeeDetailsVO”); 2. Calling Invoke Method with String Param Serializable params[]={strUserID}; am.invokeMethod(“initFormMasterVO”, params); 3. Calling Invoke Method with different data types if(pageContext.getParameter(“go”)!=null) { String fromDateStr = pageContext.getParameter(“fromDate”) ; Date fromDate = stringToDate(fromDateStr); String toDateStr = pageContext.getParameter(“toDate”) ; […]
Removing the selected row a. Using RowSetIterator //The below logic should be written in the AMImpl.java public void deleteStudentRows() { XxcusStudentDataEOVOImpl vo = getXxcusStudentDataEOVO1(); XxcusStudentDataEOVORowImpl row = null ; RowSetIterator rowIter = vo.createRowSetIterator(“studentData”) ; String empNo = null; while(rowIter.hasNext()) { row = (XxcusStudentDataEOVORowImpl)rowIter.next(); ///FETCH System.out.println(“ID –>” + […]
Initialization of the VO 1. Method to execute the VO without any bind parameter // Below code has to be written in the AMImpl.java and the VO name differs based on your project setup public void initOeOrdersVO() { OeOrderHeadersVOImpl vo = getOeOrderHeadersVO1(); vo.executeQuery(); //OPEN operation on cursor } 2. Method to […]
1. Button (SubmitButton) //In Below Code: “showDetails” refers to the ID of the submitButton Item if(pageContext.getParameter(“showDetails”)!=null) { am.invokeMethod(“showStudentData”); } 2. PopList //In the belowCode “bgPopEvent” refers to the fireAction Property of the link Item if(eventName!=null && “bgPopEvent”.equals(eventName)) { OAMessageChoiceBean bgPopIDBean = (OAMessageChoiceBean)webBean.findIndexedChildRecursive(“bgPopID”); String displayStr = bgPopIDBean.getSelectionText(pageContext) ; […]
Use System.out.println When running the OA Framework pages from jDeveloper itself, you can write debug messages using System.out.println. These debug messages will be displayed in the console of jDeveloper. Pro Ease of use, as you simply enter free text messages Debug messages simply appear without the need to set any profile options Cons Too much […]
An OAF page consists of 2 Deployable Regions – SharedRegion and Page and they are with the naming convention RN.xml and PG.xml. The technology is designed such a way that , the definition of RN/PG gets stored in the below MDS (Meta Data Service) – DB tables, whey get deployed on the server. If they […]