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

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s