// fusionrest agent · procurement

Work Confirmations

workConfirmations Based on 26C

Create, change, delete and look up Work Confirmations, with document actions and lines. Actions include cancel and submit.

The record key workConfirmationsUniqID 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.

/fscmRestApi/resources/11.13.18.05/workConfirmations
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE3 actions
Record key
workConfirmationsUniqID
Required on create
POHeaderId
At a glance
34 fields1 finders3 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 /fscmRestApi/resources/11.13.18.05/workConfirmations?fields=BalanceToFinish,Buyer,BuyerId,Comments,ContractAmountToDate&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "BalanceToFinish": 0,
      "Buyer": "<string, max 240>",
      "BuyerId": 0,
      "Comments": "<string, max 240>",
      "ContractAmountToDate": 0
    }
  ],
  "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 26C REST specification.

Fields 34

AttributeTypeUse
BalanceToFinishnumberRead-onlySearchable
Buyertext · max 240Read-onlySearchable
BuyerIdnumberRead-onlySearchable
Commentstext · max 240Optional on createUpdatable
ContractAmountToDatenumberRead-onlySearchable
CreatedBytext · max 64Read-only
CreationDatedate-timeRead-only
Currencytext · max 80Read-onlySearchable
CurrencyCodetext · max 15Read-onlySearchable
CurrentPaymentDuenumberRead-onlySearchable
ImportSourcetext · max 25Optional on createUpdatableSearchable
LastUpdateDatedate-timeRead-only
LastUpdatedBytext · max 64Read-only
OrderNumbertext · max 30Optional on createSearchable
PODescriptiontext · max 240Read-onlySearchable
POHeaderIdnumberRequired on createSearchable
PeriodEndDatedateOptional on createUpdatableSearchable
PeriodStartDatedateOptional on createUpdatableSearchable
PreviouslyApprovedAmountnumberRead-onlySearchable
ProjectedRetainageThisPeriodnumberRead-onlySearchable
SoldToLegalEntitytext · max 240Optional on createSearchable
SoldToLegalEntityIdnumberOptional on createSearchable
Statustext · max 80Read-onlySearchable
StatusCodetext · max 25Read-onlySearchable
Suppliertext · max 360Read-onlySearchable
SupplierIdnumberRead-onlySearchable
SupplierSitetext · max 240Read-onlySearchable
SupplierSiteIdnumberRead-onlySearchable
TotalCompletedThisPeriodnumberRead-onlySearchable
TotalCompletedToDatenumberRead-onlySearchable
WorkConfirmationIdnumberRead-onlySearchable
WorkConfirmationNumbertext · max 30Read-onlySearchable
WorkConfirmationRequestDatedate-timeOptional on createUpdatableSearchable
WorkConfirmationSequenceNumbernumberRead-only

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

Finders 1

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 3

Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/workConfirmations/{workConfirmationsUniqID}/child/<name>. Add them to a GET with expand.

Actions 3

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