Friday, June 19, 2015

Quantity Budget Control in Oracle Projects/Oracle Purchasing

Problem: 1 :Material Quantity Budget Control  Project wise in Purchase

Problem : 2: Indent Budget Control
Business Objective
To achieve the budget control on qty in purchase order/Indent as per defined budget in that period at the level of Project/Task
Solution Type
 Custom Built  or Configuration
Solution Approach
We need to provide provision to define Project Budget at Qty level by creating a extra table on Project.
We can also do a work around by defining the Expenditure type supported by the DFF definition and linking the Item Number with the Exp Type.
Once budget is defined, we can do a form personalization at the purchase/indent form to control the qty.
Impact
Number of Exp type will increase and users might face problem in LOV