FV — Federal Financials
190 documented tables · 67 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
FV_BUDGET_USER_HDR |
Information about a budget user group | hub-leaning |
FV_TRANSMISSION_FORMATS |
Table to store all the transmission formats supported by the Fund Balance with Treasury Import Process | hub-leaning |
FV_YE_GROUPS |
Year End group definitions | hub-leaning |
FV_AAN_SETUP_HDRS_ALL |
Base table used for the AR/AP Netting Receivables Eligibility Criterion Setup form | hub-leaning |
FV_TRANSMISSION_RECORDS |
Table to store all the transmission records for fund balance with treasury import process | satellite-leaning |
FV_FINANCE_CHARGE_CONTROLS_ALL |
Contains finance charge information | satellite-leaning |
FV_DMS_AGENCY_DEFINITIONS_ALL |
Stores agency information needed by the Delinquent Invoice Referral process | hub-leaning |
FV_YE_GROUP_SEQUENCES |
Sequence information for each group | satellite-leaning |
FV_CUST_FINANCE_CHRGS_ALL |
Contains customer finance charge information | satellite-leaning |
FV_CCR_VENDORS |
The FV_CCR_VENDORS table stores all the data from CCR that does not have a logical place in the Payables data | satellite-leaning |
FV_ASSIGN_REASON_CODES_ALL |
Stores data elements needed for the Prompt Payment Statistics report | standalone |
FV_SF1219_TEMP |
Stores transactions that are processed by the FMS Form 1219/1220 process | satellite-leaning |
FV_INTERAGENCY_FUNDS_ALL |
Interagency information | link |
FV_INV_SELECTED_DUEDATE |
Stores invoice records processed through the Due Date Calculation process so records will not be reprocessed | link |
FV_VOIDED_CHECKS |
Stores checks voided in Payables; used by the DIT Voided Check process | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
FV_CCR_GRP |
GRP | 6 | 7 packages |
FV_SLA_PROCESSING_PUB |
PUB | 4 | 1 packages |
FV_PO_VALIDATE_GRP |
GRP | 1 | 1 packages |
FV_DRILLDOWN_PUB_PKG |
PUB | 1 | 0 packages |