// fusionrest agent · sales and service (cx)

Deal Registrations

deals Based on latest (2026.09)

Create, change and look up Deal Registrations, with deal approval history, deal product and deal resources. Actions include auto sync deal size and product amount total and calculate product amount total.

The record key dealsUniqID is a generated hash. Take it from the record's links (rel self) in a GET response; never build it yourself.

Oracle documents an Effective-Of header and an effectiveDate parameter for this resource, used for date-effective reads and changes.

/crmRestApi/resources/11.13.18.05/deals
Operations
GET (list)GET (one)POST (create)PATCH (update)56 actions
Record key
dealsUniqID
Required on create
none marked
At a glance
110 fields6 finders25 children
Extra parameters
?effectiveDate=Effective-Of:
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/deals?fields=AccountPartyNumber,ApprovalTaskStatusCode,ApprovedByPartyName,ApprovedDate,CloseDate&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AccountPartyNumber": "<string, max 30>",
      "ApprovalTaskStatusCode": "<string>",
      "ApprovedByPartyName": "<string, max 255>",
      "ApprovedDate": "2026-01-31",
      "CloseDate": "2026-01-31"
    }
  ],
  "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 110

AttributeTypeUse
AccountPartyNumbertext · max 30Read-onlySearchable
ApprovalTaskStatusCodetextOptional on createUpdatable
ApprovedByPartyNametext · max 255Read-only
ApprovedDatedateOptional on createUpdatable
CloseDatedateOptional on createUpdatableSearchable
CombinedConPrPhonetext · max 255Read-onlySearchable
ConPrPhoneAreaCodetext · max 10Optional on createUpdatable
ConPrPhoneCountryCodetext · max 10Optional on createUpdatable
ConPrPhoneNumbertext · max 40Optional on createUpdatable
ContactEmailAddresstext · max 320Optional on createUpdatableSearchable
ContactFirstNametext · max 150Optional on createUpdatable
ContactIdnumberOptional on createUpdatable
ContactJobTitletext · max 100Optional on createUpdatable
ContactLastNametext · max 150Optional on createUpdatable
ContactNametext · max 900Optional on createUpdatable
ContactPartyNumbertext · max 30Read-onlySearchable
CreatedBytext · max 64Read-only
CreationDatedate-timeRead-onlySearchable
CurrencyCodetext · max 20Optional on createUpdatable
CustomerFormattedAddresstextOptional on createUpdatable
CustomerIdnumberOptional on createUpdatable
CustomerLocationAddrElementAttribute1textOptional on createUpdatable
CustomerLocationAddrElementAttribute2textOptional on createUpdatable
CustomerLocationAddrElementAttribute3textOptional on createUpdatable
CustomerLocationAddrElementAttribute4textOptional on createUpdatable
CustomerLocationAddrElementAttribute5textOptional on createUpdatable
CustomerLocationAddress1textOptional on createUpdatable
CustomerLocationAddress2textOptional on createUpdatable
CustomerLocationAddress3textOptional on createUpdatable
CustomerLocationAddress4textOptional on createUpdatable
CustomerLocationAddressLinesPhonetictextOptional on createUpdatable
CustomerLocationBuildingtextOptional on createUpdatable
CustomerLocationCitytextOptional on createUpdatableSearchable
CustomerLocationCountrytextOptional on createUpdatableSearchable
CustomerLocationCountytextOptional on createUpdatable
CustomerLocationFloorNumbertextOptional on createUpdatable
CustomerLocationPostalCodetextOptional on createUpdatableSearchable
CustomerLocationPostalPlus4CodetextOptional on createUpdatable
CustomerLocationProvincetextOptional on createUpdatable
CustomerLocationStatetextOptional on createUpdatableSearchable
CustomerNametext · max 900Optional on createUpdatable
CustomerPartyTypetext · max 30Read-only
DealApprovedBytextOptional on createUpdatable
DealContactNametext · max 360Optional on createUpdatable
DealCustomerNametext · max 360Optional on createUpdatable
DealExpirationDatedateOptional on createUpdatableSearchable
DealIdnumberOptional on createSearchable
DealNametext · max 250Optional on createUpdatableSearchable
DealNumbertext · max 30Optional on createSearchable
DealRejectedBytextOptional on createUpdatable
DealRejectedCommentstext · max 250Optional on createUpdatable
DealRejectedReasonCodetext · max 30Optional on createUpdatable
DealReturnCommentstext · max 250Optional on createUpdatable
DealReturnReasonCodetext · max 30Optional on createUpdatable
DealReturnedBytextOptional on createUpdatable
DealSizenumberOptional on createUpdatableSearchable
DealSubmittedBynumberRead-only
DealTypetext · max 30 · default ORA_NEWOptional on createUpdatable
DealWithdrawnBytextOptional on createUpdatable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Read-only
LastUpdatedBytext · max 64Read-only
LeadIdnumberOptional on createUpdatableSearchable
LeadNametext · max 250Read-only
LeadNumbertext · max 30Optional on createUpdatableSearchable
ManageApprovalDataFlagyes/noRead-only
ManageGeneralDataFlagyes/noRead-only
ManageOpptyDataFlagyes/noRead-only
ManagePartnerDataFlagyes/noRead-only
ManageTeamDataFlagyes/noRead-only
MatchedAccountPartyIdnumberOptional on createUpdatable
MatchedAccountPartyNumbertext · max 30Read-onlySearchable
MatchedAccountPartyUniqueNametext · max 900Read-only
MatchedContactPartyIdnumberOptional on createUpdatable
MatchedContactPartyNametext · max 360Read-only
MatchedContactPartyNumbertext · max 30Read-onlySearchable
NotesSourceObjectCodetextRead-only
OptyIdnumberOptional on createUpdatableSearchable
OptyNametext · max 275Read-only
OptyNumbertext · max 30Optional on createUpdatableSearchable
OwnerIdnumberOptional on createUpdatableSearchable
OwnerPartyNametext · max 360Optional on createUpdatable
OwnerPartyNumbertext · max 30Read-onlySearchable
PartnerCompanyNumbertext · max 30Optional on createSearchable
PartnerIdnumberOptional on createUpdatableSearchable
PartnerLeveltext · max 50Read-only
PartnerOwnerIdnumberRead-only
PartnerOwnerNametext · max 450Read-onlySearchable
PartnerPartyNametext · max 360Optional on createUpdatableSearchable
PartnerTypetext · max 30Optional on createUpdatable
ProgramEnrollmentIdnumberOptional on createUpdatable
ProgramEnrollmentNumbertext · max 30Read-onlySearchable
RejectedByPartyNametext · max 255Read-only
RejectedDatedateOptional on createUpdatable
ReturnedByPartyNametext · max 255Read-only
ReturnedDatedateOptional on createUpdatable
SearchKeytextOptional on createUpdatable
StatusCodetext · max 30 · default ORA_DRAFTOptional on createUpdatableSearchable
SubmittedByPartyNametext · max 360Read-only
SubmittedDatedateRead-only
UpdateFlagyes/noRead-only
WithdrawnByPartyNametext · max 255Read-only
WithdrawnDatedateOptional on createUpdatable
canApproveyes/noRead-only
canCopyDealyes/noRead-only
canRejectyes/noRead-only
canReturnyes/noRead-only
canSubmityes/noRead-only
canWithdrawyes/noRead-only
isApproverFlagyes/noRead-only

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 6

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 25

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

Actions 56

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