Jdev 11g Installation

Jdev 11g Installation

Save jdevstudio11110install.exe to your hard drive.
run the exe

Choose complete

Finish and check for projects

Versioning Tool

Versioning tool:

Inital setup for versioning tool TortoiseSVN:
TortoiseSVN-A revision Control, version Control, Source Control Software.

Which has several advantages:
-Document changes can be tracked(Project wise).
-Users code changes be tracked and the difference can be highlighted(keeps track of changes)
-Highly effective for debugging and maintaining the standards.
-Can create a graph of all revisions/commits. You can then easily see where you created a tag/branch or modified a file/folder.
-Folders can be locked for change.

The Pre-Requisites :


1. Apache Webserver and Localhost configuration set up. To know how to setup the webserver for local use, read Tutorial : Installing Apache, PHP 5, MySQL 5 & PhpMyAdmin 2.11 in Windows Vista/XP (Please download the Subversion Win32 binaries for Apache 2.2.x).

2. Subversion : Subversion is an open source version control system. We will be needing this package for the Win32 binaries for Apache 2.2.9 or higher to get a SVN setup up and running on your localhost. We can do version control using this package alone, but it is completely command line based. The latest release of Subversion is 1.5.2.

3. TortoiseSVN: Download and Install control software for Windows. The latest release of TortoiseSVN is 1.5.3.TortoiseSVN is an Open Source project developed under the GNU General Public License (GPL). It is free to download and free to use, either personally or commercially, on any number of PCs.

System Requirements

1. Win2k SP4, WinXP, Vista or later

2. IE6 or later

3. Windows Installer version 3.1 or later


Step 1:
TortoiseSVN is a Subversion client, implemented as a windows shell extension, a plug-in to Windows Explorer (http://tortoisesvn.tigris.org/).

The latest version can be downloaded at http://tortoisesvn.sourceforge.net/downloads. For my 32-bit processor I used 32 Bit TortoiseSVN-1.3.5.6804-svn-1.3.2.msi Installer. There is another file, TortoiseSVN-1.3.5.6804-svn-1.3.2.md5 in the download area, which is not required for installation. It contains a checksum of the installer file which is useful if you want to verify that you have downloaded the right installer (and that its not corrupted).
You can download my program HashFile (http://www.shokhirev.com/nikolai/programs/progmisc.html) and verify the installer by checking its MD5 hash (checksum). The checksum must be identical to that found in the TortoiseSVN-1.3.5.6804-svn-1.3.2.md5 file.
2.Once Instalation is complete,right click on any folder and you will find a extra buttons for tortoiseSVN and SVN Checkout.
3.Now create a folder Project in C:\ directory path and inside Projects create another folder
e.g:C:\Projects\MyProject
paste your documents in to the subfolder myproject
Step 1. Repository creation. On your hard drive create the directory for repositories of all your projects, e.g. C:\SVN. Create inside it a sub-directory \MyProject. Right-click on MyProject and choose TortoiseSVN/Create repository here:

This converts C:\SVN\MyProject into a repository with the following contents:
Step 2. Initial import. Somewhere in your hard drive (e.g. in C:\tmp) create a directory (e.g. \new) with the following three subdirectories:


C:\tmp\new\branches
C:\tmp\new\tags
C:\tmp\new\trunk

The resulting structure is:

Backup your project (C:\Projects\MyProject.), just in case.

Delete all unnecessary files that are not included in your global ignore list
Move the contents of \MyProject into the trunk subdirectory (C:\tmp\new\trunk). We will need an empty directory later, anyway.

Import the 'new' directory into the repository (Right-click/TortoiseSVN/Import):
Selelect URL as file:///C:/SVN/Myproject (forward slashes!):

The "Import finished" message shows C:\tmp\new\* :

Step 3. Creating a working directory. Now you have the repository with all your files and the empty C:\Projects\MyProject (remember, we moved all its contents to C:\tmp\new\trunk?). "To get your hands on blessed, completely approved, and fully loaded Subversion directory, you need to check it out from your repository" [6]. Right-click on C:\Projects\MyProject and choose "SVN Checkout":

Set URL to file:///C:/SVN/MyProject/trunk and Checkout directory to C:\Projects\MyProject:

Press OK. Checkout has finished:reflected in the small icons on your project directory and all containing files (and subdirectories).

 

Oracle Application Development Framework (ADF)

Oracle Application Development Framework (ADF):Oracle ADF is an end-to-end J2EE framework, fully integrated with JDeveloper:
Oracle ADF comes with extended design time facilities. By using simple drag-and-drop of the model components you can build page by page in a highly productive manner.
PL/SQL packages can be converted to java classes in integration.
A Step by Step Example:1.Install Oracle JHeadstart 11g 11.1.1.2
2.Create the HR Schema Sample Tables:
          C:\jhs-step-by-step> cd hr_schema

          C:\jhs-step-by-step\hr_schema> sqlplus hr/hr @hr.sql
3.Create a new connection:

4.Enter Connection Details and create a default web application.

5.Enter Application Name directory and package name as

6.Select Business Tier > ADF Business Components on the left, and Business Components From Tables
on the right. Click OK. Set the IDE database connections
7.create entity for the tables selected as

8.Create Updateable View Objects for All Entity Objects.
9.enter the name for APPLICATION MODULE
10.Can create levels for enitites according to the resuability.

10.Select the ViewController project in the navigator and choose Enable JHeadstart on this Project
 from the right-mouse menu. Click (Next>) from the welcome page, then click (Finish) to proceed with
enabling JHeadstart. Click (Yes to All) in the following alert that will be shown.
11.Save and observe the default service definition.The JHeadstart New Service Definition wizard auto-created List-of-Values (LOV) definitions in the View Objects for each attribute where a foreign key relationships exist in the base business component model.To inspect such an LOV definition, go to the Model project, double click on the EmployeesView view object, click on the Attributes tab and select the JobId attribute.
12.To run the JHeadstart application generator, select your ViewController project in the Application
Navigator and choose Run JHeadstart Application Generator.Press F11

Oracle fusion

Project Fusion:


· Refers to the delivery of Oracle's next-generation application product line.
· Is being designed to merge the best features of Oracle, JD Edwards, Peoplesoft, and Siebel applications into a single product based on a whole new architecture.
· Is based on service-oriented architecture (SOA), embedded analytics, and business process management (BPM) tools.
· Will be written entirely in Java.
----------------------------------------------------------------------------

Lets Get started step by step:

What is Middleware:
 Middleware is the software layer that lies between the operating system and the applications.

Service-Oriented Architecture

 SOA achieve loose coupling among interacting software agents.Includes Oracle Service Bus, Oracle Complex Event Processing, Oracle Business Rules, Oracle Business Activity Monitoring, Oracle B2B, Oracle BPEL Process Manager, Oracle Service Registry, Oracle User Messaging Service, Human Workflow, Oracle Mediator.



Oracle Fusion Middleware
It includes Web servers, application servers, content management systems, and similar tools that support application development and delivery.

• The design tool enables simplified design and debugging, and to improve productivity. Includes Oracle JDeveloper, Oracle TopLink, Oracle Application Development Framework, and Oracle Eclipse.
• This end user environment is multi-channel allowing it to be accessed from a variety of different clients (mobile clients, desktop clients, Voice-over IP (VOIP) clients). Includes Oracle WebCenter Framework and Oracle Portal.
  
  
  
  
  
  
  

TDS Report

Important Table in Payroll which will be used in TDS Report Calculations are

pay_payroll_actions







ppa, pay_assignment_actions paa, pay_run_results prr, pay_run_result_values prrv, pay_input_values_f piv, pay_element_types_f pet, pay_element_types_f_tl petl, pay_element_classifications pec, per_time_periods tp

With Xml DD

Xml Data Definitions can be used instead of RDF's

Inside the xml tag u need ot specify the parameters,groups and elements used.amd can uplaod in XML format in Data Definition.

Each set is sql statement are grouped and called.

Use Decode and Substr

Using Decode and substr together:- 

Decode wil replace the IF-THEN-ELSE

e.g

SELECT full_name,

decode(Current_employee_flag, 'Y', 'EMP',

 'N', 'Not Emp')result

FROM per_all_people_f;

Substr will filter values to the length you specify

Eg

SELECT SUBSTR('Take the first four characters', 1, 4) FIRST_FOUR
FROM dual;

To use both:

SUM(DECODE(Substr(piv.uom, 1, 1), 'M', prrv.result_value, NULL))  amount,

Will result value will grouped for numeric values.