Search Results draft_invoice_number_credited




Overview
Explore in AI Chat

Overview

APPS.PABV_CUSTOMER_INVOICES is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data as PA.PABV_CUSTOMER_INVOICES and reported with a status of VALID in both 12.1.1 and 12.2.2. It exposes draft invoice information generated for projects, drawing its data from the Project Billing and Project Costing foundation. The view is not a transactional entry point; it is a read-only, reporting-oriented construct intended for extraction, reconciliation, and third-party integration of project billing activity.

Because it is an APPS-owned BIS view, it abstracts the complexity of the underlying draft invoice model, presenting a flattened, denormalized projection suitable for ad hoc queries, BI Publisher reports, and inbound/outbound interfaces. Organizations commonly query it to identify invoices pending approval, released but untransferred drafts, drafts rejected during transfer to Receivables, and credits applied against previously generated invoices.

Underlying Base Objects

The view is documented as referencing the following base objects:

  • PA_DRAFT_INVOICES_ALL (SYNONYM) — the primary transactional table holding draft invoice header records for projects across all operating units.
  • PA_PROJECTS_ALL (SYNONYM) — the project master, providing project-level context such as project identifiers.
  • PA_LOOKUPS (VIEW) — the lookup values view used to resolve coded values such as transfer status and generation error flags into their meaningful descriptions.

The view is not referenced by any database object, confirming it as a terminal reporting dependency. Standard joins link draft invoices to their project via PROJECT_ID and to descriptive lookup values via the referenced lookup view. All three base objects reside in the APPS schema, so no cross-schema grants are required for APPS-privileged sessions.

Key Columns

The view exposes date, amount, identifier, and descriptive attributes. Notable columns include:

Common Use Cases and Queries

Typical uses include monitoring the draft-to-Receivables pipeline, diagnosing transfer rejections, and tracing credits back to original invoices.

To examine credited drafts:

SELECT draft_invoice_num,
       draft_invoice_number_credited,
       project_id,
       ar_invoice_number,
       transferred_date
FROM   apps.pabv_customer_invoices
WHERE  draft_invoice_number_credited IS NOT NULL;

To identify drafts pending transfer with an error flag:

SELECT draft_invoice_num,
       "_LA:GENERATION_ERROR_FLAG" AS generation_error,
       transfer_rejection_reason
FROM   apps.pabv_customer_invoices
WHERE  transferred_date IS NULL;

Filtering by ORG_ID is essential in multi-organization deployments, and lookup-based columns should be resolved through PA_LOOKUPS values when user-friendly labels are needed.