Items Version 2
items Based on 26C
Look up Items Version 2, with item revision and item supplier association. Actions include add items to delete group and add supplier associations to delete group. Changes only through its actions.
The record key itemsUniqID 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)2 actions
- Record key
itemsUniqID- Required on create
- no create on this resource
- At a glance
- 487 fields3 finders4 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/items?fields=ATOForecastControl,ATPCode,ATPComponentsCode,ATPComponentsValue,ATPValue&limit=25&onlyData=true
{
"items": [
{
"ATOForecastControl": 0,
"ATPCode": "N",
"ATPComponentsCode": "N",
"ATPComponentsValue": "<string>",
"ATPValue": "<string>"
}
],
"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 487
| Attribute | Type | Use |
|---|---|---|
ATOForecastControl | number | Searchable |
ATPCode | text · max 1 · default N | Searchable |
ATPComponentsCode | text · max 1 · default N | Searchable |
ATPComponentsValue | text | Searchable |
ATPValue | text | Searchable |
AcceptableEarlyDays | number | Searchable |
AccountingRuleId | number | Searchable |
AccountingRuleValue | text | Searchable |
AcdType | text · max 30 · default PROD | Searchable |
AllowExpressDeliveryFlag | yes/no · max 1 | Searchable |
AllowItemDescriptionUpdateFlag | yes/no · max 1 · default true | Searchable |
AllowMaintenanceAssetFlag | yes/no · max 1 · default false | Searchable |
AllowSubstituteReceiptsFlag | yes/no · max 1 | Searchable |
AllowSuspendFlag | yes/no · max 1 · default false | Searchable |
AllowTerminateFlag | yes/no · max 1 · default false | Searchable |
AllowUnorderedReceiptsFlag | yes/no · max 1 | Searchable |
AllowedUnitsLookupCode | number · default 3 | Searchable |
AltItemCode | text · max 40 | Searchable |
ApprovalStatus | text · max 30 | Searchable |
ApprovalStatusValue | text | Searchable |
AssembleToOrderFlag | yes/no · max 1 · default false | Searchable |
AssetActivityCauseValue | text | |
AssetActivityShutdownTypeValue | text | |
AssetCategoryId | number | Searchable |
AssetCategorySIN | number | Searchable |
AssetCategoryValue | text | Searchable |
AssetClass | text · max 30 · default EQ | Searchable |
AssetClassValue | text | Searchable |
AssetItemTypeValue | text | |
AssetTrackedFlag | yes/no · max 1 · default false | Searchable |
AssetTrackedValue | text | Searchable |
AttachmentEntityName | text · max 255 · default ITEM_ENTITY | Searchable |
AutoCreatedConfigurationFlag | yes/no · max 1 · default false | Searchable |
AutomaticallyExpireASNFlag | yes/no · default false | Searchable |
BOMItemType | number · default 4 | Searchable |
BackOrderableFlag | yes/no · max 1 | Searchable |
BackToBackEnabledFlag | yes/no · max 1 · default false | Searchable |
BaseItemId | number | Searchable |
BaseItemValue | text | Searchable |
BillingTypeValue | text | Searchable |
BuildInWIPFlag | yes/no · max 1 · default false | Searchable |
BulkPickedFlag | yes/no · max 1 · default false | Searchable |
BuyerEmailAddress | text | Searchable |
BuyerId | number | Searchable |
BuyerOrganizationId | number | Searchable |
BuyerOrganizationValue | text | Searchable |
CASNumber | text · max 30 | Searchable |
CarryPercentage | number | Searchable |
ChangeBitMap | text · max 400 · default 0 | Searchable |
ChangeLineId | number · default -1 | Searchable |
ChangeNotice | text | |
ChangeOrderLineSequenceNumber | number | Read-only |
CheckMaterialShortageFlag | yes/no · max 1 · default false | Searchable |
ChildLotEnabledFlag | yes/no · max 1 · default false | Searchable |
ChildLotFormatValidationFlag | yes/no · max 1 · default false | Searchable |
ChildLotParent | text | Searchable |
ChildLotPrefix | text · max 30 | Searchable |
ChildLotStartingNumber | number | Searchable |
CollateralFlag | yes/no · max 1 | Searchable |
CommonSupplyProjectDemandFlag | yes/no · max 1 | Searchable |
CommsActivationReqdFlag | yes/no · max 1 | Searchable |
ConfigMatch | text · max 30 | Searchable |
ConfigModelType | text · max 30 | Searchable |
ConfigModelTypeValue | text | Searchable |
ConfigOrganization | text · max 30 | Searchable |
ConsignedFlag | yes/no · default false | Searchable |
ContainerItemFlag | yes/no · max 1 | Searchable |
ContainerTypeCode | text · max 30 | Searchable |
ContainerTypeValue | text | Searchable |
ContextChangeLineId | number | |
ContextDate | date-time | |
ContextVersionId | number | |
ContractManufacturingFlag | yes/no · max 1 · default false | Searchable |
CopyAssociationsFlag | yes/no · default false | |
CopyAttachmentsFlag | yes/no · default false | |
CopyCategoriesFlag | yes/no · default false | |
CopyFromItemId | number | |
CopyFromItemValue | text | Searchable |
CopyFromOrganizationId | number | |
CopyFromOrganizationValue | text | Searchable |
CopyFromRevisionId | number | |
CopyFromRevisionValue | text | Searchable |
CopyFromVersionId | number | |
CopyFromVersionValue | text | Searchable |
CopyItemAndApplyTemplatesFlag | yes/no | |
CopyLotAttributeFlag | yes/no · max 1 · default false | Searchable |
CopyOrganizationAssignmentsFlag | yes/no · default false | |
CostingEnabledFlag | yes/no · max 1 · default false | Searchable |
CoverageScheduleId | number | Searchable |
CreateConfiguredItem | text | Searchable |
CreateFixedAssetFlag | yes/no | |
CreateFixedAssetValue | text | Searchable |
CreateSupplyAfterDate | date | Searchable |
CreateSupplyFlag | yes/no · max 1 · default true | Searchable |
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 | Searchable |
CssEnabledFlag | yes/no · max 1 · default false | Searchable |
CumulativeManufacturingLeadTime | number | Searchable |
CumulativeTotalLeadTime | number | Searchable |
Currency | text · max 15 | Searchable |
CurrentPhaseCode | text · max 30 | Searchable |
CustomerOrderEnabledFlag | yes/no · max 1 · default false | Searchable |
CustomerOrderFlag | yes/no · max 1 · default false | Searchable |
CycleCountEnabledFlag | yes/no · max 1 · default false | Searchable |
DRPPlannedFlag | yes/no · default false | Searchable |
DaysEarlyReceiptAllowed | number | Searchable |
DaysLateReceiptAllowed | number | Searchable |
DaysMaximumInventorySupply | number | Searchable |
DaysOfCover | number | Searchable |
DefaultBuyerValue | text | Searchable |
DefaultGrade | text · max 150 | Searchable |
DefaultGradeValue | text | Searchable |
DefaultLotStatusId | number | Searchable |
DefaultLotStatusValue | text | Searchable |
DefaultRepairTransactionName | text | Searchable |
DefaultSalesOrderSourceTypeValue | text | Searchable |
DefaultSerialStatusId | number | Searchable |
DefaultSerialStatusValue | text | Searchable |
DefaultShippingOrganization | number | Searchable |
DefaultShippingOrganizationValue | text | Searchable |
DefaultSoSourceType | text · max 30 · default INTERNAL | Searchable |
DefaultingControlValue | text | Searchable |
DefectTrackingOnFlag | yes/no · max 1 | Searchable |
DemandPeriod | number | Searchable |
DemandTimeDays | number | Searchable |
DemandTimeFence | text | Searchable |
DemandTimeFenceCode | number | Searchable |
DimensionUOMCode | text · max 3 | Searchable |
DimensionUOMValue | text | Searchable |
DownloadableFlag | yes/no · max 1 | Searchable |
EAMActivityCauseCode | text | |
EAMActivityNotificationFlag | yes/no | |
EAMActivityShutdownStatus | text | |
EAMActivitySourceCode | text | |
EAMActivitySourceValue | text | |
EAMActivityTypeCode | text | |
EAMActivityTypeValue | text | |
EAMItemType | number | |
EffectivityControl | number · default 1 | Searchable |
EffectivityControlValue | text | Searchable |
ElectronicFormatFlag | yes/no · max 1 | Searchable |
EligibilityRuleFlag | yes/no · max 1 | Searchable |
EnableGenealogyTrackingFlag | yes/no · max 1 · default false | Searchable |
EnableIotFlag | yes/no · max 1 · default false | Searchable |
EnabledFlag | text · max 1 · default Y | Searchable |
EndAssemblyPeggingCode | text · max 1 · default N | Searchable |
EndDateActive | date | Searchable |
EnforceShipToLocation | text · max 255 | Searchable |
EnforceShipToLocationCode | text · max 25 | Searchable |
EngineeredItemFlag | yes/no · max 1 · default false | Searchable |
EventFlag | yes/no · max 1 | Searchable |
ExcludeFromBudgetFlag | yes/no · default false | Searchable |
ExpenditureTypeValue | text | Searchable |
ExpenseAccount | number | Searchable |
ExpenseAccountValue | text | Searchable |
ExpenseSIN | number | Searchable |
ExpirationActionCode | text · max 32 | Searchable |
ExpirationActionInterval | number | Searchable |
ExpirationActionValue | text | Searchable |
ExpirationDateCalculationBasis | text · max 3 | Searchable |
ExpirationDateCalculationBasisValue | text | Searchable |
FinancingAllowedFlag | yes/no · max 1 | Searchable |
FixedDaysSupply | number | Searchable |
FixedLeadTime | number | Searchable |
FixedLotSizeMultiplier | number | Searchable |
FixedOrderQuantity | number | Searchable |
ForcePurchaseLeadTimeFlag | yes/no · max 1 · default true | Searchable |
ForecastControlValue | text | Searchable |
ForecastHorizon | number | Searchable |
ForecastTypelValue | text | Searchable |
FormattedDescription | text · max 2147483647 | Searchable |
GdsnOutboundEnabledFlag | text · max 1 | Searchable |
GradeControlFlag | yes/no · max 1 · default false | Searchable |
HardPeggingLevelValue | text | Searchable |
HazardClassId | number | Searchable |
HazardClassValue | text | Searchable |
HazardousMaterialFlag | yes/no · max 1 · default false | Searchable |
HoldDays | number | Searchable |
IbItemInstanceClass | text | |
IgnoreDuplicateItemFlag | yes/no · default false | |
ImplementationDate | date-time | Searchable |
IncludeInRollUpFlag | yes/no · max 1 | Searchable |
InstanceClassValue | text | |
InternalOrderEnabledFlag | yes/no · max 1 · default false | Searchable |
InternalOrderFlag | yes/no · max 1 · default false | Searchable |
InternalVolume | number | Searchable |
InvItemIdChar | text · max 255 | Read-onlySearchable |
InventoryAssetFlag | yes/no · max 1 · default false | Searchable |
InventoryCarryPenalty | number | Searchable |
InventoryItemFlag | yes/no · max 1 · default false | Searchable |
InventoryItemStatusCode | text · max 10 | Searchable |
InventoryOrganizationId | number | Searchable |
InventoryOrganizationValue | text | Searchable |
InventoryPlanningCode | number · default 6 | Searchable |
InventoryPlanningMethodValue | text | Searchable |
InvoiceCloseTolerancePercentage | number | Searchable |
InvoiceEnabledFlag | yes/no · max 1 · default false | Searchable |
InvoiceMatchOptionValue | text | Searchable |
InvoicedFlag | yes/no · max 1 · default false | Searchable |
InvoicingRuleId | number | Searchable |
InvoicingRuleValue | text | Searchable |
ItemCatalogGroupId | number | Searchable |
ItemClass | text | Searchable |
ItemDescription | text · max 240 | Searchable |
ItemExtensibleFlexfieldCategoryCode | text · max 240 | |
ItemId | number | Searchable |
ItemNumber | text · max 300 | Searchable |
ItemStatusValue | text | Searchable |
ItemType | text · max 30 | Searchable |
Keyword | text · max 255 | Searchable |
Language | text · max 4 | Read-onlySearchable |
LastSubmittedNewItemRequest | text | Searchable |
LastSubmittedNirId | number | Searchable |
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 | Searchable |
LifecyclePhaseValue | text | Searchable |
ListPrice | number | Searchable |
LocationControlCode | number · default 1 | Searchable |
LongDescription | text · max 4000 | Searchable |
LotControlCode | number · default 1 | Searchable |
LotControlValue | text | Searchable |
LotDivisibleFlag | yes/no · max 1 · default false | Searchable |
LotExpirationControlValue | text | Searchable |
LotMergeEnabledFlag | yes/no · max 1 · default false | Searchable |
LotSplitEnabledFlag | yes/no · max 1 · default false | Searchable |
LotStatusEnabledFlag | yes/no · max 1 · default false | Searchable |
LotSubstitutionEnabledFlag | yes/no · max 1 | Searchable |
LotTranslateEnabledFlag | yes/no · max 1 · default false | Searchable |
MRPCalculateATPFlag | yes/no · max 1 | Searchable |
MRPPlanningCode | number · default 6 | Searchable |
MarketPrice | number | Searchable |
MatchApprovalLevel | number | Searchable |
MatchApprovalLevelValue | text · max 255 | Searchable |
MatchConfigurationOptionValue | text | Searchable |
MaterialBillableCode | text · max 30 | Searchable |
MaterialTransactionEnabledFlag | yes/no · max 1 · default false | Searchable |
MaturityDays | number | Searchable |
MaximumDaysOfSupply | number | Searchable |
MaximumInventoryWindow | number | Searchable |
MaximumLoadWeight | number | Searchable |
MaximumMinmaxQuantity | number | Searchable |
MaximumOrder | number | |
MaximumOrderQuantity | number | Searchable |
MinimumFillPercent | number | Searchable |
MinimumLicenseQuantity | number | Searchable |
MinimumMinmaxQuantity | number | Searchable |
MinimumOrderQuantity | number | Searchable |
NegativeDeviationFactor | number · default 0 | Searchable |
NegativeMeasurementError | number | Searchable |
NegotiationRequiredFlag | yes/no · max 1 | Searchable |
ObjectVersionNumber | number | Searchable |
OntPricingQuantitySource | text · max 30 · default P | Searchable |
OperationSlackPenalty | number | Searchable |
OrderCost | number | Searchable |
OrderManagementIndivisibleFlag | yes/no · max 1 | Searchable |
OrderModifierStartQuantityFlag | yes/no · max 1 | Searchable |
OrderableOnWebFlag | yes/no · max 1 | Searchable |
OrgId | number | Read-onlySearchable |
OrgIdChar | text · max 255 | Read-onlySearchable |
OrganizationCode | text | Searchable |
OrganizationId | number | Searchable |
OutputTaxClassificationCodeValue | text | Searchable |
OutsideOperationUOMType | text | |
OutsideProcessServiceFlag | yes/no · max 1 · default false | Searchable |
OutsideProcessingFlag | yes/no | |
OutsideProcessingUnitTypeValue | text | |
OutsourcedAssemblyFlag | yes/no | |
OverReturnTolerance | number | Searchable |
OverShipmentTolerance | number | Searchable |
OvercompletionToleranceType | number | Searchable |
OvercompletionToleranceTypeValue | text | Searchable |
OvercompletionToleranceValue | number | Searchable |
PSStructureInstanceNumber | number | Searchable |
PSSubInventoryId | number | Searchable |
PUOMClass | text | |
PYStructureInstanceNumber | number | Searchable |
PYSubInventoryId | number | Searchable |
PackTypeValue | text | Searchable |
PackagingStringValue | text | Searchable |
ParentChildGenerationCode | text · max 1 | Searchable |
PartsSourcingValue | text | Searchable |
PaymentTermsId | number | Searchable |
PaymentTermsValue | text | Searchable |
Pegging | text | Searchable |
PickComponentsFlag | yes/no · max 1 · default false | Searchable |
PickingRuleId | number | Searchable |
PickingRuleValue | text | Searchable |
PlannedInventoryPointFlag | yes/no · max 1 | Searchable |
Planner | text | Searchable |
PlannerCode | text · max 10 | Searchable |
PlanningMakeBuyCode | number · default 2 | Searchable |
PlanningMakeBuyValue | text | Searchable |
PlanningMethodValue | text | Searchable |
PlanningTimeDays | number · default 1 | Searchable |
PlanningTimeFence | text | Searchable |
PlanningTimeFenceCode | number · default 4 | Searchable |
PositiveDeviationFactor | number · default 0 | Searchable |
PositiveMeasurementError | number | Searchable |
PostprocessingDays | number · default 0 | Searchable |
PreliminaryItemFlag | yes/no · max 1 · default true | Read-onlySearchable |
PrepositionPointFlag | yes/no · max 1 · default false | Searchable |
PreprocessingDays | number | Searchable |
PriceTolerancePercentage | number | Searchable |
PrimaryUOMCode | text · max 3 | Searchable |
PrimaryUOMValue | text | Searchable |
ProcessCostingEnabledFlag | yes/no · max 1 · default false | Searchable |
ProcessExecutionEnabledFlag | yes/no · max 1 · default false | Searchable |
ProcessQualityEnabledFlag | yes/no · max 1 · default false | Searchable |
ProcessSupplyLocatorId | number | Searchable |
ProcessSupplyLocatorValue | text · max 255 | Searchable |
ProcessSupplySubinventory | text · max 10 | Searchable |
ProcessSupplySubinventoryValue | text | Searchable |
ProcessYieldLocatorId | number | Searchable |
ProcessYieldLocatorValue | text | Searchable |
ProcessYieldSubinventory | text · max 10 | Searchable |
ProcessYieldSubinventoryValue | text | Searchable |
ProcessingDays | number | Searchable |
ProcurementBusinessUnitName | text | Searchable |
PurchasableFlag | yes/no · max 1 · default false | Searchable |
PurchasingFlag | yes/no · max 1 · default false | Searchable |
PurchasingInputTaxClassificationValue | text | Searchable |
PurchasingTaxCode | text · max 50 | Searchable |
QuantityRcvExceptionCode | text · max 25 | Searchable |
QuantityReceivedToleranceAction | text | Searchable |
QuantityReceivedTolerancePercentage | number | Searchable |
RMAInspectionRequiredFlag | yes/no · default false | Searchable |
ReceiptCloseTolerancePercentage | number | Searchable |
ReceiptDateActionValue | text | Searchable |
ReceiptDaysExceptionCode | text · max 25 | Searchable |
ReceiptRountingValue | text | Searchable |
ReceivingRoutingId | number | Searchable |
RecipeEnabledFlag | yes/no · max 1 · default false | Searchable |
RecoveredPartDispCode | text · max 30 | Searchable |
RecoveredPartDispositionValue | text | Searchable |
ReleaseAuthorizationRequiredValue | text | Searchable |
ReleaseTimeDays | number | Searchable |
ReleaseTimeFence | text | Searchable |
ReleaseTimeFenceCode | number | Searchable |
RepairLeadtime | number | Searchable |
RepairProgram | number · default 3 | Searchable |
RepairProgramValue | text | Searchable |
RepairYield | number | Searchable |
ReplacementType | text · max 30 | Searchable |
ReplacementTypeValue | text | Searchable |
ReplenishmentMaximumOrder | number | Searchable |
ReplenishmentMinimumDays | number | Searchable |
ReplenishmentMinimumOrder | number | Searchable |
ReplenishmentType | text | Searchable |
RequestId | number | Searchable |
RequiresFulfillmentLocFlag | yes/no · max 1 · default false | Searchable |
RequiresItemAssociationFlag | yes/no · max 1 · default false | Searchable |
ReservableFlag | yes/no · default true | Searchable |
RestrictLocatorsFlag | yes/no · default false | Searchable |
RestrictSubinventoriesFlag | yes/no · default false | Searchable |
RetestInterval | number | Searchable |
ReturnableFlag | yes/no · max 1 · default false | Searchable |
RevisionForVersion | text | |
RevisionQuantityControlFlag | yes/no · default false | Searchable |
RoundingControlTypeFlag | yes/no | Searchable |
RoundingFactor | number | Searchable |
SOAuthorizationCode | number · default 1 | Searchable |
SUOMClass | text | |
SafetyStockPlanningMethod | text · max 30 · default NOT_PLANNED | Searchable |
SafetyStockPlanningMethodValue | text | Searchable |
SalesAccount | number | Searchable |
SalesAccountValue | text | Searchable |
SalesProductType | text · max 30 | Searchable |
SalesProductTypeValue | text · max 255 | Searchable |
SalesSIN | number | Searchable |
SecondaryDefaultId | text · max 30 | Searchable |
SecondaryUOMCode | text · max 3 | Searchable |
SecondaryUnitofMeasureValue | text | Searchable |
SerialGenerationValue | text | Searchable |
SerialNumberControlCode | number · default 1 | Searchable |
SerialStartingNumber | text · max 80 | Searchable |
SerialStartingPrefix | text · max 80 | Searchable |
SerialStatusEnabledFlag | yes/no · max 1 · default false | Searchable |
ServiceBillingEnabledFlag | yes/no · max 1 · default false | Searchable |
ServiceDuration | number | Searchable |
ServiceDurationPeriodCode | text · max 10 | Searchable |
ServiceDurationPeriodCodeClass | text | |
ServiceDurationPeriodValue | text | Searchable |
ServiceDurationTypeCode | text · max 3 · default O | Searchable |
ServiceDurationTypeValue | text | Searchable |
ServiceRequestEnabledCode | text · max 30 | Searchable |
ServiceRequestEnabledValue | text | Searchable |
ServiceStartDelay | number · default 0 | Searchable |
ServiceStartTypeCode | text · max 3 · default MS | Searchable |
ServiceStartTypeValue | text | Searchable |
ServiceStartingDelay | number | Searchable |
ServiceableProductFlag | yes/no · max 1 · default false | Searchable |
ShelfLifeCode | number · default 1 | Searchable |
ShelfLifeDays | number · default 0 | Searchable |
ShipModelCompleteFlag | yes/no · max 1 · default false | Searchable |
ShippableFlag | yes/no · max 1 · default false | Searchable |
ShrinkageRate | number | Searchable |
SourceOrganizationId | number | Searchable |
SourceOrganizationValue | text | Searchable |
SourceSubinventory | text · max 10 | Searchable |
SourceSubinventoryOrganizationId | number | Searchable |
SourceSubinventoryOrganizationValue | text | Searchable |
SourceSubinventoryValue | text | Searchable |
SourceType | number | Searchable |
StandardCoverage | text | Searchable |
StandardLotSize | number | Searchable |
StartDateActive | date | Searchable |
StartingLotNumber | text · max 30 | Searchable |
StartingLotPrefix | text · max 80 | Searchable |
StockEnabledFlag | yes/no · max 1 · default false | Searchable |
StockLocatorControlValue | text | Searchable |
StructureInstanceNumber | number | Searchable |
StructureItemTypeValue | text | Searchable |
StyleItemFlag | yes/no · max 1 | Searchable |
StyleItemId | number | Searchable |
StyleItemNumberValue | text | Searchable |
SubInventoryId | number | Searchable |
SubcontractingComponent | number | Searchable |
SubcontractingComponentValue | text | Searchable |
SubstitutionDays | number | Searchable |
SubstitutionWindow | text | Searchable |
SubstitutionWindowCode | number | Searchable |
SummaryFlag | text · max 1 · default N | Searchable |
TagetInventoryWindow | number | Searchable |
TargetInventoryDaysofSupply | number | Searchable |
TaxCode | text · max 50 | Searchable |
TaxableFlag | yes/no · max 1 · default false | Searchable |
Template | text | Searchable |
TemplateId | number | |
Text | text · max 1000 | Read-onlySearchable |
TextIndexItemId | number | Read-onlySearchable |
TrackInstalledBaseFlag | yes/no | |
TrackingQuantityId | text · max 30 · default P | Searchable |
TrackingUnitofMeasure | text | Searchable |
TradeItemDescriptor | text · max 35 | Searchable |
TransactionConversionValue | text | Searchable |
TransactionEnabledFlag | yes/no · max 1 · default false | Searchable |
UNNumberId | number | Searchable |
UNNumberValue | text | Searchable |
UOMPricingValue | text | Searchable |
UnderCompletionToleranceTypeValue | text | Searchable |
UnderCompletionToleranceValue | number | Searchable |
UnderReturnTolerance | number | Searchable |
UnderShipmentTolerance | number | Searchable |
UnitHeightQuantity | number | Searchable |
UnitLengthQuantity | number | Searchable |
UnitOfIssue | text · max 25 | Searchable |
UnitOfIssueValue | text | Searchable |
UnitVolumeQuantity | number | Searchable |
UnitWeightQuantity | number | Searchable |
UnitWidthQuantity | number | Searchable |
UseApprovedSupplierFlag | yes/no · max 1 · default false | Searchable |
UserItemTypeValue | text | Searchable |
VMIFixedOrderQuantity | number | Searchable |
VMIForecastType | number · default 1 | Searchable |
VariableLeadTime | number | Searchable |
VehicleItemFlag | yes/no · max 1 | Searchable |
Version | text | Read-only |
VersionAsOfDate | date-time | Searchable |
VersionDescription | text | Read-only |
VersionEnableFlagAtICC | text | |
VersionEndDate | date-time | Searchable |
VersionId | number · default -1 | Searchable |
VersionPlannedEffectiveDateTime | date-time | |
VersionStartDate | date-time | Searchable |
VersionStatus | text | Read-only |
VolumeUOMCode | text · max 3 | Searchable |
VolumeUOMValue | text | Searchable |
WIPSupplyLocatorValue | text | |
WIPSupplySubinventory | text · max 10 | Searchable |
WIPSupplySubinventoryValue | text | Searchable |
WIPSupplyType | number · default 1 | Searchable |
WIPSupplyTypeValue | text | Searchable |
WarehouseEquipmentFlag | yes/no · default false | Searchable |
WebStatus | text · max 30 · default UNPUBLISHED | Searchable |
WebStatusValue | text | Searchable |
WeightUOMCode | text · max 3 | Searchable |
WeightUOMValue | text | Searchable |
WhUpdateDate | date | Searchable |
WipSupplyLocatorId | number | Searchable |
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 4
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/items/{itemsUniqID}/child/<name>. Add them to a GET with expand.
ItemEffCategoryFields depend on your pod's flexfield setup (check
/describe).ItemRevisionGET Item Revisions · 34 fields · 1 findersAltRevisionCodeAttachmentEntityNameChangeLineIdContextChangeLineIdContextDateContextVersionIdCopyAttachmentsCopyDocumentsCreatedByCreationDateTimeEffectivityDateEndEffectivityDateImplementationDateInvItemIdCharInventoryItemIdItemIdItemRevisionDescriptionLastUpdateDateTimeLastUpdateLoginLastUpdatedByObjectVersionNumberObjectVersionNumber1OrgIdCharOrganizationIdOrganizationId1RequestIdRevisionCodeRevisionExtensibleFlexfieldCategoryCodeRevisionIdRevisionIdCharRevisionReasonRevisionReasonValueVersionAsOfDateVersionIdItemSupplierAssociationFields depend on your pod's flexfield setup (check
/describe).ItemSupplierEffCategoryFields depend on your pod's flexfield setup (check
/describe).
Actions 2
POST …/action/addItemsToDeleteGroup·deleteGroupNameitemsInfoPOST …/action/addSupplierAssociationsToDeleteGroup·deleteGroupNamesupplierAssociationsInfo
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/itemsand 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:ATOForecastControl, notatoforecastcontrol. 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.