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
- 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:
- PO_REQUISITION_LINES_ALL
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
REQUISITION_LINE_ID: Link between PO_REQUISITION_LINES_ALL And PO_REQ_DISTRIBUTIONS_ALL
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
3. PO_REQ_DISTRIBUTIONS_ALL
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
Know-Oracle 