Items Version 2
itemsV2 Based on 26C
Create, change and look up Items Version 2, with item category, item revision and item supplier association. Actions include add items to delete group and add supplier associations to delete group.
The record key itemsV2UniqID is a generated hash. Take it from the record's links (rel self) in a GET response; never build it yourself.
- Operations
- GET (list)GET (one)POST (create)PATCH (update)9 actions
- Record key
itemsV2UniqID- Required on create
OrganizationId- At a glance
- 309 fields3 finders15 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/itemsV2?fields=ATPComponentsValue,ATPValue,AcceptableEarlyDays,AccountingRuleValue,AllowExpressTransactionsFlag&limit=25&onlyData=true
{
"items": [
{
"ATPComponentsValue": "<string>",
"ATPValue": "<string>",
"AcceptableEarlyDays": 0,
"AccountingRuleValue": "<string>",
"AllowExpressTransactionsFlag": false
}
],
"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 309
| Attribute | Type | Use |
|---|---|---|
ATPComponentsValue | text | Optional on createUpdatableSearchable |
ATPValue | text | Optional on createUpdatableSearchable |
AcceptableEarlyDays | number | Optional on createUpdatableSearchable |
AccountingRuleValue | text | Optional on createUpdatableSearchable |
AllowExpressTransactionsFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
AllowMaintenanceAssetFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
AllowPurchasingDocumentDescriptionUpdateFlag | yes/no · max 1 · default true | Optional on createUpdatableSearchable |
AllowSubstituteReceiptsFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
AllowSuspendFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
AllowTerminateFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
AllowUnorderedReceiptsFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
ApprovalStatusValue | text | Optional on createUpdatableSearchable |
AssembleToOrderFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
AssetCategoryValue | text | Optional on createUpdatableSearchable |
AssetClassValue | text | Optional on createUpdatableSearchable |
AssetTrackedFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
AssetTrackedValue | text | Optional on createUpdatableSearchable |
AutoCreatedConfigurationFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
AutomaticallyExpireASNFlag | yes/no · default false | Optional on createUpdatableSearchable |
BackOrderableFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
BackToBackEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
BaseItemValue | text | Optional on createUpdatableSearchable |
BillingTypeValue | text | Optional on createUpdatableSearchable |
BuildInWIPFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
BulkPickedFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
BuyerEmailAddress | text | Optional on createUpdatableSearchable |
BuyerOrganizationValue | text | Optional on createUpdatableSearchable |
CASNumber | text · max 30 | Optional on createUpdatableSearchable |
CarryingCostPercentage | number | Optional on createUpdatableSearchable |
ChangeNotice | text | Optional on createUpdatable |
ChangeOrderLineSequenceNumber | number | Read-only |
CheckMaterialShortageFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
ChildLotEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
ChildLotFormatValidationFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
ChildLotParent | text | Optional on createUpdatableSearchable |
ChildLotPrefix | text · max 30 | Optional on createUpdatableSearchable |
ChildLotStartingNumber | number | Optional on createUpdatableSearchable |
CollateralFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
CommonSupplyProjectDemandFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
CommsActivationRequiredFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
ConfigModelTypeValue | text | Optional on createUpdatableSearchable |
ConsignedFlag | yes/no · default false | Optional on createUpdatableSearchable |
ContainerItemFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
ContainerTypeValue | text | Optional on createUpdatableSearchable |
ContractManufacturingFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
CopyAssociationsFlag | yes/no · default false | Optional on createUpdatable |
CopyAttachmentsFlag | yes/no · default false | Optional on createUpdatable |
CopyCategoriesFlag | yes/no · default false | Optional on createUpdatable |
CopyFromItemValue | text | Optional on createUpdatableSearchable |
CopyFromRevisionValue | text | Optional on createUpdatableSearchable |
CopyFromVersionValue | text | Optional on createUpdatableSearchable |
CopyItemAndApplyTemplatesFlag | yes/no | Optional on createUpdatable |
CopyLotAttributeFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
CopyOrganizationAssignmentsFlag | yes/no · default false | Optional on createUpdatable |
CostingEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
CreateConfiguredItem | text | Optional on createUpdatableSearchable |
CreateFixedAssetFlag | yes/no | Optional on createUpdatable |
CreateFixedAssetValue | text | Optional on createUpdatableSearchable |
CreateSupplyAfterDate | date | Optional on createUpdatableSearchable |
CreateSupplyFlag | yes/no · max 1 · default true | Optional on createUpdatableSearchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreatedFromItemId | number | Read-onlySearchable |
CreatedFromItemNumber | text · max 255 | Read-onlySearchable |
CreatedFromItemRevision | text · max 255 | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
CreationDateTime | date-time | Read-onlySearchable |
CriticalComponentFlag | yes/no · default false | Optional on createUpdatableSearchable |
CumulativeManufacturingLeadTime | number | Optional on createUpdatableSearchable |
CumulativeTotalLeadTime | number | Optional on createUpdatableSearchable |
CustomerOrderEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
CustomerOrderFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
CustomerSelfServiceEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
CycleCountEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
DaysEarlyReceiptAllowed | number | Optional on createUpdatableSearchable |
DaysLateReceiptAllowed | number | Optional on createUpdatableSearchable |
DaysOfCover | number | Optional on createUpdatableSearchable |
DefaultBuyerValue | text | Optional on createUpdatableSearchable |
DefaultGradeValue | text | Optional on createUpdatableSearchable |
DefaultLotStatusValue | text | Optional on createUpdatableSearchable |
DefaultRepairTransactionName | text | Optional on createUpdatableSearchable |
DefaultSalesOrderSourceTypeValue | text | Optional on createUpdatableSearchable |
DefaultSerialStatusValue | text | Optional on createUpdatableSearchable |
DefaultShippingOrganizationValue | text | Optional on createUpdatableSearchable |
DefaultingControlValue | text | Optional on createUpdatableSearchable |
DefectTrackingOnFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
DemandPeriod | number | Optional on createUpdatableSearchable |
DemandTimeDays | number | Optional on createUpdatableSearchable |
DemandTimeFence | text | Optional on createUpdatableSearchable |
DimensionUOMValue | text | Optional on createUpdatableSearchable |
DownloadableFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
EffectivityControlValue | text | Optional on createUpdatableSearchable |
ElectronicFormatFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
EligibilityRuleFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
EnableContractCoverage | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
EnableGenealogyTrackingFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
EnableIotFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
EnforceShipToLocationValue | text · max 255 | Optional on createUpdatableSearchable |
EngineeredItemFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
EventFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
ExpenditureTypeValue | text | Optional on createUpdatableSearchable |
ExpirationActionInterval | number | Optional on createUpdatableSearchable |
ExpirationActionValue | text | Optional on createUpdatableSearchable |
ExpirationDateCalculationBasis | text · max 3 | Optional on createUpdatableSearchable |
ExpirationDateCalculationBasisValue | text | Optional on createUpdatableSearchable |
FinancingAllowedFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
FixedDaysSupply | number | Optional on createUpdatableSearchable |
FixedLeadTime | number | Optional on createUpdatableSearchable |
FixedLotSizeMultiplier | number | Optional on createUpdatableSearchable |
FixedOrderQuantity | number | Optional on createUpdatableSearchable |
ForcePurchaseLeadTimeFlag | yes/no · max 1 · default true | Optional on createUpdatableSearchable |
ForecastControlValue | text | Optional on createUpdatableSearchable |
ForecastHorizon | number | Optional on createUpdatableSearchable |
ForecastTypelValue | text | Optional on createUpdatableSearchable |
FormattedDescription | text · max 2147483647 | Optional on createUpdatableSearchable |
GradeControlFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
HardPeggingLevelValue | text | Optional on createUpdatableSearchable |
HazardClassValue | text | Optional on createUpdatableSearchable |
HazardousMaterialFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
HoldDays | number | Optional on createUpdatableSearchable |
IgnoreDuplicateItemFlag | yes/no · default false | Optional on createUpdatable |
IncludeInRollUpFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
InstanceClassValue | text | Optional on createUpdatable |
InternalVolume | number | Optional on createUpdatableSearchable |
InternallyTransferableFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
InventoryAssetFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
InventoryCarryPenalty | number | Optional on createUpdatableSearchable |
InventoryItemFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
InventoryPlanningMethodValue | text | Optional on createUpdatableSearchable |
InvoiceCloseTolerancePercentage | number | Optional on createUpdatableSearchable |
InvoiceEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
InvoiceMatchOptionValue | text | Optional on createUpdatableSearchable |
InvoicedFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
InvoicingRuleValue | text | Optional on createUpdatableSearchable |
IssueUOMValue | text | Optional on createUpdatableSearchable |
ItemClass | text | Optional on createUpdatableSearchable |
ItemDescription | text · max 240 | Optional on createUpdatableSearchable |
ItemExtensibleFlexfieldCategoryCode | text · max 240 | Optional on createUpdatable |
ItemId | number | Optional on createSearchable |
ItemNumber | text · max 300 | Optional on createUpdatableSearchable |
ItemObjectTypeValue | text | Read-onlySearchable |
ItemStatusValue | text | Optional on createUpdatableSearchable |
Keyword | text · max 255 | Optional on createUpdatableSearchable |
LastSubmittedNewItemRequest | text | Optional on createUpdatableSearchable |
LastUpdateDate | date-time | Read-onlySearchable |
LastUpdateDateTime | date-time | Read-onlySearchable |
LastUpdateLogin | text · max 32 | Read-onlySearchable |
LastUpdatedBy | text · max 64 | Read-onlySearchable |
LeadTimeLotSize | number · default 1 | Optional on createUpdatableSearchable |
LifecyclePhaseValue | text | Optional on createUpdatableSearchable |
ListPrice | number | Optional on createUpdatableSearchable |
LongDescription | text · max 4000 | Optional on createUpdatableSearchable |
LotControlValue | text | Optional on createUpdatableSearchable |
LotDivisibleFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
LotExpirationControlValue | text | Optional on createUpdatableSearchable |
LotMergeEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
LotSplitEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
LotStatusEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
LotSubstitutionEnabledFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
LotTranslateEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
MRPCalculateATPFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
MarketPrice | number | Optional on createUpdatableSearchable |
MatchApprovalLevelValue | text · max 255 | Optional on createUpdatableSearchable |
MatchConfigurationOptionValue | text | Optional on createUpdatableSearchable |
MaterialTransactionEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
MaturityDays | number | Optional on createUpdatableSearchable |
MaximumLoadWeight | number | Optional on createUpdatableSearchable |
MaximumMinmaxQuantity | number | Optional on createUpdatableSearchable |
MaximumOrderQuantity | number | Optional on createUpdatableSearchable |
MinimumFillPercent | number | Optional on createUpdatableSearchable |
MinimumLicenseQuantity | number | Optional on createUpdatableSearchable |
MinimumMinmaxQuantity | number | Optional on createUpdatableSearchable |
MinimumOrderQuantity | number | Optional on createUpdatableSearchable |
NegativeDeviationFactor | number · default 0 | Optional on createUpdatableSearchable |
NegativeMeasurementError | number | Optional on createUpdatableSearchable |
NegotiationRequiredFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
OperationSlackPenalty | number | Optional on createUpdatableSearchable |
OrderCost | number | Optional on createUpdatableSearchable |
OrderManagementIndivisibleFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
OrderModifierStartQuantityFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
OrderableOnWebFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
OrganizationCode | text | Optional on createUpdatableSearchable |
OrganizationId | number | Required on createSearchable |
OutputTaxClassificationCodeValue | text | Optional on createUpdatableSearchable |
OutsideProcessServiceFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
OverReturnTolerance | number | Optional on createUpdatableSearchable |
OverShipmentTolerance | number | Optional on createUpdatableSearchable |
OvercompletionToleranceTypeValue | text | Optional on createUpdatableSearchable |
OvercompletionToleranceValue | number | Optional on createUpdatableSearchable |
PackTypeValue | text | Optional on createUpdatableSearchable |
PackagingStringValue | text | Optional on createUpdatableSearchable |
PartsSourcingValue | text | Optional on createUpdatableSearchable |
PaymentTermsValue | text | Optional on createUpdatableSearchable |
PickComponentsFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
PickingRuleValue | text | Optional on createUpdatableSearchable |
Planner | text | Optional on createUpdatableSearchable |
PlanningMakeBuyValue | text | Optional on createUpdatableSearchable |
PlanningMethodValue | text | Optional on createUpdatableSearchable |
PlanningTimeDays | number · default 1 | Optional on createUpdatableSearchable |
PlanningTimeFence | text | Optional on createUpdatableSearchable |
PositiveDeviationFactor | number · default 0 | Optional on createUpdatableSearchable |
PositiveMeasurementError | number | Optional on createUpdatableSearchable |
PostprocessingDays | number · default 0 | Optional on createUpdatableSearchable |
PreliminaryItemFlag | yes/no · max 1 · default true | Read-onlySearchable |
PreprocessingDays | number | Optional on createUpdatableSearchable |
PriceTolerancePercentage | number | Optional on createUpdatableSearchable |
PricingUOMValue | text | Optional on createUpdatableSearchable |
PrimaryUOMValue | text | Optional on createUpdatableSearchable |
ProcessCostingEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
ProcessExecutionEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
ProcessQualityEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
ProcessSupplyLocatorValue | text · max 255 | Optional on createUpdatableSearchable |
ProcessSupplySubinventoryValue | text | Optional on createUpdatableSearchable |
ProcessYieldLocatorValue | text | Optional on createUpdatableSearchable |
ProcessYieldSubinventoryValue | text | Optional on createUpdatableSearchable |
ProcessingDays | number | Optional on createUpdatableSearchable |
ProcurementBusinessUnitName | text | Optional on createUpdatableSearchable |
PurchasableFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
PurchasingFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
PurchasingInputTaxClassificationValue | text | Optional on createUpdatableSearchable |
QuantityReceivedToleranceAction | text | Optional on createUpdatableSearchable |
QuantityReceivedTolerancePercentage | number | Optional on createUpdatableSearchable |
RMAInspectionRequiredFlag | yes/no · default false | Optional on createUpdatableSearchable |
ReceiptCloseTolerancePercentage | number | Optional on createUpdatableSearchable |
ReceiptDateActionValue | text | Optional on createUpdatableSearchable |
ReceiptRoutingValue | text | Optional on createUpdatableSearchable |
RecipeEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
RecoveredPartDispositionValue | text | Optional on createUpdatableSearchable |
ReleaseAuthorizationRequiredValue | text | Optional on createUpdatableSearchable |
ReleaseTimeDays | number | Optional on createUpdatableSearchable |
ReleaseTimeFence | text | Optional on createUpdatableSearchable |
RepairLeadtime | number | Optional on createUpdatableSearchable |
RepairYield | number | Optional on createUpdatableSearchable |
ReplacementTypeValue | text | Optional on createUpdatableSearchable |
ReplenishmentMaximumDaysOfSupply | number | Optional on createUpdatableSearchable |
ReplenishmentMaximumOrder | number | Optional on createUpdatableSearchable |
ReplenishmentMinimumDaysOfSupply | number | Optional on createUpdatableSearchable |
ReplenishmentMinimumOrder | number | Optional on createUpdatableSearchable |
ReplenishmentSourceTypeValue | text | Optional on createUpdatableSearchable |
RequestId | number | Optional on createUpdatableSearchable |
RequiresFulfillmentLocationFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
RequiresItemAssociationFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
ReservableFlag | yes/no · default true | Optional on createUpdatableSearchable |
RestrictLocatorsFlag | yes/no · default false | Optional on createUpdatableSearchable |
RestrictSubinventoriesFlag | yes/no · default false | Optional on createUpdatableSearchable |
RetestInterval | number | Optional on createUpdatableSearchable |
ReturnableFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
RevisionQuantityControlFlag | yes/no · default false | Optional on createUpdatableSearchable |
RoundingControlTypeFlag | yes/no | Optional on createUpdatableSearchable |
RoundingFactor | number | Optional on createUpdatableSearchable |
SafetyStockPlanningMethodValue | text | Optional on createUpdatableSearchable |
SalesAccountValue | text | Optional on createUpdatableSearchable |
SalesProductTypeValue | text · max 255 | Optional on createUpdatableSearchable |
SecondaryUOMValue | text | Optional on createUpdatableSearchable |
SerialGenerationValue | text | Optional on createUpdatableSearchable |
SerialStartingNumber | text · max 80 | Optional on createUpdatableSearchable |
SerialStartingPrefix | text · max 80 | Optional on createUpdatableSearchable |
SerialStatusEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
ServiceBillingEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
ServiceDuration | number | Optional on createUpdatableSearchable |
ServiceDurationPeriodValue | text | Optional on createUpdatableSearchable |
ServiceDurationTypeValue | text | Optional on createUpdatableSearchable |
ServiceRequestEnabledValue | text | Optional on createUpdatableSearchable |
ServiceStartDelay | number · default 0 | Optional on createUpdatableSearchable |
ServiceStartTypeValue | text | Optional on createUpdatableSearchable |
ShelfLifeDays | number · default 0 | Optional on createUpdatableSearchable |
ShipModelCompleteFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
ShippableFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
ShrinkageRate | number | Optional on createUpdatableSearchable |
SourceOrganizationValue | text | Optional on createUpdatableSearchable |
SourceSubinventoryOrganizationValue | text | Optional on createUpdatableSearchable |
SourceSubinventoryValue | text | Optional on createUpdatableSearchable |
StandardCoverageValue | text | Optional on createUpdatableSearchable |
StandardLotSize | number | Optional on createUpdatableSearchable |
StartingLotNumber | text · max 30 | Optional on createUpdatableSearchable |
StartingLotPrefix | text · max 80 | Optional on createUpdatableSearchable |
StockEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
StockLocatorControlValue | text | Optional on createUpdatableSearchable |
StructureItemTypeValue | text | Optional on createUpdatableSearchable |
StyleItemFlag | yes/no · max 1 | Optional on createSearchable |
StyleItemNumberValue | text | Optional on createUpdatableSearchable |
SubcontractingComponentValue | text | Optional on createUpdatableSearchable |
TaxableFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
Template | text | Optional on createUpdatableSearchable |
TrackingUOMValue | text | Optional on createUpdatableSearchable |
TransactionConversionValue | text | Optional on createUpdatableSearchable |
TransactionEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
TransferOrdersEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
UNNumberValue | text | Optional on createUpdatableSearchable |
UnderCompletionToleranceTypeValue | text | Optional on createUpdatableSearchable |
UnderCompletionToleranceValue | number | Optional on createUpdatableSearchable |
UnderReturnTolerance | number | Optional on createUpdatableSearchable |
UnderShipmentTolerance | number | Optional on createUpdatableSearchable |
UnitHeightQuantity | number | Optional on createUpdatableSearchable |
UnitLengthQuantity | number | Optional on createUpdatableSearchable |
UnitVolumeQuantity | number | Optional on createUpdatableSearchable |
UnitWeightQuantity | number | Optional on createUpdatableSearchable |
UnitWidthQuantity | number | Optional on createUpdatableSearchable |
UseApprovedSupplierFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
UserItemTypeValue | text | Optional on createUpdatableSearchable |
VMIFixedOrderQuantity | number | Optional on createUpdatableSearchable |
VariableLeadTime | number | Optional on createUpdatableSearchable |
VehicleItemFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
VolumeUOMValue | text | Optional on createUpdatableSearchable |
WIPSupplyLocatorValue | text | Optional on createUpdatable |
WIPSupplySubinventoryValue | text | Optional on createUpdatableSearchable |
WIPSupplyTypeValue | text | Optional on createUpdatableSearchable |
WarehouseEquipmentFlag | yes/no · default false | Optional on createUpdatableSearchable |
WebStatusValue | text | Optional on createUpdatableSearchable |
WeightUOMValue | text | Optional on createUpdatableSearchable |
Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.
Finders 3
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
ItemNumberAltKey·ItemNumberItemRF·ItemNumberOrganizationCodeItemVersionAltKey·AcdTypeChangeLineIdInventoryOrganizationIdVersionId
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 15
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/itemsV2/{itemsV2UniqID}/child/<name>. Add them to a GET with expand.
ItemAttachmentGET · POST · PATCH · DELETE Item Revision Attachments List of Values · 43 fieldsAsyncTrackerIdAttachedDocumentIdBaseDocumentIdCategoryNameContentRepositoryFileCheckedOutByContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDataTypeNameDatabaseDescriptionDatabaseTitleDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDocumentIdDocumentPreviewURLDocumentURLDownloadInfoEntityNameErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlItemIdLastUpdateDateLastUpdatedByLastUpdatedByUserNameOrganizationIdPrimaryCategoryFlagRevisionIdTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameAttachedDocumentsDFFGET · POST · PATCH Attached Documents Descriptive Flexfield · 3 fieldsAttachedDocumentId__FLEX_Context__FLEX_Context_DisplayValueItemCategoryGET · POST · PATCH · DELETE Item Categories · 17 fieldsCategoryCodeCategoryNameCreatedByCreationDateTimeEndDateItemCatalogItemCategoryAssignmentIdItemCategoryHierarchyCodeItemCategoryHierarchyNameItemIdLastUpdateDateTimeLastUpdateLoginLastUpdatedByOrganizationIdRequestIdSequenceNumberStartDateItemDFFGET · POST · PATCH Descriptive Flexfield for Items · 4 fieldsInventoryItemIdOrganizationId__FLEX_Context__FLEX_Context_DisplayValueItemEffCategoryGET · POST · PATCH · DELETE Item Extensible Flexfields · 1 findersFields depend on your pod's flexfield setup (check
/describe).ItemGlobalDFFGET · POST · PATCH Global Descriptive Flexfield for ItemsFields depend on your pod's flexfield setup (check
/describe).ItemRevisionGET · POST · PATCH Item Revisions · 16 fields · 1 findersCreatedByCreationDateTimeEffectivityDateEndEffectivityDateImplementationDateItemIdItemRevisionDescriptionLastUpdateDateTimeLastUpdateLoginLastUpdatedByOrganizationIdRequestIdRevisionCodeRevisionExtensibleFlexfieldCategoryCodeRevisionIdRevisionReasonValueItemRevisionDFFGET · POST · PATCH ItemRevisionDFF · 3 fieldsRevisionId__FLEX_Context__FLEX_Context_DisplayValueItemRevisionEffCategoryGET · POST · PATCH · DELETE Extensible Flexfields for Item RevisionsFields depend on your pod's flexfield setup (check
/describe).ItemRevisionTranslationGET · POST · PATCH Item Revision Translatable Attributes · 9 fieldsCreatedByCreationDateTimeDescriptionLanguageLastUpdateDateTimeLastUpdateLoginLastUpdatedByRevisionIdSourceLanguageRevisionAttachmentGET · POST · PATCH · DELETE Item Revision Attachments · 30 fieldsAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDocumentURLDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlLastUpdateDateLastUpdatedByLastUpdatedByUserNameTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameItemSupplierAssociationGET · POST · PATCH Item-Supplier Associations · 18 fieldsAddressAddressNameAlternateSupplierNumberAssociationIdCreationDateTimeItemIdLastUpdateDateTimeOrganizationIdPartySiteNumberPrimaryFlagRegistryIdRequestIdSupplierExtensibleFlexfieldCategoryCodeSupplierIdSupplierItemNumberSupplierNameSupplierSiteAssociationStatusValueSupplierSiteIdItemSupplierEffCategoryGET · POST · PATCH · DELETE Extensible Flexfields for Item-Supplier AssociationsFields depend on your pod's flexfield setup (check
/describe).ItemTranslationGET · POST · PATCH Item Translatable Attributes · 9 fieldsCreationDateTimeHTMLLongDescriptionItemDescriptionItemIdLanguageLastUpdateDateTimeLongDescriptionOrganizationIdSourceLanguageProductCostsGET · POST · PATCH Product Costs · 4 fieldsCostSourceCurrencyCodeLastContractPriceMaterialCost
Actions 9
POST …/action/addItemsToDeleteGroup·deleteGroupNameitemsInfoPOST …/action/addSupplierAssociationsToDeleteGroup·deleteGroupNamesupplierAssociationsInfoPOST …/{itemsV2UniqID}/child/ItemAttachment/{ItemAttachmentUniqID}/action/cancelCheckOutPOST …/{itemsV2UniqID}/child/ItemAttachment/{ItemAttachmentUniqID}/action/checkIn·fileNamefiletitlecontentTypePOST …/{itemsV2UniqID}/child/ItemAttachment/{ItemAttachmentUniqID}/action/checkOutPOST …/{itemsV2UniqID}/child/ItemAttachment/{ItemAttachmentUniqID}/action/downloadAttachmentAuditPOST …/{itemsV2UniqID}/child/ItemAttachment/{ItemAttachmentUniqID}/action/fetchVersionsPOST …/{itemsV2UniqID}/child/ItemAttachment/{ItemAttachmentUniqID}/action/previewAttachmentAuditPOST …/{itemsV2UniqID}/child/ItemAttachment/{ItemAttachmentUniqID}/action/updateActiveVersion·versionId
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/itemsV2and ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
ItemNumberAltKeyfor the agent's main search: its variables become clean tool parameters. - 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:ATPComponentsValue, notatpcomponentsvalue. - 13 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. - Text fields have maximum lengths (shown in the field table). Longer values are rejected.