// fusionrest agent · supply chain and manufacturing · inventory management

Resource Rates

resourceRates Based on 26C

Create, change, delete and look up Resource Rates, with resource rate details. Actions include add cost element and decrease cost.

The record key resourceRatesUniqID 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/resourceRates
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE7 actions
Record key
resourceRatesUniqID
Required on create
CostBookCodeCostBookIdCostOrgIdCostOrgNameCurrencyCodeEffectiveStartDateInvOrgIdInvOrgNameResourceIdResourceNameScenarioIdUOM
At a glance
49 fields1 finders2 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/resourceRates?fields=AttachmentEntityName,CostBookCode,CostBookId,CostOrgCode,CostOrgId&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AttachmentEntityName": "CST_STD_RESOURCE_RATES",
      "CostBookCode": "<string, max 30>",
      "CostBookId": 0,
      "CostOrgCode": "<string, max 150>",
      "CostOrgId": 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 49

AttributeTypeUse
AttachmentEntityNametext · default CST_STD_RESOURCE_RATESOptional on createUpdatableSearchable
CostBookCodetext · max 30Required on createSearchable
CostBookIdnumberRequired on createSearchable
CostOrgCodetext · max 150Read-onlySearchable
CostOrgIdnumberRequired on createSearchable
CostOrgNametext · max 240Required on createSearchable
CreatedBytext · max 64Read-only
CreationDatedate-timeRead-only
CreationSourcetext · max 11 · default RESTOptional on createUpdatableSearchable
CurrencyCodetext · max 15Required on createSearchable
EffectiveEndDatedateOptional on createSearchable
EffectiveStartDatedateRequired on createSearchable
ExtendedPrecisionnumber · default 5Read-onlySearchable
FromPeriodNametext · max 15Optional on createUpdatableSearchable
InvOrgCodetext · max 18Read-onlySearchable
InvOrgIdnumberRequired on createSearchable
InvOrgNametext · max 240Required on createSearchable
LastUpdateDatedate-timeRead-only
LastUpdateSourcetext · max 11 · default RESTOptional on createUpdatableSearchable
LastUpdatedBytext · max 64Read-only
LastUsedDatedate-timeOptional on createUpdatableSearchable
LastUsedTransactionIdnumberOptional on createUpdatable
PeriodStatusCodetext · max 30Read-onlySearchable
PeriodStatusMeaningtext · max 80Read-onlySearchable
PeriodicAverageFlagMeaningtext · max 80Read-onlySearchable
Precisionnumber · default 2Read-onlySearchable
PreviousEffectiveEndDatedate-timeOptional on createUpdatableSearchable
PreviousEffectiveStartDatedate-timeOptional on createUpdatableSearchable
PreviousStandardResourceRateIdnumberOptional on createUpdatable
PrimaryBookFlagyes/no · max 1Read-onlySearchable
ProcessedFlagMeaningtext · max 80Read-onlySearchable
ResourceCodetext · max 30Read-onlySearchable
ResourceIdnumberRequired on createSearchable
ResourceNametext · max 80Required on createSearchable
ResourceTypetext · max 30Read-onlySearchable
ResourceTypeMeaningtext · max 80Read-onlySearchable
ScenarioEventIdnumberOptional on createUpdatable
ScenarioIdnumberRequired on createSearchable
ScenarioNumbertext · max 30Optional on createSearchable
ScenarioPublishHeaderIdnumberOptional on createUpdatable
ScenarioRollupHeaderIdnumberOptional on createUpdatable
StagedForStandardCostAdjustmentFlagyes/no · max 1Optional on createUpdatableSearchable
StandardResourceRateIdnumberOptional on createSearchable
StatusCodetext · max 30 · default IN_PROCESSOptional on createSearchable
StatusCodeMeaningtext · max 80Read-onlySearchable
ToPeriodNametext · max 15Optional on createUpdatableSearchable
TotalRatenumberRead-onlySearchable
UOMtext · max 30Required on createSearchable
UOMNametext · max 25Read-onlySearchable

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 2

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

Actions 7

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