You are browsing the archive for Oracle Federal Financials.

1096 Form for 1099-G or 1099-INT

 

NAME: 1096 Form for 1099-G or 1099-INT
SHORT CODE: FV1096SR
MODULE: Oracle Federal Financials

Description: 1096 Annual Summary and Transmittal of U.S. Information Returns (for 1099-G and 1099-INT)
Navigation: Oracle Federal Financials Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Tax Reporting Entity : Tax Reporting Entity
  • Set of Books ID : Ledger ID
  • Payer name source : Payer name source

 

Oracle Federal Financials Tables

Oracle Federal Financials – Database tables:

  • FV_1096_DATA_ALL
  • FV_1099C_ALL
  • FV_1099_TAPE_DATA_ALL
  • FV_AAN_MATCHED_AR_TEMP
  • FV_AAN_MATCHES_TEMP
  • FV_AAN_SETUP_DETAILS_ALL
  • FV_AAN_SETUP_HDRS_ALL
  • FV_ACH_CTX_VENDOR_TEMP
  • FV_ALC_ADDRESSES_ALL
  • FV_APPROPRIATION_DTL
  • FV_APPROPRIATION_HDR
  • FV_AP_CASH_POS_TEMP
  • FV_ARAP_FINAL_CHECK
  • FV_AR_BATCHES_ALL
  • FV_AR_CONTROLS_ALL
  • FV_ASSIGN_REASON_CODES_ALL
  • FV_BD_CONTROLS
  • FV_BE_ACCOUNT_PAIRS
  • FV_BE_APPRN_LINES
  • FV_BE_INTERFACE
  • FV_BE_INTERFACE_CONTROL
  • FV_BE_INTERFACE_HISTORY
  • FV_BE_RPR_TRANSACTIONS
  • FV_BE_TRANSACTION_CODES
  • FV_BE_TRANSACTION_TYPES
  • FV_BE_TRX_CODES
  • FV_BE_TRX_DTLS
  • FV_BE_TRX_HDRS
  • FV_BE_TRX_SUB_TYPES
  • FV_BUDGETARY_TRANSACTIONS
  • FV_BUDGET_DISTRIBUTION_DTL
  • FV_BUDGET_DISTRIBUTION_HDR
  • FV_BUDGET_LEVELS
  • FV_BUDGET_OPTIONS
  • FV_BUDGET_USER_DTL
  • FV_BUDGET_USER_HDR
  • FV_CCR_FILE_TEMP
  • FV_CCR_ORGS
  • FV_CCR_PROCESS_REPORT
  • FV_CCR_VENDORS
  • FV_CFS_REP_LINES
  • FV_CFS_REP_LINE_CALC
  • FV_CFS_REP_LINE_DTL
  • FV_CFS_REP_TEMP
  • FV_CUST_FINANCE_CHRGS_ALL
  • FV_CUST_VEND_XREFS
  • FV_DELINQ_INVOICES_ALL
  • FV_DISCOUNTED_INVOICES
  • FV_DMS_AGENCY_DEFINITIONS_ALL
  • FV_DMS_CODE_ASSIGNMENTS_ALL
  • FV_DMS_CODE_DEFINITIONS_ALL
  • FV_DOC_CR_TEMP
  • FV_ECS_ACH_VENDOR_TEMP
  • FV_ECS_NCRPAY_TEMP
  • FV_ETC_ACTIVITIES
  • FV_EVENTS_TRANSACTION_CODE
  • FV_EXTRACT_DETAIL_GT
  • FV_FACTS1_DIFF_BALANCES
  • FV_FACTS1_FED_ACCOUNTS
  • FV_FACTS1_HEADER_ID_GT
  • FV_FACTS1_LINE_BALANCES
  • FV_FACTS1_PERIOD_ATTRIBUTES
  • FV_FACTS1_PROCESSED_JE_HDRS
  • FV_FACTS1_RUN
  • FV_FACTSI_TEMP
  • FV_FACTS_ATTRIBUTES
  • FV_FACTS_AUTHORIZATIONS
  • FV_FACTS_BUDGET_ACCOUNTS
  • FV_FACTS_BUD_FED_ACCTS
  • FV_FACTS_CONTACTS_HDR
  • FV_FACTS_CONTACTS_LINES
  • FV_FACTS_EDIT_CHECK_STATUS
  • FV_FACTS_ENDING_BALANCES
  • FV_FACTS_FEDERAL_ACCOUNTS
  • FV_FACTS_FOOTNOTE_HDR
  • FV_FACTS_FOOTNOTE_LINES
  • FV_FACTS_PERIOD_BALANCES
  • FV_FACTS_PRC_DTL
  • FV_FACTS_PRC_HDR
  • FV_FACTS_REPORT_T1
  • FV_FACTS_REPORT_T2
  • FV_FACTS_RT7_ACCOUNTS
  • FV_FACTS_RT7_CODES
  • FV_FACTS_RUN
  • FV_FACTS_SUBMISSION
  • FV_FACTS_TEMP
  • FV_FACTS_TRX_TEMP
  • FV_FACTS_TS_RELATIONS
  • FV_FACTS_USSGL_ACCOUNTS
  • FV_FBWT_IMPORT_DATA
  • FV_FBWT_SUPPORT_DATA
  • FV_FBWT_TEMP
  • FV_FBWT_TRANSFER_DATA
  • FV_FEDERAL_OPTIONS
  • FV_FINANCE_CHARGE_CONTROLS_ALL
  • FV_FINANCE_CHARGE_HISTORY
  • FV_FINANCE_CHRG_CUST_CLASSES
  • FV_FINCHRG_DEBITMEMO_TEMP
  • FV_FUNDS_AVAIL_ACCT_RANGES
  • FV_FUNDS_AVAIL_REP_DEF
  • FV_FUNDS_AVAIL_TEMP
  • FV_FUND_DISTRIBUTION_DTL
  • FV_FUND_DISTRIBUTION_HDR
  • FV_FUND_GROUPS
  • FV_FUND_PARAMETERS
  • FV_GOALS_133_TEMP
  • FV_GOALS_224_TEMP
  • FV_HOLIDAY_DATES
  • FV_INTERAGENCY_FUNDS_ALL
  • FV_INTERIM_CASH_RECEIPTS_ALL
  • FV_INVOICE_FINANCE_CHRGS_ALL
  • FV_INVOICE_RETURNS_ALL
  • FV_INVOICE_RETURN_DATES_ALL
  • FV_INVOICE_STATUSES_ALL
  • FV_INVOICE_STATUSES_HIST_ALL
  • FV_INV_SELECTED_DUEDATE
  • FV_INV_SELECTED_DUEDATE_TEMP
  • FV_IPAC_IMPORT
  • FV_IPAC_IMPORT_ERRORS
  • FV_IPAC_IMPORT_HISTORY
  • FV_IPAC_RECURRING_INV
  • FV_IPAC_TRX_ALL
  • FV_LEGAL_ENTITIES
  • FV_LOCKBOX_IPA_TEMP
  • FV_OPAC_AUDIT_ALL
  • FV_OPAC_BILLING_ALL
  • FV_OPAC_UPLOAD_TEMP
  • FV_OPERATING_UNITS_ALL
  • FV_PAYMENT_FORMAT_TEMP
  • FV_PAYMENT_TYPE_MAP_ALL
  • FV_PB_SEQ_ASSIGNMENTS_ALL
  • FV_PROMPT_PAY_TEMP
  • FV_PYA_ACCOUNTS_TRANS_CODES
  • FV_PYA_ANTICIPATED_FUNDS
  • FV_PYA_AUDITS
  • FV_PYA_FISCALYEAR_MAP
  • FV_PYA_FISCALYEAR_SEGMENT
  • FV_PYA_SELECTED_TRX
  • FV_PYA_TRANSACTIONS
  • FV_PYA_TRANSACTION_CRITERIA
  • FV_PYA_TRANSACTION_HISTORY
  • FV_RCV_TRANSACTIONS
  • FV_RECEIVABLES_ACTIVITY_TEMP
  • FV_RECEIVABLE_TYPES_ALL
  • FV_REC_CUST_TRX_TYPES_ALL
  • FV_REFUNDS_VOIDS_ALL
  • FV_REPORT_DEFINITIONS
  • FV_SF1080_DETAIL_TEMP
  • FV_SF1080_HEADER_TEMP
  • FV_SF1081_TEMP
  • FV_SF1219_AUDITS
  • FV_SF1219_DEFINITIONS_ACCTS
  • FV_SF1219_MANUAL_LINES
  • FV_SF1219_ORG_TEMP
  • FV_SF1219_REPORT_TEMPLATE
  • FV_SF1219_TEMP
  • FV_SF132_APP_REAPP_SCH
  • FV_SF133_CCIDS_GT
  • FV_SF133_DEFINITIONS_ACCTS
  • FV_SF133_DEFINITIONS_COLS_TEMP
  • FV_SF133_DEFINITIONS_LINES
  • FV_SF133_LOAD_ACCTS
  • FV_SF133_LOAD_LINES
  • FV_SF224_AUDITS
  • FV_SF224_TEMP
  • FV_SF224_VOID_TEMP
  • FV_STATUS_FUNDS_FINAL
  • FV_STATUS_FUNDS_TEMP
  • FV_STATUS_OBLIG_TEMP
  • FV_SUMMARY_CONSOLIDATE_ALL
  • FV_SYSTEM_PARAMETERS
  • FV_TC_MAP_DTL_ALL
  • FV_TC_MAP_HDR_ALL
  • FV_TC_OFFSETS
  • FV_TERMS_TYPES
  • FV_THIRD_PARTY_TEMP
  • FV_TOP_EXCLUSION_CRITERIA_ALL
  • FV_TPP_ASSIGNMENTS_ALL
  • FV_TPP_CHECK_DETAILS_ALL
  • FV_TP_BULK_FMT_DATA
  • FV_TP_TS_AMT_DATA
  • FV_TRANSACTION_EVENTS
  • FV_TRANSACTION_HEADERS
  • FV_TRANSMISSION_FIELDS
  • FV_TRANSMISSION_FORMATS
  • FV_TRANSMISSION_RECORDS
  • FV_TREASURY_CHECK_RANGES
  • FV_TREASURY_CONFIRMATIONS_ALL
  • FV_TREASURY_SYMBOLS
  • FV_VALUE_OF_FUND_PERIODS
  • FV_VOIDED_CHECKS
  • FV_VOIDS_TEMP
  • FV_YE_CLOSED_TREASURY_SYMBOLS
  • FV_YE_GROUPS
  • FV_YE_GROUP_SEQUENCES
  • FV_YE_SEQUENCE_ACCOUNTS
  • FV_YE_SEQ_BAL_TEMP

Federal Financials Concurrent Programs

Oracle Federal Financials Concurrent Programs:

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
FVFCTTRC Generate FACTS II Reports and Bulk Files
FVFCTRGR Transaction Register with Facts II Attributes Report
FVXRFFAR Status of Funds Report
FVFCTUTS US SGL Account Table Setup
FVFCTBWA Trial Balance with FACTS II Attributes Report
FVFCTWAB Trial Balance with FACTS II Attributes by Treasury Symbol
FVFCTRBR FACTS II Trial Balance Report
FVFCTATS FACTS Attributes Table Setup
FVFCTSMP FACTS II Treasury Symbol Mapping Process
FVFCTEXR FACTS II Exception Report
FVFCBLKR FACTS II Bulk File Creation
FVXBTGLP Budgetary Transaction GL Posting Process
FVPPPPEX Prompt Payment Exception Report
FVFCCHKR FACTS II Edit Check Log Creation
FVSF1080_NEW Invoice PrintĀ  1080
FVR1099R 1099-C Preprinted Form Report
FVXPPRCR Payments Without Reason Codes Report
FVXYECPF Year End Closing Process
FVXTRBVC Disbursements in Transit Voided Checks
FVX1219P FMS Form 1219/1220 Process
FVX1219R FMS Form 1219/1220 Report
FV1219ER FMS Form 1219/1220 Exception Report
FVAANMIR AR/AP Netting Match Process
FVAANMPB Add AP Debit Memo to Payment Batch
FVAANDCM AR/AP Netting Credit and Debit Memo Generation
FVAANPPR AR/AP Netting Register
FVXDCDFF Receivables Activity Worksheet
FVPPPPST Prompt Payment Main Report
FVBGTDIS Create Budgetary Discount Transactions
FVDCACRP Apply Cash Receipts
FVXDCACC Accrue Finance Charges
FVXDCAFC Assign Finance Charges
FVXDUDRP Due Date Calculation Execution Report
FVXFODDC Due Date Calculation
FVXPOSOR Status of Obligations Report
FVXTRJIP Disbursements in Transit Transactions
FVSF1166 SF 1166 EDP Voucher and Schedule of Payments
FVR1096R 1096 – Annual Summary and Transmittal of U.S. Information Returns
FVR1099P 1099-C Setup Process
FVXSISTN Supplier Tax Identification Number Listing
FVXPIEXT Load Federal Financial Seed Data
FVFC2SUB FACTS II Submission
FVTI133P GOALS SF133 Program
FVXTSRPT Treasury Symbol Listing
FVFACTDR FACTS I Detail Report
FVPYTRPP PYA Transaction Pool Process
FVPYTRPR PYA Transactions Report
FVPYTRPE PYA Transactions Exception Report
FVPYJCRP PYA Journal Creation Process
FVPYTRHR PYA Transaction History Report
FVBETTSR Budget Execution Transaction Register by Treasury Symbol
FVBESUMR Budget Execution Transaction Register
FVBERPRP BE Reprogramming Documents Creation and Approval Process
FVBEFUND Budget Execution Funds Checking/Reservation
FVBEGLTP Update BE-GL transfer status
FVDCACCD Accrue Finance Charge Detail Report
FVXFACLR Agency Confirmation Report
FVFB652E 6652 Statement of Differences – Deposits
FVFB652I 6652 Statement of Differences – Disbursements
FVTNCRR ECS NCR Vendor Report Program
FVTPPDPR ECS PPDP Vendor Report Program
FVTPPDR ECS PPD Vendor Report Program
FVTCCDPR ECS CCDP Vendor Report Program
FVTCCDR ECS CCD Vendor Report Program
FVCFSRDS Financial Statements Table Setup
FVFBDDDR Disbursement, Deposit Ticket and Debit Voucher Differences Report
FVFBWTRR Fund Balance with Treasury Reconciliation Report
FVFBDDDP Disbursement, Deposit Ticket and Debit Voucher Differences Process
FVFBWTRP Fund Balance with Treasury Reconciliation Process
FVFUNAVS Funds Availability Table Setup
FVXFDDIP Delinquent invoice Referral Process
FVXFDDIR Delinquent Invoice Referral Process
FVXFDDIE Delinquent Invoice Referral Electronic File
FVRDIEFR Delinquent Invoices Eligible for Referral Report
FVFBWTIM Fund Balance with Treasury Reconciliation Import Process
FVCFSCMR Consolidated Financial Statements Report
FVXCFSPB Consolidated Financial Statements Process
FVIPDISR IPAC Disbursement Exception Report
FVIPUPDB Update IPAC Disbursement Records
FVIPDISB Upload IPAC Disbursement
FVSLRPRO Program to run SQL*Loader
FVSUPDAR Suppliers Deactivation Report
FVFACTRR Transaction Register with FACTS I Attributes Report
FVXFDTDV Deposit and Debit Voucher Transaction Report
FVXFIPAC IPAC Transaction Report
FVDWFBTS Fund Balance File Formats Table Setup
FVFBAPWR Appropriation Warrants Report
FVFB55TB 6655 Receipt Account Trial Balance Report
FVFB55UR 6655 Unavailable Receipt Account Transaction Report
FVFB55RC 6655 Receipt Account Ledger Report
FVFB6654 6654 Undisbursed Appropriation Account Trial Balance Report
FVFB6653 6653 Undisbursed Appropriation Account Ledger Report
FVINVSTA Invoice Status Report
FVXYECFP Carry Forward Budgetary Account Balances Process
FVFUNAVR Status of Funds Availability Report
FVFUNAVB Status of Funds Availability Process
FVFACTBR Trial Balance with FACTS I Attributes Report
FVFACTTR Trial Balance with FACTS I Attributes by Treasury Symbol
FVBEINTR Budget Execution Transactions Import Report
FVBEINTB Budget Execution Transactions Import Process
FVAPCPDR Cash Position Detail Report
FVAPCPDP Cash Position Detail Process
FVFACTRB Transaction Register with FACTS I Attributes
FVX1081L_BATCH Invoice Print Batch SF 1081
FVX1080L_BATCH Invoice Print Batch SF 1080
FVSF1081 Invoice Print SF 1081
FV133NYB SF133 Multiple Year/ No Year Report
FVDCLCKB Lockbox Finance Charge Application
FVSF133B SF133 One Year Report
FVFCTRGB FACTS Transaction Register
FVTI224P GOALS FMS Form 224 Program
FVTIOBUP OPAC Billing Data Format Program
FVTIOBRP OPAC Billing Data Format Program Re-run
FVSF224R FMS Form 224 Report
FVSF224P FMS Form 224 Process
FV224EXR FMS Form 224 Exception Report
FVTIFACT FACTS I Interface
FVFACTSE FACTS I Exception Report
FVSF224L FMS Form 224 Detail Transaction Listing
FVXBEGLS SF133 Table Set-up Procedure
FVXBEGLP SF133 One Year Report on Budget Execution
FVXBGLPN SF133 Multiple Year/ No Year Report on Budget Execution
FVXDCIFE Identify Federal Employees
FVXYECER Year End Closing Execution Report
FVFCTHRC FACTS II Header File Creation
FVFCTDRC FACTS II Detail File Creation
FVXTIVC1 Vendor Check NCR Format Report
FVTICTXR CTX ACH Vendor Report Program
FVTIACHR ECS ACH Vendor Report Program
FVTI224R GOALS FMS Form 224 Report Program
FVTIOBUR OPAC Billing Data Upload File
FVFACTSR FACTS I Report ATB File
FVTI133R GOALS SF133 Report Program
FVFCTWAF FACTS II Trial Balance
FVR1099T 1099-C Electronic Filing
FVDCAFCO Assign Finance Charge Output Report
FVIPPROB IPAC Transaction Selection
FVIPCRBF IPAC Bulk File and Automatic Receipt Creation Process
FVIPDTLR IPAC Transaction Detail Report
FVIPEXCR IPAC Transaction Exception Report
FVFCTBTR Trial Balance by Treasury Symbol (old)
FVFACTFR FACTS I Trial Balance
FVIAUPDB Update Interagency Transfers
FVSF132R SF132 Apportionment and Reapportionment Schedule
FV1099GR 1099-G Form
FV1099IR 1099-INT Form
FVAPTPPR Third Party Payments Process
FVTPPBLD Third Party Payments Report
FVTPREMB Historical Third Party Remittance Process
FVTPPREM Historical Third Party Remittance Report
FV1096SR 1096 Form for 1099-G or 1099-INT
FVSUMSCH Summary Schedule Program
FVCONCTX CTX Consolidated File Payment Program
FVCOCCDP Bulk Data CCD+ Consolidated Payment File Program
FVCOPPDP Bulk Data PPD+ Consolidated Payment File Program
FVCONSTN Bulk Data Salary Travel NCR Consolidated Payment File Program
FVTSMSR Summary Schedule Report Program
FV1099IM 1099-INT Electronic Media
FV1099GM 1099-G Electronic Media
RXFVFTXR RX-only: FACTS Transaction Register
RXFVFCTB RX-only: FACTS II Trial Balance
RXFVF1TB RX-only: FACTS I Trial Balance
FVTBTRSB Trial Balance by Treasury Symbol
FVIPAPMT IPAC Automatic Payments Process
RXFVTBTS RX-Only: Trial Balance by Treasury Symbol
FVRXLODR Load RX Reports
FVSPCCDR SPS CCD Vendor Payment Format Report
FVSPCCDPR SPS CCDP Vendor Payment Format Report
FVSPPPDR SPS PPD Vendor Payment Format Report
FVSPPPDPR SPS PPDP Vendor Payment Format Report
FVSPNCRR SPS NCR Vendor Payment Format Report
FV1219BF GOALS FMS 1219/1220 Program
FMS FORM 1219/1220 REPORT SET Request Set FMS Form 1219/1220 Report Set
FMS FORM 1219/1220 REPORTS Request Set FMS Form 1219/1220 Reports
FVXDCDFR Receivables Activity Worksheet Report
FVCCREXT Request Set CCR Extract File Request Set
CCR Data Processing Request Set Stage CCR Data Processing – Request Set CCR Extract File Request Set
CCR Data Transfer Request Set Stage CCR Data Transfer – Request Set CCR Extract File Request Set
FVPGDTSR Purge Treasury Symbols Report
FVPURTSP Purge Treasury Symbol Process
FVIBKRPT IPAC Bulk File Creation Report
FVIBYTSL Payment Instruction Treasury Symbol Listing Report
FVPRMPAY Prompt Payment Reports
FVX1081L_NEW Invoice Print New SF 1081
FVUSSADR USSGL Account Derivation Rules Report
FVIPCRBE IPAC Bulk File Exception Report
FVFC1VAU FACTS I Vendor Type Update
FVFC1JCR FACTS I Journal Creation
FVX1080L_SEL Invoice Print Selected SF 1080
FVX1080L_NEW Invoice Print New SF 1080
FVX1081L_SELECT Invoice Print Selected SF1081
FVFC1CAU FACTS I Customer Class Code Update
FVFC1FAC FACTS I Federal Accounts Creation Process
PSABCRRP Federal Budgetary Control Results Report
FVAPRFPR FMS 224 Populate Payable Refunds Report
FVAPRFPP FMS 224 Populate Payables RefundsĀ  Process
FVCCRXML Program to query CCR vendors against the CCR
FVBEUEXR Budget Users Exception Report
FVCCRDPP CCR Data Processing
FVCCRLDS CCR Data Load Sensitive
FVCCRLDC CCR Data Load Complete
FVCCRDLP CCR Data Transfer
FVSF224E SF224 Extract Program
FVFCT2BB FACTS II Ending Balance Detail
RXFVRACR RX-only: Reimbursable Activity Report
FVGARTRX Generate Receivables for Reimbursable Related Expenditures
FVRDTGLS Populate Reimbursable Activity Report Definitions
FVREIMB Reimbursable Activity Report