XLA/SLA AMB Components Underlying Data Structure

Posted on 27-May-11. Filed under: R12 | Tags: , , |

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 it to print off: R12 Simple ERD of SLA AMB Components

In addition, here’s the SQL from a SQL Developer report I’ve developed to provide a data extract from the above which documents most SLA configs: SLA JLT and ADR Detail for AMB Components SQL.

Hope it helps..

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

Goodbye T-Codes! An Intro to R12 Subledger Accounting (SLA) for Federal Financials

Posted on 30-Sep-08. Filed under: R12 | Tags: , , , |

I thought it would be appropriate to upload the presentation I gave with Cary Payne (i360 Technologies) at the Collaborate ’08 FEDSIG meeting in Denver.  The presentation’s goal was to provide an introduction to SLA Concepts, Capabilities and Terminology with a focus on relevant topics to Federal Financials customers.  We presented how R12 Subledger Architecture allows us to finally improve accounting processes & accuracy through retiring the the old USSGL Transaction Code model.  Its important to note that implementing SLA is required for Federal Financials customers upgrading to R12 as USSGL Transaction Codes are no longer an option for accounting events.  And from my perspective, that’s definitely a good thing!

The presentation agenda is comprised of:

  • SLA Basic Terminology and Benefits to Federal Financials
  • Accounting Methods Builder (AMB) Components
  • Demonstration (sorry you missed the live version, but screen shots are included in the presentation)
  • Standard SLA Reports and Reconciliation Tools
  • Secondary Ledgers
  • Other SLA and AMB Components/Features
  • Implementing SLA
  • Additional Resources

There’s a lot to SLA and the hardest part for me was figuring out where to start in trying to understand it.  Once the pieces of the concepts fall into place, its not too bad.  Please see the click the link to view the presentation and I hope it provides a valuable introduction to these concepts.  It was a great experience to figure it out and I hope others can benefit.


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

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