Flexfields Metadata
productManagementFlexfieldsMetadata Based on 26C
Look up Flexfields Metadata, with attribute group metadata. Actions include generate json flexfields metadata and get flexfield metadata. Changes only through its actions.
The record key productManagementFlexfieldsMetadataUniqID 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
productManagementFlexfieldsMetadataUniqID- Required on create
- no create on this resource
- At a glance
- 8 fields3 finders3 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/productManagementFlexfieldsMetadata?fields=ContextCategoryCode,ContextCode,DescriptiveFlexfieldCode,FlexfieldUsageCode,PageCategoryCode&limit=25&onlyData=true
{
"items": [
{
"ContextCategoryCode": "<string, max 255>",
"ContextCode": "<string, max 80>",
"DescriptiveFlexfieldCode": "<string, max 40>",
"FlexfieldUsageCode": "<string, max 30>",
"PageCategoryCode": "<string, max 800>"
}
],
"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 8
| Attribute | Type | Use |
|---|---|---|
ContextCategoryCode | text · max 255 | Read-onlySearchable |
ContextCode | text · max 80 | Read-onlySearchable |
DescriptiveFlexfieldCode | text · max 40 | Read-onlySearchable |
FlexfieldUsageCode | text · max 30 | Read-onlySearchable |
PageCategoryCode | text · max 800 | Read-onlySearchable |
PageCode | text · max 30 | Read-onlySearchable |
PageId | number | Read-onlySearchable |
SequenceNumber | 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.
Finders 3
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
ChangeMandatoryAttributesFinder·ItemClassCodeItemMandatoryAttributesFinder·ItemClassCodeManufacturerMandatoryAttributesFinder·ItemClassCode
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/productManagementFlexfieldsMetadata/{productManagementFlexfieldsMetadataUniqID}/child/<name>. Add them to a GET with expand.
AttributeGroupMetadataGET Attribute Groups Metadata · 27 fieldsAdvancedQbeFlagApiNameCExtensionAttribute2CExtensionAttribute3CExtensionAttribute4CExtensionAttribute5ContextCodeContextDescriptionContextIdentifierContextNameContextUniqueIdCreatedByEditPrivilegeNameEnabledFlagFlexfieldUsageCodeInstructionHelpTextLastUpdateDateLastUpdateLoginLastUpdatedByMasterToChildOrganizationMultirowFlagProtectedFlagRWDEffLayoutStyleToSkuTranslatableFlagVariantAttributeViewPrivilegeNameAttributesMetadataGET Attributes Metadata · 44 fieldsApplicationIdBiEnabledFlagBiEqualizationTagCExtensionAttribute1CExtensionAttribute2CExtensionAttribute3CExtensionAttribute4CExtensionAttribute5CheckboxCheckedValueCheckboxUncheckedValueColumnNameCreatedByCreationDateDefaultTypeDefaultValueDerivationValueDescriptiveFlexfieldCodeDisplayHeightDisplayTypeDisplayWidthDynamicUrlEnabledFlagInFieldHelpTextIndexedFlagLastUpdateDateLastUpdateLoginLastUpdatedByMultirowUniqueKeyFlagPromptRangeTypeReadOnlyFlagRequiredFlagSegmentCodeSegmentDescriptionSegmentIdentifierSegmentNameSegmentUniqueIdSequenceNumberShortPromptShowValueDescriptionFlagTerminologyHelpTextUomClassCodeUomClassIdValueSetIdValueSetMetadataGET Value Sets Metadata · 27 fieldsCreatedByCreationDateDataSecurityObjectNameDescriptionHybridSearchEnabledIndependentValueSetIdLastUpdateDateLastUpdateLoginLastUpdatedByMaximumLengthMaximumValueMinimumValueModuleIdPrecisionProtectedFlagScaleSecurityEnabledFlagTableValueSetWhereClauseUppercaseOnlyFlagValidationTypeValueDataTypeValueSetCodeValueSetDiscriminatorValueSetIdValueSetIdentifierValueSubtypeZeroFillFlag
Actions 2
POST …/action/generateJsonFlexfieldsMetadata·effCodePOST …/action/getFlexfieldMetadata·itemClassCodeeffCodepageCode
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/productManagementFlexfieldsMetadataand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
ChangeMandatoryAttributesFinderfor 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:ContextCategoryCode, notcontextcategorycode. onlyData=trueremoveslinks, and this resource's key only comes fromlinks. Leave it off when you need the key.- A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through.