Search Results fv_link_gl_to_payments_v

Overview

FV_LINK_GL_TO_PAYMENTS_V is a Federal Financials (FV) reporting view in Oracle E-Business Suite 12.1.1 and 12.2.2 that establishes a reconciliation bridge between Oracle Payables payment activity and General Ledger journal entries. Its stated purpose is to link General Ledger postings to Payables payments, allowing federal accounting users and subledger reconciliation teams to trace payment distributions back to the specific journal lines generated in GL. The view is therefore central to payment-to-GL reconciliation reporting, federal year-end close analysis, and audit trails that require matching subledger payment events with posted accounting entries.

The ETRM metadata explicitly notes that this object is "Not implemented in this database" and that no base objects are documented in the 12.2.2 view definition record. This means the view is delivered as part of the Federal Financials product seed data and is available in environments where FV is licensed and installed, but it is not guaranteed to exist in every EBS instance. Implementers should verify existence in FND_VIEWS prior to referencing it in custom reports.

Underlying Base Objects

Although the 12.2.2 metadata documents no referenced base objects, the view text provided in the ETRM excerpt defines the view over a substantial join of Payables, General Ledger, and supplier tables:

• AP_PAYMENT_DISTRIBUTIONS_ALL and AP_INVOICE_PAYMENTS_ALL — payment distribution and invoice-payment association lines.
• AP_CHECKS_ALL and AP_INVOICES_ALL — payment documents and source invoices.
• GL_JE_HEADERS, GL_JE_LINES, GL_PERIODS, and GL_CODE_COMBINATIONS — posted journal headers, lines, accounting periods, and account combinations.
• PO_VENDORS and AP_LOOKUP_CODES — supplier identification and payment distribution type lookups.

The joins are driven by reference columns on GL_JE_LINES (REFERENCE_2, REFERENCE_3, REFERENCE_6, REFERENCE_8, REFERENCE_9, REFERENCE_10), which carry the invoice ID, check ID, distribution line number, invoice payment ID, and payment line type respectively. The literal REFERENCE_6 = 'AP PAYMENTS' anchors the result set to payment-related journal lines.

Key Columns

• VENDOR_ID — Supplier identifier, sourced from PO_VENDORS and matched to the invoice.
• VENDOR_TYPE — Vendor type lookup code from PO_VENDORS.
• ELIMINATIONS_ID — Attribute9 on the supplier record, used for federal eliminations processing.
• ENTERED_DR / ENTERED_CR — Debit and credit amounts entered on the GL journal line.
• CCID — Code combination ID of the accounting flexfield on the journal line.
• SOB — Set of Books identifier from the journal line.
• COA — Chart of accounts identifier derived from GL_CODE_COMBINATIONS.
• PERIOD_YEAR / PERIOD_NUM — Accounting period year and number from GL_PERIODS.

Common Use Cases and Queries

The view supports payment reconciliation, federal eliminations reporting, and audit substantiation of posted payment journals. A representative query retrieves posted payment activity for a supplier and period:

• SELECT vendor_id, entered_dr, entered_cred, ccid, period_year, period_num FROM fv_link_gl_to_payments_v WHERE vendor_id = :p_vendor AND period_year = :p_year;
• SELECT ccid, SUM(entered_dr), SUM(entered_cr) FROM fv_link_gl_to_payments_v GROUP BY ccid;

Because the view filters on GJH.ACTUAL_FLAG = 'A', GJL.STATUS = 'P', and P.POSTED_FLAG = 'Y', only actual, posted payment journals are returned. Future-dated payments are handled through the decode logic on REFERENCE_10 and the FUTURE_PAY_POSTED_FLAG filter, ensuring unposted future payments are excluded until realized.