Create a Purchase Requisition in Oracle Apps and Base Table Relations
By Jag - April 21, 2014
Purchase Requisition is a demand sheet issue by Inventory , Sales, Manufacturing , Planning department and handover to Purchasing department. Purchase Requisition Sheet is define that which item is need to be purchase, when we need it, How many qty we need, In which price we need it.
Create a Purchase Requisition in Oracle Apps
Navigations : Purchasing, Vision Operations (USA) » Requisitions » Requisitions
Information are Split into three parts
Header Information
- Type: a) Purchase Requisition b) Internal Requisition
- Prepare
- Status a) Incomplete b) Approved c) In process,
- Currency
Line Information
- Type: a) Goods b) Expense
- Destinations Type: a) Inventory b) Expense
- Origination:
- Location:
- Sub inventory
- Source : Inventory , Suppiler
Distribution Info
- Account : Charge, Variance, Accrual
This Form split in to two part : Header and lines.Headers information stored inPO_REQUISITION_HEADERS_ALL and lines information store in PO_REQUISITION_LINES_ALL . click on Distributions tab and enter/check the charge account, Variance account, Accrual account. Distribution information store inPO_REQ_DISTRIBUTIONS_ALL table .
Purchase Requisition Distribution Info
Save the record and Click the ‘Approve’ button to submit this requisition for approval.
Purchase Requisition for Approval
Check submit for Approval and Click ‘OK’ button to send the Approval notification to the concerned person. Approval Hierarchies are used to route the documents to the concerned person for Approval. The document can be ‘approved’ or ‘rejected’.FOR PO REQUISITION REPORT AND RELATION
1
2
3
4
5
6
| Select * from po_requisition_headers_all where trunc(creation_date)=trunc(sysdate)Select * from po_requisition_lines_all where trunc(creation_date)=trunc(sysdate)Select * from po_req_distributions_all where trunc(creation_date)=trunc(sysdate) |
To check the ‘ Status of your Requisition ’ by navigating to ‘ Requisition summary ’. Here you can get your ‘requisition’ details by entering your requisition number.:
Navigations : Purchasing, Vision Operations (USA) » Requisitions » Requisition Summary
Here You can check the status of Requisition.
Here, our requisition is approved. You can also view the ‘Action History’ of the requisition by navigating to Tools>> Action History.
Purchase Requisition history
Requisitions Type
Internal Requisitions are created if the Items are to be obtained from one Inventory location to another location within the same organization. Here the source of the requisition would be INVENTORY. There is no approval process for internal requisition.
How to cancel Requisition in R12
Navigations : Purchasing, Vision Operations (USA) » Requisitions » Requisition Summary
- Query With Requisition Number
- Go to TOOLS Menu and select option called ‘Control’.
- Choose the option “Cancel Requisition”.
0 comments