Recap on adding items for the new American Recovery Act Symbols
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.
Oracle Federal Applications 
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.
Larry.Baugh
12-Mar-09
There’s definately a lot to find out about this subject. I really like all of the points you’ve made.
Anonymous
14-Oct-14
This is super helpful, thanks! I cannot believe there are no previous comments on this.
Anonymous
12-Jun-15