FVBEINTB Federal Budget Execution Transactions Import Process Poor Performance Issue
(Doc ID 2213457.1)
Last updated on MARCH 04, 2019
Applies to:Oracle U.S. Federal Financials - Version 12.2.3 and later
Information in this document applies to any platform.
NOTE: In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
On : 12.2.3 version, BUDGET
Budget Execution Transactions Import Process
Budget Execution Transactions Import Process is taking a very long time and we opened our New fiscal Year and the data is stuck
when you look at the Code FV_BE_INT_PKG - line number 1573
-- FROM fv_budget_distribution_dtl
WHERE fund_value = valid_rec.fund_value
AND set_of_books_id = valid_rec.set_of_books_id
AND budget_level_id < valid_rec.budget_level_id
The above query is completely wrong
fv_be_trx_dtls has no fund_value budget_level_id columns and we are still referring these columns
Table fv_budget_distribution_dtl should have been used in the above SQL query
The issue can be reproduced at will with the following steps:
1. Go to Federal Administrator.
2. Run the Budget Execution Transactions Import Process
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document