// fusionrest agent · sales and service (cx)

Opportunities

opportunities Based on latest (2026.09)

Create, change, delete and look up Opportunities, with ai object hints, assessments and child revenue. Actions include assign opportunity and copy opportunity.

/crmRestApi/resources/11.13.18.05/opportunities
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE106 actions
Record key
OptyNumber
Required on create
CurrencyCodeNamePrimaryOrganizationId
At a glance
116 fields2 finders73 children
I want to…List the latest 25Count recordsGet one recordCreate oneUpdate one

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Finder
Include children (expand)
Paging and options
limit
Endpoint and headers
GET /crmRestApi/resources/11.13.18.05/opportunities?fields=AccountPartyNumber,AssetId,AssetNumber,AssetProduct,AssetSerialNumber&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AccountPartyNumber": "<string, max 30>",
      "AssetId": 0,
      "AssetNumber": "<string, max 100>",
      "AssetProduct": "<string>",
      "AssetSerialNumber": "<string, max 100>"
    }
  ],
  "count": 25,
  "hasMore": true,
  "limit": 25,
  "offset": 0
}

Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's latest (2026.09) REST specification.

Fields 116

AttributeTypeUse
AccountPartyNumbertext · max 30Read-onlySearchable
AssetIdnumberOptional on createUpdatable
AssetNumbertext · max 100Optional on createUpdatableSearchable
AssetProducttextOptional on createUpdatable
AssetSerialNumbertext · max 100Read-onlySearchable
AssignmentModetext · max 30Optional on createUpdatable
AverageDaysAtStagenumberRead-only
BatchTagtext · max 30Optional on createUpdatable
BdgtAmountnumberOptional on createUpdatable
BdgtAmtCurcyCdtext · max 15Optional on createUpdatable
BudgetAvailableDatedateOptional on createUpdatable
BudgetedFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
ChampionFlagyes/no · max 1 · default falseOptional on createUpdatable
ClosePeriodtextRead-onlySearchable
Commentstext · max 2000Optional on createUpdatable
ConflictIdnumber · default 0Optional on createUpdatableSearchable
CreatedBytext · max 64Read-only
CreationDatedate-timeRead-onlySearchable
CrmConversionRatenumberOptional on createUpdatableSearchable
CrmCurrencyCodetext · max 15Read-only
CurrencyCodetext · max 15Required on createUpdatableSearchable
CustPartyTypetext · max 30Optional on createUpdatableSearchable
CustomerAccountIdnumberOptional on createUpdatable
DealHorizonCodetext · max 30Optional on createUpdatable
DecisionLevelCodetext · max 30Optional on createUpdatable
DeleteFlagyes/noRead-only
Descriptiontext · max 2000Optional on createUpdatable
DescriptionTexttext · max 255Read-only
DownsideAmountnumber · default 0Optional on createUpdatable
EffectiveDatedateOptional on createUpdatableSearchable
EmailAddresstext · max 320Read-only
ExpectAmountnumber · default 0Optional on createUpdatable
ForecastCategorytext · max 30Optional on createUpdatableSearchable
ForecastOverrideCodetext · max 30Optional on createUpdatable
HintCodetext · max 10Read-only
IBAssetIdnumberOptional on createUpdatableSearchable
IBAssetNumbertext · max 80Read-onlySearchable
IBAssetProducttextOptional on createUpdatable
IBAssetSerialNumbertext · max 80Read-onlySearchable
KeyContactIdnumberOptional on createUpdatableSearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Optional on createUpdatable
LastUpdatedBytext · max 64Read-only
LineOfBusinessCodetext · max 30Optional on createUpdatableSearchable
LookupCategorytext · max 30Read-onlySearchable
ManageGeneralProfileDataFlagyes/noRead-only
ManageRestrictedProfileDataFlagyes/noRead-only
ManageRevenueDataFlagyes/noRead-only
ManageTeamDataFlagyes/noRead-only
MaximumDaysInStagenumberRead-only
Nametext · max 275Required on createUpdatableSearchable
OpportunityOrigintext · max 30 · default SALES_OPTYOptional on createUpdatableSearchable
OpportunityTypeCodetext · max 30Optional on createUpdatable
OptyCreatedBytext · max 64Optional on create
OptyCreationDatedate-timeOptional on createUpdatableSearchable
OptyIdnumberOptional on createSearchable
OptyLastUpdateDatedate-timeOptional on createUpdatableSearchable
OptyLastUpdatedBytext · max 64Optional on createUpdatableSearchable
OptyNumbertext · max 30Optional on createSearchable
OwnerPartyNumbertext · max 30Read-onlySearchable
OwnerResourcePartyIdnumberOptional on createUpdatableSearchable
PartyName1text · max 360Read-onlySearchable
PartyUniqueName1text · max 900Read-onlySearchable
PhaseCdtext · max 30 · default "B - Working the Deal"Read-only
PrSrcNumbertext · max 100Optional on createUpdatable
PredWinProbnumberRead-onlySearchable
PrimaryCampaignIdnumberOptional on createUpdatableSearchable
PrimaryCampaignNametextOptional on createUpdatableSearchable
PrimaryCampaignNumbertext · max 30Optional on createUpdatableSearchable
PrimaryCompetitorIdnumberOptional on createUpdatableSearchable
PrimaryCompetitorPartyNumbertext · max 30Read-onlySearchable
PrimaryContactEmailAddresstext · max 320Read-only
PrimaryContactEmailPreftext · max 255Read-only
PrimaryContactFormattedPhoneNumbertextRead-only
PrimaryContactPartyNametext · max 360Read-onlySearchable
PrimaryContactPartyNumbertext · max 30Read-onlySearchable
PrimaryContactPhonePreftext · max 255Read-only
PrimaryOrganizationIdnumberRequired on createUpdatable
PrimaryOrganizationName_transienttextOptional on createUpdatable
PrimaryPartnerCompanyNumbertext · max 30Optional on createSearchable
PrimaryPartnerIdnumberOptional on createUpdatableSearchable
PrimaryPartnerOrgPartyNametext · max 360Optional on createUpdatable
PrimaryRevenueIdnumberOptional on createUpdatable
PrimarySubscriptionIdnumberOptional on createUpdatable
PrimarySubscriptionNumbertext · max 120Read-only
QuotaFactornumberRead-only
QuotedFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
RcmndWinProbnumber · default 0Read-only
ReasonWonLostCodetext · max 30Optional on createUpdatableSearchable
RecommendedActiontext · max 180Read-onlySearchable
RecordSettextRead-onlySearchable
Registeredtext · max 30Optional on createUpdatable
RegistrationStatustext · max 30Optional on createUpdatable
RegistrationTypetext · max 30Optional on createUpdatable
RenewalProcesstext · max 30Optional on createUpdatable
Revenuenumber · default 0Optional on createUpdatable
RiskLevelCodetext · max 30Optional on createUpdatable
SalesAccountUniqueNametext · max 900Read-only
SalesChannelCdtext · max 50Optional on createUpdatableSearchable
SalesMethodtext · max 50Read-onlySearchable
SalesMethodIdnumberOptional on createUpdatableSearchable
SalesStagetext · max 50Read-only
SalesStageIdnumberOptional on createUpdatableSearchable
Selectedyes/noOptional on createUpdatable
SetupRefCodetext · max 80Optional on createUpdatableSearchable
SourceTypetextRead-only
StageStatusCdtext · max 30 · default "Open"Read-only
StatusCodetext · max 30Optional on createUpdatableSearchable
StgOrdernumberRead-only
StrategicLevelCodetext · max 30Optional on createUpdatable
TargetPartyIdnumberOptional on createUpdatableSearchable
TargetPartyNametext · max 360Read-only
TargetPartyPrimaryAddressCountrytext · max 2Read-only
UpdateFlagyes/noRead-only
UpsideAmountnumber · default 0Optional on createUpdatable
WinProbnumberOptional on createUpdatableSearchable

Names, types, labels and flags from Oracle's REST specification (latest (2026.09)). Flexfield and custom attributes vary by pod: check /describe for yours.

Finders 2

Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.

Check a payload

Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.

Children 73

Child resources sit under one record: /crmRestApi/resources/11.13.18.05/opportunities/{OptyNumber}/child/<name>. Add them to a GET with expand.

Actions 106

Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.

Use in AI Agent Studio

More in For Builders.

Pitfalls