FV Tables (190)

FV - Federal Financials — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
FV_1096_DATA_ALL 6 Temporary processing table populated by FV 1099-GOV and 1099-INT reports for the generation of FV 1096 report
FV_1099C_ALL 32 Temporary processing table populated by the FVX1099C process
FV_1099_TAPE_DATA_ALL 7 Temporary processing table populated by FV 1099-GOV and 1099-INT reports
FV_ALC_ADDRESSES_ALL 36 Stores Agency Location Code Addresses
FV_ALC_GWA_CATEGORIES 26 Stores the GWA Reporter Categories with effective start and end dates for each ALC with non-blank business activity.
FV_AP_CASH_POS_TEMP 13 Temporary table for processing PMC-29 Cash Position
FV_AR_ACC_CATEGORY_MAP_DTL 24
FV_AR_ACC_CATEGORY_MAP_HDR 8
FV_AR_BATCHES_ALL 41 Stores receipt batch header information to be processed by the Apply Cash Receipt process
FV_AR_CONTROLS_ALL 4 Contains finance accrual charge information
FV_AR_FIN_CHRG_INVOICES_ALL 23
FV_AR_FIN_CHRG_INV_LINES_ALL 15
FV_ASSIGN_REASON_CODES_ALL 31 Stores data elements needed for the Prompt Payment Statistics report
FV_BD_CONTROLS 12 Contains budgetary discount transactions
FV_BE_ACCOUNT_PAIRS 11 Transaction Type/Sub Type account pairings
FV_BE_INTERFACE 75 Users insert records into this table before executing the Budget Execution Transactions Import Process
FV_BE_INTERFACE_CONTROL 5 Stores the control information required for import processing
FV_BE_INTERFACE_HISTORY 75 Same structure as the FV_BE_INTERFACE table
FV_BE_RPR_TRANSACTIONS 103 Stores the details for the reprogramming transactions
FV_BE_TRANSACTION_TYPES 37 FV_BE_TRANSACTION_TYPES is used to store appropriation transaction types. This is the base table for the Define Budget Transaction Type for
FV_BE_TRX_CODES 9 Stores the transaction codes associated with a transaction type. This is the base table for the detail block of the Define Budget Transactio
FV_BE_TRX_DTLS 76 Stores the transaction details for all budget execution transactions. This is the base table for the detail block of the Define Appropriatio
FV_BE_TRX_HDRS 70 Stores the document information for all budget execution transactions. This is the base table for the header block of the Define Appropriati
FV_BE_TRX_SUB_TYPES 12 Stores the sub types associated with a transaction type. This is the base table for the detail block of the Define Budget Transaction Types
FV_BUDGET_DISTRIBUTION_DTL 72 Budgeting segments data needed for a budget level
FV_BUDGET_DISTRIBUTION_HDR 30 Treasury symbols and fund values data
FV_BUDGET_LEVELS 31 Defines the required level of a budget
FV_BUDGET_OPTIONS 8 Budget freeze level for a Set of Books
FV_BUDGET_USER_DTL 17 User budget access level options
FV_BUDGET_USER_HDR 25 Information about a budget user group
FV_CCID_CFS_GT 2
FV_CCR_BPN_CLOB_DATA 1
FV_CCR_CLASS_CODES 8
FV_CCR_FILE_TEMP 272 The FV_CCR_FILE_TEMP table definition includes all the fields present in the complete CCR extract file. The data from the extract files is f
FV_CCR_FLAGS 3
FV_CCR_ORGS 14 This table stores information about the operating units with access to each DUNS/DUNS+4 number
FV_CCR_PROCESS_GT 270
FV_CCR_PROCESS_REPORT 12 The FV_CCR_PROCESS_REPORT temporarily stores the errors encountered during the upload process for reporting purposes.
FV_CCR_VENDORS 351 The FV_CCR_VENDORS table stores all the data from CCR that does not have a logical place in the Payables data model. It also stores a suppl
FV_CFS_REP_LINES 17
FV_CFS_REP_LINE_CALC 20
FV_CFS_REP_LINE_DTL 52
FV_CFS_REP_TEMP 15
FV_CUST_FINANCE_CHRGS_ALL 15 Contains customer finance charge information
FV_CUST_VEND_XREFS 25 Base table used for the AR/AP Netting Customer Vendor Cross Reference form
FV_DELINQ_INVOICES_ALL 47 Stores temporary information needed by the Delinquent Invoices Referral Process
FV_DISCOUNTED_INVOICES 15 Stores discount information on invoices that had available discounts
FV_DMS_AGENCY_DEFINITIONS_ALL 28 Stores agency information needed by the Delinquent Invoice Referral process
FV_DMS_CODE_ASSIGNMENTS_ALL 24 Stores program code information needed by the Delinquent Invoice Referral process
FV_DMS_CODE_DEFINITIONS_ALL 26 Stores program code assignments information needed by the Delinquent Invoice Referral process
FV_DOC_CR_TEMP 9 Stores the document identifiers which match the search criteria given in the Find window of the Document Cross-Reference window
FV_ETC_ACTIVITIES 30 Stores QuickCodes for public sector applications
FV_EVENTS_TRANSACTION_CODE 7 Stores short list of US SGL transaction codes for a particular transaction event
FV_EXTRACT_DETAIL_GT_LOGS 68
FV_FACTS1_DIFF_BALANCES 12 Stores data used for FACTS I report generation.
FV_FACTS1_FED_ACCOUNTS 7 Stores the Federal accounts required for FACTS I report generation.
FV_FACTS1_HEADER_ID_GT 2
FV_FACTS1_LINE_BALANCES 25 Stores information about the journal lines required for FACTS I report generation.
FV_FACTS1_PERIOD_ATTRIBUTES 25 Stores the USSGL accounts and their attributes along with amounts required for the FACTS I report generation.
FV_FACTS1_PROCESSED_JE_HDRS 2 Stores Journal Header ID for the processed journal lines required for FACTS I report generation.
FV_FACTS1_RUN 11 Stores the periods and status for which the FACTS I report was run.
FV_FACTS2_CLOSING_VALIDATION 26 Stores the closing group and closing account information related to US SGL account
FV_FACTS2_EDIT_PARAMS 26 Stores the hard edit 13 and 14 flag values
FV_FACTS2_RETAIN_BAL 28 Stores the ending balance of previous fiscal year and beginning balance of current fiscal year.
FV_FACTSII_ACCOUNTS_GT 5
FV_FACTSII_ENDING_BALANCES 21 Stores the period year ending balances for the FACTSII reporting.
FV_FACTSI_TEMP 17
FV_FACTS_ATTRIBUTES 45 Stores the USSGL accounts required for the FACTS II report generation and all corresponding attributes related to them
FV_FACTS_AUTHORIZATIONS 26 Authorization records for the Treasury symbol
FV_FACTS_BUDGET_ACCOUNTS 31 Stores the budget account codes and related information
FV_FACTS_BUD_FED_ACCTS 26 Holds information about the federal account symbols associated with the budget account codes
FV_FACTS_EDIT_CHECK_STATUS 3 FV_FACTS_EDIT_CHECK_STATUS
FV_FACTS_ENDING_BALANCES 22 Stores the FACTS-I yearly ending balances
FV_FACTS_FEDERAL_ACCOUNTS 32 Information about the federal account symbol and its associated budget account, if applicable
FV_FACTS_FOOTNOTE_HDR 8 Stores the footnote comments as part of the FACTS II Submission Process
FV_FACTS_FOOTNOTE_LINES 9 Stores the footnote sequence and text for a treasury symbol
FV_FACTS_PERIOD_BALANCES 23 This table is used by FACTS I Interface process to store Period Ending Balances.
FV_FACTS_PRC_DTL 28 Table used for Reporting Code Mapping
FV_FACTS_PRC_HDR 32 Table used for FACTS Reporting Code Mapping
FV_FACTS_REPORT_T2 63 Temporary work table populated with summary data used in FACTS report generation
FV_FACTS_RT7_ACCOUNTS 27 Holds values for the US SGL accounts
FV_FACTS_RT7_CODES 28 Authorization codes data
FV_FACTS_RUN 7 Counter information for FACTS file submission
FV_FACTS_SUBMISSION 57 Stores FACTS submission information
FV_FACTS_TEMP 79 FACTS II bulk file transactions data
FV_FACTS_TRX_TEMP 53 Temporary table that stores the FACTS transactions
FV_FACTS_USSGL_ACCOUNTS 56 USSGL accounts data
FV_FINANCE_CHARGE_CONTROLS_ALL 40 Contains finance charge information
FV_FINANCE_CHARGE_GRP_DTLS_ALL 30
FV_FINANCE_CHARGE_GRP_HDRS_ALL 26
FV_FINANCE_CHARGE_HISTORY 32 Contains finance charge rate or flat fee information for each related finance charge
FV_FINANCE_CHRG_CUST_CLASSES 29 Contains finance charge customer types
FV_FINCHRG_DEBITMEMO_TEMP 7 Stores the records that are processed in the Accrue Finance Charge process
FV_FUNDS_AVAIL_ACCT_RANGES 10 The Account Ranges that are defined for each column are stored here
FV_FUNDS_AVAIL_REP_DEF 12 This table contains the column definitions for all the Funds Available Reports .The seed process will populate this table.
FV_FUNDS_AVAIL_TEMP 6
FV_FUND_GROUPS 30 Distinct code for each Set of Books
FV_FUND_PARAMETERS 63 Contains fund parameters information
FV_FUND_PARAMETERS_HISTORY 58 Contains fund parameters history information
FV_GOALS_224_TEMP 5 Information for the FMS Form 224 GOALS file format
FV_GTAS_ACTIVITY_BALANCES 27
FV_GTAS_HEADER_ID_GT 2
FV_HOLIDAY_DATES 25 Contains Holidays/Non-Working Dates information
FV_INTERAGENCY_FUNDS_ALL 36 Interagency information
FV_INTERIM_CASH_RECEIPTS_ALL 43 Contains payment batch information
FV_INVOICE_FINANCE_CHRGS_ALL 22 Contains finance charges information associated with invoices entered in Oracle Public Sector Receivables system
FV_INVOICE_RETURNS_ALL 27 Contains returned invoice information used as part of Due Date Calculation
FV_INVOICE_RETURN_DATES_ALL 13 Contains invoice information used as part of Due Date Calculation
FV_INVOICE_STATUSES_ALL 29 Invoice statuses information for use on the Report on Receivables Due From Public, or Schedule 9 report
FV_INVOICE_STATUSES_HIST_ALL 24 Invoice status history information
FV_INV_SELECTED_DUEDATE 23 Stores invoice records processed through the Due Date Calculation process so records will not be reprocessed
FV_INV_SELECTED_DUEDATE_TEMP 14 Temporary table that stores information about invoices selected for due date payments
FV_IPAC_IMPORT 155 Table used for IPAC disbursement import
FV_IPAC_IMPORT_ERRORS 3 Table Used to store IPAC import errors
FV_IPAC_IMPORT_HISTORY 155 Table used for IPAC disbursement import
FV_IPAC_RECURRING_INV 9 Holds the recurring invoices found in the IPAC file during the Upload IPAC Disbursement proces
FV_IPAC_TRX_ALL 82 IPAC transactions table
FV_LOCKBOX_IPA_TEMP 8 FV_LOCKBOX_IPA_TEMP is used by the Lockbox Finance Charge Application process during the processing of a AutoLockbox transmission.
FV_OPERATING_UNITS_ALL 35 Operating unit information
FV_PAYMENT_FORMAT_TEMP 5
FV_PAYMENT_TYPE_MAP_ALL 9
FV_PB_SEQ_ASSIGNMENTS_ALL 32 The FV_PB_SEQ_ASSIGNMENTS_ALL table is used to define the payment batch sequence assignments . This is the base table for the Payment Batch
FV_PROMPT_PAY_TEMP 10 Temporary reporting table
FV_PYA_ACCOUNTS_TRANS_CODES 31 Contains offset acounts and transaction codes for different Prior Year Adjustment event combinations
FV_PYA_AUDITS 13 Tracks all the original transactions that have been processed by the Transaction Pool process, along with the batch identifier, header ident
FV_PYA_FISCALYEAR_MAP 26 Stores the fiscal year segment values and their respective mapped period ranges
FV_PYA_FISCALYEAR_SEGMENT 26 Stores the fiscal year segment names
FV_PYA_TRANSACTIONS 53 Stores all the Prior Year Adjustment transactions with the account, the amount, PYA event, and source details
FV_PYA_TRANSACTION_HISTORY 35 Stores all the Prior Year Adjustment transactions processed in the PYA Journal Creation Program
FV_RCV_TRANSACTIONS 9 Information about prior period receipts
FV_RECEIVABLES_ACTIVITY_TEMP 4 FV_RECEIVABLES_ACTIVITY_TEMP is a temporary table that is populated by the Receivables Activity Worksheet Process. This table serves as the
FV_RECEIVABLE_TYPES_ALL 9 Types of receivables
FV_REC_CUST_TRX_TYPES_ALL 24 Transactions for a specified receivable type
FV_REFUNDS_VOIDS_ALL 52 Refund, void, and chargeback invoice information for use by the FMS Form 224 report
FV_REIMB_ACTIVITY_TEMP 53
FV_REIMB_DEFINITIONS_LINES 11
FV_REIMB_DEF_ACCT_ASSIGN 11
FV_REIMB_SEGMENT 26
FV_REPORT_DEFINITIONS 60 Data elements needed for the SF 1081 Voucher and Schedule of Withdrawals and Credits document and the FMS Form 224 Statement of Transaction
FV_SF1080_DETAIL_TEMP 9 Line information for generation of the SF 1080 Report
FV_SF1080_HEADER_TEMP 18 Customer information utilized in the generation of the SF 1080 Report
FV_SF1081_TEMP 15 Customer information utilized in the generation of SF 1081 Voucher and Schedule of Withdrawals and Credits
FV_SF1219_AUDITS 21 Stores transactions that are already reported in the FMS Form 1219/1220 report, when run on final mode
FV_SF1219_DEFINITIONS_ACCTS 38 Stores the flexfield account structures that are used to restrict the transactions reported in the FMS Form 1219/1220 report
FV_SF1219_MANUAL_LINES 9 Base table for the FMS Form 1219/1220 Transaction Correction form. Holds the user-assigned report lines for manual transactions.
FV_SF1219_ORG_TEMP 4 Stores the calculated report lines which are to be reported on the FMS Form 1219/1220 report, along with their corresponding organization id
FV_SF1219_REPORT_TEMPLATE 4 Seed table that stores all the standard report lines that appear on the FMS Form 1219/1220 report
FV_SF1219_TEMP 44 Stores transactions that are processed by the FMS Form 1219/1220 process
FV_SF132_APP_REAPP_SCH 175 This table contains the column definitions for all the columns in the SF132 Apportionment and Re Apportionment
FV_SF133_CCIDS_GT 3
FV_SF133_DEFINITIONS_ACCTS 75 Stores the accounts needed for the SF 133 Report on Budget Execution
FV_SF133_DEFINITIONS_COLS_TEMP 18 Temporary table populated with summary data calculated by the SF 133 Report on Budget Execution process
FV_SF133_DEFINITIONS_LINES 16 Stores the data elements required for the SF 133 Report on Budget Execution
FV_SF133_LOAD_ACCTS 4 Seed table used to load the USSGL account codes into the FV_SF133_DEFINTIONS_LINES table
FV_SF133_LOAD_LINES 7 Seed table used to load the SF 133 Report on Budget Execution line number and label into the FV_SF133_DEFINITIONS_LINES table
FV_SF224_AUDITS 27 Tracks records that have already been reported on the FMS Form 224 Statement of Transactions report
FV_SF224_MAP 10 This table stores the combination of Business Activity and GWA Reporter Category and the report ability of transaction categories for that c
FV_SF224_RUN 3 This table maintains the last run extract process status of the 224 process.
FV_SF224_TEMP 64 Contains those records selected for reporting in the specified period
FV_SF224_VOID_TEMP 10 Used by FMS Form 224 process to store the voided transactions for processing
FV_STATUS_FUNDS_FINAL 16 Stores all calculations done in the stored procedure for the Status of Funds report
FV_STATUS_FUNDS_TEMP 4 Stores all temporary calculations done in the stored procedure for the Status of Funds report
FV_STATUS_OBLIG_TEMP 19 Temporary report table for Status of Obligation report
FV_SUMMARY_CONSOLIDATE_ALL 35 Base table for the form Summary Schedules and Consolidated Payment File that stores the Payment Batch names with Control Number and Consoli
FV_SYSTEM_PARAMETERS 24 Stores Federal System parameters
FV_TAS_BETC_MAP 26
FV_TC_MAP_DTL_ALL 28 Detail information of the transaction code mapping window
FV_TC_MAP_HDR_ALL 25 Contains the header information of the transaction mapping information
FV_TC_OFFSETS 27 Stores treasury confirmation offset information
FV_TERMS_TYPES 27 Payment terms information
FV_THIRD_PARTY_TEMP 12 This table is used to store information to be reported on Third Party Remittance Report
FV_TOP_EXCLUSION_CRITERIA_ALL 33
FV_TPP_ASSIGNMENTS_ALL 32 Defines the third party assignments
FV_TPP_CHECK_DETAILS_ALL 11 Stores information about each payment that was changed
FV_TP_BULK_FMT_DATA 19 Stores all the agency-related data and the total payment amount along with the total number of payment records
FV_TP_TREASURY_SYMBOLS 39
FV_TP_TS_AMT_DATA 6
FV_TRANSACTION_EVENTS 30 Defines transaction events for a given activity in an application
FV_TRANSACTION_HEADERS 12 Stores header information for a transaction event activity, application, user, responsibility, or transaction type
FV_TREASURY_CHECK_RANGES 9 Contains the check ranges defined for treasury confirmation payment batch
FV_TREASURY_CONFIRMATIONS_ALL 38 Contains information about the paid schedule numbers, Treasury check number ranges, and payment schedules sent to the U.S. Treasury; stores
FV_TREASURY_SYMBOLS 63 New base table for the Define Appropriation Parameters form
FV_TREASURY_SYMBOLS_HISTORY 64 New base table for the Purge Treasury Symbols process
FV_VALUE_OF_FUND_PERIODS 10 Current value of funds rates information
FV_VOIDED_CHECKS 12 Stores checks voided in Payables; used by the DIT Voided Check process
FV_YE_CLOSED_TREASURY_SYMBOLS 6 Populated by the Year End process when closing a Treasury Symbol in Final mode
FV_YE_GROUPS 28 Year End group definitions
FV_YE_GROUP_SEQUENCES 25 Sequence information for each group
FV_YE_SEQUENCE_ACCOUNTS 30 Detail table of FV_YE_GROUP_SEQUENCES
FV_YE_SEQ_BAL_TEMP 47 Temporary table populated during the Year End Closing process