PV — Partner Management
86 documented tables · 32 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
PV_PARTNER_PROGRAM_B |
Captures partner program, and membership details | hub |
PV_ATTRIBUTES_B |
Partner attribute identifiers | hub |
PV_PROCESS_RULES_B |
Process Rules | hub |
PV_GE_BENEFITS_B |
Benfits and its status | hub |
PV_PARTNER_PROGRAM_TYPE_B |
Partner Program Type - base table | hub-leaning |
PV_PG_ENRL_REQUESTS |
Container for enrollment requests submitted for membership into programs. | satellite-leaning |
PV_REFERRALS_B |
Referrals base table | satellite-leaning |
PV_GE_HISTORY_LOG_B |
Captures the transaction history log for a given entity. | satellite-leaning |
PV_PG_INVITE_HEADERS_B |
Container for storing invitations sent to partners for enrollment into programs. | hub-leaning |
PV_GE_CHKLST_ITEMS_B |
Container for Task Items that needs to be checked. | hub-leaning |
PV_PG_MEMBERSHIPS |
Container for partner's program membership details. | hub-leaning |
PV_ATTRIBUTE_CODES_B |
Partner attribute identifiers | hub-leaning |
PV_ENTY_SELECT_CRITERIA |
Entity selection criteria | satellite-leaning |
PV_GE_QSNR_ELEMENTS_B |
Container for questionnaire element details. | satellite-leaning |
PV_GE_NOTIF_RULES_B |
Captures the notification rules for a given entity. | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
PV_RULE_RECTYPE_PUB |
PUB | 0 | 20 packages |
PV_CHECK_MATCH_PUB |
PUB | 14 | 13 packages |
PV_ENTY_ATTR_VALUE_PUB |
PUB | 4 | 10 packages |
PV_ASSIGNMENT_PUB |
PUB | 5 | 8 packages |
PV_TERR_ASSIGN_PUB |
PUB | 11 | 5 packages |
PV_MATCH_V2_PUB |
PUB | 6 | 4 packages |
PV_BG_PARTNER_MATCHING_PUB |
PUB | 4 | 3 packages |
PV_WORKFLOW_PUB |
PUB | 20 | 3 packages |
PV_OPP_MATCH_PUB |
PUB | 5 | 2 packages |
PV_REFERRAL_COMP_PUB |
PUB | 3 | 2 packages |