Oracle Web Services On Demand Guide > Oracle CRM On Demand Objects Accessible Through Web Services > Core Parent Objects (Web Services v1.0) >
Opportunity
The opportunity object allows employees to identify and record a potential revenue-generating event that has arisen with an account or contact. Opportunities can be generated from marketing campaigns when leads indicate that they are interested in a product or service that has been offered. Parent Objects
Account, Campaign, Contact, CustomObject1 - CustomObject3 Child Components
Activity, Attachment, Book, Competitor, Contact, Lead, Note, and OpportunityTeam. NOTE: The Revenue child object for Opportunity is actually called Product.
For information about using attachments with this object, see Using Attachments with Web Services On Demand. Methods Called
Table 246 details the methods called by the Opportunity service.
Fields
Table 247 details the required and read-only fields for the opportunity object.
Table 247. Required and Read-Only Fields for the Opportunity Object
|
|
|
Opportunity (parent) |
AccountId |
Required |
CloseDate |
Required |
OpportunityName |
Required |
SalesStage |
Required |
Audit Fields |
Read-only |
LastUpdated |
Read-only |
OpportunityConcatField |
Read-only |
Activity |
AccountLocation |
Read-only |
CreatedDetail |
Read-only |
MEEventName |
Read-only |
Opportunity |
Read-only |
OpportunityIntegrationId |
Read-only |
OpportunityExternalId |
Read-only |
CreatedbyEmailAddress |
Read-only |
ModifiedbyEmailAddress |
Read-only |
CODInteractionTime |
Read-only |
CODWrapUpTime |
Read-only |
CODHandleTime |
Read-only |
CODIVRTime |
Read-only |
CODQueueHoldTime |
Read-only |
CODTotalHoldTime |
Read-only |
DescriptionShadow |
Read-only |
Duration |
Read-only |
Audit Fields |
Read-only |
Attachment |
DisplayFileName |
Required |
FileNameOrURL |
Required |
FileDate |
Read-only |
FileSize |
Read-only |
OpportunityId |
Read-only |
Id |
Read-only |
ModId |
Read-only |
Audit Fields |
Read-only |
Book |
BookName |
Required |
BookId |
Read-only |
SystemAssociateFlag |
Read-only |
ModId |
Read-only |
Audit Fields |
Read-only |
Competitor |
CompetitorId |
Required |
CompetitorExternalSystemId |
Required |
ReverseRelationshipRole |
Required |
RelationshipRole |
Required |
StartDate |
Required |
OpportunityCompetitorId |
Read-only |
Contact |
Age |
Read-only |
OwnerFullName |
Read-only |
CreatedbyEmailAddress |
Read-only |
ModifiedbyEmailAddress |
Read-only |
LastActivityDate |
Read-only |
FirstNameShadow |
Read-only |
LastNameShadow |
Read-only |
OpportunityTeam |
OpportunityAccess |
Required |
UserId |
Required |
Partner |
OpportunityPartnerId |
Read-only |
PartnerExternalSystemId |
Required |
ReverseRelationshipRole |
Required |
RelationshipRole |
Required |
StartDate |
Required |
Product |
ProductRevenueId |
Read-only |
ProductCategoryId |
Read-only |
ProductCategory |
Read-only |
ProductPartNumber |
Read-only |
ProductStatus |
Read-only |
ProductType |
Read-only |
OpportunityId |
Read-only |
OpportunityName |
Read-only |
OpportunityIntegrationID |
Read-only |
OpportunityExternalSystemId |
Read-only |
OpportunitySalesStage |
Read-only |
OpportunityAccountId |
Read-only |
OpportunityAccountName |
Read-only |
OpportunityAccountLocation |
Read-only |
OpportunityAccountExternalSystemId |
Read-only |
OpportunityAccountIntegrationId |
Read-only |
ContactFirstName |
Read-only |
ContactLastName |
Read-only |
Table 248 details the status key for the opportunity object.
Table 248. Status Key for the Opportunity Object
|
|
Opportunity (parent) |
Audit Fields |
AccountId |
ExternalSystemId |
Id |
IntegrationId |
Activity |
Audit Fields |
ExternalSystemId |
Id |
IntegrationId |
OpportunityId |
Attachment |
Audit Fields |
Id |
OpportunityId |
Book |
Audit Fields |
BookId |
ModId |
Competitor |
Audit Fields |
OpportunityCompetitorId |
CompetitorId |
CompetitorExternalSystemId |
Contact |
Audit Fields |
AccountId |
ContactId |
ExternalSystemId |
IntegrationId |
OpportunityId |
Lead |
Audit Fields |
AccountId |
ContactId |
ExternalSystemId |
IntegrationId |
LastUpdated |
LeadId |
OpportunityId |
OpportunityNote |
Audit Fields |
ExternalSystemId |
Id |
IntegrationId |
OpportunityId |
Partner |
Audit Fields |
OpportunityPartnerId |
PartnerId |
PartnerExternalSystemId |
Product |
Audit Fields |
ExternalId |
ProductRevenueId |
IntegrationID |
Table 249 details the pick map fields for the opportunity object.
Table 249. Pick Map Fields for the Opportunity Object
|
|
|
Opportunity (parent) |
Owner |
OwnerId |
AccountExternalSystemId |
AccountId |
Territory |
TerritoryId |
KeyContactIntegrationId |
KeyContactId |
KeyContactExternalSystemId |
KeyContactId |
Activity |
AccountIntegrationId |
AccountId |
AccountExternalId |
AccountId |
Address |
AddressId |
AssignedTo |
AssignedToId |
CampaignExternalId |
CampaignId |
CampaignIntegrationId |
CampaignId |
Dealer |
DealerId |
DelegatedBy |
DelegatedById |
FundRequest |
FundRequestId |
OpportunityIntegrationId |
OpportunityId |
OpportunityExternalId |
OpportunityId |
PrimaryContactIntegrationId |
PrimaryContactId |
PrimaryContactExternalId |
PrimaryContactId |
LeadIntegrationId |
LeadId |
LeadExternalId |
LeadId |
OwnerExternalId |
OwnerId |
OwnerIntegrationId |
OwnerId |
SRIntegrationId |
SRId |
SRExternalId |
SRId |
CustomObject1Name |
CustomObject1Id |
CustomObject2Name |
CustomObject2Id |
CustomObject3Name |
CustomObject3Id |
Book |
BookName |
BookId |
Contact |
AccountExternalSystemlId |
AccountId |
AccountIntegrationId |
AccountId |
ManagerExternalSystemId |
ManagerId |
ManagerIntegrationId |
ManagerId |
OwnerEmailAddress |
OwnerId |
OwnerExternalId |
OwnerId |
OwnerIntegrationId |
OwnerId |
SourceCampaignName |
SourceCampaignId |
|
SourceCampaignExternalId |
SourceCampaignId |
TimeZoneName |
TimeZoneId |
CustomObject1Name |
CustomObject1Id |
CustomObject2Name |
CustomObject2Id |
CustomObject3Name |
CustomObject3Id |
Competitor |
PrimaryContactName |
ContactId |
PartnerExternalSystemId |
PartnerId |
PartnerName |
PartnerId |
Partner |
PrimaryContactName |
ContactId |
CompetitorExternalSystemId |
CompetitorId |
CompetitorName |
CompetitorId |
Product |
ProductName |
ProductId |
ProductExternalSystemId |
ProductId |
ProductIntegrationId |
ProductId |
ContactExternalSystemId |
ContactId |
ContactIntegrationId |
ContactId |
Owner |
OwnerId |
CustomObject5Name |
CustomObject5Id |
CustomObject5ExternalSystemId |
CustomObject5Id |
CustomObject6Name |
CustomObject6Id |
CustomObject6ExternalSystemId |
CustomObject6Id |
Table 250 provides a list of the filterable fields for the child components of the opportunity objects, and a list of user key combinations for each child component.
Table 250. Filterable Fields and User Key Fields on the Opportunity Object's Child Components
|
|
User Key Field Combinations |
Opportunity (parent) |
All |
OpportunityId |
IntegrationId |
ExternalSystemId |
Activity |
Type |
Type and Description |
Owner |
IntegrationId |
Subject |
ExternalSystemId |
DueDate |
Priority |
Status |
Attachment |
None |
Id |
ExternalSystemId |
FileNameOrURL and FileExtension |
Book |
None |
BookId |
BookName |
Competitor |
OpportunityCompetitorId |
OpportunityCompetitorId |
PrimaryContactId |
CompetitorExternalSystemId |
EndDate |
CompetitorId |
CompetitorId |
CompetitorExternalSystemId |
ReverseRelationshipRole |
RelationshipRole |
StartDate |
ModifiedDate |
Contact |
ContactType |
AccountName and Private |
ContactFirstName |
ContactFirstName and ContactLastName and Private |
JobTitle |
IntegrationId |
ContactLastName |
ExternalSystemId |
Owner |
Id |
Lead |
Campaign |
IntegrationId |
EstimatedCloseDate |
ExternalSystemId |
Rating |
Source |
Status |
LeadOwner |
PotentialRevenue |
ProductInterest |
SalesPerson |
LeadId |
Note |
Subject |
Subject and Description |
IntegrationId |
ExternalSystemId |
OpportunityTeam |
UserFirstName |
OpportunityTeamId |
UserLastName |
UserId |
ModifiedDate |
UserExternalSystemId |
OpportunityAccess |
UserEmail |
OpportunityAccessId |
UserAlias |
OpportunityTeamId |
TeamRole |
UserExternalSystemId |
UserId |
Partner |
OpportunityPartnerId |
OpportunityPartnerId |
PrimaryContactId |
PartnerExternalSystemId |
EndDate |
PartnerId |
PartnerId |
PartnerExternalSystemId |
ReverseRelationshipRole |
RelationshipRole |
StartDate |
ModifiedDate |
Product |
OpportunityIntegrationId |
ExternalSystemId |
OpportunityExternalSystemId |
OpportunityIntegrationId |
OpportunitySalesStage |
ProductRevenueId |
OpportunityAccountId |
IntegrationId |
OpportunityAccountName |
OpportunityAccountLocation |
OpportunityAccountExternalSystemId |
OpportunityAccountIntegrationId |
ModifiedDate |
ContactId |
ContactExternalSystemId |
ContactIntegrationId |
Contract |
OwnerId |
Owner |
SerialNumber |
Revenue |
ExpectedRevenue |
Quantity |
PurchasePrice |
PurchaseDate |
|
StartCloseDate |
|
NumberOfPeriods |
Frequency |
Probability |
Forecast |
AssetValue |
Premium |
ShipDate |
Status |
Type |
Warranty |
ProductRevenueId |
ExternalSystemId |
IntegrationId |
ProductId |
ProductName |
ProductExternalSystemID |
ProductionIntegrationId |
ProductCategoryId |
ProductCategory |
ProductPartNumber |
ProductStatus |
ProductType |
OpportunityId |
OpportunityName |
Table 251 details the picklists available for the opportunity object.
Table 251. Picklists Available for the Opportunity Object
|
|
Opportunity (parent) |
LeadSource |
Priority |
Probability |
ReasonWonLost |
Status |
Type |
Year |
Make |
Model |
OpportunityTeam |
TeamRole |
Product |
Frequency |
Probability |
Status |
Type |
Warranty |
Contract |
For more information on the fields accessible through the Opportunity Web service, go to the Web Services Administration page within the Oracle CRM On Demand application, and generate the WSDL file for the opportunity object.
|