For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
Problem Statement:
Today, you can cancel requisitions even if during the process, budgetary control fails to release funds reserved against the requisition. We allow this behavior because we do not want the requisitions to be placed on purchase orders that are no longer needed and reach the suppliers.
Solution proposal:
1. As discussed in a previous article, the first step is to run the Cancel Requisition Lines in Spreadsheet from Fusion Self Service Procurement to see all open commitments that need to be liquidated in a given period
2. You then have to decide whether to cancel these requisitions or place any approved ones on a purchase order.
3. You can set the Budgetary control default date rule to 'System Date' as opposed to 'Current Transaction Budget Date'. This will ensure that any cancellations will have the funds released in the current period.
NOTE: 3. is set up in the FSM Task 'Manage Budgetary Control'
4. In the event that a requisition is canceled but the funds are not released because of a closed period, you can adopt the following process:
a) Create a report using OTBI to see all requisition distributions with Fund Status of 'Failed'. (These are the distributions that are holding funds)
b) Create a manual encumbrance commitment journal entry for Encumbrance Accounting reversals (If applicable)
c) Manually fix the budget
We do not expect that you will have too many of requisitions in this status but if you do, this is the recommendation.
We are reviewing ideas to enhance these processes including a funds check warning upon cancellation of requisitions or other alternatives. Goes without saying these are merely ideas at this time not time bound proposals.
Hope this article is helpful. Do let us know with your comments and ratings.
Customers / Support
There were a couple of questions in this area in the recent past in our internal forums. I thought this tip might be helpful if you are not already familiar with the same.
Context:
The symptom that caused this question was an error submitting a budget controlled requisition for approval: Missing Currency Conversion on transaction
Steps the customer followed:
1. Create a requisition
2. Added project details
3. Submitted requisition for approval
4. Funds check failed with the missing currency conversion error
Analysis:
The first check the customer did was to check if a currency conversion was defined between the requisition's functional currency and the budget currency. This came back positive, i.e. a conversion rate was present.
On further detailed analysis, my colleague found the following issues:
1. The conversion rate type on the control budget was not the same that was used on the requisition
2. The budget date though has to also be considered was moot here because of 1.
Conclusion:
Concept: The check funds process will attempt to convert the requisition amount to the control budget currency using the rate type in the control budget and the budget date entered in requisition distribution.
So when you encounter an error, first ensure that the rate type used between the control budget and the requisition are the same and secondly that a rate has been defined for the budget date on the distribution.
Hi All,
Unable to Duplicate Requisition it shows "In Budget is a required field" error.
In our requisition screen, we are using mandatory DFF name "In Budget".
Please help me with this.
Thanks,
Dev Thota.
Customers / Support
This issue has also been brought more than a couple of times in various forums. I think it is important for you to take note of this.
Issue:
Budget control enabled lines must not be allowed to be split in Process Requisitions.
Fix:
Fusion Self Service Procurement has added a validation check to ensure that a split is not allowed for such requisitions unless the Funds Status is set to Not Applicable or is Null.
Customers / Support
This article is important for the following reasons:
a) It reminds you of a feature that was enabled in 19B with Opt-in (this is a Purchasing Opt-in) entitled: Reinstate Unfulfilled Requisition Demand When Canceling a Purchase Order under Budgetary Control
b) Also importantly, it seeks to remind you that this Opt-in is set to expire in Update 19D which means you will now automatically be entitled to the behavior that this feature has to offer
What this feature offers:
1. When the Opt-in prescribed has been turned on and a requisition line is BCEA enabled, if the corresponding Purchase Order line is canceled with the option 'Retain Unfulfilled Demand', the system will create a new requisition line (reinstate) instead of the existing one
2. Funds will be reserved for the new line, importantly, even when there isn't enough funds available to reserve.
This way, the requester of the original line will receive their requested item/s without any further process requirements.
Context:
The customer in this case observed that when they create 'Incomplete' requisitions through SOAP or FBDI processes, the budgetary control process did not kick off Funds Reservation on Submit even though the configuration was set to Reserve on Submit.
Tip:
We support Reserve on Approval for budgetary controls when using FBDI or SOAP Services to import and create requisitions. So the customers have the following 2 choices:
1. Create the requisitions in Approved status when using these services so that the Funds Reservation is kicked off
2. Import the requisitions as Incomplete and submit the requisitions through the UI for approval for the funds reservation process to be kicked off
Hi all,
In Requisition / PO line-entry all inventory items are coming, We need to restrict some items for some people.
Please suggest.
Thanks,
Dev Thota.
Hi all,
Work Order(WO): Requisition is approved without approval.
Thanks,
Dev Thota.
Customers / Support
I have seen a reasonable number of questions around this tip which is why I wanted to provide a quick reminder of how Funds Status operates in the context of Internal Material Transfer (IMT) flows.
Business Flow:
The customers in this case wanted to know if there was a bug in the system where the Funds Status on the Requisition never changed to Liquidated from Reserved even after the goods were received. The context of this concern were IMT flows.
Tip:
My colleague Mara provided the clarification that I think is quite useful to know the next time this question arises in anyone's mind or if Support gets asked this question in SRs:
=========================================================================================================
In the internal material transfer flow you won't see the funds status change from Reserved to Liquidated in the requisition pages.
This is because Inventory is not supporting budgetary control at the moment. However, Cost Management handles budgetary control and encumbrance accounting processing of the expenditure after final delivery for requisition sourced transfer orders.
In the Budgetary Control workarea you should be able to see the budget impact with the report Review Budgetary Control Transactions. There should be an entry for the expenditure created by Costing, which will mean that the corresponding commitment in the requisition is released/liquidated.
=========================================================================================================
The client has a budget for every Capital Expenditure (CAPEX) . They track based on certain categories. For example vehicle budget. At the time of the request , amount needs to be checked against the budget.
When raising a purchase requisition the user normally enters the asset clearing account for the charge account. This is to ensure the FA clearing account selected in the process of asset addition.
How to check the budget against the relevant account at the time of purchase requisition.