Manage Federal Lookups

Define the lookups used by the various Oracle U.S. Federal Financials features.

Here's how you define these lookups:

1. In the Setup and Maintenance work area, go to the Manage Federal Lookups task:

   • Offering: Financials

   • Functional Area: U.S. Federal Financials

   • Task: Manage Federal Lookups

2. Search for the lookup type by using either of these options:

   • In Lookup Type, enter the lookup type and then click Search.
   • In User Module Name, select the user module and then click Search. For example, to define Treasury lookups, select Federal Treasury.

     The search results display the lookup types and the predefined lookup codes.

3. Select the lookup type for which you want to define lookup codes, and in the lookup codes section, click Create from the Actions list.
4. In the new row, enter the values for the new lookup.
   • In Lookup Code, enter the lookup code. A lookup code should consist of 30 or fewer characters, upper-case for alphabetic characters, and no spaces. You can use an underscore between words instead of spaces. Don't begin the code with ORA as this is a value reserved by Oracle for system-provided lookup types and values.
   • From the Reference Data Set list, select the reference data set to be used for the lookup code.
   • In Meaning, enter text that will appear as a value in the LOV.
   • (Optional) In Description, enter a description for the lookup.

5. Click Save and Close.

Here are some examples of lookup codes defined for U.S. Federal Financials:

Lookup Type	Lookup Type Meaning	Lookup Code	Reference Data Set	Meaning
ORA_FV_BUDGET_SUBFUNCTION	Budget Subfunction Code	NNN	Common Data Set	NNN
ORA_FV_PERIOD_OF_AVAILABILITY	Period of Availability	YYYY	Common Data Set	YYYY
ORA_FV_CTA_RECLASS_JOURNAL_CAT	CTA Reclassification Journal Category		Common Data Set