R12 Federal Financials Subledger Accounting Teardown Webinar, 10-Aug, 9:00am ET

OAUG has invited me to present as part of their upcoming Best of COLLABORATE ’12 Educational Series.  I’ll be delivering the R12 Federal Financials Subledger Accounting Teardown presentation via Webinar on Friday, August 10th, starting at 9AM EDT.  This presentation is a deep-dive into most of the key SLA concepts that support the R12 Federal Financials SLA accounting engine.  My goal is to share what I’ve learned through 1 1/2 years of supporting one of the most complex Federal R12 upgrades to-date, now live for 5+ months.

Here’s the presentation agenda:

This is free for all OAUG (more...)

6-digit USSGL and GTAS Implementation Postponed 1 Year, until FY14

Treasury announced on Friday, July 13th that the implementation of GTAS and the proposed 6-digit USSGL has been postponed until Dec, 2013.

Here’s a copy of the memo sent out:

Signed Memo to All CFOs and Deputy CFO GTAS 7 13 12


Important R12 FV PO Commitment Accounting Attribute Assignment Updates identified in patch 13610367

Patch 13610367, released earlier this year, provided an update to the seeded Federal Purchasing AAD that is important for all R12.1 Federal PO Customers to understand, even if not using the seeded Federal SLA definitions.  The AAD change included updates to a couple of the key Accounting Attribute Assignments for the FV PO Commitment JLT. 

The changes were:

Accounting Attribute Assignment: Allocated to Distribution Type, changed to source: Allocated to Main Document Distribution Type
Accounting Attribute Assignment: Allocated to First Distribution Identifier, changed to source: Allocated to Main Document Distribution Identifier

The SLA configuration we’re using at my current gig is non-seeded and agency-unique but modeled (more...)

Oracle Spring ’12 Federal Development Update

I didn’t attend, but there was an Oracle Federal Financial Briefing on 17-Apr in Reston where information was shared about some of the upcoming GTAS enhancements and target patch release dates.  Personally, besides focusing on our Fed R12.1.3 stabilization efforts on my current gig, I’m working to get smart on some of the basics associated with GTAS, the upcoming 6-digit USSGL standard and new Federal Accounting/System process changes associated.

As soon as we can get our hands on these new GTAS patches, we need to jump on them to start understanding some of the impacts to our (more...)

Oct’11 Federal Financials Update

I was able to get a copy of the E-Business Suite Federal Financials Update slides presented at this year’s Oracle Federal Forum on October 18th. Most of the content revolves around the upcoming Federal interface changes and transition to the Governmentwide Treasury Account Symbol Adjusted Trial Balance System (GTAS) to replace FACTS I & II.  I’m sure these changes are definitely going to keep us busy!!

Here is the link:

OracleFedForum EBS Directions


XLA/SLA AMB Components Underlying Data Structure

For anyone dealing with R12 Subledger Accounting (SLA) configuration and troubleshooting, it can be helpful to understand how the SLA Accounting Methods Builder (AMB) Components are organized within the XLA schema of the R12 database.  Here’s an Entity Relationship Diagram (ERD) I’ve put together as a tool to utilize when needing to build queries of most SLA configurations.  This doesn’t encompass every type of SLA component (e.g. it doesn’t include Business Flow data), since I focused it on just the AMB Components I deal with the most, but includes the major components.

Here’s a PDF copy of (more...)

Finally Cool: @OracleFedApps is on Twitter

If you haven’t visited the actual blog lately and are just keeping up via  a blog reader or some other type of subscription, you might have missed that I incorporated a Twitter feed a couple months back.  I admit, my tweets aren’t going to be as entertaining as @CharlieSheen and I don’t expect to have 8 million+ followers like @BarackObama, but I’m trying to share a few experiences from the R12.1.3 Federal upgrade I’m working through.  Hoping the short info may benefit others going through the same.  Tweets are a great quick, simple way to (more...)

R12 SLA Sources Breakdown

One of the most fundamental components of the R12 Subledger Accounting Architecture (SLA) is the concept of SLA Sources.  There is a good bit of documentation on many SLA components, including my prior OAUG Presentations on SLA, but good explanations of SLA sources are a bit harder to find.  So I thought I’d take a shot at helping spread better understanding with this post.

SLA Source values play critical roles in XLA event processing and R12 GL journal creation such as:

  • fundamental data elements that drive how Journal Line Type (JLT) and Account Derivation Rules (ADR) are (more...)

Be aware of R12 Data Model changes to properly assess R12 upgrade rework

Any entity upgrading to R12 should sufficiently understand the data model changes between 11i and R12.  Based on an entities’ dependence on the existing 11i data models that change, there can be a significant level of rework required to ensure that existing custom RDF/BI Pubisher Reports, Discoverer Reports, outbound interfaces, custom views, custom SQL & PL/SQL, etc. will function properly in the R12 environment.  Analysis of custom objects relative to the data model changes can’t just be limited to whether objects will compile or run in R12, but should also include analysis of whether the proper data is (more...)

Taking the edge off implementing SLA…

Are you struggling w/SLA burnout??  Looking for something to fill the time during a potential government shutdown??

Fully understanding and implementing SLA for Federal Financials continues to be quite a challenge in a current upgrade I’m working on.  This is especially true when trying to ensure all the proper Upward/Downward accounting is properly done, but at the same time ensuring the PYA adjustments are not overstated as part of document revisions.

So, we thought we’d have a little fun and honor Colorado’s Microbrewing heritage with a nice new little home-brewed special for our team to help us enjoy (more...)