Recap on adding items for the new American Recovery Act Symbols

Posted on 12-Mar-09. Filed under: Budget Execution | Tags: , |

Getting new Federal Account Symbols assigned to an agency isn’t exactly an every day occurrence, but I’m seeing a lot of that with the new funding being distributed as part of the recent American Recovery and Reinvestment Act (which was of course signed right here in Denver).  As a quick refresh, the following steps are necessary to start using these new accounts:

1) Setup the new Funds in the Accounting Flexfield value-set (Setup > Flexfields > Key > Values) .  If any parent hierarchies are being used, be sure to make sure they are properly updated.

2) Setup the new Treasury Account Codes (Fed Admin: Setup > Appropriation > Treasury Account Codes) which includes setting up the new 4-digit main account, the main account description, and the Fund Type.

3) Setup the new Treasury Symbols (Fed Admin: Setup >Appropriation > Federal Account Symbols) and then click the Parameters button to complete the Treasury Symbol setup including associating the Fund Parameters record with the AFF Fund value.  The Fund must be linked to a Treasury Symbol to support Budget Execution, FACTS and other Fed Admin functionality.

4) Setup the Budget Accounts (Fed Admin: Setup >Appropriation > Budget Accounts) to link these additional attributes to the Treasury Symbols.

5) Setup the Budget Distributions (Fed Admin: Budget > Define > Budget Distributions) to support entering Appropriations and distributing the money for the new funds.

6) If using Projects, its likely that new Projects may need to be setup for the new funds depending on how Projects is implemented and how account generator is driving the fund value.

Treasury Symbols data is stored in a few tables:

fv.fv_fund_groups,fv.fv_treasury_symbols, fv.fv_fund_parameters & fv.fv_facts_federal_accounts

If you’re a Discoverer customer……

….you may notice when looking at these tables that some data element values don’t make much sense.  This is because these tables use various lookup codes vs storing actual values in some of these fields.  To help make the data more friendly when pulling from these tables, you may wish to create custom Discoverer folders using SQL such as the following which brings in the meaning values for the fields.

Fed FV Fund Groups
SELECT g.*,
l.meaning fund_type_meaning
FROM applsys.fnd_lookup_values l,
fv.fv_fund_groups g
WHERE l.lookup_type = ‘FUND_TYPE’
AND l.LOOKUP_CODE   = g.FUND_type;

Fed FV Treasury Symbols
SELECT s.*,
a.meaning disb_224_meaning,
b.meaning Time_frame_meaning,
c.meaning resource_type_meaning,
e.meaning custodial_meaning,
CASE
WHEN DEF_INDEF_FLAG = ‘D’
THEN ‘Definite’
WHEN DEF_INDEF_FLAG = ‘I’
THEN ‘Indefinite’
ELSE NULL
END definite_meaning
FROM fv.fv_treasury_symbols s,
applsys.fnd_lookup_values a,
applsys.fnd_lookup_values b,
applsys.fnd_lookup_values c,
applsys.fnd_lookup_values e
WHERE s.sf224_type_code = a.lookup_code
AND a.lookup_type       = ‘SF224_TYPE’
AND s.time_frame        = b.lookup_code
AND b.lookup_type       = ‘FUND_TIME_FRAME’
AND s.resource_type     = c.lookup_code
AND c.lookup_type       = ‘RESOURCE TYPE’
AND s.cust_non_cust = e.lookup_code
AND e.lookup_type       = ‘FV_CUST_NON_CUST’;

Fed FV Fund Parameters
SELECT s.*,
a.meaning disb_224_meaning,
b.meaning Fund_category_meaning,
c.meaning resource_type_meaning
FROM fv.fv_fund_parameters s,
applsys.fnd_lookup_values a,
applsys.fnd_lookup_values b,
applsys.fnd_lookup_values c
WHERE s.sf224_type_code = a.lookup_code
AND a.lookup_type       = ‘SF224_TYPE’
AND s.fund_category     = b.lookup_code
AND b.lookup_type       = ‘FUND_CATEGORY’
AND s.resource_type     = c.lookup_code
AND c.lookup_type       = ‘RESOURCE TYPE’;

Hope that helps.

Advertisements

Make a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

3 Responses to “Recap on adding items for the new American Recovery Act Symbols”

RSS Feed for Oracle Federal Applications Comments RSS Feed

Also, I forgot to add that be sure to run the Program: Incremental Add/Delete Summary templates to make sure that funds control is properly applied for the new funds. Be sure to check to make sure the summary account balances are being updated accurately after running this request as I have seen some issues with it. If you see issues, then probably the best thing to do is to drop and re-create your summary templates.

There’s definately a lot to find out about this subject. I really like all of the points you’ve made.

This is super helpful, thanks! I cannot believe there are no previous comments on this.


Where's The Comment Form?

  • Purpose

    Sharing info, perspectives and solutions in support of the Oracle Federal E-Business Suite/Financials Community.
  • OracleFedApps Tweets

    Error: Twitter did not respond. Please wait a few minutes and refresh this page.

  • FedCFO Tweets

    Error: Twitter did not respond. Please wait a few minutes and refresh this page.

  • Send In Your Federal Apps Tips

    Have something you want to share with other readers? Just click Submit Tip to send it.
  • Ping Larry

    Have a quick question/ comment? You can Instant Message Larry at www.imlarry.com
  • Chat with Larry

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

%d bloggers like this: