Year End

Quick Collaborate ’10 Update

Posted on 20-Apr-10. Filed under: Events, News, Procurement, R12, Year End |

The trip was quick, but I enjoyed getting a quick taste of Collaborate ’10.  Thanks to all those who attended my presentation bright and early on Monday morning.  I have uploaded the slides from my presentation here for reference:  Finally Federal!  Exploring Projects Release 12.1.

I was able to catch the FedSig meeting where I got my first chance to see the Contract Lifecycle Management (CLM) product live.  The presentation included a demonstration of core R12 Advance Procurement Suite (APS) functionality with the CLM features integrated in.  I thought the CLM demo team did a good job and certainly were well-versed in Federal (including DoD) Contracting business processes.  For anyone interested in CLM, be sure to get up to speed on the core R12 APS functionality available, which you could start doing now.  That will serve as a good baseline for understanding the additional features that the CLM product provides when available.  There is a good amount of documentation on R12 APS functionality available online and feel free to check out my Collaborate ’09 Presentation on the APS functionality I thought would be most relevant to the Federal Community.  CLM is said to be available “Calendar Year 2010”, when R12.1.3 is released.  The 12.1 Release Content Documents have been updated to include 12.1.3 features, which makes me think 12.1.3 may not be too far off, although the Procurement RCD doesn’t include anything about CLM.

I also attended another Projects Federal Accounting features session by Neeraj Garg of Project Partners, where I picked up a few pieces of info that I hadn’t figured out yet on the R12.1 projects functionality.  He did a great job.

It was evident from the Cliff Godwin Oracle Apps Strategy Session & the Financials Road Map Session, that Oracle is going to start turning up the pressure to upgrade from 11i10.  Extended support for 11i10 ends in 2013 and Oracle is strongly suggesting to get moving on the R12 upgrade planning/execution.

Another quick nugget: there are a few new pieces of Federal functionality planned for 12.1.3 as documented in the updated Financials 12.1 RCD (Note: 561580.1).  It looks like the Federal Year-End process is being enhanced to better support Pre-Closing Entries and some enhancements to the CCR integration functionality are included.

Read Full Post | Make a Comment ( None so far )

Treating Budgetary Accounts as Balance Sheet Accounts for Year-End Rollover

Posted on 23-Oct-08. Filed under: Funds Control, Year End | Tags: , |

In-case anyone might have missed it, Oracle has provided functionality to streamline the Federal year-end process a bit.  Oracle released patch 5200606 in June 2006 that allows for budgetary accounts to be automatically rolled over (just as asset & liability accounts have always been) as part of the year-end.  This mitigates the necessity of running the Carry Forward Budgetary Account Balances process or a Mass Allocation (what we had to use prior to the Carry Forward Budgetary Account Balances process existence), which essentially created a large journal of offsetting debits/credits in the first period (this is often has been setup as an adjusting period in the calendar definition) of each fiscal year (FY).  This new balance sheet treatment of budgetary accounts seems to save time and eliminates one of the year-end process steps.  I’m familiar with two agencies who have done this in production: National Endowment for Humanities (NEH) & Small Business Administration (SBA).  NEH seemed to be the first as they identified Bug 6620773 (fixed in patch 6753414).  I recently helped SBA just a bit with it for this latest year-end and it works well (there were a few other non-related issues that complicated things just a bit though!).  We are also planning to use this functionality for USAF DEAMS.  Documentation on the functionality/process is available in metalink notes: 373163.1 (, 373649.1 (, the above Bug/Patch & the R12 Fed Financials User Guide speaks a little bit to it.

The effort to update Fed Financials to utilize the new process is actually fairly simple.  Upon patch application and prior to opening the first period of the next FY, run the GL Concurrent request: ‘Program – Track Budgetary Debit/Credit Accounts as Balance Sheet Accounts’ for the set of books.  After this concurrent request is run, when opening the first period of the next FY, the budgetary account balances will be automatically established.  Furthermore, the old Carry Forward Budgetary Account Balances can never be run again.

Required Summary Template Changes

While the process to initialize this functionality is pretty straight forward, there is an impact to the summary account balances based on using this functionality when transitioning from the old method.  Traditionally, summary templates for budgetary funds control are often setup with an Amount Type of ‘Year to Date’.  This worked well because the carry forward journal would always re-establish any 4000 account balances (e.g. 4650) in the current year, thus the YTD accounts would always have enough funding.  By eliminating the carry forward posting, if summary accounts are still set to YTD, the accounts don’t include remaining availability from the prior FY.  The solution to this issue is to update the summary templates to use an Amount Type of ‘Project to Date’.  Project to Date (PJTD) essentially means Inception to Date.  This will allow cumulative remaining balances at the end of one FY to be available in the next FY.

Set amount type to: Project to Date

However, setting the summary templates to PJTD can also result in an issue that some funds available balances will be inflated.  This is the case for customers who have previously used the Carry Forward Budgetary Account Balances or Mass Allocation processes to re-establish the balances for each prior year.  This issue exists where the earliest period of the summary template definition is prior to the last carry forward period.  Since PJTD will include 1) the initial establishment of the funds balances as well as 2) the re-establishment of remaining funds available balances as part of each carry forward, the PJTD balances will be inflated by the sum of the amounts re-established.  For example, if the earliest period of a template is set to 2002 and remaining 2004 funding was carried over at each year-end  (2005, 2006,2007,2008), the funds available balances would be inflated due to the carry over in each of the 4 years after the initial appropriation year.  A solution to this issue is to update the earliest period of the template definition to the last time the Carry Forward Budgetary Account Balances ran/was posted.  This will update the summary account balances to just include activity since the earliest period defined. This is well defined in the GL User Guide: “Enter the Earliest Period for which you want General Ledger to maintain your actual, encumbrance and budget summary account balances. General Ledger maintains summary account balances for this accounting period and for subsequent periods.”    So if an agency is looking to implement the new functionality effective FY 2009, then prior to beginning 2009 activity, the summary templates’ earliest period should be updated to OCT-BEG-2008 (or whatever is the first period in 2008 (likely an adjusting period) where the 2007 carry forward journal was posted to.

Update Earliest Period to: The period corresponding to the last time the Carry Forward Budgetary Account Balances ran/was posted.

Another consideration in making this change is that if Funds Availability FSGs or custom reports are built to look at YTD summary account balances (such as using some of the YTD-Actual seeded FSG column sets), those would likely need to be updated to refer to Project-Actual.

Update 9 Nov 2008: Seems we’re still having issues with the excess balances even with the Earliest Period change suggestion above.  Need to figure out what’s going, but that may not be the total solution.

Read Full Post | Make a Comment ( 3 so far )

Liked it here?
Why not try sites on the blogroll...