This chapter covers the following topics:
Oracle Partner Management provides an extensible attribute framework to manually or automatically capture any kind of information about your partners. This information is presented in the performance and profile tab on the partner detail page. Partner profile attributes that track a partner's performance, such as Sales YTD and Opportunities Won, are displayed in the performance tab.
Performance profiles are numeric calculated values, based on partner transactions, which are refreshed at user-defined intervals. Non-performance related profiles such as partner certification, partner industry, and partner annual revenue are displayed in the profile tab. These profile values are either entered manually--directly or through a program enrollment questionnaire--or derived based on partner transactions.
Partner profiles are also accessible to the partner user from the partner dashboard. Both vendor and partner users can update the profile information if assigned update permission. For more information on attribute security, see Setting Up Attribute Security. The application maintains a history of the changes for profiles that are updated manually including changes made to partner contact profiles. In addition to partner profile attributes, the extensible attribute framework is also used to manually capture partner contact profiles. This information is presented in the Profile tab on the Partner Contact Detail page for the vendor user.
An attribute is a specific piece of information about an individual partner. Examples of partner attributes include a partner's geographic coverage, the number of opportunities a partner currently has open, and the number of referrals a partner has submitted year to date (YTD).
Attribute information can be collected from a partner program enrollment request, entered by a vendor or partner user, or calculated based on partner data and transactions.
Attribute information is used to create a profile for a partner, and is available from tabs on a partner's Partner Details page and View Trends page. Collectively, partner profile information is used to track key performance indicators that appear on the channel manager dashboard.
Oracle Partner Management provides you with a thorough set of seeded partner attributes, which are described in detail in the section, Seeded Attributes. In the application, a channel administrator can view all the attributes from the Attributes Overview page. For a description of the information available on this page, refer to The Attributes Overview Page. A channel administrator can also create customized attributes, if needed, to meet her organization's needs. Refer to Setting up Custom Attributes for additional information.
Oracle Partner Management provides numerous seeded partner attributes. The seeded attributes track a variety of facts about a partner. For an individual partner, the attributes provide a thorough, up-to-date partner profile. Collectively, partner attributes are used to build a 360-degree view of a channel's performance. The Channel Administrator can view details about seeded attributes, and can also define the order in which the attributes appear on the profile.
Seeded attributes can be informational or performance based. Informational attributes provide information about a partner that is unlikely to change frequently, such as a partner's industry. Performance attributes provide current information about a partner's activities, and are updated by concurrent programs. Most seeded attributes are performance attributes.
Performance attributes can be cumulative or noncumulative. Performance attributes allow a vendor to track a partner's performance over a period of time and are captured at a monthly level. These monthly values can be further aggregated to an annual value for some performance attributes. Cumulative performance attributes are additive, meaning the measurements taken at the monthly levels can be summed up to calculate the yearly figure. For example, the attribute Opportunities Won YTD tracks the total number of indirect opportunities a partner has won during the current fiscal year and is the sum of Opportunities Won for each month for that fiscal year.
Noncumulative attributes are point in time values, providing a snapshot for a specific partner performance profile attribute at the time the attribute was refreshed. These monthly level values cannot be summed up to calculate the yearly figure. For example, the attribute Open Opportunities Count lists the number of opportunities that are open currently for a partner or partners. You cannot sum up the Open Opportunities Count for each month to derive the annual Open Opportunities Count, because most likely an open opportunity in a prior month will have closed in the current month.
There are three types of performance attributes:
Partner Performance Attributes: Partner performance information appears in the Performance tab of the Partner Detail page. The Performance tab contains tables that provide information for specific partner attributes. For cumulative attributes, the year to date (YTD) totals are displayed. Taken in total, the attribute information provided on the tab provides a profile of a partner's current performance. Both cumulative and noncumulative performance attributes are used to track partner performance.
Partner performance information is calculated by the concurrent program PV - Refresh attribute text table, which populates the pv_search_attr_values table. A majority of these partner performance attributes are aggregated from the Partner Trend Attributes, so make sure that the Partner trend attributes are updated prior to running this concurrent program. Refer to the Performance Attribute Refresh Dependencies table.
Partner Trend Attributes: Partner trend information appears in the View Trends page, which is accessed by clicking the View Trends button on the Performance tab on the Partner Details page. A partner trend attribute tracks a partner's performance for a particular attribute over a specific period of time.
Partner trend information is calculated by the concurrent program PV: Refresh Partner Trend Values, which populates the pv_entity_attr_trends table.
Partner Group Performance Attributes: Partner group performance information is used to populate the Key Metrics bin on a channel manager's dashboard. The Key Metrics bin contains aggregated performance attribute information for all partners whose data the vendor employee can access (either through channel team membership, the employee's role in a resource group, or due to permissions). Both cumulative and noncumulative performance attributes are used to track partner group performance.
The data contained in the Key Metrics bin is populated by a query, which draws data from the pv_search_attr_trends table and other partner tables. The following table provides information about Oracle Partner Management seeded partner attributes.
Attribute | Description | Category | Display Style | Enabled For |
---|---|---|---|---|
Additional Channel Offering | Additional services provided by the partner (Implementation specific) | General | Multi-Select | Profile Tab |
Allow Partner to Edit Opportunities | A vendor can control partner opportunity access on a partner-by-partner basis | |||
Capacity Rating | Partner's capacity rating (Implementation specific) | General | Single-Select | Profile Tab |
Claims Paid | Total claim settlement amount paid for soft funds and special pricing request based on settlement date | Marketing | Currency | Trends Page |
Claims Paid YTD | Total claim amount paid for soft funds and special pricing request based on settlement date during the current fiscal year | Marketing | Currency | Performance Tab |
Country | Countries that the partner has a presence in | General | Multi-Select | Profile Tab |
Customer Annual Revenue | Annual revenue of the partner as stored in TCA table | General | Currency | Profile Tab |
Deals Accepted | Total deal amount accepted based on deal creation date | Sales | Currency | Trends Page |
Deals Accepted Count | Total number of deals accepted based on deal creation date | Sales | Count | Trends Page |
Deals Accepted YTD | Total deal amount accepted based on deal creation date during the current fiscal year | Sales | Currency | Performance Tab, Key Metrics Bin |
Deals Accepted YTD Count | Total number of deals accepted based on deal created during the current fiscal year | Sales | Count | Performance Tab, Key Metrics Bin |
Deals Close Rate | Deals Closed Count/Deals Accepted Count | Sales | Percentage | Performance Tab |
Deals Closed | Amount of total number of closed opportunities, based on the date the deal status changes to 'Closed. Opportunity Won' | Sales | Currency | Trends Page |
Deals Closed Count | Total number of closed opportunities based on the date the deal status changes to 'Closed. Opportunity Won' | Sales | Count | Trends Page |
Deals Closed YTD | Amount of total number of closed opportunities, where the deal status changes to 'Closed. Opportunity Won' during the current fiscal year | Sales | Currency | Performance Tab |
Deals Submitted Count | Total number of deals that are not in draft status based on deal creation date | Sales | Count | Trends Page |
Deals Submitted YTD Count | Total number of deals that are not in draft status based on deal created during the current fiscal year | Sales | Count | Performance Tab |
Functional Expertise | Partner expertise with regards to vendor product or service offering | General | Multi-Select | Profile Tab |
Funds Paid | Total settlement amount paid for fund requests based on the settlement date | Marketing | Currency | Trends Page |
Funds Paid YTD | Total settlement amount paid for fund requests based on settlement date during the current fiscal year | Marketing | Currency | Performance Tab, Key Metrics Bin |
Funds Requested | Total amount requested for fund requests based on the submitted date | Marketing | Currency | Trends Page |
Funds Requested YTD | Total amount requested for fund requests based on the submitted date during the current fiscal year | Marketing | Currency | Profile Tab, Key Metrics Bin |
Geographic Coverage | Partner's Geographic Coverage (Implementation specific) | General | Multi-Select | Profile Tab |
Inactive Partners | Total number of active partners that have not placed an order (where partner is the 'sold-to') in the time span specified by the profile ' PV: Inactive Partners Time Window' | General | Count | Key Metrics Bin |
Indirect Sales | Total amount based on the transaction date. This information is captured by Oracle Trade Management from the Point-of-Sale system | Sales | Currency | Trends Page |
Indirect Sales Prior year | Total amount based on transaction date during last fiscal year. This information is captured by Oracle Trade Management from the Point-of-Sale system | Sales | Currency | Performance Tab |
Indirect Sales YTD | Total amount based on transaction date during the current fiscal year. This information is captured by Oracle Trade Management from the Point-of-Sale System | Sales | Currency | Performance Tab, Key Metrics Bin |
Industry | Partner's Industry (Implementation specific) | General | Multi-Select | Profile Tab |
Last Order Date | Date of the last order where partner is the 'Sold to' party base on last ordered date | Sales | Date | Profile Tab |
New Partners | Total number of partners created in the time span specified by the profile ' PV: New Partners Time Window' | General | Count | Key Metrics Bin |
Open Claims | Total amount remaining for all open claims generated from referral, soft funds and special pricing | Marketing | Currency | Performance Tab, Trends Page, Key Metrics Bin |
Open Opportunities | Total amount of open indirect opportunities that a partner is working on | Sales | Currency | Performance Tab, Trends Page, Key Metrics Bin |
Open Opportunities Count | Total number of open indirect opportunities that a partner is working on | Sales | Count | Performance Tab, Trends Page, Key Metrics Bin |
Opportunities Won | Total amount of indirect opportunities that a partner has won based on decision date | Sales | Currency | Trends Page |
Opportunities Won Prior year | Total amount of indirect opportunities that a partner has won based on decision date during the last fiscal year | Sales | Currency | Performance Tab |
Opportunities Won YTD | Total amount of indirect opportunities that a partner has won based on decision date during the current fiscal year | Sales | Currency | Performance Tab |
Opportunity Acceptance Rate | Number of opportunities accepted by partner divided by the number of opportunities offered to partner | Sales | Percentage | Performance Tab, Key Metrics Bin |
Opportunity Close Rate | Number of opportunities won by the partner divided by the number of opportunities accepted by the partner | Sales | Percentage | Performance Tab, Key Metrics Bin |
Partner Enrollment Date | Partner enrollment date | General | Date | Profile Tab |
Partner Level | Partner level (Implementation specific) | General | Single-Select | Profile Tab |
Partner Member Type | Partner member type (Standard, Global, Subsidiary) | General | Single-Select | Profile Tab |
Partner Name | Partner Name | General | String | Profile Tab |
Partner Type | Partner type (End user, Original Equipment Manufacturer, Prospect, Distributor, Reseller). Users can define additional types | General | Single-Select | Profile Tab |
Partnership Activity | Partnership Activity (Implementation specific) | General | Multi-Select | Profile Tab |
Product Categories Available in Special Pricing | Product categories that a partner is authorized to submit special pricing requests for (Implementation specific) | General | Multi-Select | Profile Tab |
Products Bought Last Year | List of products bought by the partner in the last twelve months. (from the current date) This is captured by taking union of products on all orders shipped last year where Partner is the 'Bill to' party | Sales | Multi-Select | Profile Tab |
Products Sold Last Year | List of all products sold by the partner in the last twelve months. (from the current date) This metric is calculated by taking union on products on all line items maintained in the POS table against the given partner | Sales | Multi-Select | Profile Tab |
Referral Commission Paid | Total commission amount paid based on the date the referral status changes to 'Closed. Fee Paid' | Marketing | Currency | Trends Page |
Referral Commissions Paid YTD | Total commission amount paid based on the date the referral status changes to 'Closed. Fee Paid' during the current fiscal year | Marketing | Currency | Performance Tab, Key Metrics Bin |
Referrals Accepted | Total referral amount accepted based on referral creation date | Marketing | Currency | Trends Page |
Referrals Submitted Count | Total number of referrals that are not in draft status based on referral creation date | Marketing | Count | Trends Page |
Referrals Accepted YTD | Total referral amount accepted based on referral creation date during the current fiscal year | Marketing | Currency | Performance Tab, Key Metrics Bin |
Referrals Accepted YTD count | Total number of referrals accepted based on referral creation date during the current fiscal year | Marketing | Count | Performance Tab, Key Metrics Bin |
Referrals submitted YTD count | Total number of referrals that are not in draft status based on referral creation date during the current fiscal year | Marketing | Count | Performance Tab |
Sales | Total amount of all orders shipped where a partner is the sold-to party, based on the order date | Sales | Currency | Trends Page |
Sales Prior Year | Total amount of all orders shipped where a partner is the sold-to party, based on order date during the prior fiscal year | Sales | Currency | Performance Tab |
Sales YTD | Total amount of all orders shipped where a partner is the sold-to party based on order date during the current fiscal year | Sales | Currency | Performance Tab, Key Metrics Bin |
State | States in which the partner has a presence | General | Multi-Select | Profile Tab |
Total Partners | Total number of partners managed | General | Count | Key Metrics Bin |
A vendor user with the Channel Administrator responsibility can access the Attributes Overview page. The Attributes Overview page displays all the attributes that can be associated with a partner.
The following table describes the information that appears on the Attributes - Overview page.
Column | Description |
---|---|
Profile Attribute Name | The name of the attribute. Seeded attribute names can not be modified. |
Attribute Type | Indicates how the attribute's data is populated. Three attribute types are available: list of values, text box, and derived.
|
Display Style | For attributes with a type of text box, derived, or list of values, the display status indicates the information type of the attribute. For attributes with a type of list of values, the display style is flexible, and can be set up according to a vendor's business requirements. Refer to Setting up Attribute Display Styles for additional information. |
Category | The functional category of the attribute. Refer to Setting up Attribute Categoriesfor additional information. |
Attribute Values | The View Values link appears in this column if the attribute has an internal List of Values associated with it. Click View Values to access the Attribute Details page, from which you can set up or modify an attribute's list of values. |
Refresh Frequency | The frequency with which the attribute is updated by the appropriate concurrent program. Refer to Setting up Refresh Frequency for additional information. |
Other Attribute Information | Enables you to assign one or more roles to an attribute |
Active | The attribute is enabled and is displayed in the respective profile pages. |
Update | Select this icon to navigate to the attribute edit page. |
Remove | Select to remove an attribute. You can remove only attributes for which no data has been collected. Additionally, seeded attributes cannot be removed; this icon is grayed out for them. |
Many attributes are associated with a list of values. For many of the seeded attributes, and for some derived custom attributes, the list of values is populated from a Lookup or an external table. The list of values for other attributes can be set up by a channel administrator. If a list of values can be set up internally, a View Values link appears in the attribute's Attribute Values column. Refer to Setting up an Internal List of Values for more information.
The following table lists the seeded attributes that are associated with a list of values, and indicates the list of values source and additional information. The source can be the name of a Lookup, a SQL statement, or Internal if the list of values is created from within Oracle Partner Management.
Attribute | Display Style | List of Values Source | Enabled For |
---|---|---|---|
Functional Expertise | Multi-Select | ENI_PROD_DEN_HRCHY_PARENTS_V WHERE PURCHASE_INTEREST = 'Y' AND (DISABLE_DATE IS NULL OR DISABLE_DATE > SYSDATE) | Partner |
Product Categories for Special Pricing | Multi-Select | ENI_PROD_DEN_HRCHY_PARENTS_V WHERE PURCHASE_INTEREST = 'Y' AND (DISABLE_DATE IS NULL OR DISABLE_DATE > SYSDATE) | Partner |
Partner Type | Check Box | INTERNAL | Partner |
Country | Multi-Select | FND_TERRITORIES_VL | Partner, Opportunity |
Industry | Multi-Select | LOOKUP (PRM_IND_CLASSIFICATION_TYPE) | Partner, Opportunity |
Partner Member Type | Radio Button | INTERNAL | Partner |
Geographic Coverage | Multi-Select | INTERNAL | Partner, Opportunity |
Additional Channel Offering | Multi-Select | INTERNAL | Partner, Opportunity |
Partnership Activity | Multi-Select | INTERNAL | Partner, Opportunity |
Campaign | External List of Values | AMS_P_SOURCE_CODES_V WHERE SC.STATUS IN ('ACTIVE', 'ONHOLD','COMPLETED') AND SC.SOURCE_TYPE IN ('EVEH','EVEO','CAMP','CSCH') | Opportunity |
Capacity Rating | Drop Down | INTERNAL | Partner, Opportunity |
Partner Level | Drop Down | INTERNAL | Partner, Opportunity |
State | Multi-Select | AR_LOCATION_VALUES WHERE LOCATION_SEGMENT_QUALIFIER = 'STATE' | Partner, Opportunity |
Customer | External List of Values | ASF_CUSTOMER_LOV_V WHERE PARTY_TYPE IN ('ORGANIZATION', 'PERSON') | Opportunity |
Opportunity Status | Drop Down | AS_STATUSES_VL WHERE ENABLED_FLAG = 'Y' AND OPP_FLAG = 'Y | Opportunity |
Product Category | Multi-Select | ENI_PROD_DEN_HRCHY_PARENTS_V WHERE PURCHASE_INTEREST = 'Y' AND (DISABLE_DATE IS NULL OR DISABLE_DATE > SYSDATE) | Opportunity |
Sales Channel | Drop Down | ASO_I_SALES_CHANNELS_V WHERE ENABLED_FLAG = 'Y' | Opportunity |
Sales Stage | Drop Down | AS_SALES_STAGES_ALL_VL WHERE ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE) | Opportunity |
Offer | External List of Values | AMS_P_SOURCE_CODES_V | Opportunity |
Win Probability | Drop Down | AS_FORECAST_PROB_ALL_VL WHERE ENABLED_FLAG = 'Y'AND ((SYSDATE BETWEEN START_DATE_ACTIVE AND END_DATE_ACTIVE) OR(SYSDATE > START_DATE_ACTIVE AND END_DATE_ACTIVE IS NULL)) | Opportunity |
Sales Methodology | Drop Down | AS_SALES_METHODOLOGY_VL WHERE SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE) | Opportunity |
Customer/Account Type | Drop Down | LOOKUPS (CUSTOMER_ACCOUNT_TYPE) | Opportunity |
Routing Status | Drop Down | LOOKUPS (PV_ROUTING_STAGE) | Opportunity |
Customer Category | Drop Down | AR_LOOKUPS WHERE LOOKUP_TYPE = 'CUSTOMER_CATEGORY' AND ENABLED_FLAG = 'Y' | Opportunity |
Products Bought Last Year | Multi-Select | MTL_SYSTEM_ITEMS_B WHERE ORGANIZATION_ID = FND_PROFILE.VALUE('ORG_ID') | Partner |
Products Sold Last Year | Multi-Select | MTL_SYSTEM_ITEMS_B WHERE ORGANIZATION_ID = FND_PROFILE.VALUE('ORG_ID') | Partner |
A channel administrator may need to perform the following tasks, either during implementation or as ongoing administrative tasks:
Setting up Attribute Categories
Setting up Attribute Display Styles
Setting up an Internal List of Values
Setting up Attribute Security
Setting up Refresh Frequency
Refreshing Attribute Values with Concurrent Programs
Reordering Attributes
Migrating Partner Type Values
Attributes can be organized into different functional categories: General, Marketing, PRM, Resource, or Sales. The categories are used to group attributes on the Profile and Performance tabs on the Partner Details page.
A vendor user can set up additional categories either during or after implementation. Additional attribute categories are added through Oracle Forms, by adding new lookup values to the lookup type Attribute Categories (PV_ATTRIBUTE_CATEGORY_TYPE).
An attribute's Display Style indicates the type of control that will be used to provide information about the attribute. An attribute's Display Style is determined by its Attribute Type. Most of the seeded attributes with an Attribute Type of List of Values have flexible Display Styles, which can be set up by the channel administrator according to business requirements.
Depending on the drop-down list associated with the attribute, the channel manager can select one of two Display Style controls:
Multiselect or check box
Radio button or drop-down list
When a channel administrator creates a custom attribute, she indicates both the attribute type and display style. For more information, see Setting up Custom Attributes.
When the View Values link is available for an attribute, a channel administrator can set up an internal list of values for the attribute. Click the View Values link to access the Attributes - Overview page and set up an attribute's internal list of values.
Notes
Description: How the attribute appears in the list.
Inactive: Select to prevent the attribute from appearing in the list.
Partner attributes enable the channel manager to search for partners and track partner performance. These can be seeded or custom attributes that the channel administrator creates. To ensure the confidentiality and security of partner attributes, set the PV: Enable Profile Attribute Security profile option to Yes at the site level. To control whether vendor or partner users can view or update partner attributes, assign the appropriate permissions to user roles and roles to attributes. If you set the profile option to No, all roles can view and update attributes irrespective of the permissions assigned to the roles.
The permissions that you can assign to roles are PV_PARTNER_UPDATE_PROFILE_ATTRIBUTE and PV_PARTNER_VIEW_PROFILE_ATTRIBUTE. User roles can be existing or newly created. These roles include channel managers, channel representatives, and primary and secondary partner users.
You assign roles to attributes in the Attribute Details page. If you select to assign ALL ROLES to a partner attribute, both vendor and partner users can view and update the attribute based on the permission assigned to their role. Otherwise only the role assigned to the attribute can view or update the attribute based on the permission assigned to the role.
Attributes that track partner performance and trends need to be refreshed periodically. You set up an attribute's refresh frequency from the Attribute Details - Properties page, which is accessed by clicking the Refresh Frequency link for an attribute. The refresh frequency is subsequently used by concurrent programs to update an attribute's information.
How frequently a specific attribute should be refreshed depends on business requirements. You can specify that an attribute be refreshed hourly, daily, weekly, or monthly:
Hour - Refresh if the last refresh exceeds the specified number of hours.
Day - Refresh if the last refresh exceeds the specified number of days.
Week - Refresh if the last refresh occurred before the specified number of weeks. It is important to note that one week does not always equal seven days. For example, if the refresh frequency was set to one week, and the last refresh occurred on Friday, if the concurrent program runs on Monday the attribute will be refreshed again because the week has changed.
Month - Refresh if the last refresh occurred before the specified number of months.
When setting up a refresh frequency, you should also take into consideration whether or not an attribute's value is derived from, and thus dependent upon, another attribute. For information on attribute refresh dependencies, refer to Understanding Performance Attribute Refresh Dependencies.
Attributes for which you have not assigned a refresh frequency are refreshed whenever the concurrent programs run.
Many of the partner performance and partner group performance attributes derive their values from other attributes. Specifically, many of the partner performance attribute values are derived from partner trend measures, while many of the partner group performance attribute values are derived from partner performance attributes.
When an attribute is dependent upon another attribute for its value, the other attribute must be refreshed before the dependent attribute can be updated successfully. You must understand attribute dependencies to properly set up refresh values. The following table maps the dependencies between the three types of performance attributes.
Partner Group Measure | Depends on Partner Measure | Depends on Partner Trend Measure |
---|---|---|
Open Opportunities Count | Open Opportunities Count | Open Opportunities Count |
Open Opportunities | Open Opportunities | Open Opportunities |
Sales YTD | Sales YTD | Sales |
Indirect Sales YTD | Indirect Sales YTD | Indirect Sales |
Opportunity Close Rate | Opportunity Close Rate | -- |
Opportunity Acceptance Rate | Opportunity Acceptance Rate | -- |
Referral Commissions Paid YTD | Referral Commissions Paid YTD | Referral Commission Paid |
Referrals Accepted YTD | Referrals Accepted YTD | Referrals Accepted |
Referrals Accepted YTD Count | Referrals Accepted YTD Count | -- |
Deals Accepted YTD Count | Deals Accepted YTD Count | Deals Accepted Count |
Deals Accepted YTD | Deals Accepted YTD | Deals Accepted |
Funds Requested YTD | Funds Requested YTD | Funds Requested |
Funds Paid YTD | Funds Paid YTD | Funds Paid |
Open Claims | Open Claims | Open Claims |
-- | Sales Prior Year | Sales |
-- | Indirect Sales Prior Year | Indirect Sales |
-- | Opportunities Won YTD | Opportunities Won |
-- | Opportunities Won Prior Year | Opportunities Won |
-- | Referrals Submitted YTD Count | Referrals Submitted Count |
-- | Deals Close Rate | Deals Closed Count divided by Deals Accepted Count |
-- | Deals Closed YTD | Deals Closed |
-- | Deals Submitted YTD Count | Deals Submitted Count |
-- | Claims Paid YTD | Claims Paid |
Total Partners | -- | -- |
New Partners | -- | -- |
Inactive Partners | -- | -- |
The refresh frequency value is used by one of two concurrent programs to determine whether or not an attribute needs to be updated.
PV: Refresh Partner Trend Values - This program calculates the partner trend performance measures summarized at a monthly level.
PV: Refresh Attribute Text Table - This program calculates the performance and derived attributes for each partner and allows the attribute details for a particular partner to be used in the matching process. Note: Data from some earlier releases of Oracle Partner Management may contain a primary key that overlaps the next value in the sequence. This could cause errors and prevent the partner program creation process from completing properly. To correct this, run the Full Refresh of the PV: Refresh Attribute Text Table concurrent program, which essentially replaces all of the primary key ID's in the table.
The following table provides the parameters of the PV: Refresh Partner Trend Values concurrent program.
Parameter | Description |
---|---|
Start from Beginning of Month | Identifies the starting month to refresh (only applies to measures that are cumulative). Non-cumulative measures are always calculated for the current month only. |
To Ending of Month | Identifies the ending month to refresh (only applies to measures that are cumulative). Non-cumulative measures are always calculated for the current month only. |
New Partners Only | If Yes, then only process for new partners. New partners are defined as partners created after the last refresh run of this concurrent program (stored in the profile 'PV: Partner Trend Last Refresh'). |
Ignore Refresh Interval | If Yes, process all attributes even though the time interval from the last refresh has not exceeded the refresh interval set for some attributes. |
For currency measures, the PV: Refresh Partner Trend Values concurrent program converts all currency to the currency stored in the profile PV: Common Currency for Rules Engines. If this profile is not set, it defaults to USD.
The following table provides the parameters of the PV: Refresh Attribute Text Table concurrent program.
Parameter | Description |
---|---|
New Partners Only | Only process for new partners. New partners are defined as partners created after the last refresh run of this concurrent program (stored in the profile PV: Refresh Search Attributes Last Update Date). |
For currency measures, this concurrent program converts all currency to the currency stored in the profile PV: Common Currency for Rules Engines. The default value is USD.
Reordering of attributes can be done only from the Channel Administrator responsibility. The Attribute overview page is the starting point for the attributes reordering process. Reordering is done at a category level; therefore, a Channel Administrator must select a specific category prior to initiating the reordering process.
Currently. a partner can be assigned one partner type only. If you are upgrading from an earlier Oracle Partner Management release you need to perform some administrative functions to successfully migrate your partner type data:
Populate the PV_PARTNER_TYPE_RANKING lookup table with a numerical ranking for each existing partner type. The table is seeded with some partner types and ranking data; and vendors can add to and modify the seeded values. The PV: Partner Type Migration concurrent request uses this lookup table to assign a single type to each partner by evaluating all of the partner’s existing types and selecting the top-ranked type (the type with the lowest value).
For example, if a partner is currently assigned both Reseller and OEM partner types, and the value assigned to Reseller is lower than that assigned to OEM, then the partner’s new type will be Reseller. Vendors must provide a ranking for each partner type except for the VAD type. The VAD is always considered the top-ranked partner type, regardless of the ranking specified by the vendor. See Partner Profile Attribute lookups for more information.
After establishing the partner type rankings, run the PV: Partner Type Migration concurrent program to assign the new rankings to existing partners. The program can be run in Evaluation or Execution mode. See Concurrent Programs for Partner Profile Attributes for more information. The concurrent program generates a log file that provides information about the migration, including the original partner types and the new partner type for each partner.
A channel administrator can create custom attributes to track additional information about partners. Customized attributes can be used to gather information about a partner or to derive information from other sources through SQL statements and database functions.
Navigation
Log on with the channel administrator responsibility, navigate to the Attributes Overview page, and click the Create button that appears on the Attributes - Overview page to access the Create Attribute page.
Notes
Attribute Type: Select Text Box, List of Values, or Derived. The attribute type determines the options that will be available in the Display Style drop-down list. Subsequently, the Display Style further determines what additional information must be provided for an attribute.
Status: Selecting Active makes the attribute visible in the application.
Expose to Partner: Makes the attribute visible to partners from their profiles. Not selecting this option for an attribute makes it visible to vendor users only.
Requires Data Validation: Selecting this attribute indicates that updates made to the attribute must be approved. When an update is made to the attribute for a specific partner, an e-mail notification is sent to the channel manager(s) for the partner informing him of the change. In addition, the validation history for the attribute is tracked for the attribute for each partner.
Two icons appear beside an attribute that requires validation. One icon takes a user to the Validation Information page, which allows the user to provide notes or documentation to support the change. The other icon takes a user to a page that displays the attribute's validation history.
Related To: Enables the attribute for use in specific areas of the application. All the following options are available for Text Box and List of Values attributes; for a Derived attribute, only the Partner and Opportunity options are available.
Partner: Makes the attribute visible on Partner Details pages. The section that the attribute appears in is determined by the Category selection.
Lead Referral: Select to enable the attribute for use when creating questions associated with a Referral benefit. When a partner user submits a referral, the answers she provides are used to update the partner's profile.
Partner Contact: Select this option to display the attribute on partner contact pages.
Deal Registration: Select to enable the attribute for use when creating questions associated with a Deal Registration benefit. When a partner user submits a deal registration, the answers she provides are used to update the partner's profile.
Opportunity: Select this options to associate the attribute with opportunities. The attribute will appear on opportunity pages.
Countries: Associates an attribute with one or more countries. When a country is selected for an attribute, the attribute is available for partners whose identifying address matches the country. More than one country can be selected for an attribute. The default is All.
Partner Types: Select one or more partner types to limit the attribute to specific types of partners, or select All to use the attribute for all partners.
Enabled for Locator: Select to include an attribute in the Partner Locator. Enabling an attribute for the Partner Locator allows a potential customer to use the attribute to search for a partner.
Enabled for Matching Services: Select to enable an attribute to be used in the following areas:
Opportunity Matching: Enabling an attribute for matching services enables it to be used for automatic and manual opportunity matching. Note that you also need to select Related To: Opportunity for the attribute to be available for opportunity matching.
Partner Program Requirements: Enabling an attribute for matching also makes it available for use as a requirement for a partner program.
Partner Search: Enabling an attribute for matching services provides potential customers with an advanced search tool that they can use to locate partners that meet certain criteria.
Locator: Enabling an attribute for matching services makes it available in the Partner Locator advanced search.
The following table lists all the attribute types and display styles available for custom attributes. The table also provides additional information for those attributes and display styles that require additional information during set up.
Attribute Type | Display Style | Additional Information for Attribute |
---|---|---|
List of Values | Check Box | No |
Multi Select | Enter the number of lines to be included in the list. | |
Percentage | By default, the percentage values must add up to 100%. To change the percentage total, modify the profile value PV: Attribute Percentage Total. | |
Radio Button | No | |
Drop Down | No | |
Text Box | Currency | Decimal points: Number of decimal points used for rounding. Character Width: number of characters allowed in the text box. Value Type: Used to evaluate attribute during opportunity matching. Specify Minimum or Maximum. |
Date | Value Type: Used to evaluate attribute during opportunity matching. Specify Minimum or Maximum. | |
Numeric | Decimal points: Number of decimal points used to round amounts. Value Type: Used to evaluate attribute during opportunity matching. Specify Minimum or Maximum. |
|
Text | Number of lines: The number of lines to be allowed in the text box. Character Width: The number of characters allowed in the text box. |
|
Derived | Currency | No |
Date | No | |
Numeric | Value Type: Used to evaluate attribute during opportunity matching. Specify Minimum or Maximum. | |
Text | No | |
List of Values | No | |
Percentage | Value Type: Used to evaluate attribute during opportunity matching. Specify Minimum or Maximum. |
Creating a derived attribute involves providing code that is used to populate attribute values. A derived partner profile attribute can be populated by a PL/SQL stored procedure or package, or by a SQL statement. A user-defined SQL statement is used to populate the list of values that is associated with an attribute with List Of Values value type.
Coding for derived attributes is done in the Derived Attribute Properties section of the Attribute Detail page. This section appears when you click Create after providing the attribute's initial details.
Notes
LOV Lookup SQL: If List Of Values was selected as the attribute's value type, this field appears, and contains a sample SQL statement. The user changes the SQL statement to generate the desired list of values.
Value Type: If numeric or percentage was selected as the attribute's value type, this field appears. Value type is used to evaluate the attribute during opportunity matching. Select Minimum to indicate that the attribute with the lowest value wins; select Maximum to indicate that the attribute with the highest value wins.
Enabled For: Indicates the areas of the application to which the attribute will apply. If multiple areas are selected, a different function can be created for each.
Function Name: The function name and code. A function is actually a PL/SQL package. The package and procedure must exist in the database. The function name for the attribute must follow the following format: <procedure-name>(:party_id,:output)
Validate: Click to check a SQL statement's syntax or to check a function's syntax and to validate that the function appears in the database.
Derived attributes support all the return types that are currently supported by Oracle Applications: currency, date, null_check, number, and string.
Currently, the following procedure template is supported. The procedure expects an IN parameter of NUMBER type and an OUT parameter of JTF_VARCHAR2_TABLE_4000 type:
PROCEDURE <procedure-name> ( p_partner_id NUMBER, x_output OUT JTF_VARCHAR2_TABLE_4000 ) IS <declarations> BEGIN x_output := JTF_VARCHAR2_TABLE_4000(); <logic to derive the output values and store them in x_output table> END;
The following is an example of a procedure that would be used to create an attribute that calculates a partner's actual revenue:
PROCEDURE Partner_Revenue( p_partner_id NUMBER, x_assigned_count OUT JTF_VARCHAR2_TABLE_4000 ) IS CURSOR lc_count IS SELECT orgp.curr_fy_potential_revenue annual_revenue FROM apps.pv_partner_profiles PV, apps.hz_organization_profiles orgp WHERE orgp.curr_fy_potential_revenue IS NOT NULL AND orgp.party_id = pv.partner_party_id AND pv.partner_id = p_partner_id ; indx NUMBER := 1; BEGIN x_assigned_count := JTF_VARCHAR2_TABLE_4000(); FOR lc_cursor IN lc_count LOOP x_assigned_count.EXTEND; x_assigned_count(indx) := lc_cursor.annual_revenue; indx := indx + 1; END LOOP; End;
The application provides a the following sample SQL statement that can be modified to create a custom SQL statement for a list of values:
select pac.attr_code code, pac.description meaning, pac.description description from pv_attribute_codes_v1 pac where pac.attribute_id = ? and pac.enabled_flag = 'Y'
In the SQL statement, attribute_id can refer to a table column or an actual attribute id.
For a derived attribute with a List Of Values value type, a list of values is provided through a user-defined SQL statement. The following example provides a SQL statement for a derived list of values attribute where:
The attribute id = xxxx
The list of values is derived from an external lookup FND_EXAMPLE_LOOKUP
select lkp.lookup_code code, lkp.meaning meaning, lkp.description description from fnd_lookups lkp where lkp.lookup_type = 'FND_EXAMPLE_LOOKUP'. and xxxx= ?