Manage Federal Lookups

In U.S. Federal Financials, lists of values in drop-down lists are stored as lookups.

You can add values to some predefined lookups according to your business requirements. For example, U.S. Federal Financials includes a Budget Subfunction Code field on the New Fund Attribute page for setting up federal fund attributes. You can create user-defined lookup values, or lookups, for this field.

Each list of values (LOV) has its own lookup table. An entry within a lookup table consists of these elements:

• A lookup type identifies the table in which a lookup value exists. In effect, it distinguishes lookup values belonging to one LOV from those belonging to others.
• Within a given lookup type, each entry correlates a "lookup code" to a "meaning." The code is an internal value. The meaning is the text that actually appears in an LOV.
• Each entry might also have a description.

The configuration level of a lookup type identifies whether the lookups in that lookup type can be edited. This applies data security to lookups. The configuration levels are user, extensible, and system. While you can't update or delete system lookup types, you can update or delete user and extensible lookup types based on your requirements.

Here are the predefined system lookup types for U.S. Federal Financials:

Lookup Type	Lookup Type Meaning	Where It's Used
ORA_FV_AGENCY_TYPE	Type	Manage Agency Location Codes Manage Federal Account Symbols Manage Treasury Account Symbols
ORA_FV_APPORTIONMENT_CAT_CODE	Apportionment Category Code	Manage Fund Attributes Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage GTAS Balances
ORA_FV_AUTHORITY_DURATION_CODE	Authority Duration Code	Manage Treasury Account Symbols
ORA_FV_AUTHORITY_TYPE	Authority Type	Manage Federal Attributes Manage Federal Attribute Supplemental Rules
ORA_FV_AVAILABILITY_TYPE_CODE	Availability Type Code	Manage Treasury Account Symbols Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage GTAS Balances
ORA_FV_BEA_CATEGORY_CODE	BEA Category Code	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage Fund Attributes Manage GTAS Balances
ORA_FV_BEA_CATEGORY_TYPE	BEA Category Type	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage GTAS Balances
ORA_FV_BETC_TYPE	BETC Type	Manage Treasury Account Symbols
ORA_FV_BORROWING_SOURCE	Borrowing Source	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage Fund Attributes Manage GTAS Balances
ORA_FV_BUDGET_SPENDING_TYPE	Budget Spending Type	Manage USSGL Accounts
ORA_FV_BUDGT_IMPACT_INDICATOR	Budget Impact Indicator	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage GTAS Balances
ORA_FV_CHECK_PAYMENT_FORMAT	Check Payment Format	Manage Payment Type Mapping
ORA_FV_CLOSING_METHOD	Closing Method	Manage Fund Attributes
ORA_FV_CURR_OR_SUBSEQUENT	Current or Subsequent	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage GTAS Balances
ORA_FV_CUST_OR_NONCUST_CODE	Custodial or Noncustodial Code	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage Fund Attributes Manage GTAS Balances
ORA_FV_DACT_FILE_NAME	DATA Act File Name	Manage Federal DATA Act Balances
ORA_FV_DACT_FILE_A_AMOUNT_TYPE	DATA Act File A Amount Type	Manage Federal DATA Act Balances
ORA_FV_DACT_FILE_C_PRELI_FINAL	DATA Act File C preliminary Final	Manage Federal DATA Act Balances
ORA_FV_DATA_ACT_AMOUNT_TYPE	DATA Act Amount Type	Manage Federal DATA Act Balances
ORA_FV_DATA_ACT_AWARD_TYPE	DATA Act Award Type	Manage Orders (Purchase Orders)
ORA_FV_DATA_ACT_BAL_TYPE	DATA Act Balance Type	Manage Federal DATA Act Balances
ORA_FV_DATA_ACT_FILE_TYPE	DATA Act File Type	Manage Federal DATA Act Balances
ORA_FV_DATA_ACT_OPERATOR	DATA Act Operator	Manage Federal DATA Act Balances
ORA_FV_DEFINITE_OR_INDEFINITE	Definite or Indefinite	Manage Fund Attributes
ORA_FV_DIRECT_OR_REIMBURSEABLE	Direct or Reimbursable	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage Fund Attributes Manage GTAS Balances
ORA_FV_DISBURSING_TYPE	Disbursing Type	Manage Agency Location Codes
ORA_FV_DOCUMENT_NUMBER_ENTRY	Document Number Entry	Manage Federal Ledger Options
ORA_FV_DOCUMENT_NUMBER_TYPE	Document Number Type	Manage Federal Ledger Options
ORA_FV_EXCHANGE_OR_NO_EXCHANGE	Exchange or Nonexchange	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage Fund Attributes Manage GTAS Balances
ORA_FV_FED_FILE_CREATION_TYPE	Federal File Creation Type	Create Federal Files process
ORA_FV_FED_OR_NONFED_CODE	Federal or Non-Federal Code	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage GTAS Balances Manage Suppliers Manage Customers
ORA_FV_FINANCING_ACCOUNT_CODE	Financing Account Code	Manage Treasury Account Symbols
ORA_FV_FUNDING_DERIVATION_TYPE	Funding Derivation Type	Manage Treasury Account Symbols Manage Fund Attributes
ORA_FV_GTAS_BALANCE_TYPE	GTAS Beginning Ending Balance	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage GTAS Balances
ORA_FV_NEW_OR_BAL	New or Balance Code	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage GTAS Balances Manage Fund Attributes
ORA_FV_NORMAL_BALANCE	Normal Balance	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage GTAS Balances Manage USSGL Accounts
ORA_FV_PAM_ACH_PAYMENT_FORMAT	Electronic Payment Format	Manage Payment Type Mapping
ORA_FV_PAM_PAYMENT_TYPE	PAM Payment Type	Manage Payment Type Mapping
ORA_FV_PAYMENT_OR_COLLECTION	Payment or Collection	Manage CTA FBWT Account Definitions Manage Treasury Account Symbols
ORA_FV_PAYMENT_RANGE_TYPE	Payment Range Type	Manage Treasury Payment Schedules
ORA_FV_PRIOR_YEAR_ADJUSTMENT	Prior Year Adjustments Code	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage GTAS Balances
ORA_FV_REDUCTION_TYPE	Reduction Type	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage GTAS Balances
ORA_FV_REPORTING_TYPE	Reporting Type	Manage Treasury Account Symbols
ORA_FV_SPS_ACH_PAYMENT_FORMAT	Electronic Payment Format	Manage Payment Type Mapping
ORA_FV_SPS_PAYMENT_TYPE	SPS Payment Type	Manage Payment Type Mapping
ORA_FV_SUM_SCHED_STATUS	Summary Schedule Status	Manage Treasury Payment Schedules
ORA_FV_TREASURY_CONFIRM_STATUS	Treasury Confirmation Status	Manage Treasury Payment Schedules
ORA_FV_BE_LEVEL_OPERATION	Budget Level Security Context Operation	BE Level Security Object
ORA_FV_RPT_CODE_VALID_STATUS	Reporting Code Validation Status	Manage DATA Act Balances
ORA_FV_CTA_REPORT_PARAM	CTA Report Parameters	Perform CTA Reporting process
ORA_FV_REPORT_CODE_OPERATOR	Reporting Code Operators	Manage Federal Attribute Supplemental Rules
ORA_FV_ATTRIBUTE_CATEGORY	Federal Attribute Category	Manage Federal Attributes
ORA_FV_TRADING_PARTNER_SOURCE	Federal Trading Partner Source	Manage Federal Attributes
ORA_FV_PURCHASE_ORDER_SOURCE	Federal Purchase Order Source	Manage Federal Attributes
ORA_FV_FUND_ATTR_SOURCE	Federal Fund Attribute Source	Manage Federal Attributes
ORA_FV_SOURCE_VALUE	Federal Source Value	Manage Federal Attributes Manage Federal Account Attributes Manage Federal Attribute Supplemental Rules
ORA_FV_ACC_ATTRIBUTE_STATUS	Federal Account Attribute Status	Manage Federal Ledger Options
ORA_FV_DATA_ACT_REPORTABLE	Federal DATA Act Reportable	Manage Federal Attributes
ORA_FV_CRITERIA_OPERATOR	Criteria Operator	Manage DATA Act Balances
ORA_FV_FEDERAL_ATTRIBUTES	Federal Attributes	Manage Federal Attributes
ORA_FV_CREATE_FED_FILE_MODE	Create Federal File Process Mode	Create Federal Files process
ORA_FV_GTAS_TRIAL_BALANCE_TYPE	GTAS Trial Balance Type	Create Federal Files process
ORA_FV_AR_ADJ_STATUS	Federal Receivables Adjustment Status	Global descriptive flexfield in Accounts Receivable transactions
ORA_FV_IPAC_TXN_SUB_CATE	Federal IPAC Transaction Subcategory	Global descriptive flexfield in Accounts Receivable transactions
ORA_FV_REC_TXN_CATE	Federal Receivables Accounting Transaction Category	Global descriptive flexfield in Accounts Receivable transactions
ORA_FV_IPAC_RECORD_TYPE	Record Type	Manage IPAC Transactions
ORA_FV_IPAC_TXN_TYPE	Transaction Type	Manage IPAC Transactions
ORA_FV_AP_HOLD_MESSAGE	Hold Message	Invoices Hold
ORA_FV_SAM_PROCESS_TYPE	SAM Process Type	Import SAM Trading Partner process

Here are the predefined user lookups:

Lookup Type	Lookup Type Meaning	Where It's Used
ORA_FV_CATEGORY_B_CODE	Apportionment Category B Code	Manage GTAS Balances
ORA_FV_BUDGET_SUBFUNCTION	Budget Subfunction Code	Manage Fund Attributes
ORA_FV_DISASTER_EMER_FUND_CODE	Disaster Emergency Fund Code	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage Fund Attributes Manage GTAS Balances
ORA_FV_OBJECT_CLASS_CODE	Object Class Code	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage GTAS Balances
ORA_FV_PERIOD_OF_AVAILABILITY	Period of Availability	Manage Treasury Account Symbols Manage Fund Attributes
ORA_FV_PROGRAM_ACTIVITY_CODE	Program Activity	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage GTAS Balances
ORA_FV_PROGRAM_REPORT_CATEGORY	Program Report Category Code	Manage Federal Attributes Manage Federal Attribute Supplemental Rules Manage GTAS Balances
ORA_FV_CTA_RECLASS_JOURNAL_CAT	CTA Reclassification Journal Category	Manage Journals

Here are the predefined extensible lookups:

Lookup Type	Lookup Type Meaning	Where It's Used
ORA_FV_DISC_LOST_REASON_CODE	Discount Reason Code	Manage Federal Setup Options
ORA_FV_FUND_TYPE	Fund Type	Manage Treasury Account Symbols
ORA_FV_INTEREST_REASON_CODE	Interest Reason Code	Manage Federal Setup Options