My Oracle Support Banner

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.
FVBEINTB

Symptoms

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

ACTUAL BEHAVIOR
---------------
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

(SELECT MAX(budget_level_id)
  -- FROM fv_budget_distribution_dtl
  FROM fv_be_trx_dtls
  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

EXPECTED BEHAVIOR
-----------------------
Table fv_budget_distribution_dtl should have been used in the above SQL query

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Federal Administrator.
2. Run the Budget Execution Transactions Import Process

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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