My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.