Search Results fv_voided_checks_s

Overview

FV_DISB_IN_TRANSIT is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that supports the Treasury disbursement-in-transit accounting process. In Oracle EBS 12.1.1 and 12.2.2, this package is used to record, offset, and reverse accounting entries associated with payments and payment instruments that have been issued but have not yet cleared the bank. The package generates the journal entries required to move funds between the disbursement-in-transit clearing account and the corresponding cash or bank account, and it manages the accounting reversal that occurs when previously issued checks or payments are voided.

The user search term "fv_voided_checks_s" indicates interest in the sequencing or surrogate-key mechanism used to identify voided check records. FV_DISB_IN_TRANSIT references FV_VOIDED_CHECKS and FV_VOIDED_CHECKS_S, the latter being the sequence or view that supplies unique identifiers for voided check rows consumed during the accounting reversal logic performed by the package.

Key Procedures and Functions

• MAIN — Serves as the primary entry point or orchestration routine of the package. It coordinates the overall processing of disbursement-in-transit accounting, reading source transactions and driving the creation of journal entries and related offset records through the general ledger interface.
• VOID — Handles the voiding of previously issued disbursements. It retrieves voided check information (including keys sourced from FV_VOIDED_CHECKS_S), reverses the corresponding in-transit accounting entries, and ensures the original accounting is properly backed out.
• GET_SEGMENT_VALUES — A helper routine that derives or validates accounting flexfield segment values used when constructing journal entry lines, ensuring that the correct code combinations are populated for the accounting distributions.

The package does not expose an APPS-referenced public API in the conventional sense; the procedure classification is OTHER, and the package is not referenced by any other database object, confirming it is invoked directly rather than through an inter-package dependency chain.

Tables Accessed

• AP_CHECKS, AP_CHECKS_ALL — Source payment and check records used to identify disbursements requiring in-transit accounting.
• AP_INVOICE_PAYMENTS, AP_INVOICE_PAYMENTS_ALL — Payment-to-invoice relationships supporting accounting distribution.
• AP_AE_LINES, AP_AE_LINES_ALL — Payables accounting entry lines read or written during entry generation.
• AP_PAYMENT_PROGRAMS — Payment program metadata used during processing.
• FV_VOIDED_CHECKS, FV_VOIDED_CHECKS_S — Voided check records and their key sequence, used for reversal accounting.
• FV_TREASURY_CONFIRMATIONS, FV_TREASURY_CONFIRMATIONS_ALL, FV_TREASURY_CHECK_RANGES — Treasury confirmation and check range data.
• FV_OPERATING_UNITS, FV_TC_OFFSETS — Operating unit context and treasury offset rules.
• GL_INTERFACE, GL_INTERFACE_CONTROL, GL_JE_HEADERS, GL_JE_LINES, GL_CODE_COMBINATIONS — General ledger journal creation and interface control.
• FV_UTILITY, FND_FLEX_APIS, FND_FLEX_EXT, FND_GLOBAL — Utility, flexfield, and environment support routines.

Usage Notes

FV_DISB_IN_TRANSIT is typically invoked through Oracle Treasury and Payables accounting workflows and the concurrent programs that generate in-transit and void accounting entries. It relies on FND_REQUEST and FND_CONCURRENT for concurrent request submission and on MO_GLOBAL and MO_UTILS for multi-org operating unit context. Custom implementations should not call it directly unless the standard accounting interfaces are understood, because it writes to GL_INTERFACE and GL_JE_LINES and depends on valid period status and ledger configurations.