Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Procurement/Purchase – Requisition take a look

Posted on June 15th, 2007 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Procurement/purchasing is basically buying of goods and services, based on internal requirements, which will be used as input for the processing of the end product for a given company.
The input varies from simple stationery or MRO requirement (termed as indirect goods, as they are not directly involved in production processing) to raw materials (termed as direct, as they are used for production processing) and services.

How many types of Requisition in PO module we have?

There are two different kind of Requisition

  • Internal Requisition
  • Purchase requisition

handWhat is an Internal Requisition?

A requisition from the Purchasing system that will directly result in the generation of a sales order in the Order Management system through the Order Import process in Order Management.

Why do we use internal requisition/internal sales order?
Internal Requisition/Internal Sales Order provide the mechanism for requesting and transferring material from one inventory organization to other inventory organization or expense location.

What is the location in Oracle Purchasing?
Oracle Purchasing uses locations to identify the final delivery location for both inventory and vendor sourced requisition. It is using the hr_locations table.

What is an Internal customer?
When using Internal Requisition/Internal Sales Orders, it is required to create an internal customer for each destination organization and a customer ship-to site for each deliver-to location within the destination organization. Define the same address for your customer ship-to-site as your deliver-to location.

handThen what is Purchase Requisition?

The Purchase Requisition is the procedural method by which different departments of organization may request the purchase of goods and/or services, which require processing by Procurement Department.

handWhat is life Cycle of Purchase Requisition?
If you are using i-procurement this consist of 4 distinct sub-processes like:
iproc flow

A Requisition is generated either manually or by system, which is ultimately turned into a purchase order by the buyer. Sometimes the buyer decides a request for quotation (RFQ) is required by other suppliers to determine the best price for the goods or services requested. Once the quote is back, that information is used to finalize the purchase order.

handWhat is flow of Requisition?
A functional flow of Requisition cycle can be represented as

handWhat are the important Tables for Requisition?
These are the main tables:

PO_Requisition_Headers_All : it stores information about requisition headers. Each row contains the requisition number and Addition relevant information. REQUISTION_HEADER_ID is primary key.

HR_Employees : it’s a view that contains information about employees. You must have a row for each requestor, requisition preparer, approver , buyer or receiver . The primary key is EMPLOYEE_ID.

PO_Requisition_Lines_All : This table stores the information about the requisition lines like quantity , item , deliver to location , requestor etc. Primary Key is REQUISTION_LINE_ID

MTL_System_Items_B : This is the definition table for items. This table holds the definitions for inventory items, and purchasing items. The primary key is INVENTORY_ITEM, ORGANIZATION_ID.

PO_REQ_Distributions_All : This table stores the information about the accounting distributions associated with each requisition line. Each requisition line must have at least one accounting distribution. Each row includes the accounting flex field id and requisition line quantity. The primary key is DISTRIBUTION_ID.

GL_CODE_Combinations: This table stores valid Accounting Flex Field segment value combinations for each accounting flex field structure within your GL application. GL_CODE_COMBINATIONS is populated by the system when a new accounting flex field combination is used, either through dynamic insertion or manually.

This can be best represented as per data model as:

Here are the drill down information for these two driving table:

1. PO_Requisition_Headers_All

  • SEGMENT1 – Requisition Number
  • AUTHORIZATION_STATUS – Lookup code and can have values
    • APPROVED Document has been Approved
    • CANCELLED Document has been Cancelled
    • IN PROCESS Document is still undergoing Approval
    • INCOMPLETE Document is not yet Complete
    • PRE-APPROVED Document is Approved but not yet Accepted
    • REJECTED Document as been Rejected
    • REQUIRES REAPPROVAL Requires Reapproval
    • RETURNED Document has been Returned
  • REQUISITION_HEADER_ID Unique Requisition ID (PK)

2. PO_Requisition_Lines_ALL

  • REQUISITION_LINE_ID Requisition line unique identifier
  • REQUISITION_HEADER_ID Requisition header unique identifier
  • LINE_NUM Line number
  • QUANTITY Quantity of Line item
  • LINE_LOCATION_ID Document shipment schedule unique identifier

How we map the Main screen for Requisition with database table.

req screens

Related Posts

Posted in Beginner, Oracle Purchasing | 11 Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
11 Responses
  1. Arun Says:

    Hi Brother,
    Somebody cannot share their knowledge becoz they dont like.But the persons like you are sharing the knowledge and unknowingly you are creating opportunities for the peeople.Hats offff to u all guys Really these r the words from heart not from the lips….

    Arun Babu R

  2. SURESHRAJ Says:

    guys , hats off to u all .As arun said deftly u people are generous enough tp share ur hard earned ideas ,Thx a lot….

  3. Vijay Upadhayay Says:

    I m very new to oracle. It’s really nice to read all this. Thankkkkkkkkkkkkk UUUUUUUUUUUU.

  4. Krishna Says:


    Can U Please tell me whether can we create Internal Requistion and Internal Sales Order Using SOme API’s through back end.If it is Possible can u Please share those API’s or if any sample code u have…

    Thanks a lot

  5. Gowtham Says:

    Thanks bro u r a kind hearted legend. This information is really a million dollar worth.

    Thank Q, once again

  6. Venkat Says:

    Thank Q

  7. Syam Says:

    Ur articles are like balancing wheels for new learners of oracle apps bicycle

  8. Derrick Says:

    It’s easy to complicate things, but not so easy to explain complex concepts in terms so anyone can understand. Great work! Thank you so much!

  9. vasavi Says:

    i want pseudo code of requisition

  10. Dhanu Says:

    Hi i am very new for oracle apps, could u explain to me what is requisition in general terms?

  11. javeed Says:

    Ur articles are like balancing wheels for new learners of oracle apps bicycle

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.