Seeded Budgetary Control Analysis Inconsistent Results Across Sub-reports (Doc ID 3032420.1)

Last updated on JULY 16, 2024

Applies to:

Symptoms

On : 11.13.23.10.0 version, Ess Jobs, Migration/Maintenance and Audit

ACTUAL BEHAVIOR
---------------
The Seeded Budgetary Control Analysis report shows balance difference between the sub reports generated for the same Control Budget and Period

EXPECTED BEHAVIOR
-----------------------
For the 3 sub reports to show the same balances


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Schedule the Seeded Budgetary Control Analysis report with the parameters
- Control Budget Name
- Budget From and To
- Include Additional Attributes: No

2. Review the sub report generated "Funds available Trend", "View Funds Available", "Account Activities", the balances as are show below

Budget Balance          Consumption                   Reservation                 Transaction all matches for "Funds available Trend" and "View Funds Available",
601,087,050,000.00    56,163,932.58                 601,145,363.130.58     601,143,213,289.88

BUT same concepts for "Account Activities",
600,000,000,000.00    56,163,932.58                 600,058,313.024.58     600,056,163,289.88

Cause

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