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>)))"