Search Results hz_customer_profiles

Overview

PA_CE_INVOICES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2, delivered as part of the PA (Projects) product family. It exposes a consolidated, joined representation of draft project invoices together with the customer billing profile information required for downstream invoice processing and integration. The view is closely associated with the Oracle Receivables (AR) and Oracle Customers (HZ) data model, since it links project draft invoices to their bill-to customer and bill-to site through the trading community architecture (TCA) tables.

The view is filtered to a specific processing state: it only returns draft invoices where TRANSFER_STATUS_CODE = 'P' and RELEASED_DATE IS NOT NULL. This means the view presents invoices that have been released and are pending transfer to Receivables, making it a reliable source for pre-transfer reporting and for programs that must identify invoices ready for the transfer run.

Underlying Base Objects

Per the documented view text, PA_CE_INVOICES_V is defined over five APPS objects (resolved as synonyms):

• PA_DRAFT_INVOICES_ALL — draft invoice header, supplying invoice date, currency, transfer status, released date, bill-to address and bill-to customer, and organization.
• PA_DRAFT_INVOICE_ITEMS — draft invoice lines, supplying invoice amount, line amount, draft invoice number, and line number.
• PA_PROJECTS_ALL — project header, supplying the project identifier and project currency code.
• HZ_CUSTOMER_PROFILES — customer profile/account, joined on CUST_ACCOUNT_ID and SITE_USE_ID.
• HZ_CUST_SITE_USES_ALL — customer site uses, joined on CUST_ACCT_SITE_ID and constrained to site use code 'BILL_TO' and status 'A'.

The relationship is driven from the draft invoice. PA_DRAFT_INVOICES_ALL is joined to PA_PROJECTS_ALL on PROJECT_ID and to PA_DRAFT_INVOICE_ITEMS on PROJECT_ID and DRAFT_INVOICE_NUM. The invoice is joined to HZ_CUST_SITE_USES_ALL via BILL_TO_ADDRESS_ID, and to HZ_CUSTOMER_PROFILES via BILL_TO_CUSTOMER_ID. The profile class is resolved with NVL(CP1.PROFILE_CLASS_ID, CP.PROFILE_CLASS_ID), where CP1 is an outer-joined site-use-level profile and CP is the account-level profile.

Key Columns

• PROJECT_ID — project identifier linking the invoice to PA_PROJECTS_ALL.
• AMOUNT — draft invoice line amount; BASE_AMOUNT — amount in the project functional currency.
• CURRENCY_CODE / FUNCTIONAL_CURRENCY_CODE — invoice currency and project functional currency.
• TRX_DATE — invoice date; ORG_ID — owning operating unit.
• PROFILE_CLASS_ID — resolved customer profile class, used for tax and invoice presentation rules.
• TRX_NUMBER — draft invoice number; LINE_NUM — draft invoice line number.

Common Use Cases and Queries

The view is typically used to report released draft invoices awaiting transfer to Receivables, and to validate that bill-to customer profiles are correctly assigned before the transfer program executes. A representative query follows:

SELECT PROJECT_ID, TRX_NUMBER, LINE_NUM, AMOUNT,
       CURRENCY_CODE, TRX_DATE, ORG_ID, PROFILE_CLASS_ID
FROM   APPS.PA_CE_INVOICES_V
WHERE  ORG_ID = :p_org_id;

Because the view joins HZ_CUSTOMER_PROFILES and HZ_CUST_SITE_USES_ALL, it is also a convenient source when reconciling invoice data against customer profile attributes such as PROFILE_CLASS_ID.