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 240 details the methods called by the Opportunity service.
Fields
Table 241 details the required and read-only fields for the opportunity object.
Table 241. 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 242 details the status key for the opportunity object.
Table 242. 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 243 details the pick map fields for the opportunity object.
Table 243. 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 244 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 244. 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 245 details the picklists available for the opportunity object.
Table 245. 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.
|