Project Costs
projectCosts Based on 26C
Change and look up Project Costs, with adjustments. Actions include adjust project costs. No create.
The record key projectCostsUniqID 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.
- Operations
- GET (list)GET (one)PATCH (update)1 action
- Record key
projectCostsUniqID- Required on create
- no create on this resource
- At a glance
- 167 fields0 finders3 children
- Extra parameters
?effectiveDate=Effective-Of:
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/projectCosts?fields=AccountingDate,AccountingPeriod,AccrualItemFlag,AdjustingItem,AdjustmentStatus&limit=25&onlyData=true
{
"items": [
{
"AccountingDate": "2026-01-31",
"AccountingPeriod": "<string, max 15>",
"AccrualItemFlag": false,
"AdjustingItem": 0,
"AdjustmentStatus": "<string, max 80>"
}
],
"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 167
| Attribute | Type | Use |
|---|---|---|
AccountingDate | date | Read-onlySearchable |
AccountingPeriod | text · max 15 | Read-onlySearchable |
AccrualItemFlag | yes/no · max 1 | Read-onlySearchable |
AdjustingItem | number | Read-onlySearchable |
AdjustmentStatus | text · max 80 | Read-onlySearchable |
AllowAdjustments | text · max 1 | Read-onlySearchable |
AssignmentId | number | Read-onlySearchable |
AssignmentName | text · max 80 | Read-onlySearchable |
AssignmentNumber | text · max 30 | Read-onlySearchable |
BillableFlag | yes/no · max 1 | Read-onlySearchable |
BorrowedAndLentDistributed | text · max 80 | Read-onlySearchable |
BorrowedAndLentDistributedCode | text · max 1 | Read-onlySearchable |
BurdenCostCreditAccount | text | Read-onlySearchable |
BurdenCostCreditAccountCombinationId | number | Read-onlySearchable |
BurdenCostDebitAccount | text | Read-onlySearchable |
BurdenCostDebitAccountCombinationId | number | Read-onlySearchable |
BurdenedCostCreditAccount | text | Read-onlySearchable |
BurdenedCostCreditAccountCombinationId | number | Read-onlySearchable |
BurdenedCostDebitAccount | text | Read-onlySearchable |
BurdenedCostDebitAccountCombinationId | number | Read-onlySearchable |
BurdenedCostInProjectCurrency | number | Read-onlySearchable |
BurdenedCostInProviderLedgerCurrency | number | Read-onlySearchable |
BurdenedCostInReceiverLedgerCurrency | number | Read-onlySearchable |
BurdenedCostInTransactionCurrency | number | Read-onlySearchable |
CapitalEventNumber | number | Read-onlySearchable |
CapitalizableFlag | yes/no · max 1 | Read-onlySearchable |
Comment | text · max 240 | Read-onlySearchable |
ContractId | number | Read-onlySearchable |
ContractName | text · max 300 | Read-onlySearchable |
ContractNumber | text · max 120 | Read-onlySearchable |
ConvertedFlag | yes/no · max 1 | Read-onlySearchable |
CostActionId | number | Read-onlySearchable |
CostActionType | text · max 120 | Read-onlySearchable |
CostAllocationKeyflexId | number | Read-onlySearchable |
CostElement | text · max 255 | Read-onlySearchable |
CostId | number | Read-onlySearchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
CrossChargeType | text · max 80 | Read-onlySearchable |
CrossChargeTypeCode | text · max 2 | Read-onlySearchable |
Document | text · max 240 | Read-onlySearchable |
DocumentEntry | text · max 240 | Read-onlySearchable |
DocumentEntryId | number | Read-onlySearchable |
DocumentId | number | Read-onlySearchable |
Email | text · max 240 | Read-onlySearchable |
ExpenditureBusinessUnit | text · max 240 | Read-onlySearchable |
ExpenditureBusinessUnitId | number | Read-onlySearchable |
ExpenditureCategory | text · max 240 | Read-onlySearchable |
ExpenditureItemDate | date | Read-onlySearchable |
ExpenditureOrganization | text · max 240 | Read-onlySearchable |
ExpenditureOrganizationId | number | Read-onlySearchable |
ExpenditureType | text · max 240 | Read-onlySearchable |
ExpenditureTypeClass | text · max 80 | Read-onlySearchable |
ExpenditureTypeClassCode | text · max 3 | Read-onlySearchable |
ExpenditureTypeId | number | Read-onlySearchable |
ExternalBillRate | number | UpdatableSearchable |
ExternalBillRateCurrency | text · max 15 | UpdatableSearchable |
ExternalBillRateSourceName | text · max 150 | UpdatableSearchable |
ExternalBillRateSourceReference | text · max 30 | UpdatableSearchable |
FundingSourceId | text · max 150 | Read-onlySearchable |
FundingSourceName | text · max 360 | Read-onlySearchable |
FundingSourceNumber | text · max 50 | Read-onlySearchable |
FundsStatus | text · max 30 | Read-onlySearchable |
HoldIntercompanyInvoiceFlag | yes/no · max 1 | Read-onlySearchable |
HoldIntercompanyRevenueFlag | yes/no · max 1 | Read-onlySearchable |
HoldInvoiceFlag | yes/no · max 1 | Read-onlySearchable |
HoldRevenueFlag | yes/no · max 1 | Read-onlySearchable |
IntercompanyBillRate | number | UpdatableSearchable |
IntercompanyBillRateCurrency | text · max 15 | UpdatableSearchable |
IntercompanyBillRateSourceName | text · max 150 | UpdatableSearchable |
IntercompanyBillRateSourceReference | text · max 20 | UpdatableSearchable |
IntercompanyInvoiceAmountInProviderLedgerCurrency | number | Read-onlySearchable |
IntercompanyInvoiceStatus | text · max 1 | Read-onlySearchable |
IntercompanyInvoicedPercentage | number | Read-onlySearchable |
IntercompanyRecognizedRevenuePercentage | number | Read-onlySearchable |
IntercompanyRevenueInProviderLedgerCurrency | number | Read-onlySearchable |
IntercompanyRevenueStatus | text · max 1 | Read-onlySearchable |
InventoryItem | text · max 240 | Read-onlySearchable |
InventoryItemId | number | Read-onlySearchable |
InventoryItemNumber | text · max 300 | Read-onlySearchable |
InventoryTransactionNumber | text · max 255 | Read-onlySearchable |
InvoiceAmountInReceiverLedgerCurrency | number | Read-onlySearchable |
InvoicedPercentage | number | Read-onlySearchable |
InvoicedStatus | text · max 1 | Read-onlySearchable |
Job | text · max 240 | Read-onlySearchable |
JobId | number | Read-onlySearchable |
LaborDistributionOriginalTransactionReference | text · max 120 | Read-onlySearchable |
LastUpdateDate | date-time | Read-onlySearchable |
LastUpdatedBy | text · max 64 | Read-onlySearchable |
NetZeroItemFlag | yes/no · max 1 | Read-onlySearchable |
NonlaborResource | text · max 240 | Read-onlySearchable |
NonlaborResourceId | number | Read-onlySearchable |
NonlaborResourceOrganization | text · max 240 | Read-onlySearchable |
NonlaborResourceOrganizationId | number | Read-onlySearchable |
OriginalTransactionReference | text · max 120 | Read-onlySearchable |
PayrollCosted | text · max 80 | Read-onlySearchable |
PayrollCostedCode | text · max 1 · default N | UpdatableSearchable |
PayrollId | number | Read-onlySearchable |
PayrollName | text · max 120 | Read-onlySearchable |
PersonId | number | Read-onlySearchable |
PersonName | text · max 240 | Read-onlySearchable |
PersonNumber | text · max 30 | Read-onlySearchable |
PersonType | text · max 20 | Read-onlySearchable |
ProjectId | number | Read-onlySearchable |
ProjectName | text · max 240 | Read-onlySearchable |
ProjectNumber | text · max 25 | Read-onlySearchable |
ProjectRoleId | number | Read-onlySearchable |
ProjectRoleName | text · max 240 | Read-onlySearchable |
ProviderBusinessUnit | text · max 240 | Read-onlySearchable |
ProviderBusinessUnitId | number | Read-onlySearchable |
ProviderLedgerCurrency | text · max 80 | Read-onlySearchable |
ProviderLedgerCurrencyCode | text · max 15 | Read-onlySearchable |
ProviderLedgerCurrencyConversionDate | date | Read-onlySearchable |
ProviderLedgerCurrencyConversionRate | number | Read-onlySearchable |
ProviderLedgerCurrencyConversionRateType | text · max 30 | Read-onlySearchable |
ProviderOrganization | text · max 240 | Read-onlySearchable |
ProviderOrganizationId | number | Read-onlySearchable |
Quantity | number | Read-onlySearchable |
RawCostCreditAccount | text | Read-onlySearchable |
RawCostCreditAccountCombinationId | number | Read-onlySearchable |
RawCostDebitAccount | text | Read-onlySearchable |
RawCostDebitAccountCombinationId | number | Read-onlySearchable |
RawCostInProjectCurrency | number | Read-onlySearchable |
RawCostInProviderLedgerCurrency | number | Read-onlySearchable |
RawCostInReceiverLedgerCurrency | number | Read-onlySearchable |
RawCostInTransactionCurrency | number | Read-onlySearchable |
RawCostRateInTransactionCurrency | number | Read-onlySearchable |
ReceiverBusinessUnit | text · max 240 | Read-onlySearchable |
ReceiverBusinessUnitId | number | Read-onlySearchable |
ReceiverOrganization | text · max 240 | Read-onlySearchable |
ReceiverOrganizationId | number | Read-onlySearchable |
RecognizedRevenuePercentage | number | Read-onlySearchable |
ResourceInstance | text · max 255 | Read-onlySearchable |
ResourceName | text · max 255 | Read-onlySearchable |
ResourceTransactionNumber | text · max 255 | Read-onlySearchable |
RevenueCategoryCode | text · max 30 | Read-onlySearchable |
RevenueInReceiverLedgerCurrency | number | Read-onlySearchable |
RevenueStatus | text · max 1 | Read-onlySearchable |
RunActionId | number | Read-onlySearchable |
RunId | number | Read-onlySearchable |
SalesOrderNumber | text · max 255 | Read-onlySearchable |
ShipmentNumber | text · max 255 | Read-onlySearchable |
SourceDistributionLayerReference | number | Read-onlySearchable |
SourceTransactionQuantity | number | Read-onlySearchable |
SourceTransactionType | text | Read-onlySearchable |
SupplyChainTransactionActionId | number | Read-onlySearchable |
SupplyChainTransactionSourceTypeId | number | Read-onlySearchable |
SupplyChainTransactionTypeId | number | Read-onlySearchable |
TaskId | number | Read-onlySearchable |
TaskName | text · max 255 | Read-onlySearchable |
TaskNumber | text · max 100 | Read-onlySearchable |
TransactionCurrency | text · max 80 | Read-onlySearchable |
TransactionNumber | number | Searchable |
TransactionSource | text · max 240 | Read-onlySearchable |
TransactionSourceId | number | Read-onlySearchable |
TransferOrderNumber | text · max 255 | Read-onlySearchable |
TransferPriceInProjectCurrency | number | Read-onlySearchable |
TransferPriceInProviderLedgerCurrency | number | Read-onlySearchable |
TransferPriceInReceiverLedgerCurrency | number | Read-onlySearchable |
TransferPriceInTransactionCurrency | number | Read-onlySearchable |
TransferredFromTransactionNumber | number | Read-onlySearchable |
UnitOfMeasure | text · max 80 | Read-onlySearchable |
UnitOfMeasureCode | text · max 30 | Read-onlySearchable |
UserExpenditureBatch | text · max 200 | Read-onlySearchable |
WorkOrderNumber | text · max 255 | Read-onlySearchable |
WorkType | text · max 240 | Read-onlySearchable |
WorkTypeId | number | Read-onlySearchable |
Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.
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/projectCosts/{projectCostsUniqID}/child/<name>. Add them to a GET with expand.
AdjustmentsGET Adjustments · 11 fieldsAdjustedByAdjustedOnAdjustmentSourceAdjustmentSourceCodeAdjustmentStatusAdjustmentStatusCodeAdjustmentTypeAdjustmentTypeCodeExpenditureItemIdRejectionReasonRejectionReasonCodeProjectCostsDFFGET · PATCH Project Costs Descriptive Flexfields · 3 fieldsExpenditureItemId__FLEX_Context__FLEX_Context_DisplayValueProjectStandardCostCollectionFlexFieldsGET · PATCH Project Standard Cost Collection FlexfieldsFields depend on your pod's flexfield setup (check
/describe).
Actions 1
POST …/{projectCostsUniqID}/action/adjustProjectCosts·ContractNumberTaskIdBurdenCostDebitAccountCombinationIdProjectNameRawCostDebitAccountCombinationIdProjectRoleIdTransactionCurrencyHoldInvoiceFlagCapitalizableFlagRawCostInTransactionCurrencyJustificationCommentHoldRevenueFlagBurdenedCostDebitAccountCombinationIdProjectNumberProjectIdTaskNumberBillableFlagQuantityRawCostCreditAccountCombinationIdContractIdTransactionCurrencyCodeFundingSourceNameAdjustmentTypeContractNameAdjustmentTypeCodeExpenditureTypeIdFundingSourceNumberFundingSourceIdProjectRoleNameBurdenCostCreditAccountCombinationIdExpenditureTypeTaskNameBurdenedCostCreditAccountCombinationId
Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/projectCostsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
- This resource can change data. Put a human approval step before any create, update, delete or action call.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:ExternalBillRate, notexternalbillrate. - 157 fields are read-only: sending them in POST or PATCH fails or is ignored. The builder leaves them out.
onlyData=trueremoveslinks, and this resource's key only comes fromlinks. Leave it off when you need the key.- Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through.