FVBEINTB Federal Budget Execution Transactions Import Process Poor Performance Issue (Doc ID 2213457.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle U.S. Federal Financials - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

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

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