OAF by SSPatil

1.    Intoduction to OAF

2.    Structure of OAF

3.    Onion Structure of OAF

4.    MVC Architecture of OAF

5.    CSS Styles in OAF

6.    Naming Convention in OAF

7.    Installation Steps Of JDeveloper

8.    Sample OAF Page Creation.

9.    Regions in OAF

10.  Items in OAF

11.  Displaying Exception in OAF page

12.  Displaying Data from Database

13.  Inserting Data into Database

14.  Partial Page Rendering (PPR) in OAF

15.  Calling one page to Another page in OAF

16.  Search page in OAF

17.  Update Page in OAF

18.  Registration of OAF Page in Apps

19.  Personalization in OAF

20.  Calling D2K Form From OAF page

21.  Search page using Query Region

22.  Invoking sequence in OAF Page

23.  Calling the Procedure in OAF

24.  Creating Train Region in OAF

25.  Prepared Statement in OAF

26.  Migrating OAF pages from one instance to another

27.  Adding Submit Button Programmatically.

28.  Adding Message Lov Input through personalization.

29.  Uploading File to server from OAF Page

30.  How to create TAB Page in OAF

31.  Adding HTML Tab/Menu to the standard OAF page.

32.  How to Bounce Apache Server in R12

33.  How to ADD/Remove Global Buttons in OAF Page.

34.  How to Add New Row to a Table Region in OAF

35.  Export data from OAF to Excel programmatically

36.  Reusable Codes in OAF

37.  Import Commands in OAF

38.   How to create External Lov in OAF

39.  VO Extension in OAF

40.  Key Flex Field(KFF) in OAF

41.  How to get the value of the field in OAF

42.  How to Create ViewObject(VO) Dynamically

43.  How to create view object in OAF 

44.   How to remove personalization in OAF

45.  Error while deploying the OAF page in R12.2.4

How to translate the custom OAF pages

Translation of custom OAF pages.

We can translate the language of a custom OAF page using XLIFF file.

Below is the command to extract the XLIFF File.

java oracle.jrad.tools.trans.extractor.XLIFFExtractor /xx/oracle/apps/po/webui/PoPrintReportPG -languages JA-JP -mmd_dir $OA_HTML/jrad -root $JAVA_TOP/xx/ -xliff_dir $JAVA_TOP/xx/ -source db -username apps -password <apps password> -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<host>)(PORT=<port>))(CONNECT_DATA=(SID=<sid>)))"

The XLIF file will be exported to the specified -xliff dir ($JAVA_TOP/xx/).

Once you get the .xlf file edit the file and add the translations.

         <trans-unit id=".xx.oracle.apps.po.webui.PoPrintReportPG..mainRN...windowTitle" translate="yes" maxbytes="4000" maxwidth="30" size-unit="char">

            <source>Print Report</source>

            <target>帳票出力</target>

            <prop-group name="ora_untranslatable">

               <prop prop-type="tagName">pageLayout</prop>

               <prop prop-type="attributeName">windowTitle</prop>

            </prop-group>

         </trans-unit>

Add the translated text in <target> section.

Move the file to any working directory and run the XLIFF import command.

The XLIFF Importer takes a translated XLIFF file and imports it into the MDS Repository.

Below is the command to import the XLIFF File.

java oracle.jrad.tools.trans.imp.XLIFFImporter $JAVA_TOP/xx/oracle/apps/po/webui/PoPrintReportPG.xlf -username apps -password <apps password> -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=<host>)(Port=<port>))(CONNECT_DATA=(SID=<sid>)))"

Error while deploying the OAF page in R12.2.4

Error while deploying the OAF page in R12.2.4

When I am migrating the objects from R12.1.3 to R12.2.4 I am facing the below error.

Exception Details.

oracle.apps.fnd.framework.OAException: Could not load application module 

'xxmsc.oracle.apps.wsm.TLS.server.AssemblyLotAM'.

The solution for this is, we need to follow below steps. In R12.2.4 the weblogic server was introduced. We need to create the custom jar files and it must be made available for WebLogic to pick it up.

Steps

=====

Go to the custom path where class file is present

adcgnjar

Bounce the oacore

cd $ADMIN_SCRIPTS_HOME

./admanagedsrvctl.sh stop oacore_server1

./admanagedsrvctl.sh start oacore_server1

Bounce the apache

./adapcctl.sh stop 

./adapcctl.sh start

Validation View Object (VVO) in OAF.

Validation View Object

When you implement business logic in your entity object, you will frequently find that you need to execute some simple sql statements, and not just for pure validation purpose.

For ex:-

A purchase order header has many lines. Each line assigned to unique line number.

This line is defined as the current maximum line number for the entire purchase order +1. At run time, we need to query the database to find out the what the maximum line number is for a given purchase order header.

Select max (line_num) from po_lines_all where po_header_id =:1;

Whenever you need to execute the sql like this, you can create view object dynamically from a sql statement, or you can predefine a declarative view object for it.

For an implementation standpoint, validation view object are no different from regular view object, they are different only by the use case.

How to clear the cache in Oracle Application (OAF cache)

How to clear the cache in OAF

Step1:- Navigate to Functional Administrator responsibility.

                

Step2:- Click on Core services tab

               

                

Step3:- Click on Caching Framework Tab

     

Step4:- Click on Global configuration

               

                

Step5:- Click on Clear All Cache

                

                A warning message related to performance will come, say yes

               

                

                

How to remove personalization in OAF

How to remove personalization in OAF

Now we are goin to learn how to remove the personalization in OAF.

Step1:- Login to oracle application.

Step2:- Switch to Functional Administrator responsibility.

Step3:- Click on personalization tab.

Step4:- For application, Enter the respective application name.

Step5:- Click on the Personalized Checkbox.

Step6:- Click Go.

Step7:- Remove or De-activate your personalization by selecting the personalization level at

             which you made a particular personalization.

OR

Step1:- Login to oracle application.

Step2:- Switch to Functional Administrator responsibility.

Step3:- Click on personalization tab.

Step4:- Click on import/export sub tab menu.

Step5:- For application, Enter the respective application name.

Step6:- Provide the document path.

             To get the path

            Go to sql developer run the following it will give the path.          

begin   

jdr_utils.listCustomizations('/oracle/apps/icx/por/reqmgmt/server/MyReqsGlanceVO');   

      //Give the page path on which u did personalization or if u did extension provide on    which u extended.

end;

Step7:- Click on Go.

Step8:- select the personalization and delete it.

How to create view object(VO) in OAF

How to create view object in OAF

Now we are going to learn how to create the view object.

We will create the view object in hello ward page.

Steps to create the view object

Step1:- Right click on project select new

           

Step2:- Select ADF Business Component and the view object and click ok.

           

Step3:- Welcome window appears click on next.

             Specify the below details.

            Package:- sangu.oracle.apps.ont.HelloWord.server

            Name :- EmployeeVO

Note:- the view object should be in .server directory and view object name ends with VO for  

best practice.

 Click on next , next.

Step4:- In step 5 of View Object creation write the sql query for view object and click next.

           

Step5:- In step 8 check the Generate Java File check box and click finish.

           

This completes the creation of View Object.

 Now we have to attach this view object to Application Module.

Step6:- Double click on AM and select the vo from left side and move that to right side and

 click on apply and ok.

           

Now the view object is successfully attached to AM. Now we can use this vo anywhere in the project.

           

How to Create ViewObject(VO) Dynamically in OAF

Create ViewObject(VO) Dynamically

Now we are going to learn about how to create the view object (VO) programmatically.

Write the following code in In ProcessRequest

import oracle.apps.fnd.framework.server.OAViewDef
import oracle.apps.fnd.framework.OAViewObject 

    SampleAMImpl am=(SampleAMImpll)pageContext.getApplicationModule(webBean);

    if(am!=null)

    {

        OAViewDef viewdef=(OAViewDef)am.getOADBTransaction().createViewDef();

        viewdef.setSql("select ename from scott.emp");

        OAViewObject vo=(OAViewObject)am.createViewObject("SampleVO1",viewdef);

       

         //SampleVO1 is ViewObject Name

            

    }