Saturday 15 August 2015

Creating Database Connection

Creating Database Connection


Open the OAF... >>


Click the connection tab>>Database>>Right click >>New Database Connection
click next>>>

Connection name: Oracle>>click next.
Now,Give the HOST details.

go tot the patch file>>>

F:\p9172975_R12_GENERIC\jdevhome\jdev\dbc_files\secure   give the VIS.DBC file.

open it with notepad--> you can find HOST file details.

Drive:Thin
HostName:apps.ora.com
JDBCport:1521
SID:VIS

>next>testconnection>Success>ok.>click finish.
------------------------------------------------------------------------------------------------------------

Creating Workspace and Project

Right click on Application>>New OA Workspace.

file name:Hello
Package: p9172975_R12_GENERIC\jdevhome\jdev\Myproject.

>>select OA Project>>OK
click next>Project Name: HelloPR 
                  Default Name: hello.oracle.apps.po.hello.webui

>>click next>>select the
 Database:Oracle
DBCFilename : p9172975_R12_GENERIC\jdevhome\jdev\dbc_files\secure\VIS,dbc
UserName: operations
Password: welcome

Application Short Name :PO
Responsibility Key Work :PURCHASING_OPERATIONS
>>CLICK>FINISH

--------------------------------------------------------------------------------------

Creating Application Module

Right click on the server>New>ADFBusinessComponents>ApplicationModule.

>Package:hello.oracle.apps.po.hello.server
  Name:HelloAM
>>Next>Next>Finish.

Creating PAGE

Right click on the server>New>OAComponent>PAGE>OK

Name: HelloPG
Package:hello.oracle.apps.po.hello.webui

Set the properties:

Click on the region--Change the ID:HelloPLRN
 Bc4J>>>AM Defination:hello.oracle.apps.po.hello.server.HelloAM                                                Window: Hello
Title: My First Page


>>>>>>>>>>>>>>>>RUN THE PAGE>>>>>>>>>>>>>>>>>>>>>>>>> 




Sunday 2 August 2015

Installation Of OAF

Installation Of OAF

OAF is used to develop Oracle Apps web pages by using J-development(J-dev 10.1.3).
This OAF come into picture to replace D2K forms, and to meet some new requirements from Oracle Corporation.


Step-1

First we need to find correct version of J-dev.

To find it.

 Login into Oracle Apps home page with Username and Password.




Click on About this Page at the bottom of the Home Page.






Then click on Technology Components Tab.
Here you can see the OA Framework Version.




So, My Version of OAF is 12.0.4 ...>>> some Versions can be 12.1.1.

OA Framework 12.1.1
MDS Version 9.0.5.4.81 (build 481)
UIX Version 2.2.18
BC4J Version 9.0.3.13.51


Step-2

Now go to Meta link : https://metalink.oracl.com (note 416708.1) & download the corresponding J-dev version file. It will be in ZIP file format.

If you cannot able to download I have a sample patch file.. I can mail to your mail Id.Please put your comments in comment tab.



Release 11i


OA Framework 5.10 patch
Oracle JDeveloper 9i Patch
ATG.PF.H (patch 3438354 or Oracle Applications 11.5.10)
Patch 4045639 9IJDEVELOPER WITH OA EXTENSION ARU FOR FWK.H
ATG PF CU1 (patch 4017300)
Patch 4141787 9IJDEVELOPER WITH OA EXTENSION ARU FOR CU1
ATG PF CU2 (patch 4125550)
Patch 4573517 Oracle9i JDeveloper with OA Extension for 11.5.10 CU2
11i.ATG_PF.H RUP3 (patch 4334965)
Patch 4725670 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11i10 RUP3
11i.ATG_PF.H RUP4 (patch 4676589)
Patch 5455514 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11i10 RUP4
11i.ATG_PF.H RUP5 (patch 5473858)
Patch 6012619 9IJDeveloper With OA Extension ARU FOR 11i10 RUP5
11i.ATG_PF.H.RUP6 (patch 5903765)
Patch 6739235 9IJDeveloper With OA Extension ARU FOR 11i10 RUP6
Patch 6469392 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11I10 RUP6
11i.ATG_PF.H.delta.7 (patch 6241631)
Patch 8751878 9I JDEVELOPER WITH OA EXTENSION ARU FOR 11I RUP7

Release 12.0

ATG Release 12 Version
Oracle JDeveloper 10g Patch
12.0.0
Patch 5856648 10g Jdev with OA Extension
12.0.1  (patch 5907545)
Patch 5856648 10g Jdev with OA Extension
12.0.2  (patch 5484000 or 5917344)
Patch 6491398 10g Jdev with OA Extension ARU for R12 RUP2 (replaces 6197418)
12.0.3  (patch 6141000 or 6077669)
Patch 6509325 10g Jdev with OA Extension ARU for R12 RUP3
12.0.4 (patch 6435000 or 6272680)
Patch 6908968 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12 RUP4
12.0.5 (No new ATG code released)
No new JDev patch required
12.0.6  (patch 6728000 or patch 7237006)
Patch 7523554 10G Jdeveloper With OA Extension ARU for R12 RUP6

Release 12.1

ATG Release 12.1 Version
Oracle JDeveloper 10g Patch
12.1 (Controlled Release - only included for completeness)
Patch 7315332 10G Jdev with OA Extension ARU for R12.1 (Controlled Release)
12.1.1 (rapidInstall or patch 7303030)
Patch 8431482 10G Jdeveloper with OA Extension ARU for R12.1.1
12.1.2 (patch 7303033 or patch 7651091)
Patch 9172975 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.2
12.1.3 (patch 9239090 or patch 8919491)
Patch 9879989 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.3
12.1.3.1 (patch 11894708)
Patch 9879989 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.3
12.1.3.2 (patch 15880118)
Patch 9879989 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.3

Release 12.2

ATG Release 12.2 Version
Oracle JDeveloper 10g Patch
12.2
Patch 17513160 10G JDeveloper with OA Extension ARU for R12.2, certfied on Windows 7, Windows XP-SP2, and Linux. Preferred web browser is Microsoft Internet Explorer 6.0 or above.
12.2.3
Patch 17888411 10G JDeveloper with OA Extension ARU for R12.2.3, certfied on Windows 7, Windows XP-SP2, and Linux. Preferred web browser is Microsoft Internet Explorer 8.0 or above for the Skyros Look-and-Feel and Internet Explorer 6.0 or above for the Swan Look-and-Feel.

After Downloading the Patch file Paste it in the local drive and Unzip it.

Step-3

You will find 3 folders:

  • Jdevbin
  • Jdevdoc
  • Jdevhome

Jdevbin: It includes an extended version of the J-dev 10g & OA Framework class libraries.

Jdevdoc: This contains all help documentation including the OAF Developer Guide.


Jdevhome: It Includes the OA Framework Toolbox Tutorial sources & Developer working area.

Step-4--->Creating Environment Variable.

Now, We need to create Environment Variable.

Navigation is My Computer>>Properties>>Advanced>>Environment Variable>>New.




Click OK and close the “My Computer” windows.

When J Developer is launched it will now automatically save your files and settings to the central user home rather than the default home in the installation directory.

Step-5-->Get the Database file

   Now,We have our J-developer Environment ready, we need to get some environment specific setup completed. so that you can interact with your         E-BS(E-Business Suite).

    In order to enable us access to apps we will need to obtain the DBC file & copy it to our Local drive.

DBC file contain the details of Host,Port,& SID which helps in validating the session.
We can get the DBC file from server in FND top.
         (or)
We can get the path details in Oracle Apps>About this page>Java System Properties>DBC file.

D:\Oracle\VIS\Inst\apps\VIS_apps\appl\fnd\12.0.0\secure\VIS.dbc 

copy this file and paste it in local j-dev home i.e

F:\p9172975_R12_GENERIC\(patchfile)jdevhome\jdev\dbc_files\secure

***setup is completed***

Launch J Developer 10g,



The method to launch J Developer with vary depending on operating system, operating system version, and the shell.
Note: The first time J Developer 10g is launched you see the Start Page. It is something you should close.





*********************************************************************************
Thanks
Chandu...Like and Share it.
https://learnonlinecomputers.blogspot.com/b/post-preview?token=1lvKNk8BAAA.s6EZUSQ13WBjFqa6rd8icw.ELJiLewGNFSx5AbzQ_7EVg&postId=4404955679935433100&type=PAGE

Saturday 1 August 2015

Oracle Application Framework(OAF)

[OAF]--Oracle Application Framework

What is OAF?
Oracle Application Framework is a Framework developed by Oracle Corporation for application development within the Oracle E-Business Suite[EBS].
           OAF is the standard approach for building and launching Apps web pages.This includes the "i"Modules, such as i-Receivables,i-Procurement,etc..
           The Framework is collection of templates or classes or software libraries proving a defined API(Application Programming Interface).

The main AIM is to facilitate software development by allowing designers & programmers to devote their time to meeting software requirements rather than dealing with the more standard low-level details of proving a working system, thereby reducing overall development time.

    OAF mainly comes into the picture to replace D2K forms it came because to meet some new requirements from Oracle Corporation.

 till now we have 3 kinds of applications..
  • Form based
  • Self-Web applications based
  • Mobile devices applications based 
"Form based applications mainly based on the client/server technology.As we know we were using the tool Form Builder 6i/9i & database as Oracle."
    ***In case of self -service web based applications we should use Oracle database only & not any one.This is mainly based on MVC(Model View Controller) Architecture.***

MVC is inherited from J2ee architecture.Here we can use the terminology like pages,instead of forms.Here we use the J-Developer.(Jdev 10.1.3.).

Why Should We Use OAF?

  • Open through web browser.
  • Light weight component compares to Forms.
  • Look & Feel is very good compare to forms.
Dis Advantages:
  • Only Oracle database should use.
  • No drag & drop option.

*********************************************************************************
Thanks
Chandu...Like and Share it.

Friday 26 June 2015

How to Record PC Screen

This video shows you how to record your PC screen | Desktop screen using VLC player



  • Go to google search engine, type VLC Player.
  • Download VLC Player.
  • Now open the VLC Player |click on Media on menu bar and then click on Open Capture Device.
  • In this Capture mode-choose Desktop and in Options bar set the capture rate as eg-60.00f/s
  • In Play bar> select convert |select the appropriate file type eg-MP4/MOV and give the profile name eg-record1 now save it.
  • Give the destination path| paste the profile name(record1) here and browsing the destination path, for example C:\Users\XXXX\Documents\record1
  • Click on start button--the record will starts automatically.
  • After completing the record close the VLC.
  • By going to the destination path you can find the recorded video.
  • Play the video and Enjoy.