Results for “order_header_id”

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

Overview

PV.PV_PG_INVITE_HEADERS_B is the base table in the Oracle E-Business Suite Partner Management (PV) module that serves as the container for storing invitations sent to partners for enrollment into partner programs. In release 12.1.1 and 12.2.2 this table anchors the outbound side of the partner recruitment and onboarding lifecycle: a channel manager or program administrator issues an invitation, records the target party and program, associates any commercial offer or price list, and tracks the invitation through its validity window until an enrollment request is generated. The row therefore represents a discrete business event — the dispatch of an invitation — rather than a transactional detail line.

Each invitation header is identified by the surrogate primary key INVITE_HEADER_ID, enforced through PV_PG_INVITE_HEADERS_B_PK and reinforced by the unique index PV_PG_ENRL_INVITE_HEADERS_B_U1 on the same column. The companion translation table PV_PG_INVITE_HEADERS_TL carries the multilingual descriptive text, preserving the standard Oracle EBS base/translation pattern. Heuristic Data Vault classification of the mined foreign-key structure places this object as hub-leaning; from a modeling perspective it behaves as a business hub around which link and satellite structures (enrollment requests, party notifications, translations) are organized.

Key Information Stored

The documented physical schema contains fifteen columns. The most significant are described below; the surrogate key is distinguished from business-key candidates.

• INVITE_HEADER_ID — surrogate primary key and unique-index column; the single business-key candidate documented for this table.
• INVITE_TYPE_CODE — classifies the invitation, driving downstream enrollment behavior.
• PARTNER_ID — the invited partner party; a primary filter in partner-facing reporting.
• INVITE_FOR_PROGRAM_ID — the target partner program, joining to PV_PARTNER_PROGRAM_B.
• QP_LIST_HEADER_ID — the associated price list / offer header, joining to AMS_OFFERS (the object referenced in the user's search).
• INVITED_BY_PARTNER_ID — the partner that issued the invitation, supporting partner-to-partner recruitment.
• INVITE_END_DATE — expiration of the invitation; essential for validity and re-issue logic.
• ORDER_HEADER_ID — links the invitation to any originating order.
• TRXN_EXTENSION_ID — extension reference joining to IBY_FNDCPT_TX_EXTENSIONS.
• OBJECT_VERSION_NUMBER — optimistic locking column.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

The dominant use cases are tracking outstanding invitations, measuring conversion into enrollment requests, and reconciling invitations against the offers or price lists they promote.

• Open invitation aging: select invitations whose INVITE_END_DATE has not yet passed and that have no corresponding row in PV_PG_ENRL_REQUESTS.
• Offer correlation: join QP_LIST_HEADER_ID to AMS_OFFERS to report which commercial offers generate the most partner invitations.
• Program recruitment funnel: aggregate counts by INVITE_FOR_PROGRAM_ID and INVITE_TYPE_CODE.
• Partner self-service reporting: filter by PARTNER_ID or INVITED_BY_PARTNER_ID.

Sample pattern joining the offer and program dimensions:

• SELECT h.INVITE_HEADER_ID, h.INVITE_TYPE_CODE, h.INVITE_END_DATE
• FROM PV.PV_PG_INVITE_HEADERS_B h, AMS.AMS_OFFERS o, PV.PV_PARTNER_PROGRAM_B p
• WHERE h.QP_LIST_HEADER_ID = o.OFFER_ID AND h.INVITE_FOR_PROGRAM_ID = p.PROGRAM_ID;

Related Objects

• AMS_OFFERS — referenced via QP_LIST_HEADER_ID; the offer promoted by the invitation.
• PV_PARTNER_PROGRAM_B — referenced via INVITE_FOR_PROGRAM_ID; the enrollment target program.
• IBY_FNDCPT_TX_EXTENSIONS — referenced via TRXN_EXTENSION_ID.
• PV_PG_ENRL_REQUESTS — child table joining on INVITE_HEADER_ID; captures resulting enrollments.
• PV_GE_PARTY_NOTIFICATIONS — notification activity tied to the invitation.
• PV_PG_INVITE_HEADERS_TL — translation table for multilingual invitation text.