Search Results accrue_on_receipt_flag




Overview
Explore in AI Chat

Overview

APPS.PA_PROJ_AP_INV_DISTRIBUTIONS is a reporting and integration view in Oracle E-Business Suite that joins Oracle Payables invoice distribution data with Oracle Projects and Oracle Purchasing attributes. It exposes invoice distributions at the line level, enriched with project, task, expenditure type, vendor, ledger, and commitment context. The view is primarily consumed by Oracle Projects and Oracle Grants accounting flows, as well as by external reports and interfaces that require Payables invoice activity mapped to project expenditures. Because it surfaces both entered and converted (base) currency amounts and a variety of derived flags, the view is well suited for reconciliation, accrual analysis, and audit reporting across the Projects-to-Payables boundary.

Underlying Base Objects

The view is defined over a set of APPS synonyms, views, and PL/SQL packages. Documented base objects in ETRM 12.2.2 include:

Notably, the view calls PA_CMT_UTILS.get_inv_cmt multiple times, once per currency perspective (entered, converted, and reporting), passing the accrue_on_receipt_flag from PO_DISTRIBUTIONS_ALL as one of its arguments. This makes the view a key surface for commitment and accrual reporting tied to purchase order receipts.

Key Columns

  • accrue_on_receipt_flag (from po1.accrue_on_receipt_flag, defaulted via NVL to 'N') — indicates whether the associated purchase order distribution uses accrual on receipt; this is the column relevant to the user's search.
  • invoice_num, invoice_date, invoice_currency_code, source, invoice_type_lookup_code — invoice identification and origin.
  • vendor_name — supplier name from PO_VENDORS.
  • distribution_line_number, description, accounting_date, amount, base_amount — distribution detail and amounts.
  • posted_flag (Y/N) and approved_flag — derived statuses, with approved_flag computed via AP_INVOICES_PKG.GET_APPROVAL_STATUS.
  • project_id, line_type_lookup_code, pa_quantity, pa_addition_flag — project linkage and quantity/addition attributes.
  • po_distribution_id, po_line_id — purchasing references.
  • historical_flag, prepay_amount_remaining — historical and prepayment tracking.
  • sla_ledger_cash_basis_flag — from GL_LEDGERS, indicating cash basis ledger behavior.

Common Use Cases and Queries

Typical uses include auditing PO-receipt accruals, reconciling Payables distributions to project expenditures, and reporting by supplier, project, or ledger. A representative query filtering on the accrue_on_receipt_flag is:

  • SELECT invoice_num, distribution_line_number, accrue_on_receipt_flag, po_distribution_id, amount FROM apps.pa_proj_ap_inv_distributions WHERE accrue_on_receipt_flag = 'Y';
  • Join this view to PO_DISTRIBUTIONS_ALL or PA_PROJECTS_ALL to enrich accrual reporting with PO and project detail.
  • Filter posted_flag = 'Y' to isolate only posted distributions for GL-related analysis.