Tuesday, 20 April 2021

Installation Steps Of JDeveloper

 

INSTALLATION PROCESS OF JDeveloper




Step1:- First you need to download the JDeveloper patch of the version.
   All the patches   we can download from the Oracle Meta link, and the file size is
   1.2 GB.



Step2:- Extract the ZIP file and open the patch folder you will find three folders.    
                        >jdevbin.
                        >jdevdoc.
                        >jdevhome.
                        


Step3:-Go to

               Jdevbinàjdevàbin
              Their u find jdev and jdevW icons.
   The jdev is for UNIX environment and jdevW is for Windows environment.
               Create the shortcut of jdevW. And send to desktop




Step4:-Next we have to create the JDev environmental variable for windows.
  
   >Right Click on My Computer  select properties.
    Properties--> Advanced System Settings-->  Environment veriable
    next click on New Button for adding a New User variable as show in the   
    below figure.
     

         >Next select Advanced System Settings.
                                         


>Next Select Environment Veriables.





>Click on new to create new environment veriable.




          >Give the Variable name--> JDEV_USER_HOME
   Variable Value --> path of the jdevhome\jdev







Step5:-After creating the environment veriable we have to move the DBC file      
   from Oracle Apps fnd top to jDeveloper patch.
                        
 Here we are using WinScp which connects to the server from our desktop system.
After finding where exactly the DBC file located go to that particular path and copy the DBC file.
(/oracle/apps/r12/inst/apps/visr12_ebsr12/appl/fnd/12.0.0/secure)

After  copying, in your desktop system go to
Jdevhome--> jdev--> dbc_files--> secure
Here we will not find any files or documents the folder is empty now we need to paste the DBC file which we copied from the Oracle Apps Instance Server.

   

Move the file from server to local machine
 
 



  

Step6:-After moving the DBC file now open the JDeveloper and create the
     Data Base Connection.

After opening the file it will ask for Configure File Type Associations, on     check box check all the available types to associate with JDeveloper.  

Go to Connections tab after that Right Click on Data Base folder and then select New Database Connection…,
           
           





After selecting the New Database Connection,the welcome window will open just click on next.
After that in nex window give the connection name. Make sure that Connection type should be Oracle(JDBC), click next.



In the Authentication tab specify the username and password,
give Oracle SQL Developer tool connection name.




Next in connection tab give the connection details
            Host Name:-ebsr12.com
JDBC Port  :1521
SID              :visr12
Click next




Next in test tab click on test connection  and check for the connection is it success or not.
           
            





Step7:-After creating the DataBase Connections,
   Set the default project properties.
   Go to Tools à Default Project Properties

   



In that select Runtime connection, adjust the runtime connection information, necessary  for the database and Oracle E-Business Suite.

Brows the DBC file from the jDeveloper patch where we moved from the server. (Jdevhome--> jdev--> dbc_files--> secure)

 Username:- The user name is Oracle Apps instance User Name(sspatil)
 Password:- Password is Oracle Apps instance Password.

Application Short Name:- In which application u want to run  give the         
                                                Application Short Name of that application.
 Responsibility key:- Responsibility key of that application short name.




This finishes the configuration of JDeveloper.

Friday, 4 July 2014

Regions in OAF

PageLayout Region

By default this is the top most region for any OAF page. We can create any number of regions/items as children of this region. It provides some common functionalities to all pages like footer (privacy & copyright links), root AM, window title, title, function name etc.. 

Bean: oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean

DefaultSingleColumn Region

This region is used for holding items in single column. Suppose we added 4 items inside this region, then all these item appear in one single column as shown below:

Bean: oracle.apps.fnd.framework.webui.beans.layout.OADefaultSingleColumnBean

DefaultDoubleColumn Region

OAF DefaultDoubleColumn region is used to hold items in two columns. Prompt of items will be right justified and the input fields will be left justified.
For example as shown below, six items are added under this region which appears in two columns (3 items in each):


Bean: oracle.apps.fnd.framework.webui.beans.layout.OADefaultDoubleColumnBean

MessageComponentLayout Region

It serves the multiple column display of components in an OAF page and also satisfies the standard UI guidelines. messageComponentLayout region set Rows =x and columns =y in property inspector. Now this is used instead of DefaultSingleColumn and DefaultDoubleColumn.

TableLayout, RowLayout, CellFormat Region

We can create our items using messageComponentLayout region by setting number of rows and columns. However if that doesn't satisfy our requirement, then we can use tableLayout region and can place the items manually as we want. It provides 2 regions (rowLayout & cellFormat) using which we can have different number of columns for each row. All together, these 3 regions work as follows:
  • TableLayout can contain multiple rowLayout, each corresponding to a row.
  • RowLayout contains multiple cellFormat, each corresponding to a column.
  • Finally, inside cellFormat region, we can add different items.


Query Bean Region


When we want to perform a search on a page, instead of creating different items for criteria fields and serch button, we can use query region. It provides built in functionality such as search panel ,advanced search panel and Views Panel as shown below:

Bean: oracle.apps.fnd.framework.webui.beans.layout.OAQueryBean

HideShow Region

Using this region, we can show or hide regions or items which are inside this region. Also we can set default as hidden or shown on page load.

Bean: oracle.apps.fnd.framework.webui.beans.layout.OADefaultHideShowBean

PageButtonBar Region

If we want to show some items at pagelayout level, we can use pageButtonBar region as direct child of pageLayout region. Items under this region will be displayed at bottom as well as at top of the page.


Bean: oracle.apps.fnd.framework.webui.beans.nav.OAPageButtonBarBean

Table Region

Table region is used to display data in tabular form. It also supports other functionalities such as single/multiple selection, sorting.. 


Bean:  oracle.apps.fnd.framework.webui.beans.table.OATableBean

AdvancedTable Region

Advanced table extends the functionality of simple table region. It provides declarative support for these functionalities for which we to write code if using simple table region. Advanced table has many rich features, some of which can be like a table can now have an instruction text and even a tip, also table can have a navigation bar, selection column, add rows button, control bar, recalculate and many more.


Bean: oracle.apps.fnd.framework.webui.beans.table.OAAdvancedTableBean

ContentContainer Region

This region has some special properties which differentiates it from other regions. It can have different background color which can be set using shade property. It can have border all around so that it can be easily identified as separate region as shown below:

Bean: oracle.apps.fnd.framework.webui.beans.layout.OAContentContainerBean

FlowLayout Region

When we want to associate an item (mainly a button) with table or advanced table, we can create a flowLayout region. This is much easier than using tableLayout/rowLayout/cellFormat regions for performing this task.

Bean: oracle.apps.fnd.framework.webui.beans.layout.OAFlowLayoutBean

Switcher Region

Switcher region is used to dynamically switch between the items displyed in a region. It is similar to CASE statement used in programming languages. For example, using this we can show an item on one condition and hide/disable the same on another condition.

Bean: oracle.apps.fnd.framework.webui.beans.OASwitcherBean

Train Region

Suppose we have a scenario where to complete one transaction we have to navigate multiple pages such as step1, step2...
Here we can use train region which provides built in functionality for showing different stages of transaction and highlight active page.



Bean:  oracle.apps.fnd.framework.webui.beans.nav.OATrainBean

hGrid Region

This region is used when we want to display information in hierarchial structure.


Bean: oracle.apps.fnd.framework.webui.beans.table.OAHGridBean




Item Styles

ITEM STYLES:-
1) Attachment link: - Using this we can attach a file, at a time only one file is possible.
2) Attachment table :- we can attach more than one file
3) Button and Submit Button: - Both are same. But for button u won’t get any actions and we need to write the actions but in case of submit button we can get. To get the actions to button we need to set action type : in client action – fire action or fire partial action
4) Flex: - To implement flex fields (both flex fields) we can implement both types.
5) Form parameter:-To store some value in this, use this to pass the parameter values like variable
6) Form value:-It is a hidden item to store some value, but not display that, we can use this form value. To store id’s those we don’t want to display
7) Formatted Text:- Used in context branding and product branding
8) Image:- To display image – property – give image URL and style – Image Visual: image url – path of image where it is html – oa – media
9) Link: - Navigation: Destination url:http://metalink.oracle.com – visual – text – metalink. If u click this it is opened in same window and if u want to open in new window : navigation – target frame - _Blank : destination function ; to open a form in the oracle apps we will create one function and while registering the form oracle apps , this function name should be given in the destination function to open the form directly
10) Message Checkbox:- You can display check box – prompt : y/n checked value-Y and unchecked value – N
11) Message File upload:- You can browse and you will get like file : -- browse and here just give the prompt
12) MessageLOVChoice:- It is combination of both messagelovinput and message choice
13) Editor:- message text editor
14) RawText:- To display text basically
15) Reset Button:- To clear the values – properties – visual – text :reset and u can clear all the things except lov’s editor
16) Messag Radio Button and Radio Group:- For radio group – id – RG1 and for radio button – rb1 and rb2 – prompt – male and female and group name – RG1 . Through radio group you can select only one value and these 2 are under the radio group
17) Spacer:- To get the spaces between the items in horizontal and vertical way – properties – Height – 50 width – 50 and place this button where u want space in between items
18) Static styles text:- Similar to message style text , read only item and display item
19) Tip: - to provide the message, this is page level tip. property – visual – tip type : Short tip for item level – tip message – Application short name – PO and tip message name – need by date should be greater than sysdate
20) Seperator:- It separates the item and you get one line in the page which separates this item is placed, where u want separation between the items

OAF Introduction

Drawbacks of form
In form we can’t create the html kind of pages that’s why forms cant be opened using browser.
There are some other frameworks like OAF
i) AK Framework: - AK means one type of common module. It uses one responsibility called AK Developer. In AK Developer we will create items and buttons and we will write the code using java.
ii) JTF Framework:- Java technology framework mainly developed CRM Products in JTF
iii) OAF: - It has a tool (wizard) tightly integrate the oracle applications and it can’t connect to other database only oracle applications as the source.
iv) ADF: - Application development framework and it is developed to implement fusion. The fusion pages are created in ADF and fusion is combination of people soft, Siebel and jd Edwards etc.
OAF
1) We can design self service web based applications those can be run through the internet browser, which cant be developed using forms
2) In Self service web based applications form is called as page
3) Look and feel is good compared to forms
4) Less coding effort
5) Performance is high
6) Light weight components
7) Security
8) Follow java concepts
Oracle Application Framework (OA Framework) is the Oracle Applications development and deployment platform for HTML-based business applications. OA Framework consists of a set of middle-tier runtime services and a design-time extension to Oracle9i JDeveloper called Oracle Applications Extension (OA Extension).
During the first few years after the Internet evolution, the software industry witnessed an influx of rapidly changing technologies. These technologies matured, yet there are still a myriad of low-level and complex technologies that are hard to learn and implement. Under these circumstances, OA Framework has emerged as an integrated platform for developing and deploying Oracle E-Business Suite HTML-based applications,
leveraging technological advances without taking on associated complexity. Since its inception, OA Framework embraces the following principles:
�� End User Productivity
The shift from client-server to multi-tier deployments comes with many cost savings, but not without compromise. HTML-based applications started out very much like old mainframe terminals; actions on the client side resulted in a round trip to the middle tier.
Over time, user interface interactivity improved. OA Framework has always kept user interface interactivity a top priority with features such as partial page rendering (PPR), hot keys, smart choice lists and auto-completion of fields with lists of values. In addition, Oracle focuses a wealth of resources and expertise on user behavior and psychology, to develop a set of user interface layout and interaction standards, commonly known as the BLAF (Browser-Look-And-Feel) guidelines. BLAF is the default look and feel that all OA Framework applications assume, but can be personalized in many ways to meet customer branding and style requirements. OA Framework's implementation of
BLAF standards yields a consistent user experience and further enhances user productivity.
�� Enterprise-Grade Performance and Scalability
OA Framework has aggressive performance and scalability targets. Most Oracle E-Business Suite application pages have sub-second response times to most user interactions. It takes a bit longer the first time a page is accessed within the same Java Virtual Machine, but thereafter, most of the commonly needed information (such as user information) is cached in the middle tier, allowing faster response. Resources are conserved through a number of resource pooling mechanisms and the
swapping of idle resource data between memory and database.
�� Developer Productivity
OA Framework is designed around the simple Model-View-Controller (MVC) architecture. To shield application developers from costs associated with the rapidly changing technological landscape, Oracle has adopted a declarative flavor of the MVC architecture. Key building blocks of an application are defined in a descriptive manner using a simple JDeveloper user interface and then saved in an industry standard XML format. With OA Framework Release 11.5.10, Oracle is extending access and
benefits of the OA Framework development environment to all Oracle E-Business Suite customers and partners. Customers and partners can leverage the proven OA Framework technology to add extensions to their Oracle E-Business Suite applications.
�� Application Customizability
Oracle is able to exploit its twenty plus years of experience in building and deploying business applications, to architect OA Framework with durable and economical customizations. Oracle has kept that goal in focus and produced a very compelling solution with plenty of flexibility to tailor the user interface (look-and-feel) and business logic. Thanks to the declarative and object oriented nature of OA Framework, application personalization and extensibility is readily available at a fraction of the industry startup cost and at a very minimal maintenance cost, if any.
�� Open Standards
Oracle continues to be a champion of industry standards and an active participant in the development of several emerging standards. OA Framework technologies has driven several industry standards and has adopted several others as they were published. Several Oracle technology architects are active members on a number of standards drafting committees. OA Framework is J2EE based and features several industry standards such as XML, HTML, Java, JSP, SQL and Web Services.
OAF Architecture:-
OAF Follows J2EE architecture – MVC Architecture
Model – View – Controller
View is nothing but the output layout design of the page
Controller is a java file; we can capture events and actions of a page and directs the application flow.
For a page we can attach one controller and it executes from controller only
We can’t touch database using controller, we can touch only user interface and by using model we will touch the data base and model cant touch the page.
We need to have model using this only we can perform database operations
Model is nothing but a collection of BC4J Components or objects
Model:-
1) Entity Object
2) View Object
3) Application Module
4) Associations
5) View link
Entity object: - If we want to perform DML operations then only we will create entity object with out this we cant perform DML Operations
For any page we will get only one class file and to open java file and to decompile the page oracle/apps/fnd/framework/schema/server
In the above path OAEntityImpl can be found
If there is 100 attributes, then u will get 100 get and set methods.
Protected void validate entity method is used to throw the messages for any validations among the attributes.
These methods will not called from any where and the framework automatically calls when ever the data is committed or saved.
View Object :- It is nothing but the select statement using the view object. We can perform DML operations on the top of entity object. We need to create view object for all the data base operations. To retrieve we need a entity object.
It can be created in 2 ways.
i) Based on EO
ii) Individual VO
Transient Attributes:- we can not save it and show it only for calculation purpose and it is not part of the query.
For example when EMPVO is created
XML File created – EMPVO.xml
2 java files created – EMPVOimpl.java and EMPVO Rowimpl.java
XML File :- it consists of query and if u open the EMPVO.xml you can find out the query and what are the transient attributes involved if there is any.
XML File consists of query column and transient attributes. But in query column we can see only query.
The only purpose is to find out the query.
EMPVOImpl.java – The java file is created like the
Public class Empvoimpl extends OAViewObjectImpl
{
}
(Standard file) and it is found in the below path – oracle/apps/fnd/framework/server
The main purpose is to modify the query at runtime and execution can also be done in class file.
This is the base class file, what ever operations related to query like adding where conditions and passing can be done using this class file.
EmpvoRowImpl.java:- It is like a cursor and used to catch the particular record or row by row
When ever you want the transactions record by record use this RowImpl file
Public class EmpvorowImpl extends OAviewobjectRowimpl
{
}
Application Module:-
It is heart of component with out this we can’t do anything, it creates new data base session for each and every run. With out the data base session we can’t run the page. We can perform business validation and logic in application module. It access view objects
(Access all related model BC4J objects. Am mandatory for every page)
When you create Am with name Sample AM it creates 2 files
i) Xml Files – SampleAm.xml
ii) Java File – SampleAmimpl.java
XML file – It is not used -- To see ODBC package structure
We don’t use XML file but to run and create the session we will use XML File.
Java file – it is heart of AM
When ever you create VO and if u wants to access that VO then we need to attach this VO to AM. Then java files create methods for each and every VO which is attached to Am and along with that we can create our own methods also.
Public class SampleAmImpl extends OAApplicationmoduleImpl
{
}
Every thing written inside is case sensitive.
Associations:-
It is a join between entity objects (To delete a record which has master detail relation ship using association we can delete)
It create only XML File
View Link:-
It is the join between View objects and the purpose is to extend the Master table and it creates only XML File.
Controller:-
It is a java file and we have to create a controller for each and every page and to perform actions related to page we can attach any controller at run time .
Controller can’t interact with data base. It can perform actions related to page means it can’t perform DML Operations
Through model controller can interact with the data base and model can not interact with page.
Public class Empco Extends OAControllerImpl
{
Public void process request()
{
}
n This method executes while the page is loading and this method never be called once the page is loaded
n To get some default values
n Oracle/apps/fnd/framework/webui – web userinterface
Public void processformrequest()
{
}
n This method is used to execute after the page is loaded
Public void xyz ()
{
}
Both are interface, class can be extended where as interface can not.
The MDS document details loaded into data base in the JDR tables
If we want to write any code we need to write it in default methods
If we write in custom method, that method must be called on the any of the standard methods.
These 2 methods consists 2 parameters
n OAPageContext pageContext
n OAWebBean webBean
Using the page Context we can access the items like item values
All page items we want to display called as webBean only
OAWebBean : 4 types
1) OAMessagetextInput
2) OAMessageCheckboxBean
3) OASubmitbuttonBean
4) OAMessageRadioButtonBean
OAMessageTextInput x=webBean.findChildRecursive (“Requestor”);
Find Child recursive is a method which returns value in webBean
Syntax: webBean.findChildRecursive (itemid)
n This method returns value as webBean to convert this into text input and use type casting.
OAMessageTextInput x= (OAMessagetextInput Bean)
webBean.findchildrecursive (“requestor”);
The other method which is created in controller is ProcessFormdata () and it calls for execution of the page and it is not visible and it will maintained by the framework
When u will click on button 1st it will call processformdata and next processformrequest and this is order of execution.
Process request – processformdata – processformrequest ()