Wednesday, 31 July 2013

Subtabs in OAF page

Sub tabs in Employee Search Page Result for Seperating Employee Data and Manager Data

Step 1: Create a pageLayout region as you normally would.
        In my case Page EmployeeSearchPG Page is already Created.

Step 2: Select the pageLayout region in the JDeveloper Structure pane, right-click and select New > Region.
        Name your new region in accordance with the OA Framework File naming standards, and set its
        Style property to subTabLayout i.e EmplyeeTabLayoutRN
Step 3: Add two container regions to your subTabLayout region(EmplyeeTabLayoutRN).

step 4: Add View Object(Table) EmployeeSummaryVO1,ManagerVO in  EmpDataRN,ManagerDataRN
            Resion using Wizard Respectively.

Step 5:  Select the subTabLayout region(EmplyeeTabLayoutRN), right-click and select New > SubTabs.
             JDeveloper creates a  subTabs named child.

Step 6:Select the subTabs named child, right-click and select New > SubTabBar.

Step 7: Select the subTabBar region, right-click and select New > Link. Set the link's Text property to
            the label  that you want to display in the subtab. Repeat for each subtab content region that
            you created in Step
         Item Style :Link
         Destination URI="OA.jsp?page=OA.jsp?page=/oracle/apps/fnd/framework/toolbox/labsolutions 
          /webui/EmpSearchPG&retainAM=Y&addBreadCrumb=Y&" + 
         OASubTabLayoutBean.OA_SELECTED_SUBTAB_IDX + "=" + 0
         Text:Emplyee Date


         Item Style :Link
         Destination URI="OA.jsp?page=OA.jsp?page=/oracle/apps/fnd/framework/toolbox/labsolutions
         /webui/EmpSearchPG&retainAM=Y&addBreadCrumb=Y&" +
         OASubTabLayoutBean.OA_SELECTED_SUBTAB_IDX + "=" + 1

       Component Structure In jdevloper :
               Employee Search Page with Sub Tabs:

OA Framework Personalization

  •    I want to add OrderTotal Column in below Purchase Order Table.
  •        I will click on Purchase Order Table Personalization Link(Personalize "Purchase Orders Table") .

  • Click Complete View and click on Create new Item(we are adding on messageStyleText                        Item for Order Total).
  • We are doing Personalization on Site level.       
         ID                       :xxOrderTotal  
         Prompt                :Order Total
         ViewInsatance     :PoSimpleSummaryVO1
         ViewAttribute      :OrderTotal 
           Click On Apply Button

  •  Now You Can see Order Total In Purchase Order Table.

Enable Personalization link for OAF Pages

Set the values of below profiles to enable Personalization Page link in OAF Pages

          Profile Name                                                           Value

  • FND: Personalization Region Link Enabled             Yes 
  • Personalize Self-Service Defn                                 Yes 
  • Disable Self-Service Personal                                  No

Tuesday, 30 July 2013

Deploying Your ViewObject Extensions

Deploying Your ViewObject Extensions

Step 1:  Compile your Java in JDeveloper and copy ur .xml and .class files to Server

           <$JAVA_TOP>/<CompanyIdentifier>/oracle/apps/<AppsProductShortName>/server (BC4J files)
           so, if you extend a "so" view object, and your company's name is "xyz," a subclass of the Ordervompl
             view object would be in the following directory:
            Set the permissions on $JAVA_TOP/

Step 2:  Copy the .jpx definition file to the Top. 
             In my case I have creataed JpxFile Folder on JAVA_TOP  and Copied my .jpx file there .jpx file, 
             which should be located under <JDEV_USER_HOME>\myprojects, to the following   staging area:


Step 3:  Run the jpx import utility from JAVA_TOP to import substitutions specified in the .jpx definition
             file to the MDS repository.
             The import utility, jpximport.bat or the jpximport shell script. You run this utility from the command 
             line  by specifying:
             A. The database credentials of the MDS repository on your target instance
             B. The fully-qualified location of your .jpx file, which should be located under

           Using the example on substituting the OrderVo view object from  Order.jpx, your command line
            would look something like the following:

            java $JAVA_TOP/xyz/jpxFiles/Order.jpx \
           -username <apps username> \
           -password <apps password> \
          -dbconnection "(description=(address_list=(address=( 
           (host=<Host Name>)        (port=<PortNumber>)))(connect_data=(sid=<SID Name>)))"

Step 4: Bounce the web server

step  5: Do Personalization If Required

Step 6: Review your deployed extensions

  At this point the deployment of your extension is complete, and you should be able to login to your  
  application to verify that your changes have successfully taken effect.
  You can check you Extension Using JDR_util Package


Importing the XML files To MDS Repository

Importing the new directory structure/path of the page in the MDS repository

Importing the XML files:
Run the import scripts for the PG and LOVRn files.

Please see below Import Command

java \ \
/$JAVA_TOP/xxtest/oracle/apps/asn/orderstatus/webui/OrderPG.xml \
-username <apps username> \
-password <apps password> \
-rootdir /$JAVA_TOP/ \
-dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<Host Name>)(PORT=<Port Number>)) (CONNECT_DATA= (SID=<SID Name>)))"