What are the minimum classifications to create a Business Group?(i) Business Group(ii) GRE/Legal Entity(iii) HR Organization

What are the Pre-Requisites for creating a Business Group?(i) Value Sets(ii) Key Flexfields(iii) Location

What is the use of HR Organization?If we want to assign the employee information to a Business Group then we need to have HR Organization classification under a Business Group.

What is People Group?(i) It is a Flexible area for holding user-defined assignment data.(ii) Data can be used for Grouping sets of assignment together.(iii) People group can be used for Element eligibility.(iv) This information is used by the Payroll Run.(v) The data will be held in PAY_PEOPLE_GROUPS.(vi) GROUP_NAME field holds the concatenation of Segment data.

What is the KFF structure for SIT?Personal Analysis Flexfields.

What is the DFF structure for EIT?(i) Extra Person Information(ii) Assignment Extra Information(iii) Extra Location Information(iv) Extra Position Information(v) Extra Job Information(vi) Organization Developer DF

How to enable EIT?Switch Responsibility to ‘Human Resources, Vision Enterprises’Double click on ‘Security’Click on ‘Information Types’Create your own ‘Information Types’ under your ‘Responsibility Name’.

How to enable SIT?Switch Responsibility to ‘Human Resources, Vision Enterprises’Double click on ‘Other Definitions’Click on ‘Special Information Types’

What is the use of Date Track?1) It is used to maintain the record history by creating a new record when the date track mode is UPDATE and override on the existing record when the Data track mode is CORRECTION.2) The value of the Data Track record depends on the date.3) Tables ending with _F are date track tables.4) To control data tracked rows, every Date Track table must include Effective_start_date & Effective_end_date.

5) The Effective_Start_Date indicates when the record inserted.6) The Effective_End_Date indicates when the record updated or deleted.

What is the use of Object Version Number?1) It is used to capture the latest record from the data base table.2) When a row is inserted its number is set to 1.3) If any updates performed on the row then the OVN is incremented.4) Every API has the OVN parameter.5) For create API this parameter is defined as an OUT parameter.6) For update API this parameter is defined as an IN OUT parameter.7) The APIs use it to check a row has been updated by another user, to prevent overwriting their changes.

What is the Element?It is a Data Structure which is used to hold information for both Human Resources and Payroll.In Human Resources elements may represents compensation types including Earnings such as Salary, Hourly Wages and Bonuses.In Payroll, elements constitute all the items in the Payroll run process.

What are the Classification Priorities?(i) Information(ii) Non-Payroll(iii) Earnings(iv) Pre-Tax Deductions(v) Tax Deductions(vi) Employer Tax(vii) Voluntary Deductions(viii) In Voluntary Deductions

What the Element can represent?Earnings --> such as Salary, Wages & BonusesBenefits --> such as employee stock & pension plansNon-Payroll items --> such as ExpensesAbsences from workVoluntary and In-Voluntary deductionsEmployer Taxes and other Liabilities.

What are the pre-defined Elements?UK Payroll legislation provides many predefined elements--Tax--National Insurance (Employee/Employer)--Court OrdersThese Elements cannot be modified.

What are the Element Entry Concepts?Recurring à Recurring Entries can exists over many Payroll periodsNon-Recurring à Non-Recurring Entries are valid for single Payroll period only.

What are the types of Element Entry?There are four types

Normal EntryOverride EntryAdditional EntryAdjustment Entry--Additive Adjustment--Replacement Adjustment--Balance Adjustment

How can we add a new input value to an existing Element?We can add an additional input values to an existing Element if the element has not been processed in a Payroll run and the Effective data is the same date of creation of the Element.

What is the use of ID_FLEX_NUM?It is used to define the Structure Definition.The Structure Definition is held in FND_ID_FLEX_STRUCTURESThe Structure Segment Definition is held in FND_ID_FLEX_SEGMENTS

What is the Element Link?Links identify one or more assignment components that must be included in an employee's assignment for them to be eligible.Elements can, but they don’t have to, be linked by: Organization GroupJob PositionGrade LocationEmployment Category (i.e., Fulltime-Regular, Part-time-Regular)Payroll Salary Basis

What is API?Ø API is packaged procedure which can be used as an entry point into Application.Ø The advantage of using an API is we can enter new information or alter the existing data without manual enters the information into the Application.Ø APIs allow users to maintain HRMS information without using Oracle Application forms.

How do i use an API to upload the data?Ø API package contains many procedures to insert/update/delete the application data.Ø The API is not executed on its own, the API must be called or executed by other pl/sql program.Ø The API package should never be modified for custom use, if modified Oracle will not be able to support them.Ø None of the HRMS APIs issue commit, the calling module should manage the commit of the transaction.

How do i identify the Package name and version of the API?SELECT textFROM all_sourceWHERE name like ‘HR_EMPLOYEE_API%’AND text LIKE ‘%Header%’;

Where can i find information on an API and its parameters?Review the package header file for the particular API file (.pkh).

What is Object version number and how do I assign values for it in an API?Ø Object Version number is an assigned number to a row in a database table.

Ø When a new row inserted its number is set to 1Ø If any updates performed on the row then the Object version number is incremented.Ø Every API has the p_object_version_number control parameters.Ø For create APIs this parameter is defined as an OUT parameter the API assigns the Object version number to be 1 for row inserts.Ø For update APIs the parameter is defined as IN OUT, for update API the object version number is mandatory.

When the HR_7155_OBJECT_LOCKED raised?The current value of object_version_number must be passed in the API call and it is compared to the version on the row in the table. If the versions are different then the HR_7155_OBJECT_LOCKED is raised.

What is the p_validate control parameter?Every API has a p_validate control parameter.When the parameter is set to FALSE then all the business function validation is performed.If every thing is validated then row can be inserted/updated/deleted.If p_validate is set to TRUE then only the actual operation is validated.A savepoint is issued at the start of the call and a rollback is done at the end of the call.Can I use an API on an application table on which an event-based alert is defined?Ø No, if an event-based alert defined on an application table then the API will give error.Ø To run API the alert has to be disabled and re-enabled after the API has been executed.

What is the difference between an API and a publicly callable API?Ø An API is an alternative entry for data to be insert/update/delete from the application.Ø The Oracle HRMSØ Publicly callable APIs engage in validation in the same manner as the forms do with in the application.Ø Validation is performed in terms of data integrity, insuring that data relationship exist properly between related tables.Ø Validation is also performed against business functionality as the application form would enforce it.Ø Therefore, only publicly callable APIs should be used to insert/update and delete data from the application.

Installing Oracle Applications E-Business Suite R12 (12.1.1) on Windows XP / Windows 2003 ServerPosted on May 19, 2011 by Admin

Minimum Hardware Requirements:

1. Windows XP (professional or Home) Service Pack 2 / Windows 2003

Server with 2 GB RAM and make sure you have NTFS file system.

2. Hard Disk 250 GB where 233 GB space is required for vision

installation (excluding media pack; which needs around 37 GB space).

You can use external hard drive too. Don’t listen to those who advise you

to install EBS R12 without vision database. I know you are installing all

this for learning etc.

////////////////////////////////////////////////////////////////////////////

Very Important Note:

1. Make sure there is no oracle product installed on your system. No

entry of oracle should be in windows registry except system default by

windows itself. So it is recommended to use fresh system for this

purpose. If you tried a failed installation before on your PC then reinstall

the Operating System again otherwise you will waste your time.

2. There should be !!!!NO!!! JDK installed on your machine. EBS will

install JDK version on your machine otherwise you will get errors I don’t

want to discuss all this here. Just NO JDK on your machine.

////////////////////////////////////////////////////////////////////////////

Pre-requisites; Utilities:

1. Microsoft VC++

• Make sure that it must be VC 8 or above because VC 6 was valid up to

11i. If you do it with VC 6 then utilities check will not give error but you

will stuck at 13% or 66% installation.

• While installing VC++ make sure it is done in C:\MSVS\VC. No spaces

in any directory structure of any software you install as pre-requisite for

Oracle Apps.

• Copy cl.exe from C:\MSVS\VC\bin to C:\WINDOWS\System32

2. Perl – http://www.activestate.com/Products/ActivePerl/

• Version 5.8 or more and use MSI package type.

• Perl is only needed if you are using Oracle Media Pack. If you are

downloading from oracle site then you can skip this installation.

3. CYGWIN – http://cygwin.com/

• Download setup.exe to your machine.

• Run setup.exe and click Next, which will bring up the Choose

Installation Type screen.

• Select ; Install from Internet and Click Next

• Select ; Root Directory C:\cygwin and select radio button

• Install for ; All Users and Default Text File Type ; DOS / text ; Next

Local Package Directory can be any but C:\cygwin is recommended. ;

Next Direct Connection.

• Click on Next again to get to the Select Packages screen, and select the

following packages (click on to toggle):

a. All Default

b. Archive Default, plus manually select the zip package

c. Base Default, plus manually select the following extra packages: ash,

coreutils, diffutils, findutils, gawk, grep, sed, tar and which

d. Devel Default, plus manually select binutils, gcc, gcc-core, gcc-g++,

make and mktemp

e. Doc Default, plus manually select cygwin-doc and man

f. Editors Default, plus manually select vim

g. Interpreters Default, plus manually select gawk

h. Shells Default, plus manually select ash and tcsh

i. Utils Default, plus manually select cygutils and file

• Click on Next again to download the selected files. It will take some

time depending upon mirror site you selected and after download cygwin

setup will be automatically starts.

• After installation completed, Open folder C:\cygwin\bin and rename

followings:

• gawk.exe to awk.exe

• grep.exe to egrep.exe

• make.exe to gnumake.exe

• gcc.exe to cc.exe

• You can override the name if system says that awk or egrep or cc

already exits just remove or move to some other place.

4. Set the Path to include the C:\cygwin\bin

• C:\> set PATH = %PATH%;c:\cygwin\bin

• And then check your PATH to see that it include C:\cygwin\bin

• C:\> echo %PATH%

////////////////////////////////////////////////////////////////////////////

Oracle Media:

You should be having Lasted available Oracle media pack

(recommended) or Software download from oracle site and follow the

unzipping instruction as per oracle documentation. I have downloaded it

from: https://edelivery.oracle.com/

////////////////////////////////////////////////////////////////////////////

Domain Name Configuration:

1. Open file c:\windows\system32\drivers\etc\hosts. Enter a domain next

to localhost entry you will be using this domain while installing Oracle

Applications. I used mydomain so you can replace what ever you want.

198.168.10.102 is IP Address of my PC you should enter your machine’s

IP. If you don’t know it you can find it.

C:\>ipconfig

Example

127.0.0.1 localhost

198.168.10.102 SystemName.mydomain.com

2. Go to Control Panel > Systems > Computer Name Tab > Click on

Change > Click on More > Enter Primary DNS Suffix as ‘mydomain’.

3. Open Network connections, Select your Connection on which your

machine is connected (You will find Wireless or LAN) and right click and

select properties. Select Internet Protocol (TCP/IP) and click on to

properties. Click on Advanced button and go to DNS tab. Enter DNS

suffix for this connection as ‘mydomain’.

4. Restart the PC.

////////////////////////////////////////////////////////////////////////////

Staging the Oracle:

If you have Oracle Media Pack then:

Insert the Start Here DVD in DVD Rom and go to folder:

StageR12\startCD\Disk1\rapidwiz in DOS Prompt and type:

D:\StageR12\startCD\Disk1\rapidwiz\adautostg.pl

And follow the wizard.

Finally you must have these five folders in StageR12 Directory:

1. oraAppDB

2. oraApps

3. oraAS

4. oraDB

5. startCD

Note: If you have downloaded the media from oracle site, then you just

need to put the downloaded and extracted folders in the proper

directories… No need to do staging.

////////////////////////////////////////////////////////////////////////////

Recommended (Not necessary):

There steps are only if your installation fails due to any reason so you can

restore your registry and system to pre-installation state:

1. When Staging is done successfully then export the registry and save it

on a file.

Start > Run > regedit > File > Export and select the location where you

want to store it .

2. Take a Computer Restore Point.

Start > All Programs > Accessories > System Tools > System Restore >

Create a Restore Point > Enter name of restore point for example

‘PreOra’ and Press the Create.

3. Restart the PC.

////////////////////////////////////////////////////////////////////////////

Installing the the EBS R12

So far you have done a great job. Now time to get the job done.

1. Go to folder E:\StageR12\startCD\Disk1\rapidwiz or where you have

done your staging on hard drive or external hard drive and just click

RapidWiz

2. On welcome screen > Next and Select Install Oracle Applications E-

Bussiness R12 Check on Use Express Installation > Next

3. In Express Configuration Information screen change the following

(Leave all to default):

a. MKS directory = C:\cygwin\bin or where “cygwin\bin” is

b. MSDEV directory = C:\MSVS\VC\bin or where VC++ was installed

c. Oracle Base directory =E:\oracle or where ever you want to install

oracle applications

4. Follow the wizard and you should pass all the Pre-Install Checks. If not

then you did not follow instructions above and help yourself.

5. If you passed all the checks then just Click Next and follow the Wizard

and installation will be done in 5 steps and take about 2-3 hrs depends

upon the system.

6. After the installation is completed successfully (it should be) then Post-

Installation Checks will be preformed. If you passed all the checks It is

really a Wonderful and You Rocks

7. If your system don’t pass the Post-Installation Checks even then don’t

worry just smile coz installation is successful you need to restart your PC

and Open Command Prompt open to staging directory: d:\StageR12\

startCD\Disk1\rapidwiz

And now just type rapidwiz –restart

8. Follow the Wizard and Enter all the info as you enter before Now This

time it will take few minutes and you should pass Post-Installation

Checks

9. If still a problem just repeat above step again you will get to it .

Restart the PC and enter the URL in web browser

http://hostname.mydomain.com:8000/

10. E-Bussiness Login Username = operations Password = welcome