Search Results fv_interim_cash_receipts_all

Overview

The FV_INTERIM_CASH_RECEIPTS_ALL table is a core data object within the Federal Financials (FV) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as a staging and processing table for payment batch information, specifically within the context of U.S. federal government accounting and reporting requirements. Its primary role is to hold transactional data related to cash receipts during interim processing stages before final posting and reconciliation. The table is owned by the FV schema and is integral to the federal government's cash management and accountability processes, ensuring compliance with mandated fiscal procedures.

Key Information Stored

While the provided metadata does not list specific columns, the documented foreign keys reveal the critical linkages and types of information stored. The table centrally stores identifiers that connect payment batches to key financial and banking structures. Key reference data includes the SET_OF_BOOKS_ID, linking transactions to the general ledger. It also holds RECEIPT_METHOD_ID for defining the receipt method and multiple banking identifiers: BANK_ACCOUNT_ID from Payables, CE_BANK_ACCOUNT_ID from Cash Management, and CE_BANK_ACCT_USE_ID for the specific bank account usage. This structure indicates the table stores batch details such as creation date, status, amount totals, and references to the source data, acting as a nexus between payment operations, banking, and the general ledger.

Common Use Cases and Queries

This table is primarily accessed for tracking and reconciling payment batches within federal financial workflows. Common operational and reporting use cases include monitoring the status of interim cash receipt batches, troubleshooting batch posting issues, and generating audit trails for federal compliance. A typical query might join this table to its referenced entities to create a detailed batch report. For example:

• Tracking batch summary: SELECT ficr.batch_name, ficr.creation_date, sob.name set_of_books, arm.name receipt_method FROM fv_interim_cash_receipts_all ficr, gl_sets_of_books_11i sob, ar_receipt_methods arm WHERE ficr.set_of_books_id = sob.set_of_books_id AND ficr.receipt_method_id = arm.receipt_method_id;
• Investigating batches linked to a specific bank account via the CE_BANK_ACCT_USES_ALL relationship.
• Data validation scripts to ensure all interim batches have valid links to required setup tables before proceeding with final posting.

Related Objects

The foreign key constraints explicitly define this table's critical dependencies within the EBS architecture. As per the metadata, FV_INTERIM_CASH_RECEIPTS_ALL has direct relationships with several fundamental tables:

• GL_SETS_OF_BOOKS_11I: Links the payment batch to the general ledger ledger.
• AR_RECEIPT_METHODS: Defines the method used for the cash receipt.
• AP_BANK_ACCOUNTS_ALL: References the Payables bank account.
• CE_BANK_ACCOUNTS and CE_BANK_ACCT_USES_ALL: Reference the Cash Management bank account and its specific usage, respectively.

This network of relationships positions the table as a central hub connecting Federal Financials with core Oracle modules including General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), and Cash Management (CE).