R12 Absolute Budgetary Control on Project Gives Warning but Allows to Submit Purchase Requisition in iProcurement (Doc ID 2135297.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to create a purchase requisition in iProcurement the following warning occurs.

WARNING
-----------------------
Check funds completed with warnings
Line #1 Distribution #1 The transaction fails budgetary control at the resource level


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. iProcurement > Create a purchase requisition
2. Complete the Requisition information > fill the fields for Billing
  
  Project = Generic Project Name
  Task = 03
  Expenditure = Hardware Cost
  Expenditure Organization = ORG Name
  Expenditure Item Date = (Date)
  GL Date = (Date)
 
3. Click on Submit

4. On the 'Check fund result' page the following question appeared:
  Check Funds returned warnings. Do you still want to submit your requisition ? NO/YES

5. Click on YES

6. Confirmation shows: Requisition (number) has been submitted for approval.


----------------------------------------------------------------------

Sample Testcase:

1. The projects is having Budget 90.000
2. The resource (Hardware Cost) for which the requisition is created is having a budget of 30.000
3. There are commitments on Project, Resource Group and Resource (Hardware Cost) as 41.000
4. Available funds:
- At project level:    90.000-41.000 =  49.000
- At resource level: 30.000-41.000 = -11.000

5. The budgetary control is set as:
Project level – Absolute
Resource level – Advisory
Even if the customer is setting budgetary control as Absolute as Resource level the system is allowing the requisition to be submitted.

6. On the table pa_bc_packets there is the result code:
PROJECT_RESULT_CODE = F112 (The transaction failed budgetary control at the project level)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms