Developing a page through OA application

Developing a page through OA application (JDeveloper)

To create a page through Jdeveloper, you need to install suitable patch to run jdeveloper

Patch#p5856648 is available to accomplish this

Once you are done with Patch extraction then just go to jdev folder and run jdeveloper.exe.

To develop a new page through OA application you need to perform following tasks

·         Create a new OA workspace

·         Create an application module

·         Create a view object

·         Edit the application module

·         Create a web page

·         Edit page object

·         Test the page

Let’s go through Each and every task one by one

There are various steps mentioned below to accomplish creation of a new page.

Create a new OA workspace

Step1à Open Developer and Click menu File. In structure panel just select Workspace configured for                   Oracle Applications

Step2à When you are done with selection, just provide appropriate or suitable name according the

               application you are going to build...

               Directory name should be defaulted from the place where you have downloaded patch if not

                Please change to the appropriate one.

               

          

               

Step3à As you say OK it will prompt you to add Project Name since you have already select “Add a New 

               OA project”. Say next and provide the appropriate or suitable name

               

              

In the Above Screen you can see three optional fields (ProjectName, DirectoryName, and DefaultPackage)

Please provide Default Package Name like “oracle.apps. <appl_short_name>.module”

Step4à As you say next it will ask to create database connection at design time .Don’t set since you are 

              Going to set the connection at “Run Time”

Step5à In the Runtime Connection part please provide the DBC file name, Username& Password,

              Application Short name and the responsibility key

                                 

Step6à Once you are done click on the finish button .It will build the project and required folder
 Automatically. Please refer below screen

                                  

                         

Create an application module

      Step1àRight Click on supplier project and Select New .In the New Gallery Window open the business
                      tier window and then select Application Module in the Right panel like below

                                   

  Step2àThe Create Application Module wizard will appear shown in below pic click next

                

 

Step 3à Enter the name in Application module then click next then next

         

Step4à Select Generate Java class check box (AMImpl) where you can override method and services offered

             

Create a View Object

Step1à Right Click on the server node of the package and select view Object from the right panel

               

 Step2à Select new View object, Create View Object wizard will appear

              

Step3àMake sure You have selected correct package name and it should be in the server
Then you need to provide the correct Name ending with VO

                                

                  In the Above screen you can create VO either Rows populated by SQL query or Programmatically …
                When you select option1 then further you can create VO either updateable or Read only. When you
                select option 2 you can dynamically create

Step4à Click next until you reach step5 of the wizard

Step5àIn the query statement region, write your query according requirement

                

Step6àClick on the test button if any error encountered remove then test once again

Step7àClick next until you reached Step8 of the wizard. Here you can see 3 java classes

               

            View Object Class, View Row Class and View Object Definition Class

      View Object Class:--By default Wizard generates view object class but not the view row class but you can select both depend upon the requirements

A)Generate Java class:-- When this checkbox is selected, JDeveloper generates a Java     file you can edit to customize the entity object class' behavior. Otherwise, JDeveloper generates an XML file only.

B) Bind Variable Accessors Select to generate typesafe getters and setters for named bind variables.

C)Custom Java Datasource Methods Select to generate custom Java datasource methods 

       View Row Class:- These settings apply to the ViewRowImpl class

       A)Generate Java file When this checkbox is selected, JDeveloper generates a Java file that you can edit to customize the view row class' behavior. Otherwise, JDeveloper generates an XML file only.

      B) Accessors Select this checkbox to generate accessor methods (for example, getJob() and setJob()). These accessor methods provide type-safe access to the corresponding attribute fields. They also provide a place to add your own custom code for validation and other uses.

      C) Expose Accessors to the Client select to automatically turn all accessors into client methods. This will automatically export the client methiods, after which you must edit them using the client methods panel.

       Extends Click Extends to select view object and row base classes you want to use to generate the view object. This is useful if you are building view objects on top of a customized framework.

        Edit Application Module:- After creating View Object, you need to relate View object   with Application Module

        Step1à Expand the hierarchy of the project to display OrderDetailsAM like below

                      

                       

      Step2à Right Click and Select Edit OrderDetailsAM  and from the Available list of View     Objects from 
                  the Data model Select OrderDetailsVO

    

               

Step3à  After Selecting Shuttle it to  Data Model  and say “Apply”

                    

                        

   Create a Page :- You need to create web page as last object

   Step1à Right Click on the Package and say New ,The new Gallery window will pop up .In the Categories list, expand the Web Tier Node then Select OA Component then Page

                     

               

Step2à As you say Ok New Page box will appear .In the Name Field Please enter Page name should be ended with PG

                    

           

  

   

Edit the Page Object:-- Jdeveloper will create Empty Page Object , we need to component as per

                                        Our requirements

                                        Suppose you have a requirement to add query region to the page layout

                                        To accomplish this we need to follow following steps

Step1à By Selecting OrderDetailsPG.xml , the object will appear into the Structure window like below

                                                        

  

              Default Component of a page include a region and image

  Step2à  Next task would be you need to set page object properties.. Select region1 component properties   

                 and set following properties

                 

                   Property                       Value     

                   ID                                   PageLayoutRN (Since Region Should be ended with RN)

                   Region Style                   pagelayout

                   AM Definition                oracle.apps.oe.order.server.OrderDetailsAM

                   Window Title                 Order Details

                    Title                               Order Detail information

                    Auto Footer                    True

                

 Step3à  Add product brand Image

i)                     Right Click on PageLayoutRN component.

ii)                    From the Popup select ProductBranding

iii)                  It will create item1 in the Structure panel like below

                            

                              

                               

iv)                 Set Following properties to this item1

Property                Value

ID                            ProdBrand

Item Style                 Image

ImageURL              FNDTAPPBRAND.gif

Step4à Add a region :-- Within a web page you place content within regions.This will create a new empty region

i)                     Right Click on the PageLayoutRN and select New Region

ii)                   It will create region1 then set following properties

  

               Property                        Value

               ID                                    QueryRN

               Region Style                    query

               Construction mode          resultsBasedSearch

               Include Simple Panel        True

               Include View Panel          True

               Include Advanced Panel   True

Step5à Add a results table to query region

                To accomplish this we need to follow below lists of steps

            Step a) Right Click on the QueryRN Select New—Region Using Wizard

            Step b) In the Application Module Drop down select your created AM

                       

                                         

Step c) In Step 2 Set RegionID “ResultsTable” and Region Style “Table”

             

Step d) In Step 3 ,use Add Button and select all fields and move it to selected View Attributes then finish

Test Your Page : Once you are done with all the steps .. Right Click on the OrderDetailsPG and say 

                              Rebuild , if you got successfully compilation Then Run the Page

                               Deep Blue See ----J))))))))