Results for “fv_lockbox_ipa_temp”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FV_LOCKBOX_IPA_TEMP is a transient staging table owned by the FV (Federal Financials) schema in Oracle EBS 12.1.1 and 12.2.2. Its documented purpose is to support the Lockbox Finance Charge Application process during the processing of an AutoLockbox transmission. In the federal receivables flow, AutoLockbox imports bank transmission files containing customer receipts, and the Finance Charge Application logic must reconcile those receipts against open debit memos, invoices, and payment schedules. Because this reconciliation is multi-pass and set-based, the process temporarily persists candidate matching rows in FV_LOCKBOX_IPA_TEMP before applying the finance charges to the live subledger tables.

The table is a working/scratch object rather than a transactional system of record. Rows are written and consumed within a single run of the lockbox concurrent program, and contents are typically purged or overwritten on subsequent executions. From a heuristic Data Vault modeling perspective, this object is classified as standalone, meaning it does not sit within a hub/link/satellite dependency chain. If modeled formally, it would most naturally map to a link or transient staging construct joining a transmission, a batch, and specific receipt line entities, but the mined metadata exposes no enforced foreign keys beyond the transmission reference, so the standalone classification should be treated as a suggestion only.

Key Information Stored

The documented physical schema exposes eight columns. The most significant are:

• TEMP_ID — Surrogate primary key, enforced by the FV_LOCKBOX_IPA_TEMP_PK constraint. It uniquely identifies each staged row and is the value users search for when diagnosing a lockbox run.
• TRANSMISSION_ID — Identifies the AutoLockbox transmission being processed. Documented as referencing AP_TRANSMISSIONS_SETUP, it is the principal business-key candidate linking the staging rows back to a defined transmission definition.
• BATCH_ID — The lockbox batch within the transmission; groups receipts into the batch unit that finances charges are applied against.
• INVOICE_ID — The candidate transaction (invoice) being matched during finance charge application.
• DEBIT_MEMO_ID — The debit memo record associated with the charge application, central to federal finance-charge reconciliation.
• PAYMENT_SCHEDULE_ID — The payment schedule line being offset or adjusted.
• AMOUNT — The monetary value staged for the pending finance charge application.
• PRIORITY — Ordering attribute controlling the sequence in which candidate rows are applied.

Together, TRANSMISSION_ID, BATCH_ID, INVOICE_ID, DEBIT_MEMO_ID, and PAYMENT_SCHEDULE_ID form a plausible composite business key, though only the surrogate TEMP_ID is documented as enforced.

Common Use Cases and Queries

The primary use case is diagnostics: when a lockbox finance-charge run fails or produces unexpected results, support staff inspect the staged rows for the affected transmission.

• Retrieve all staged rows for a transmission:
  SELECT t.temp_id, t.batch_id, t.invoice_id, t.debit_memo_id, t.amount, t.priority FROM fv.fv_lockbox_ipa_temp t WHERE t.transmission_id = :transmission_id ORDER BY t.priority;
• Locate a specific row by surrogate key: SELECT * FROM fv.fv_lockbox_ipa_temp WHERE temp_id = :temp_id;
• Reconcile staged amounts against applied charges by grouping on BATCH_ID and summing AMOUNT.
• Confirm whether a run left residue behind, since stale rows may indicate an aborted process that should be investigated before rerunning.

Because the table is transient, it is unsuitable for historical or audit reporting; extract data during the run window if retention is required, and never treat it as authoritative once the concurrent program completes.

Related Objects

The documented relationship data identifies the following dependencies:

• AP_TRANSMISSIONS_SETUP — Referenced by FV_LOCKBOX_IPA_TEMP.TRANSMISSION_ID; defines the AutoLockbox transmission parameters governing the run.
• FV_LOCKBOX_IPA_TEMP_PK — The primary key constraint on TEMP_ID.
• AR_PAYMENT_SCHEDULES — Related through PAYMENT_SCHEDULE_ID for the schedules being adjusted.
• RA_CUSTOMER_TRX_ALL / RA_CUSTOMER_TRX_LINES_ALL — Related through INVOICE_ID and DEBIT_MEMO_ID for the invoice and debit memo transactions involved.
• AR_BATCHES_ALL — Related through BATCH_ID for the lockbox batch context.
• AutoLockbox concurrent programs — The Lockbox Finance Charge Application process that populates and consumes this table.

Only the AP_TRANSMISSIONS_SETUP reference and the primary key constraint are documented in the ETRM metadata; the remainder are inferred from standard Federal Financials and Receivables schema relationships and should be validated against the specific instance before relying on them.