ADF Tag Library

ADF Tag Library :


 http://jdevadf.oracle.com/adf-richclient-demo/docs/enhanced-tagdoc.html

http://jdevadf.oracle.com/adf-richclient-demo/faces/index.jspx;jsessionid=JXdMRnYXJ8lsnyhkC2LB28GCyvy1L7QLhvhsvFtj1LsRS1S1Chhs!-44105662

Notes for Hadoop Installation :)

Notes for Hadoop Installation :)

Finding out the OS version

sridhar@ubuntu:~$ ls /etc/os*release
/etc/os-release
sridhar@ubuntu:~$ cat /etc/os-release
NAME="Ubuntu"
VERSION="12.04.2 LTS, Precise Pangolin"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu precise (12.04.2 LTS)"
VERSION_ID="12.04"
sridhar@ubuntu:~$


download Hadoop From the following link

http://apache.techartifact.com/mirror/hadoop/common/hadoop-1.0.4/
File Name :hadoop-1.0.4-bin.tar.gz

Follow the blog :

http://manguesh-borker.blogspot.in/2012/06/hadoop-getting-started.html



 

Big Data Notes

Big Data  Notes


http://www.bigdataeducation.in/


Hadoop, NoSQL Databases(mongodb, marklogic, cassandra)
and Analytics

Pre-Requisites For Learning ADF

Pre-Requisites For Learning ADF

Learning ADF is very easy, but understanding the framework behind it is very tough.

We need to understand the different Frameworks Like : Struts, Springs, JSF.

I suggest to learn JSF to understand ADF more easily, as the pages developed in ADF are more or less JSF.

update you more..on JSF in new post.. !!!!


Why the New Oracle ADF Essentials is Important to JSF Developers Read @ 

ADF Showing the data in hierarchical viewer using self referential ViewLink.

ADF

Showing the data in hierarchical viewer using self referential ViewLink.

Please follow the link
http://technology.amis.nl/2013/03/01/adf-dvt-speed-date-meeting-the-hierarchy-viewer/?utm_source=dlvr.it&utm_medium=facebook

ADF EMG Useful Links

For new members interested in what services the ADF EMG provides beyond this Google Group, here's a quick run down:

* ADF EMG Samples Site - interested in finding a sample ADF application to show you an ADF tip?  Check out the Samples site with near 600 samples: http://bit.ly/adfemgsamples

* ADF EMG Task Flow Tester - forget writing your own test harness to test task flows, the ADF EMG has you covered with the Task Flow Tester: http://bit.ly/adfemgtaskflowtester

* ADF EMG Podcasts - got some spare time on the bus to work?  Why not listen to the ADF EMG Podcast for interviews and the latest ADF news: http://bit.ly/adfemgpodcast

* ADF EMG Issue Tracker - want to let others know about a problem you've encountered with ADF?  Lodge the issue on the Issue Tracker:http://bit.ly/adfemgissuetracker

* ADF Wiki - want a index to 100s of ADF blogs.  Check out the wiki: http://bit.ly/adfwiki

We hope you find these services helpful, and we look forward to the day when you make your valuable contribution to the ADF EMG community.

OAF : Method to set the hyperlink to the link bean to open the website in new window

OAF : Method to set the hyperlink to the link bean to open the website in new window

 OALinkBean linkBean = (OALinkBean) webBean.findIndexedChildRecursive("descriptionLinkID");
//here we are referring to Link Bean in Description Column


  OADataBoundValueViewObject bindValue = new OADataBoundValueViewObject(linkBean, "Hyperlink");
// We are bounding the value  "Hyperlink" to the link bean  , so it will display Description on the output and Click on //it will navigate to the binded Hyperlink.

  linkBean.setAttributeValue(linkBean.DESTINATION_ATTR, bindValue); 


Database Table is having 3 columns
Description, Hyperlink, DocumentType

Clicking on the link in the description column will open the website in new window.

I hope that the above code will help..

How to Add 1 Year to Java Date

Add 1 Year to Java Date

public static void main(String[] args) {

        SampleJava sampleJava = new SampleJava();

       

      String refEffDateStr=  "28-Jan-2013" ;

       System.out.println("Old Date -->"+ refEffDateStr) ;

        Calendar calendar = Calendar.getInstance();

       

         try{

               SimpleDateFormat simpleDateFormat = new SimpleDateFormat("dd-MMM-yyyy");

              java.util.Date javaUtilDate = simpleDateFormat.parse(refEffDateStr);

              

               calendar.setTime(javaUtilDate);

              

               calendar.add(Calendar.YEAR,1);

               Date newDate = calendar.getTime();

              

               long javaMilliseconds = javaUtilDate.getTime();

               java.sql.Date javaSqlDate = new java.sql.Date(javaMilliseconds);

               System.out.println("New Date Is -->"+ calendar.getTime());

               System.out.println("New Java Date Is -->"+ newDate);

           }

           catch(Exception e){

              

               e.printStackTrace();

           }

       

        System.out.println("In  Method :setRetroFinEffDate-->Value-->"+refEffDateStr );

       

    }

Developing Forms For Oracle Apps R12.

Developing Forms For Oracle Apps R12.

Set your   FORMS_PATH  = D:\Training\forms

Copy the following FMB files from path  /oraAS/oracle/VIS/apps/apps_st/appl/au/12.0.0/forms/US  ($AU_TOP) to your local folder.  D:\Training\forms

• Template.fmb
• APPSTAND.fmb
• APSTAND.fmb

Copy all the files from path : /oraAS/oracle/VIS/apps/apps_st/appl/au/12.0.0/resource to your local folder.  D:\Training\forms

About ICX Session

About ICX Session

Parameter	Default	Recommendation
ICX:Session Timeout	None	30 (minutes)
ICX: Limit Time	4 (hours)	4 (hours)
ICX: Limit Connect	1000	2000

    ICX:Session Timeout - This profile option determines the length of time (in minutes) of inactivity in a user's form session before the session is disabled.  Note that disabled does not mean terminated or killed.  The user is provided the opportunity to re-authenticate and re-enable their timed-out session. If the re-authentication is successful, the disabled session is re-enabled and no work is lost. Otherwise, the session is terminated without saving pending work.  This functionality is available via Patch 2012308 (included in 11.5.7, FND.E).  Note: Setting the profile value to greater than 30 minutes can drain the JVM resources and cause ‘out of memory’ errors.

·   ICX: Limit time - This profile option defines the maximum connection time for a connection – regardless of user activity.  If 'ICX:Session Timeout' is set to NULL, then the session will last only as long as 'ICX: Limit Time', regardless of user activity. 

·   ICX: Limit connect - This profile option defines the maximum number of connection requests a user can make in a single session. Note that other EBS internal checks will generate connection requests during a user session, so it is not just user activity that can increment the count. 

• Jserv(Java)TimeoutSettings
  
  

Parameter	Recommendation
disco4iviewer.properties:session.timeout	5400000 (milliseconds)
formservlet.ini:FORMS60_TIMEOUT	55 (minutes)
formservlet.properties:session.timeout	5400000 (milliseconds)
jserv.conf:ApJServVMTimeout	360  (seconds)
mobile.properties:session.timeout	5400000 (milliseconds)
zone.properties:session.timeout	5400000 (milliseconds)
zone.properties:servlet.framework.initArgs	5400000 (milliseconds)

These settings are located at: ../*ora/iAS/Apache/Jserv/etc

JServ Timeout is specified by the value of the property session.timeout in the JServ configuration file zone.properties, and represents the number of milliseconds to wait before ending an idle JServ session (the default is 30 minutes).  This timeout is used by products based on Oracle Applications Framework (OAF).  

1.       What happens when a user logs in to Ebiz ?

a.     EBS server generates a new session, which is not yet stored in the database, and

b.    encrypted version of the session id is passed back to the browser in a cookie with key-name JSESSIONID. HTTP response header looks something like,

c.    Browser uses this JSESSIONID for all further interactions with EBS server. You can easily see this, if you monitor HTTP traffic between your machine and the EBS server.

d.    Browser sends a POST request to EBS server along with cookie information which it got from the server in the first place. First and foremost, an entry is created in FND_LOGINS table.

e.    select * from fnd_logins where user_id =( select user_id from fnd_user where user_name='SRIDHAR' ) order by start_time desc;

f.    FND_LOGINS table has following important columns like LOGIN_ID, START_TIME and END_TIME. LOGIN_ID is auto generated and unique. There could be many LOGIN_IDs associated with a single USER_ID. Even if same user logs onto EBS server from the same machine using two browser instances, two rows in FND_LOGINS table would get generated, each with different LOGIN_ID.START_TIME is the time when user logs in and END_TIME is updated only if user explicitly logs out from the application.

g.    Next an entry is made into ICX_SESSIONS table. ICX_SESSIONS and FND_LOGINS tables are are correlated by the column LOGIN_ID. ICX_SESSIONS has session id whose encrypted version was sent out by EBS server in the first place when user brings up EBS login page.

h.    select * from icx_sessions where user_id =( select user_id from fnd_user where user_name='SRIDHAR' ) ;

  

i.    When user logs out from the application, with JSESSIONID passed as part of the cookie, EBS figures out from the corresponding row in ICX_SESSIONS table, gets LOGIN_ID, gets corresponding entry from FND_LOGINS table and updates END_TIME and which basically means session has been terminated

j.    Before Logout

 k.    After Logout

ADF Metadata Files

ADF Metadata Files

1. adf-settings.xml: The adf-settings.xml file keeps the UI project configurations. This file is present in the < project-root >/src/META-INF folder.
2. faces-config.xml: The faces-config.xml file contains the configurations for a web application built using JSF. This file allows us to configure managed beans, data convertors, and validators used in the UI, navigation cases, global resource bundles, view handlers, page lifecycle phase listeners, and custom lifecycle factory implementation for the application. 
3. adfc-config.xml: ADF Faces is built on top of the JSF with a lot of extra features, which are not covered by the core JSF. ADF Faces uses adfcconfig. xml to keep its configurations. As a Fusion developer, you should use adfc-config.xml to configure the navigation cases and managed bean definitions. To run your Fusion web application, you may need both facesconfig. xml and adfc-config.xml files—which is true even if you have not added any custom configuration entries in faces-config.xml. 
4. trinidad-config.xml: Apache MyFaces Trinidad forms the base for the ADF Faces component set. In fact, Trinidad components earlier were ADF Faces components, which were donated to Apache Software Foundation later in the journey. By default, the generated trinidad-config.xml file contains only the skin family name. However, trinidad-config.xml can be used to override the default configurations for accessibility settings, locale settings, state management, and so on. 
5. web.xml: The web.xml file acts as deployment descriptor for a Java-based web application. When you generate a Fusion web application by using JDeveloper, a default web.xml file with default settings will be created for you. The default entries include context parameters for configuring the runtime state of the system, security filters, data binding filters for web pages, and resource look up filters. The web.xml file also includes servlet context listeners for initializing the management and monitoring services for view and model layers. 
6. adf-config.xml: The adf-config.xml file contains application-level settings, which manage the runtime infrastructure—such as failover behavior for the application modules, global fetch limit for all the view objects, caching of resource bundles, automated refresh of page bindings, and so on—for your application.
7. weblogic-application.xml: This file is the WebLogic Server-specific deployment descriptor.

@above text is from : Oracle ADF Real World Guide by Jobinesh

Integrating OAF and XML

Integrating OAF and XML is done by easily following the steps mentioned in :

http://apps2fusion.com/at/51-ps/260-integrating-xml-publisher-and-oa-framework

One of the issue which i got is : \tmp (The system cannot find the path specified)

The solution for above issue : create a directory :   C:\tmp

and move the following file : xdo_doc_display.jsp from OA_HTML to your Jdev /OA_HTML directory

it works :)

Setting the bind parameter to LOV in OAF

How to set the bind parameter to LOV in OAF

Recently i have been facing issues while binding parameters in LOV VO.

There is a small glitch while setting bind parameters in LOV

Consider the below one if you need to a set a bind parameter :

Never mention bind parameter and value, just make the whereClause and place it.

Normal way of bind and assigning values wont work.

Following is the way you need to use for LOV VO

   public void initDeptLOVVO()

    {

    Number dno= new Number(10);

    String whereClause = "deptNo in ("+dno+")" ;

     System.out.println("executed LOV VO ");

     clearCache();

     setWhereClause( whereClause );

     executeQuery();

     System.out.println("Dept Lov QUery-->"+getQuery() ) ; 

    }

attachmentImage

OAF  attaching images

Item Style: attachmentImage

entityMap1 à Entity à’EMP_LEARNING’ (user defined entity name)

 Set viewAttribute à Empno(PK of the table EO Based One)

 Final Page

Attached Tables 

CRUD operations on two tables

In this Post, we will discuss one of the general requirements of performing CRUD operations on two tables.
OAF page based on two update-able VO's using EO's

Consider the below scenario.

1. Master Data is stored in : XXTMG_STRUCTURES
1. STRUCT_ID is Primary Key
2. Child Data is stored in : XXTMG_STRUCT_ATTRIBUTES
1. ALLOC_ATTRIBUTE_ID is Primary Key
2. STRUCT_ID is foreign Key
3. XXTMG_STRUCTURES is having ONE to ONE relation ship between XXTMG_STRUCT_ATTRIBUTES
4. Having VO based on SINGLE EO is quite simple and easy
5. Having VO based on TWO EO objects is not  straight forward, for achieving this we need to customize the default generated methods.
6. Following this link to achieve the above requirement : https://forums.oracle.com/forums/thread.jspa?threadID=61721

List of Important Websites Regarding : Oracle Apps, OAF, FMW

List of Important Websites Regarding : Oracle Apps, OAF, ADF


Oracle Applications Integration Repository : http://irep.oracle.com/

Search engine for the official Oracle documentation.

www.tahiti.oracle.com

Oracle Applications R12 Documentation : http://docs.oracle.com/cd/B34956_01/current/html/homeset.html

Oracle Apps ETRM : http://etrm.oracle.com/pls/etrm/etrm_search.search

For Oracle WebCenter : http://yonaweb.be/webcenter_tutorial/introduction

Oracle ADF Mobile Demo : http://download.oracle.com/otn_hosted_doc/jdeveloper/11gdemos/adfmobile/ShermanNewFeatiure-ADFMobileBrowser.html


One of the good ADF Book :

Oracle ADF Real World Developer’s Guide :

 http://jobinesh.blogspot.in/2012/10/oracle-adf-real-world-developers-guide.html 

List of Websites Developed in ADF 

1. http://www.baesystems.com/home
2. https://www.ladwp.com/ladwp/faces/ladwp
3.  http://www.home.agilent.com/myagilent/faces/pages_home
4.  https://www.up.ac.za/wcportal/faces/login.jspx 
5. http://www.barkeepapp.com:7001/BarkeepOnline-context-root/faces/NewUserPage
6.  http://www.dreeshomes.com/new-homes/texas/dallas/find/neighborhoods/cobblestone_parks
7. Oracle ADF Public Websites : http://www.oracle.com/technetwork/developer-tools/jdev/community/publicadf-1613113.html
8. Bengaluru International Airport http://www.bengaluruairport.com/ 
9. http://www.ccee.org.br/portal/faces/pages_publico;portal=ysCwQLGp1KJ0B7YhXNTwCgwv7YxPB0PClr1vGwNDGK2RBvhXJYQJ!1021062444!1589985077?_afrLoop=115470710875000&_afrWindowMode=0&_afrWindowId=null#%40%3F_afrWindowId%3Dnull%26_afrLoop%3D115470710875000%26_afrWindowMode%3D0%26_adf.ctrl-state%3D8nj67fjy3_4
10. SOA For HealthCare https://blogs.oracle.com/SOAForHealthcare/
11. www.panduit.com which uses fat wire and webcenter portal along with ucm and SOA/BPM

ADF  Code Samples

1. 1.http://docs.oracle.com/cd/E18941_01/tutorials/toc.htm
2. ADF Login Sample @  http://www.fireboxtraining.com/blog/2012/02/09/oracle-adf-11g-authentication-using-custom-adf-login-form/
3. ADF sessions @ OOW 2012 : https://blogs.oracle.com/onesizedoesntfitall/entry/the_year_after_the_year
4. ADF EMG Samples @ http://java.net/projects/smuenchadf/pages/ADFSamples

ADF EMG Samples

Learning any language through samples is easy. You can find the lot of samples and the same can be downloaded using SVN. kudos to the ADF EMG Team for providing the samples.

http://java.net/projects/smuenchadf/sources/samples/show

SVN Repository : https://svn.java.net/svn/smuenchadf~samples 

ADF Mobile Academy Tutorial

http://download.oracle.com/otn_hosted_doc/jdeveloper/academy/Developing%20Applications%20with%20ADF%20Mobile/player.html

http://docs.oracle.com/cd/E18941_01/tutorials/buildmobileappscontent/adfmobiletutorial_1.html

PPR On Radio Group

Steps to Create Properties View Object (PVO)

1.       Project à New ADF Business Components àView Object

2.       Specify the Name of View Object as XXTestPVO and give the corresponding package name

3.       Select Rows Populated Automatically Not Based on Query.

4.       Click Next after Step 3 , click on New and create the transient variables

5.       Create one attribute main_Attr of Type String

Select KeyAttribute ,passivate and Updatable always

6.       Create two other attributes display_rn1, display_rn2  of Type Boolean

Select Passivate and updatable always

7.       Click on Next , again Next , Select  Generate Java File , click on Next and then Finish

8.       Click on XXTestPVO and click on Tuning and select including all Transient Variables if it is not checked

9.       Now Attach it to PageAM 

Steps to implement PPR on Radio Group

1.       Create a Properties View Object (XXTestPVO) .create one Transient attribute (main_Attr) of String Type, Boolean Type Attributes as per requirement.(In Above case we created two display_rn1, display_rn2  )

2.       Since we are implementing PPR on a radiogroup item create a dummy VO

TO CREATE dummy VO Follow the below steps ;

i.                     Create a table using the following query : create table xxdummy (dummycol varchar2(30))

ii.                   Insert into xxdummy(‘abc’),insert into xxdummy(‘def’)

iii.                  Now use select dummycol from xxdummy as query and create VO , give the name as XXTestVO

iv.                 Attach it to pageAM

3.       Provide Itemname, ItemStyle, Picklist View Instance, Picklist Display Attribute , Picklist View Attribute ,Action, Event Name and parameters ,Rendered property for the item which you want to take do PPR in the Property Pallette.

Eg:

     Item Name: radGrpItm

   Item Style: MessageRadioGroup

 Picklist View Instance : XXTestVO1

Picklist Display Attribute: dummycol

Picklist View Attribute: dummycol

Action type : Fire Partial Action

     Event Name : PPREvt

     Under parameters

    Name : PPRParam

    Value : ${oa. XXTestPVO1. dummycol }

   RenderedProperty: ${oa. XXTestPVO1. main_Attr }

4.       In the Page Region 1 set Rendered as ${oa. XXTestPVO1. display_rn1 }

5.       In the Page Region 2 set rendered as ${oa. XXTestPVO1.display_rn2 }

Process Request of the CO :

      am.invokeMethod("initPPR");

Process Form Request of the CO:

     //Code for PPR

     if("PPREvt ".equals(pageContext.getParameter(OAWebBeanConstants.EVENT_PARAM)))

{

       String radioGroupValue = pageContext.getParameter("radGrpItm "); 

System.out.println("radio group value is :"+radioGroupValue);

   

    if(radioGroupValue!=null)

    {

    System.out.println("radioGroupValue is not null , going to AM method ");

    Serializable rgvS[]={radioGroupValue};

    System.out.println("serializable value of radio button passing to AM is :"+ rgvS);

    am.invokeMethod("execPPR", rgvS);

    System.out.println("back to Co after executing payePPR method in AM");

   

    }

     }

AMImpl

  public void initPPR ()

   {

     System.out.println("in initPPR ---am");

  

     OAViewObject pvo =

       (OAViewObject)findViewObject("XXTestPVO1");

    

     pvo.executeQuery();

    

     OAViewObject vo = (OAViewObject)findViewObject("XXTestPVO1");

     if (vo.getFetchedRowCount() == 0)

      vo.setMaxFetchSize(0);

     

     XXTestPVORowImpl pprrow= (     XXTestPVO RowImpl)vo.createRow();

     pprrow.setNewRowState(OARow.STATUS_INITIALIZED);

     vo.insertRow(pprrow);

 pprrow.setAttribute("main_Attr", Boolean.TRUE);

 pprrow.setAttribute("display_rn1", Boolean.TRUE);

pprrow.setAttribute("display_rn2", Boolean.FALSE);

   }

   public void execPPR(String param)

   {

     System.out.println("inside execPPR method with payee name :"+ param);

      OAViewObject vo = (OAViewObject)findViewObject("XXTestPVO1");

     if (vo.getFetchedRowCount() == 0)

      vo.setMaxFetchSize(0);

XXTestPVORowImpl pprrow= (XXTestPVORowImpl)vo.createRow();

vo.insertRow(pprrow);

     pprrow.setNewRowState(OARow.STATUS_INITIALIZED);

     

     if ("abc’".equals(param))

      {

      System.out.println("value is abc");

pprrow.setAttribute("main_Attr", Boolean.TRUE);

 pprrow.setAttribute("display_rn1", Boolean.TRUE);

pprrow.setAttribute("display_rn2", Boolean.FALSE);

      }

    else  if ("def".equals(param))

      

      {      

        System.out.println("value is def”);

pprrow.setAttribute("main_Attr", Boolean.TRUE);

 pprrow.setAttribute("display_rn1", Boolean.FALSE);

pprrow.setAttribute("display_rn2", Boolean.TRUE);

      }

   }

regards
Rekha Kasyap .