Manage Federal Lookups
Define the lookups used by the various Oracle U.S. Federal Financials features.
Here’s how you define these lookups:
-
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
-
-
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.
- Select the lookup type for which you want to define lookup codes, and in the lookup codes section, click Create from the Actions list.
- 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.
-
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