Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - FV Tables and Views

TABLE - FV.FV_1096_DATA_ALL

TABLE - FV.FV_1099C_ALL

TABLE - FV.FV_1099_TAPE_DATA_ALL

TABLE - FV.FV_ALC_ADDRESSES_ALL

TABLE - FV.FV_ALC_GWA_CATEGORIES

TABLE - FV.FV_AP_CASH_POS_TEMP

TABLE - FV.FV_AR_BATCHES_ALL

TABLE - FV.FV_AR_CONTROLS_ALL

TABLE - FV.FV_ASSIGN_REASON_CODES_ALL

TABLE - FV.FV_BD_CONTROLS

TABLE - FV.FV_BE_ACCOUNT_PAIRS

TABLE - FV.FV_BE_INTERFACE

TABLE - FV.FV_BE_INTERFACE_CONTROL

TABLE - FV.FV_BE_INTERFACE_HISTORY

TABLE - FV.FV_BE_RPR_TRANSACTIONS

TABLE - FV.FV_BE_TRANSACTION_TYPES

TABLE - FV.FV_BE_TRX_CODES

TABLE - FV.FV_BE_TRX_DTLS

TABLE - FV.FV_BE_TRX_HDRS

TABLE - FV.FV_BE_TRX_SUB_TYPES

TABLE - FV.FV_BUDGET_DISTRIBUTION_DTL

TABLE - FV.FV_BUDGET_DISTRIBUTION_HDR

TABLE - FV.FV_BUDGET_LEVELS

TABLE - FV.FV_BUDGET_OPTIONS

TABLE - FV.FV_BUDGET_USER_DTL

TABLE - FV.FV_BUDGET_USER_HDR

TABLE - FV.FV_CCID_CFS_GT

TABLE - FV.FV_CCR_FILE_TEMP

TABLE - FV.FV_CCR_ORGS

TABLE - FV.FV_CCR_PROCESS_REPORT

TABLE - FV.FV_CCR_VENDORS

TABLE - FV.FV_CFS_REP_LINES

TABLE - FV.FV_CFS_REP_LINE_CALC

TABLE - FV.FV_CFS_REP_LINE_DTL

TABLE - FV.FV_CFS_REP_TEMP

TABLE - FV.FV_CUST_FINANCE_CHRGS_ALL

TABLE - FV.FV_CUST_VEND_XREFS

TABLE - FV.FV_DELINQ_INVOICES_ALL

TABLE - FV.FV_DISCOUNTED_INVOICES

TABLE - FV.FV_DMS_AGENCY_DEFINITIONS_ALL

TABLE - FV.FV_DMS_CODE_ASSIGNMENTS_ALL

TABLE - FV.FV_DMS_CODE_DEFINITIONS_ALL

TABLE - FV.FV_DOC_CR_TEMP

TABLE - FV.FV_ETC_ACTIVITIES

TABLE - FV.FV_EVENTS_TRANSACTION_CODE

TABLE - APPS.FV_EXTRACT_DETAIL_GT

TABLE - FV.FV_FACTS1_DIFF_BALANCES

TABLE - FV.FV_FACTS1_FED_ACCOUNTS

TABLE - FV.FV_FACTS1_HEADER_ID_GT

TABLE - FV.FV_FACTS1_LINE_BALANCES

TABLE - FV.FV_FACTS1_PERIOD_ATTRIBUTES

TABLE - FV.FV_FACTS1_PROCESSED_JE_HDRS

TABLE - FV.FV_FACTS1_RUN

TABLE - FV.FV_FACTSII_ACCOUNTS_GT

TABLE - FV.FV_FACTSII_ENDING_BALANCES

TABLE - FV.FV_FACTSI_TEMP

TABLE - FV.FV_FACTS_ATTRIBUTES

TABLE - FV.FV_FACTS_AUTHORIZATIONS

TABLE - FV.FV_FACTS_BUDGET_ACCOUNTS

TABLE - FV.FV_FACTS_BUD_FED_ACCTS

TABLE - FV.FV_FACTS_EDIT_CHECK_STATUS

TABLE - FV.FV_FACTS_ENDING_BALANCES

TABLE - FV.FV_FACTS_FEDERAL_ACCOUNTS

TABLE - FV.FV_FACTS_FOOTNOTE_HDR

TABLE - FV.FV_FACTS_FOOTNOTE_LINES

TABLE - FV.FV_FACTS_PERIOD_BALANCES

TABLE - FV.FV_FACTS_PRC_DTL

TABLE - FV.FV_FACTS_PRC_HDR

TABLE - FV.FV_FACTS_REPORT_T2

TABLE - FV.FV_FACTS_RT7_ACCOUNTS

TABLE - FV.FV_FACTS_RT7_CODES

TABLE - FV.FV_FACTS_RUN

TABLE - FV.FV_FACTS_SUBMISSION

TABLE - FV.FV_FACTS_TEMP

TABLE - FV.FV_FACTS_TRX_TEMP

TABLE - FV.FV_FACTS_USSGL_ACCOUNTS

TABLE - FV.FV_FINANCE_CHARGE_CONTROLS_ALL

TABLE - FV.FV_FINANCE_CHARGE_HISTORY

TABLE - FV.FV_FINANCE_CHRG_CUST_CLASSES

TABLE - FV.FV_FINCHRG_DEBITMEMO_TEMP

TABLE - FV.FV_FUNDS_AVAIL_ACCT_RANGES

TABLE - FV.FV_FUNDS_AVAIL_REP_DEF

TABLE - FV.FV_FUNDS_AVAIL_TEMP

TABLE - FV.FV_FUND_GROUPS

TABLE - FV.FV_FUND_PARAMETERS

TABLE - FV.FV_FUND_PARAMETERS_HISTORY

TABLE - FV.FV_GOALS_224_TEMP

TABLE - FV.FV_HOLIDAY_DATES

TABLE - FV.FV_INTERAGENCY_FUNDS_ALL

TABLE - FV.FV_INTERIM_CASH_RECEIPTS_ALL

TABLE - FV.FV_INVOICE_FINANCE_CHRGS_ALL

TABLE - FV.FV_INVOICE_RETURNS_ALL

TABLE - FV.FV_INVOICE_RETURN_DATES_ALL

TABLE - FV.FV_INVOICE_STATUSES_ALL

TABLE - FV.FV_INVOICE_STATUSES_HIST_ALL

TABLE - FV.FV_INV_SELECTED_DUEDATE

TABLE - FV.FV_INV_SELECTED_DUEDATE_TEMP

TABLE - FV.FV_IPAC_IMPORT

TABLE - FV.FV_IPAC_IMPORT_ERRORS

TABLE - FV.FV_IPAC_IMPORT_HISTORY

TABLE - FV.FV_IPAC_RECURRING_INV

TABLE - FV.FV_IPAC_TRX_ALL

TABLE - FV.FV_LOCKBOX_IPA_TEMP

TABLE - FV.FV_OPERATING_UNITS_ALL

TABLE - FV.FV_PAYMENT_FORMAT_TEMP

TABLE - FV.FV_PAYMENT_TYPE_MAP_ALL

TABLE - FV.FV_PB_SEQ_ASSIGNMENTS_ALL

TABLE - FV.FV_PROMPT_PAY_TEMP

TABLE - FV.FV_PYA_ACCOUNTS_TRANS_CODES

TABLE - FV.FV_PYA_AUDITS

TABLE - FV.FV_PYA_FISCALYEAR_MAP

TABLE - FV.FV_PYA_FISCALYEAR_SEGMENT

TABLE - FV.FV_PYA_TRANSACTIONS

TABLE - FV.FV_PYA_TRANSACTION_HISTORY

TABLE - FV.FV_RCV_TRANSACTIONS

TABLE - FV.FV_RECEIVABLES_ACTIVITY_TEMP

TABLE - FV.FV_RECEIVABLE_TYPES_ALL

TABLE - FV.FV_REC_CUST_TRX_TYPES_ALL

TABLE - FV.FV_REFUNDS_VOIDS_ALL

TABLE - FV.FV_REPORT_DEFINITIONS

TABLE - FV.FV_SF1080_DETAIL_TEMP

TABLE - FV.FV_SF1080_HEADER_TEMP

TABLE - FV.FV_SF1081_TEMP

TABLE - FV.FV_SF1219_AUDITS

TABLE - FV.FV_SF1219_DEFINITIONS_ACCTS

TABLE - FV.FV_SF1219_MANUAL_LINES

TABLE - FV.FV_SF1219_ORG_TEMP

TABLE - FV.FV_SF1219_REPORT_TEMPLATE

TABLE - FV.FV_SF1219_TEMP

TABLE - FV.FV_SF132_APP_REAPP_SCH

TABLE - FV.FV_SF133_CCIDS_GT

TABLE - FV.FV_SF133_DEFINITIONS_ACCTS

TABLE - FV.FV_SF133_DEFINITIONS_COLS_TEMP

TABLE - FV.FV_SF133_DEFINITIONS_LINES

TABLE - FV.FV_SF133_LOAD_ACCTS

TABLE - FV.FV_SF133_LOAD_LINES

TABLE - FV.FV_SF224_AUDITS

TABLE - FV.FV_SF224_MAP

TABLE - FV.FV_SF224_RUN

TABLE - FV.FV_SF224_TEMP

TABLE - FV.FV_SF224_VOID_TEMP

TABLE - FV.FV_STATUS_FUNDS_FINAL

TABLE - FV.FV_STATUS_FUNDS_TEMP

TABLE - FV.FV_STATUS_OBLIG_TEMP

TABLE - FV.FV_SUMMARY_CONSOLIDATE_ALL

TABLE - FV.FV_SYSTEM_PARAMETERS

TABLE - FV.FV_TC_MAP_DTL_ALL

TABLE - FV.FV_TC_MAP_HDR_ALL

TABLE - FV.FV_TC_OFFSETS

TABLE - FV.FV_TERMS_TYPES

TABLE - FV.FV_THIRD_PARTY_TEMP

TABLE - FV.FV_TOP_EXCLUSION_CRITERIA_ALL

TABLE - FV.FV_TPP_ASSIGNMENTS_ALL

TABLE - FV.FV_TPP_CHECK_DETAILS_ALL

TABLE - FV.FV_TP_BULK_FMT_DATA

TABLE - FV.FV_TP_TS_AMT_DATA

TABLE - FV.FV_TRANSACTION_EVENTS

TABLE - FV.FV_TRANSACTION_HEADERS

TABLE - FV.FV_TREASURY_CHECK_RANGES

TABLE - FV.FV_TREASURY_CONFIRMATIONS_ALL

TABLE - FV.FV_TREASURY_SYMBOLS

TABLE - FV.FV_TREASURY_SYMBOLS_HISTORY

TABLE - FV.FV_VALUE_OF_FUND_PERIODS

TABLE - FV.FV_VOIDED_CHECKS

TABLE - FV.FV_YE_CLOSED_TREASURY_SYMBOLS

TABLE - FV.FV_YE_GROUPS

TABLE - FV.FV_YE_GROUP_SEQUENCES

TABLE - FV.FV_YE_SEQUENCE_ACCOUNTS

TABLE - FV.FV_YE_SEQ_BAL_TEMP

VIEW - APPS.FV_1099T_V

VIEW - APPS.FV_AGENCY_LOCATION_CODES_V

VIEW - APPS.FV_BE_BA_FD_DTL_V

VIEW - APPS.FV_BE_BA_FD_HDR_V

VIEW - APPS.FV_BE_GL_V

VIEW - APPS.FV_BE_RPR_DTL_V

VIEW - APPS.FV_BE_RPR_HDR_V

VIEW - APPS.FV_BE_RPR_XLA_V

VIEW - APPS.FV_BE_XLA_V

VIEW - APPS.FV_BUDGETS_WITH_DATES_V

VIEW - APPS.FV_BUDGET_DISTRIBUTION_HDR_V

VIEW - APPS.FV_FACTS1_PERIOD_BALANCES_V

VIEW - APPS.FV_FACTS1_TB_V

VIEW - APPS.FV_FACTS_CUSTOMERS_V

VIEW - APPS.FV_FACTS_PERIOD_BALANCES_TB_V

VIEW - APPS.FV_FACTS_TB_V

VIEW - APPS.FV_FACTS_TRX_V

VIEW - APPS.FV_FACTS_VENDORS_V

VIEW - APPS.FV_FUND_PARAMETERS_V

VIEW - APPS.FV_INVOICE_DTL_V

VIEW - APPS.FV_INVOICE_MASTER_V

VIEW - APPS.FV_INV_HISTSTAT_V

VIEW - APPS.FV_INV_STATCUST_V

VIEW - APPS.FV_INV_STATUSES_V

VIEW - APPS.FV_LOOKUP_CODES

VIEW - APPS.FV_LOOKUP_TYPES

VIEW - APPS.FV_PAYABLE_REFUNDS_V

VIEW - APPS.FV_PAYMENT_MASTER_V

VIEW - APPS.FV_PO_MASTER_V

VIEW - APPS.FV_PYA_GL_V

VIEW - APPS.FV_RECEIPT_MASTER_V

VIEW - APPS.FV_REQUISITION_MASTER_V

VIEW - APPS.FV_SYSTEM_PARAMETERS_V

VIEW - APPS.FV_TBAL_BY_TS_V

VIEW - APPS.FV_TC_GL_V

VIEW - APPS.FV_TPP_ASSIGNMENTS_V

VIEW - APPS.FV_TREAS_CONFIRM_CHECKS_V

VIEW - APPS.FV_XLA_AP_REF_V

VIEW - APPS.FV_XLA_AR_REF_V

VIEW - APPS.FV_XLA_CST_REF_V

VIEW - APPS.FV_XLA_PO_REF_V

Table: FV_1096_DATA_ALL

Comments

This table stores temporary records required for the generation of the 1096 report. Records are deleted from this table each time the 1099-GOV or 1099-INT reports are run.

Columns

[top of page]

FV.FV_1096_DATA_ALL does not reference any database object

FV.FV_1096_DATA_ALL is referenced by following:

APPS

SYNONYM - FV_1096_DATA

SYNONYM - FV_1096_DATA_ALL

[top of page]

Table: FV_1099C_ALL

Comments

FV_1099C_ALL is a temporary processing table that is populated by the 1099-C Cancellation of Debt process. There is one record for each cancelled debt by individual customer in this table. Records in this table are modified in the Maintain 1099-C Information window.

Columns

[top of page]

FV.FV_1099C_ALL does not reference any database object

FV.FV_1099C_ALL is referenced by following:

APPS

SYNONYM - FV_1099C

SYNONYM - FV_1099C_ALL

[top of page]

Table: FV_1099_TAPE_DATA_ALL

Comments

This table stores temporary records required for the generation of 1099-GOV and 1099-INT reports and the magnetic formats of the same reports. Records are deleted from this table each time the reports are run.

Indexes

Columns

[top of page]

FV.FV_1099_TAPE_DATA_ALL does not reference any database object

FV.FV_1099_TAPE_DATA_ALL is referenced by following:

APPS

SYNONYM - FV_1099_TAPE_DATA

SYNONYM - FV_1099_TAPE_DATA_ALL

[top of page]

Table: FV_ALC_ADDRESSES_ALL

Comments

FV_ALC_ADDRESSES_ALL Stores the Address of each ALC defined.

Indexes

Columns

[top of page]

FV.FV_ALC_ADDRESSES_ALL does not reference any database object

FV.FV_ALC_ADDRESSES_ALL is referenced by following:

APPS

SYNONYM - FV_ALC_ADDRESSES_ALL

[top of page]

Table: FV_ALC_GWA_CATEGORIES

Comments

Stores the GWA Reporter Categories with effective start and end dates for each ALC with non-blank business activity.

Indexes

Columns

[top of page]

FV.FV_ALC_GWA_CATEGORIES does not reference any database object

FV.FV_ALC_GWA_CATEGORIES is referenced by following:

APPS

SYNONYM - FV_ALC_GWA_CATEGORIES

[top of page]

Table: FV_AP_CASH_POS_TEMP

Foreign Keys from this table:

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns

[top of page]

FV.FV_AP_CASH_POS_TEMP does not reference any database object

FV.FV_AP_CASH_POS_TEMP is referenced by following:

APPS

SYNONYM - FV_AP_CASH_POS_TEMP

[top of page]

Table: FV_AR_BATCHES_ALL

Primary Key: FV_AR_BATCHES_PK

1. BATCH_ID

Foreign Keys from this table:

Comments

FV_AR_BATCHES stores receipt batch header information to be processed by the Apply Cash Receipt process.

Indexes

Columns

[top of page]

FV.FV_AR_BATCHES_ALL does not reference any database object

FV.FV_AR_BATCHES_ALL is referenced by following:

APPS

SYNONYM - FV_AR_BATCHES

SYNONYM - FV_AR_BATCHES_ALL

[top of page]

Table: FV_AR_CONTROLS_ALL

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

FV.FV_AR_CONTROLS_ALL does not reference any database object

FV.FV_AR_CONTROLS_ALL is referenced by following:

APPS

SYNONYM - FV_AR_CONTROLS

SYNONYM - FV_AR_CONTROLS_ALL

[top of page]

Table: FV_ASSIGN_REASON_CODES_ALL

Primary Key: FV_ASSIGN_REASON_CODES_ALL_U1

1. INVOICE_ID
2. ENTRY_SOURCE

Comments

FV_ASSIGN_REASON_CODES_ALL stores data elements needed for the Prompt Payment Statistical report.

Indexes

Columns

[top of page]

FV.FV_ASSIGN_REASON_CODES_ALL does not reference any database object

FV.FV_ASSIGN_REASON_CODES_ALL is referenced by following:

APPS

SYNONYM - FV_ASSIGN_REASON_CODES

SYNONYM - FV_ASSIGN_REASON_CODES_ALL

[top of page]

Table: FV_BD_CONTROLS

Foreign Keys from this table:

Comments

FV_BD_CONTROLS contains budgetary discount transactions.

Indexes

Columns

[top of page]

FV.FV_BD_CONTROLS does not reference any database object

FV.FV_BD_CONTROLS is referenced by following:

APPS

SYNONYM - FV_BD_CONTROLS

[top of page]

Table: FV_BE_ACCOUNT_PAIRS

Comments

FV_BE_ACCOUNT_PAIRS has the budgetary account pairs that are automatically debited and credited when you generate a budgetary transaction. Each Transaction/Sub Type can have multiple pairs, with each pair being debited or credited accordingly.

Indexes

Columns

[top of page]

FV.FV_BE_ACCOUNT_PAIRS does not reference any database object

FV.FV_BE_ACCOUNT_PAIRS is referenced by following:

APPS

SYNONYM - FV_BE_ACCOUNT_PAIRS

[top of page]

Table: FV_BE_INTERFACE

Comments

Users insert records in the FV_BE_INTERFACE table before executing the Budget Execution Transactions Import Process.
Scope: public
Product: FV
Lifecycle: active
Display Name: Budget Execution Interface
Category: BUSINESS_ENTITY FV_BUDGET_JOURNAL

Indexes

Columns

[top of page]

FV.FV_BE_INTERFACE does not reference any database object

FV.FV_BE_INTERFACE is referenced by following:

APPS

SYNONYM - FV_BE_INTERFACE

[top of page]

Table: FV_BE_INTERFACE_CONTROL

Comments

FV_BE_INTERFACE_CONTROL stores the control information required for import processing.
User inserts a row into this table before submitting the import process.

Indexes

Columns

[top of page]

FV.FV_BE_INTERFACE_CONTROL does not reference any database object

FV.FV_BE_INTERFACE_CONTROL is referenced by following:

APPS

SYNONYM - FV_BE_INTERFACE_CONTROL

[top of page]

Table: FV_BE_INTERFACE_HISTORY

Comments

FV_BE_INTERFACE_HISTORY has the same structure as the FV_BE_INTERFACE table.
When the user sets the profile value for budget execution transactions data to be archived, the process moves rows from the FV_BE_INTERFACE table to this table. This information is for historical reference only.

Columns

[top of page]

FV.FV_BE_INTERFACE_HISTORY does not reference any database object

FV.FV_BE_INTERFACE_HISTORY is referenced by following:

APPS

SYNONYM - FV_BE_INTERFACE_HISTORY

[top of page]

Table: FV_BE_RPR_TRANSACTIONS

Primary Key: FV_BE_RPR_TRANSACTIONS_PK1

1. TRANSACTION_ID

Foreign Keys from this table:

Comments

The FV_BE_RPR_TRANSACTIONS table stores the details for the reprogramming transactions. This is the base table for the Enter Re-programming transactions form.

Indexes

Columns

[top of page]

FV.FV_BE_RPR_TRANSACTIONS does not reference any database object

FV.FV_BE_RPR_TRANSACTIONS is referenced by following:

APPS

SYNONYM - FV_BE_RPR_TRANSACTIONS

[top of page]

Table: FV_BE_TRANSACTION_TYPES

Primary Key: FV_BE_TRANSACTION_TYPE_PK1

1. BE_TT_ID

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

FV.FV_BE_TRANSACTION_TYPES does not reference any database object

FV.FV_BE_TRANSACTION_TYPES is referenced by following:

APPS

SYNONYM - FV_BE_TRANSACTION_TYPES

[top of page]

Table: FV_BE_TRX_CODES

Comments

No longer used

Indexes

Columns

[top of page]

FV.FV_BE_TRX_CODES does not reference any database object

FV.FV_BE_TRX_CODES is referenced by following:

APPS

SYNONYM - FV_BE_TRX_CODES

[top of page]

Table: FV_BE_TRX_DTLS

Primary Key: FV_BE_TRX_DTLS_PK1

1. TRANSACTION_ID

Comments

The FV_BE_TRX_DTLS table stores the transaction details for all budget execution transactions. This is the base table for the detail block of the Define Appropriations and Define Fund Distributions forms.

Indexes

Columns

[top of page]

FV.FV_BE_TRX_DTLS does not reference any database object

FV.FV_BE_TRX_DTLS is referenced by following:

APPS

SYNONYM - FV_BE_TRX_DTLS

[top of page]

Table: FV_BE_TRX_HDRS

Primary Key: FV_BE_TRX_HDRS_PK1

1. DOC_ID

Foreign Keys from this table:

Comments

The FV_BE_TRX_HDRS table stores the document information for all budget execution transactions. This is the base table for the header block of the Define Appropriations and Define Fund Distributions forms.

Indexes

Columns

[top of page]

FV.FV_BE_TRX_HDRS does not reference any database object

FV.FV_BE_TRX_HDRS is referenced by following:

APPS

SYNONYM - FV_BE_TRX_HDRS

[top of page]

Table: FV_BE_TRX_SUB_TYPES

Comments

The FV_BE_TRX_SUB_TYPES table is used to store the sub types associated with a transaction type. This is the base table for the detail block of the Define Budget transaction types form. This is a new table.

Indexes

Columns

[top of page]

FV.FV_BE_TRX_SUB_TYPES does not reference any database object

FV.FV_BE_TRX_SUB_TYPES is referenced by following:

APPS

SYNONYM - FV_BE_TRX_SUB_TYPES

[top of page]

Table: FV_BUDGET_DISTRIBUTION_DTL

Primary Key: FV_BUDGET_DISTRIBUTION_DTL_PK

1. DISTRIBUTION_DTL_ID

Comments

FV_BUDGET_DISTRIBUTION_DTL is the base table for the budget distribution level definition window. The detail region is used to store information about budgeting segments needed for a budget level.

Indexes

Columns

[top of page]

FV.FV_BUDGET_DISTRIBUTION_DTL does not reference any database object

FV.FV_BUDGET_DISTRIBUTION_DTL is referenced by following:

APPS

SYNONYM - FV_BUDGET_DISTRIBUTION_DTL

[top of page]

Table: FV_BUDGET_DISTRIBUTION_HDR

Primary Key: FV_BUDGET_DISTRIBUTION_HDR_PK

1. DISTRIBUTION_ID

Comments

FV_BUDGET_DISTRIBUTION_HDR is the base table for the budget distribution level definition window. The header region is used to store information about Treasury symbols and fund values.

Indexes

Columns

[top of page]

FV.FV_BUDGET_DISTRIBUTION_HDR does not reference any database object

FV.FV_BUDGET_DISTRIBUTION_HDR is referenced by following:

APPS

SYNONYM - FV_BUDGET_DISTRIBUTION_HDR

[top of page]

Table: FV_BUDGET_LEVELS

Comments

FV_BUDGET_LEVELS is the base table for the Define Budget Levels window and is used to define the required level of budget.

Indexes

Columns

[top of page]

FV.FV_BUDGET_LEVELS does not reference any database object

FV.FV_BUDGET_LEVELS is referenced by following:

APPS

SYNONYM - FV_BUDGET_LEVELS

[top of page]

Table: FV_BUDGET_OPTIONS

Comments

FV_BUDGET_OPTIONS is the table used to define budget options. This table is used to define only the budget freeze level for a Set of Books.

Indexes

Columns

[top of page]

FV.FV_BUDGET_OPTIONS does not reference any database object

FV.FV_BUDGET_OPTIONS is referenced by following:

APPS

SYNONYM - FV_BUDGET_OPTIONS

[top of page]

Table: FV_BUDGET_USER_DTL

Foreign Keys from this table:

Comments

FV_BUDGET_USER_DTL is the child table to FV_BUDGET_USER_HDR and is the base table for the Define Budget Users window detail region. The detail region is used to define the user budget access level options.

Indexes

Columns

[top of page]

FV.FV_BUDGET_USER_DTL does not reference any database object

FV.FV_BUDGET_USER_DTL is referenced by following:

APPS

SYNONYM - FV_BUDGET_USER_DTL

[top of page]

Table: FV_BUDGET_USER_HDR

Primary Key: FV_BUDGET_USER_HDR_PK

1. BU_GROUP_ID

Foreign Keys to this table:

Comments

FV_BUDGET_USER_HDR is the base table for the Define Budget Users window. The header region is used to store information about the budget user group.

Indexes

Columns

[top of page]

FV.FV_BUDGET_USER_HDR does not reference any database object

FV.FV_BUDGET_USER_HDR is referenced by following:

APPS

SYNONYM - FV_BUDGET_USER_HDR

[top of page]

Table: FV_CCID_CFS_GT

Comments

Indexes

Columns

[top of page]

FV.FV_CCID_CFS_GT does not reference any database object

FV.FV_CCID_CFS_GT is referenced by following:

APPS

SYNONYM - FV_CCID_CFS_GT

[top of page]

Table: FV_CCR_FILE_TEMP

Comments

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 first loaded into this table and then later copied to the FV_CCR_VENDORS process by the data load process.

Indexes

Columns