Product Change Orders Version 2
productChangeOrdersV2 Based on 26C
Create, change and look up Product Change Orders Version 2, with change order affected object, change order next statuses and change order participants.
The record key productChangeOrdersV2UniqID 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)5 actions
- Record key
productChangeOrdersV2UniqID- Required on create
ChangeNameChangeNoticeChangeTypeIdOrganizationId- At a glance
- 56 fields0 finders23 children1 file/large text fields
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/productChangeOrdersV2?fields=ApprovalDateTime,ApprovalRequestDateTime,ApprovalStatus,ApprovalStatusValue,AssignedTo&limit=25&onlyData=true
{
"items": [
{
"ApprovalDateTime": "2026-01-31T09:00:00+00:00",
"ApprovalRequestDateTime": "2026-01-31T09:00:00+00:00",
"ApprovalStatus": 0,
"ApprovalStatusValue": "<string>",
"AssignedTo": "<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 56
| Attribute | Type | Use |
|---|---|---|
ApprovalDateTime | date-time | Read-onlySearchable |
ApprovalRequestDateTime | date-time | Read-onlySearchable |
ApprovalStatus | number | Read-onlySearchable |
ApprovalStatusValue | text | Read-onlySearchable |
AssignedTo | text | Optional on createUpdatableSearchable |
AssignedToRole | text | Optional on createUpdatableSearchable |
AssigneeId | text · max 100 | Optional on createUpdatableSearchable |
CancellationDateTime | date-time | Read-onlySearchable |
CategoryCode | text | Optional on createUpdatable |
ChangeId | number | Read-onlySearchable |
ChangeName | text · max 240 | Required on createUpdatableSearchable |
ChangeNotice | text · max 50 | Required on createSearchable |
ChangeTypeId | number | Required on createSearchable |
ChangeTypeNameValue | text · max 255 | Optional on create |
ChangeTypeValue | text · max 255 | Optional on createSearchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreationDateTime | date-time | Read-onlySearchable |
CustomerAccountNumber | text · max 255 | Optional on createUpdatableSearchable |
CustomerId | number | Optional on createUpdatableSearchable |
CustomerName | text · max 360 | Optional on createUpdatableSearchable |
Description | text · max 2000 | Optional on createUpdatableSearchable |
EffectiveImmediatelyFlag | yes/no · max 5 | Read-onlySearchable |
EffectivityIncrementDays | number | Read-onlySearchable |
FormattedDescription | text | Optional on createUpdatableSearchable |
ImplementationDateTime | date-time | Read-onlySearchable |
InitiationDateTime | date-time | Read-onlySearchable |
LastUpdateDateTime | date-time | Read-onlySearchable |
LastUpdateLogin | text · max 32 | Read-onlySearchable |
LastUpdatedBy | text · max 64 | Read-onlySearchable |
ManufacturerId | number | Optional on createUpdatableSearchable |
ManufacturerName | text · max 360 | Optional on createUpdatableSearchable |
ManufacturerRegistryId | text · max 255 | Optional on createUpdatableSearchable |
NeedByDateTime | date-time | Optional on createUpdatableSearchable |
OrganizationCode | text · max 255 | Optional on createSearchable |
OrganizationId | number | Required on createSearchable |
PriorityCode | text · max 30 | Optional on createUpdatableSearchable |
PriorityCodeValue | text · max 255 | Optional on createUpdatableSearchable |
ReasonCode | text · max 30 | Optional on createUpdatableSearchable |
ReasonCodeValue | text · max 255 | Optional on createUpdatableSearchable |
ReportedBy | text · max 64 | Optional on createUpdatableSearchable |
ReportedByUser | text · max 255 | Optional on createUpdatableSearchable |
ReportedDate | date-time | Optional on createUpdatableSearchable |
RequestedBy | text | Optional on createUpdatableSearchable |
RequestorId | text · max 100 | Optional on createUpdatableSearchable |
SourceCode | text · max 30 | Optional on createUpdatableSearchable |
SourceName | text · max 255 | Optional on createUpdatableSearchable |
StatusCode | number · default 0 | Optional on createUpdatableSearchable |
StatusCodeValue | text | Optional on createUpdatableSearchable |
StatusComments | text · max 4000 | Optional on createUpdatableSearchable |
StatusType | number · default 0 | Optional on createUpdatableSearchable |
StatusTypeValue | text | Optional on createUpdatableSearchable |
SupplierId | number | Optional on createUpdatableSearchable |
SupplierName | text · max 360 | Optional on createUpdatableSearchable |
SupplierNumber | text · max 255 | Optional on createUpdatableSearchable |
SupplierSiteCode | text · max 255 | Optional on createUpdatableSearchable |
SupplierSiteId | number | 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.
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 23
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/productChangeOrdersV2/{productChangeOrdersV2UniqID}/child/<name>. Add them to a GET with expand.
changeOrderAffectedObjectGET · POST · PATCH · DELETE Change Order Affected Objects · 14 fieldsCancelationDateTimeChangeLineIdEffectivityOnApprovalFlagImplementationDateTimeItemIdItemNumberNewItemRevisionNewRevisionReasonOldRevisionOldRevisionIdScheduledDateTimeSequenceNumberStatusCodeValueStatusTypeValuechangeOrderAffectedItemGET · PATCH Change Order Affected Items · 52 fields · 3 findersACDTypeCodeApprovalStatusApprovalStatusValueAssetTrackedValueBuyerEmailAddressCategoryCodeChangeLineIdCommonSupplyProjectDemandFlagCommsActivationRequiredFlagCreateFixedAssetValueCreateSupplyAfterDateCreatedByCreationDateTimeCriticalComponentFlagCurrentPhaseCodeDefaultRepairTransactionNameEligibilityRuleFlagEnableIotFlagEnforceShipToLocationValueExpenditureTypeValueForcePurchaseLeadTimeFlagHardPeggingLevelValueImplementationDateTimeInventoryItemStatusCodeIssueUOMValueItemClassItemDescriptionItemIdItemNumberItemStatusValueItemTypeLastUpdateDateTimeLastUpdateLoginLastUpdatedByLifecyclePhaseValueOrderModifierStartQuantityFlagPackagingStringValuePartsSourcingValuePricingUOMValuePrimaryUOMCodePrimaryUOMValueQuantityReceivedTolerancePercentageReplacementTypeValueReplenishmentSourceTypeValueRequiresFulfillmentLocationFlagSalesProductTypeValueSecondaryUOMValueStandardCoverageValueTrackingUOMValueUnderCompletionToleranceTypeValueUnderCompletionToleranceValueUserItemTypeValueItemEffCategoryGET · POST · PATCH · DELETE Item Extensible Flexfields · 1 findersFields depend on your pod's flexfield setup (check
/describe).changeOrderAffectedItemAMLGET · POST · PATCH · DELETE Change Order Affected Item Approved Manufacturers Lists · 22 fields · 1 findersACDTypeCodeACDTypeValueActiveEndDateTimeActiveStartDateTimeChangeLineIdCreatedByCreationDateTimeDescriptionImplementationDateTimeInventoryItemIdItemNumberItemRelationshipIdLastUpdateDateTimeLastUpdateLoginLastUpdatedByOrganizationCodeOrganizationIdStatusCodeStatusCodeValueTradingPartnerItemTradingPartnerItemIdTradingPartnerNamechangeOrderAffectedItemAMLDFFGET · POST · PATCH Descriptive Flexfields · 4 fieldsItemRelationshipIdItemRelationshipType__FLEX_Context__FLEX_Context_DisplayValuechangeOrderAffectedItemAttachmentGET · POST · PATCH · DELETE Change Order Affected Item Attachments · 13 fields · 2 findersCategoryCodeDatatypeCodeDescriptionDmDocumentIdDmVersionNumberDownloadInfoFileNameLastUpdateDateLastUpdatedByTitleUploadedFileLengthUploadedTextUrlchangeOrderAffectedItemStructureGET Change Order Affected Item Structures · 10 fields · 1 findersAlternateBomDesignatorBillSequenceIdChangeIdCommonBillSequenceIdCommonOrganizationCodeCommonOrganizationIdCreationDateTimeEffectivityControlLastUpdateDateTimeSourceBillSequenceIdaffectedItemStructureComponentGET · POST · PATCH · DELETE Change Order Affected Item Structure Components · 42 fieldsACDTypeCodeAbsoluteYieldAlternateBOMDesignatorBillSequenceIdChangeIdChangeLineIdChangeNoticeCompAlternateBomDesignatorCompletionTypeCompletionTypeValueComponentItemClassComponentItemIdComponentItemNumberComponentItemStructureNameComponentQuantityComponentRemarksComponentSequenceIdComponentTypeComponentTypeValueComponentYieldFactorContributeToYieldContributeToYieldValueCreationDateTimeDisableDateTimeEffectivityDateTimeFindNumberImplementationDateTimeItemSequenceNumberLastUpdateDateTimeOldComponentSequenceIdOrganizationCodeOrganizationIdPrimaryUOMValuePrimaryUomCodeProductTypeProductTypeValueQuantityRelatedFlagReplacedByReplacedByFindNumberReplacesSuggestedOperationSequenceUsePlaceholderFlagaffectedItemReferenceDesignatorGET · POST · PATCH · DELETE Change Order Affected Item Reference Designators · 9 fieldsACDTypeACDTypeValueChangeLineIdChangeNoticeCreationDateTimeDescriptionLastUpdateDateTimeReferenceDesignatorReferenceDesignatorSequenceIdaffectedItemReferenceDesignatorDFFGET · POST · PATCH Change Order Affected Item Reference Designator Descriptive Flexfields · 3 fieldsRefDesigSequenceId__FLEX_Context__FLEX_Context_DisplayValueaffectedItemStructureComponentDFFGET · POST · PATCH Change Order Affected Item Structure Component Descriptive Flexfields · 3 fieldsComponentSequenceId__FLEX_Context__FLEX_Context_DisplayValueaffectedItemSubstituteComponentGET · POST · PATCH · DELETE Change Order Affected Item Substitute Components · 11 fieldsACDTypeACDTypeValueCreationDateTimeEnforceIntegerRequirementsValueLastUpdateDateTimePrimaryUOMValuePriorityQuantitySubstituteComponentIdSubstituteComponentItemNumberSubstituteComponentSequenceIdaffectedItemSubstituteComponentDFFGET · POST · PATCH Change Order Affected Item Substitute Component Descriptive Flexfields · 3 fieldsSubCompSequenceId__FLEX_Context__FLEX_Context_DisplayValuechangeOrderAffectedObjectDFFGET · POST · PATCH Change Line Descriptive Flexfields · 4 fieldsChangeLineIdSubjectInternalName__FLEX_Context__FLEX_Context_DisplayValuechangeOrderAttachmentsGET · POST · PATCH · DELETE Change Order Attachments · 33 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileCheckedOutByContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDataTypeNameDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDocumentPreviewURLDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlLastUpdateDateLastUpdatedByLastUpdatedByUserNameTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNamechangeOrderDFFGET · POST · PATCH Change Object Descriptive Flexfields · 3 fieldsBaseChangeMgmtTypeCodeChangeId__FLEX_ContextchangeOrderEFFGET · POST · PATCH · DELETE Change Object Extensible FlexfieldsFields depend on your pod's flexfield setup (check
/describe).changeOrderNextStatusesGET Change Order Next Statuses · 5 fields · 2 findersSequenceNumberStatusCodeStatusCodeNameStatusTypeStatusTypeNamechangeOrderParticipantsGET · POST · DELETE Change Order Participants · 15 fieldsActivityTypeCodeActivityTypeValueAssigneeNameAssigneeTypeCodeAssigneeTypeValueCommentsOriginalRoleAssigneeReassignedTimeReassignedToResponseCodeResponseRequiredFromResponseRequiredFromValueResponseValueStatusCodeStatusCodeValuechangeOrderRelationshipsGET · POST · PATCH · DELETE Change Order Relationships · 15 fieldsChangeNoticeCreatedByCreationDateTimeDescriptionDestinationObjectIdDestinationObjectTypeLastUpdateDateTimeLastUpdatedByLatestFlagNameRelationshipIdRelationshipTypeSourceObjectIdSourceObjectTypeStatusrelationshipRulesGET · POST · PATCH · DELETE Change Order Relationship Rules · 14 fieldsCreatedByCreationDateDestinationObjectIDDestinationObjectNumberDestinationObjectTypeDestinationRuleStatusLastUpdateDateLastUpdatedByRelationshipIdRelationshipRuleIdSourceObjectIdSourceObjectNumberSourceObjectTypeSourceRuleStatuschangeOrderTasksGET · POST · PATCH · DELETE Change Order Tasks · 15 fieldsAssignedByAssignedDateAssignedToCompleteBeforeStatusCodeCompleteBeforeStatusCodeValueDescriptionNameNeedByDateTimeRequiredFlagSequenceNumberStartAfterStatusCodeStartAfterStatusCodeValueStatusCodeStatusCodeValueTaskIdchangeOrderTeamGET · POST · PATCH · DELETE Change Order Team · 2 fieldsGranteeNameGranteeType
Actions 5
POST …/{productChangeOrdersV2UniqID}/child/changeOrderAttachments/{changeOrderAttachmentsUniqID}/action/cancelCheckOutPOST …/{productChangeOrdersV2UniqID}/child/changeOrderAttachments/{changeOrderAttachmentsUniqID}/action/checkIn·fileNamefiletitlecontentTypePOST …/{productChangeOrdersV2UniqID}/child/changeOrderAttachments/{changeOrderAttachmentsUniqID}/action/checkOutPOST …/{productChangeOrdersV2UniqID}/child/changeOrderAttachments/{changeOrderAttachmentsUniqID}/action/fetchVersionsPOST …/{productChangeOrdersV2UniqID}/child/changeOrderAttachments/{changeOrderAttachmentsUniqID}/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/productChangeOrdersV2and 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:AssignedTo, notassignedto. - 15 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.