AP9.2.Budget Check (FS_BP) Process Doesn't Consider Source Transaction Processing Sequence When Running (Doc ID 2962472.1)

Last updated on JULY 25, 2023

Applies to:

Symptoms

When Budget checking ,using the FS_BP processor, 3 vouchers with descending accounting dates whose total amount > budget amount and having set up the Source Transactions Order by Accounting date, the 2nd voucher is ending in error with “exceeding Budget tolerance” instead of the 1st voucher – as it
has the latest accounting date and exceeds available balance.

The issue can be reproduced at will with the following steps:

1. Go to Commitment Control> Define Control Budgets>Source Transactions for AP_VOUCHER and set the Order by ACCOUNTING_DT on tab Fields.
2. Budget Definition ( Commitment Control>Define Control Budgets>Budget Definitions).
   
3. Ledger for a Unit for Us005 (Setup Financial>Business Unit related>General Ledger> Ledger for a Unit) and add the APPROP ledger group and uncheck the detail.
4. Enter a budget journal for account 500000, fund F100 and department 14000 for US005 and APPROP ledger group , amount 1500 USD ( Commitment Control>Budget Journals>Enter budget journals).
5. Check Budget overview (commitment Control>Review Budget Activities> Budget Overview).
6. Create 3 Vouchers in Descending Order of the Accounting Date with (Voucher 1 with amount 1000 USD and acctg_date =15th May 2023, Voucher 2 with amount 500 USD and acctg_date =14th May 2023, Voucher 3 with amount 500 USD and acctg_date =13th May 2023) and Save them.
   (Account Payables>Vouchers>Add/Update>Regular Entry).
7. Run Budget Check Process (Account Payables>Batch Processes>Voucher>Voucher Budget check).
8. Process ends in Warning with 2nd voucher ending in error „Exceeds Budget tolerance”, instead of the 1st voucher as expected.

For more information, check the replication document attached.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.