Oracle Concept : Oracle Purchasing : Requisitions and Types

Purchase Request is a precise document generated by an internal or external organization to notify the purchasing department of items it needs to order, their quantity, and the time frame that will be given in the future

A requisition is used in business as an internal document used to notify stores or the purchasing department of items that are needed or need to be ordered. It sets out the quantity and the time frame. It may also contain the authorization to proceed with the purchase if the required items are not available in stock.

A purchase requisition is not a purchase order and therefore should never be used to purchase goods or services or be used as an authorization to pay an invoice from a supplier or service provider.

Requisitions in Oracle

Purchase Requisitions

Use the Requisitions window to create requisitions. You must choose the requisition type (internal or purchase). You can also provide a description, unlimited notes, and defaults for requisition lines. For each requisition line, you choose the item you want to order along with the quantity and delivery location. You can get sourced pricing from catalog quotations or open blanket purchase agreements. You can also choose a price from a list of historical purchase order prices. In the Distributions window, you can charge the item to the appropriate accounts, or you can let the Account Generator create the accounts for you. Once you complete the requisition, you send it through the approval proces

Internal Requisitions

Unlike purchase requisitions, which are supplied from purchase orders, internal requisitions are supplied from internal sales orders. Internal requisitions are not picked up when you AutoCreate RFQs or purchase orders, nor can they be assigned to a buyer in the Assign Requisitions windo

Oracle Tables

  1. PO_REQUISITION_HEADERS_ALL (SEGMENT1 column in this table represents the requisition number)

This table stores Header information of a Purchase Requisition.

Important columns of this table:

REQUISITION_HEADER_ID:        It is a unique system generated Requisition identifier

PREPARER_ID:                           It is a unique identifier of the employee who  prepared the requisition

SEGMENT1:                                It is the Requisition number

AUTHORIZATION_STATUS:         Authorization status type

TYPE_LOOKUP_CODE:              Requisition type

ORG_ID:                                      Unique Operating unit unique identifier

You can get REQUISITION_HEADER_ID by executing the following command:


This table stores information about Requisition lines in a Purchase Requisition. This table stores information related to the line number, item number, item category, item description, item quantities, units, prices, need-by date, deliver-to location, requestor, notes, and suggested supplier information for the requisition line.

Important columns of this table:

REQUISITION_HEADER_ID:        It is a unique system generated Requisition identifier


LINE_NUM:                                   Indicates the Line number

LINE_TYPE_ID:                             Indicates the Line type

CATEGORY_ID:                             Unique Item category identifier

ITEM_DESCRIPTION:                   Description of the Item
QUANTITY NUMBER:                   Quantity ordered


This table stores information about the accounting distributions of a requisition line. Each requisition line must have at least one accounting distribution. Each row includes the Accounting Flexfield ID and Requisition line quantity.

Important columns of this table:

DISTRIBUTION_ID:                     Unique Requisition distribution identifier
REQUISITION_LINE_ID:             Unique Requisition line identifier
CODE_COMBINATION_ID:         Unique General Ledger charge account identifier
DISTRIBUTION_NUM:                Distribution number

How to give your first presentation : As a Oracle Consultant Perspective

Giving Presentations for Work, Training or any other purpose is very common now days. It involve creating powerpoint slides, notes and delivering it.  Here i am trying to put some points on how to make your first presentation as better and learning experience.

Theme : Create and Deliver


1. Analyse Audience :  Understand who are your audience, their knowledge level, experience level, Group size etc.

2. Research your topic : Do some learning on Topic and brush up your knowledge. Read user guide or whitepaper or discuss with friends or senior to brush it up.  User guide and Oracle support always good tools

3. Create simple Presentation ( Introduction , Body , Conclusion ) :  You are giving technical or functional presentation , so don’t worry about design , font etc etc. Focus on content and subject more.  Good Introduction to start as story , Body with your subject topic , conclusion as to finish up slides to summarize your topic

4. Note : for Each slide or topic, write down what you think of speaking. Writing will help to get more points and help in practicing.


1.  Voice : Try to be natural .  Try to make it as conversation or like you are explaining some new game to your friends.  Or you are telling movie review 🙂 .  Keep voice consistent with pace and tone.

2. Body Language : Stay relax, feel relax.  Make good eye contacts. if you are nervous then look at people you feel comfortable.  Use your hands , arms and gesture.  Take pauses if needed.  don’t hurry.

3. Practice :   Practice , Practice and Practice ( 3 times at least ).  User full size mirror to do practice.  Record your voice in mobile phone. Even you can record your video and see it again and correct your words, language or body gestures and again practice.

4. Memorized your introduction and first 2 minute at least , this will create good start and good impression 🙂

4. Smile and confident : Always keep a genuine comfort smile and feel yourself confident.  Giving presention is regular activity as IT professional and slowly slowly you will master it.

After presentation , get feedback from audience and senior.

Keep learning and Keep Growing. Best of Luck

oracle real time scenario in oracle hrms

The requirement from client to change the old leave accrual plan to a new plan.
For grades G1 and G2, leave per year is 24 days and they are increasing it to 28 days. we can simply change it in the formula and the plans and elements are all saved like “Accrual Plan 24”. This has to be changed to “Accrual Plan 28”. so we created a new accrual plan its working correctly

The issue what we are facing is when we end date the accrual plan 24 and attaching the accrual plan 28, the leave balance is resetting to 0. we need to add the older leave balance with the new one.
how it can be done?


With the current PTO
functionality, there is no mechanism to transfer accruals from one plan to
another. So if an employee leaves Plan A in the middle of the year and joins
Plan B, they lose all the year’s accruals for plan A. To correct
the accrual balance of Plan B, an adjustment element must be
created and added to the NCR (Net Calculation Rules) on the Accrual Plan. Manual process:

• Create your new plan and elements for that plan (Navigation: Total
Compensation > Basic >Accrual Plans)

• End date the original plan and attach the new plan using the Element
Entries window

• If there is a balance to be transferred, then the New plan should have an
element to adjust accruals:

a) Create an element: for instance, “Adjust Vacation”. Define
link information.

b) Attach element to the new plan using Net Calculation rules
window (net effect = ‘Add’)

Navigation: Total Compensation > Basic > .Accrual
Plans > Net Calculation Rules

• Get the net entitlement amount as of end date of original plan (use View
Accruals window – Navigation: Fastpath > Accruals)

• Adjust the balance by attaching the other net contribution element (element
created on previous step)

Element Entries window – Navigation: People > Enter and
Maintain > Assignment > Element Entries)


oracle hrms interview questions and answers from maahmed oracle hrms consultant

What are the minimum classifications to create a Business Group?

  • Business Group
  • GRE/legal Entity
  • HR Organization

What are the pre-requisites for creating a Business group?

  • Value sets
  • Key flex fields
  • 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?

  • It is a flexible area for holding user defined assignment data
  • Data can be used for grouping sets of assignment together
  • People group can be used for element eligibility
  • This information is used by the payroll run
  • The data will be held in PAY_PEOPLE_GROUPS.
  • Group_name field holds the concatenation of segment data.

What is kff structure for SIT?

Personnel analysis flexfields

What is the DFF structure for EIT?

  • Extra person information
  • Assignment extra information
  • Extra location information
  • Extra position information
  • Extra job informantion
  • 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 other definitions

Click on special information types

What is the Data Track?

  • It is used to maintain 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.
  • The value of the Data track record depends on the date
  • Tables ending with _F are date track tables
  • To control data tracked rows, every Date Track table must include Effective start date and Effective end date.
  • The effective start date indicates when the record inserted
  • The effective end date indicates when the record updated or deleted.