Opportunity

The object used by a sales organization to track information about a potential sale such as the sales account, key contacts, product interests, and potential revenues.

QName: {http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/}Opportunity

Logical Business Objects

• CRM : Opportunity Management : Opportunity

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type	Object or Service
Contains	Opportunity Contact
Contains	Opportunity Revenue Territory
Contains	Opportunity Team Member
Contains	Appointment Transient SDO
Contains	Opportunity Source
Contains	Opportunity Competitor
Contains	Opportunity Response
Contains	Opportunity Subscription
Contains	Note
Contains	Opportunity Deal
Contains	Category Summary Revenue
Contains	Opportunity Recurring Revenue
Contains	Revenue Line Set
Contains	Opportunity Split Revenue
Contains	Opportunity Reference
Contains	Opportunity Lead
Contains	Opportunity Partner
Contains	Opportunity Revenue
Handled by	Opportunity Service

Attributes

The following table describes attributes in the service data object.

Name	Type	Description
AccountNumber	string	The account number of the opportunity sales account.
Appointment	Appointment Transient	The appointments associated with the opportunity.
AssetId	long	Identifier of the asset of the opportunity.
AssetNumber	string	Asset number of the asset of the opportunity.
AssetProduct	string	The associated Asset's Product name
AssetSerialNumber	string	The associated Asset's Serial number
AverageDaysAtStage	long	The average days an opportunity remains in the current sales stage.
BdgtAmount	{http://xmlns.oracle.com/adf/svc/types/}AmountType	The budget amount from the sales account.
BudgetAvailableDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The date when the budget will be available.
BudgetedFlag	boolean	The attribute that indicates if the opportunity sales account has its budget approved for the potential purchase.
CategorySummaryRevenue	Category Summary Revenue	The category summary revenue for revenue line set enabled opportunity.
ChampionFlag	boolean	The attribute that indicates if this opportunity has a key internal sponsor.
ChildRevenue	Opportunity Revenue	The revenue items on the opportunity.
City	string	The name of the city.
Comments	string	The comments for the record.
ConflictId	long	The attribute value is used to guarantee the uniqueness of the row when duplicates are created in different databases.
ConsumerFirstName	string	The First Name of the Target Party for the opportunity.
ConsumerLastName	string	The Last Name of the Target Party for the opportunity.
Country	string	The name of the country.
CreatedBy	string	The user who created the record.
CreationDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The date when the record was created.
CrmConversionRate	decimal	The rate is used for the conversion of the revenue amount to the CRM common currency to facilitate the computation of the revenue forecast metrics. This is the amount that one currency can be exchanged for, at a specific point of time.
CrmRevenue	decimal	The opportunity revenue amount converted to the corporate currency.
CurrencyCode	string	The currency code. This attribute is used by CRM Extensibility framework.
CurrentFyPotentialRevenue	decimal	Do not use this attribute.
CustomerAccountId	long	The customer account associated with the opportunity.
DUNSNumber	string	The D-U-N-S number of the sales account.
DealHorizonCode	string	The attribute that indicates how long it may take to close the deal. This field refers to the lookup type MOO_SETID_DEAL_HORIZION.
DealHorizonCodeSetId	long	The set identifier for the Deal Horizon of this opportunity.
DecisionLevelCode	string	The attribute that indicates the decision level at the opportunity sales account to commit. This field refers to the lookup type MOO_SETID_DECISION_LEVEL.
DecisionLevelCodeSetId	long	The set identifier for the Decision Level of this opportunity.
DeleteFlag	boolean	Indicates whether the record can be deleted or not.
Description	string	The free text description of the record.
DescriptionText	string	The attribute for sales objective of the opportunity.
DownsideAmount	{http://xmlns.oracle.com/adf/svc/types/}AmountType	The worst case amount.
EffectiveDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The estimated close date for the opportunity.
EmailAddress	string	The email address associated with the record.
EmployeesTotal	decimal	The total number of employees.
ExpectAmount	{http://xmlns.oracle.com/adf/svc/types/}AmountType	The expected revenue amount.
FormattedAddress	string	Do not use this attribute.
IBAssetId	long	Identifier of the installed base asset of the opportunity.
IBAssetNumber	string	Asset number of the installed base asset of the opportunity.
IBAssetSerialNumber	string	The associated installed base Asset's Serial number
KeyContactId	long	The identifier of the primary contact.
LastAssignedDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The date when the opportunity is last assigned.
LastAssignedTimestamp	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The timestamp when the opportunity is last assigned.
LastUpdateDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The date when the record was last updated.
LastUpdateLogin	string	The login of the user who last updated the record.
LastUpdatedBy	string	The user who last updated the record.
LineOfBusinessCode	string	The line of business that is responsible for the opportunity.
LocationId	long	The identifier of the location. It is the foreign key to the HZ_LOCATIONS table.
LookupCategory	string	The status category of the opportunity.
LookupValuesId	long	The attribute for lookup value identifier for the opportunity status.
MaximumDaysInStage	long	The attribute for maximum days the opportunity can be in the sales stage prior to considering it stalled.
Name	string	The name of the opportunity.
Note	Note	The notes associated with the opportunity.
ObjectVersionNumber	int	The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.
ObjectVersionNumber1	int	The attribute is used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was last queried.
OpportunityCompetitor2	Opportunity Competitor	The attribute containing all competitors associated with the opportunity, including both primary and non-primary competitors.
OpportunityCompetitor3	Opportunity Competitor	The non-primary competitors associated with the opportunity.
OpportunityContact	Opportunity Contact	The contacts associated with the opportunity.
OpportunityDeal	Opportunity Deal	The deal registrations associated to the opportunity.
OpportunityLead	Opportunity Lead	The attribute for leads associated to the opportunity.
OpportunityReference	Opportunity Reference	The references associated with the opportunity.
OpportunityResource	Opportunity Team Member	The resources on the opportunity team.
OpportunityResponse	Opportunity Response	The attribute for marketing responses associated with the opportunity.
OpportunitySource1	Opportunity Source	The attribute for marketing sources associated to the opportunity.
OpportunitySubscription	Opportunity Subscription	Opportunity Subscription aggregates all revenue subscriptions to opportunity level.
OpportunityTypeCode	string	Display the different types of opportunity such as new, renewal and expansion.
OptyCreatedBy	string	The attribute that replicates WHO column CREATED_BY for functional use.
OptyCreationDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The attribute that replicates WHO column creation_date for functional use.
OptyId	long	The unique identifier of the opportunity. Primary Key
OptyLastUpdateDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The attribute that replicates WHO column last_update_date for functional use.
OptyLastUpdatedBy	string	The attribute that replicates WHO column last_updated_by for functional use.
OptyNumber	string	The number of the opportunity.
OwnerResourcePartyId	long	The identifier of the opportunity owner.
PartyName	string	The name of the party.
PartyName1	string	The name of the opportunity owner.
PartyType	string	The party type of the contact. The party type can only be Person, Organization, or Group.
PartyUniqueName	string	This is a derived column. For Organization, it is concatenation of unique_name_alias and suffix. For Person, it is concatenation of person_name and suffix.
PartyUniqueName1	string	The unique name of the primary opportunity competitor.
PhaseCd	string	The phase of the opportunity sales stage.
PhonePreferenceExistsFlag	boolean	The attribute that indicates if the contact has specified a phone preference.
PostalCode	string	The postal code element of the address.
PrConRelationshipId	long	The relationship identifier of the primary contact on the opportunity.
PrSrcNumber	string	The primary marketing source or campaign that generated this opportunity.
PreferredFunctionalCurrency	string	The preferred functional currency for the person or organization. The denormalized value of the PREF_FUNCTIONAL_CURRENCY in HZ_PERSON_PROFILES/HZ_ORGANIZATION_PROFILES.
PrimaryCompetitorId	long	The identifier of the primary competitor of this opportunity.
PrimaryContactEmailAddress	string	The e-mail address of the primary contact.
PrimaryContactFirstName	string	The first name of the primary contact for the opportunity.
PrimaryContactFormattedPhoneNumber	string	The formatted phone number for the primary contact on the opportunity.
PrimaryContactLastName	string	The last name of the primary contact for the opportunity.
PrimaryContactPartyId	long	The party identifier of the primary contact.
PrimaryContactPartyName	string	The name of the primary contact.
PrimaryOrganizationId	long	The identifier of the business unit to which this opportunity belongs.
PrimaryOrganizationName	string	The name of the business unit to which this opportunity belongs.
PrimaryPartnerId	long	The party identifier of primary partner.
PrimaryPartnerOrgPartyName	string	The attribute for name of primary partner assigned to the opportunity.
PrimaryRevenueId	long	The identifier for the summary revenue line for the opportunity. The summary revenue line stores the total revenue amount of an opportunity.
PrimarySubscriptionId	long	The unique identifier for the primary subscription of an opportunity.
PrimarySubscriptionNumber	string	The alternate identifier for primary subscription of the opportunity.
QuotaFactor	decimal	The quote factor of the opportunity sales stage.
QuotedFlag	boolean	Indicates that a quote has been created for this Opportunity.
RcmndWinProb	decimal	The recommended win probability for an opportunity in the sales stage.
ReasonWonLostCode	string	The win or loss reason for the opportunity. Valid values from the MOO_SETID_WIN_LOSS_REASON lookup type.
ReasonWonLostCodeSetId	long	The set identifier for the win or loss reason for the opportunity.
RecurringRevenue	Opportunity Recurring Revenue	The revenues that span over a period of time and are sourced from the same product on the opportunity.
Registered	string	The attribute that indicates the deal registration status.
RegistrationStatus	string	The registration type used for the partner-created opportunity or deal.
RegistrationType	string	The registration type used for the partner-created opportunity or deal.
RenewalProcess	string	The renewal process can be manual, do not renew or automatic renewal.
Revenue	{http://xmlns.oracle.com/adf/svc/types/}AmountType	The attribute for revenue amount.
RevenueLineSet	Revenue Line Set	The revenue line set associated with the opportunity.
RevenuePartnerPrimary	Opportunity Partner	The partners associated to the opportunity.
RevenueTerritory	Opportunity Revenue Territory	The territories assigned to the opportunity.
RevenueType	string	Do not use this attribute.
RevnId	long	The attribute for revenue identifier.
RevnLineSetEnabledFlag	boolean	The attribute that indicates whether the sales method on the opportunity is revenue line set enabled.
RiskLevelCode	string	The attribute that indicates the risk level for the opportunity. This field refers to the lookup type MOO_SETID_RISK_LEVEL.
RiskLevelCodeSetId	long	The set identifier for risk-level of an opportunity.
SalesAccountId	long	The identifier of the opportunity sales account.
SalesAccountUniqueName	string	The name of the sales account.
SalesChannelCd	string	The attribute that indicates the sales channel for the opportunity.
SalesMethod	string	The attribute for sales method of the opportunity.
SalesMethodEOObjVerNumber	int	The object version number of the sales method associated to the opportunity.
SalesMethodId	long	The sales method identifier for this opportunity. This indicates the sales process used.
SalesStage	string	The sales stage of the opportunity.
SalesStageEOObjVerNumber	int	The object version number of the sales stage associated to the opportunity.
SalesStageId	long	The identifier of the sales stage of the opportunity.
SplitRevenue	Opportunity Split Revenue	The revenue or nonrevenue credit allocated to resources who have contributed to the selling effort for the opportunity.
StageStatusCd	string	The default status for the opportunity sales stage.
State	string	The name of the state.
StatusCode	string	The pre-defined code used to indicate the status.
StatusCodeSetId	long	The set identifier for the Status of this opportunity.
StgOrder	decimal	The order of the opportunity's sales stage within the sales method.
StrategicLevelCode	string	The attribute that indicates the level of the strategic value to work with the opportunity sales account. This field refers to the lookup type MOO_SETID_STRATEGIC_VALUE.
StrategicLevelCodeSetId	long	The set identifier for strategic value of an opportunity.
TargetPartyId	long	The party identifier of the opportunity sales account.
TargetPartyName	string	The name of the sales account.
TargetPartyPrimaryAddressCountry	string	Country of the primary account's primary address.
UpdateFlag	boolean	This flag controls if the user has access to update the record.
UpsideAmount	{http://xmlns.oracle.com/adf/svc/types/}AmountType	The best case amount.
UserLastUpdateDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The date and time when the row was last updated.
WinProb	decimal	The win-probability percentage.