Update a Manufacturer Extensible Flexfield Using Manufacturers API
You can use the manufacturers REST API to get and update manufacturer extensible flexfields for any manufacturer.
Note:
It's recommend to limit the number of objects and or updates less than 50 per transaction.Let's take this scenario:
A company needs to define what Environment, Social, and Governance (ESG) Scores their manufacturers obtain. To do this, the product data steward needs to get the Manufacturer and has to gather details of each ESG category. Let's see how they would use the REST resource to do that.
- Manufacturer Name: MFC0991
- Attribute Group: ESG Score
- Attributes: Environmental Impact, Social Responsibility and Governance Practices
Take these steps:
- Get the manufacturer ID of the manufacturer using the manufacturer name.
- Get the manufacturer extensible flexfield self-link for the manufacturer.
- Get the description of the manufacturer extensible flexfield attribute Group Context ESG score for the manufacturer to get the attribute names.
- Update the manufacturer extensible flexfield attribute Environment Impact and Social Responsibility value for the manufacturer.
GET Manufacturer ID Using the Manufacturer Name
Example URL
Use this resource URL format:
GET
curl -u username:password "https://servername/fscmRestApi/resources/version/manufacturers?q=OrganizationName=MFC0991"
Example Response
{ "items": [ { "OrganizationName": "MFC0991", "Comments": "MFC0991", "RegistryId": "CDRM_951264", "DUNSNumber": "MFC0991", "Status": "A", "CreatedBy": "PIMQA", "CreationDate": "2023-12-15T12:51:30+00:00", "IsActiveFlag": null, "IsPrivateFlag": null, "LastUpdatedBy": "PIMQA", "LastUpdateDate": "2023-12-15T12:56:32.255+00:00", "ManufacturerId": 300100590916996, "PartyType": "ORGANIZATION", "Address1": "Oracle Parkway", "Address2": "Thames Valley Park", "Country": "GB", "CountryName": null, "StateName": null, "County": null, "City": "Reading", "State": "Berkshire", "PostalCode": "RG6 1RA", "PrimaryPhoneNumber": null, "PrimaryPhoneExtension": null, "Province": null, "Address3": null, "Address4": null, "AddressElementAttribute1": null, "AddressElementAttribute2": null, "AddressElementAttribute3": null, "AddressElementAttribute4": null, "AddressElementAttribute5": null, "AddressStyle": "POSTAL_ADDR_GB", "Building": null, "FloorNumber": null, "HouseType": null, "PostalPlus4Code": null, "CategoryCode": "ALL_MANUFACTURERS", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588", "name": "manufacturers", "kind": "item", "properties": { "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000057704000000057372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000047371007E0004000000017371007E0004000000047371007E00040000000278" } }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588", "name": "manufacturers", "kind": "item" }, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/Attachments", "name": "Attachments", "kind": "collection" }, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF", "name": "manufacturerEFF", "kind": "collection" } ] } ], "count": 1, "hasMore": false, "limit": 25, "offset": 0, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/manufacturers", "name": "manufacturers", "kind": "collection" } ] }
GET Manufacturer Extensible Flexfield Self-Link for the Manufacturer
Example URL
Use this resource URL format:
GET
curl -u username:password "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF"
Example Response
{ "items": [ { "CreatedBy": "PIMQA", "CreationDate": "2023-12-15T12:51:35.147+00:00", "LastUpdateDate": "2023-12-15T12:52:04.169+00:00", "LastUpdatedBy": "PIMQA", "CategoryCode": "ALL_MANUFACTURERS", "ManufacturerId": "300100590916996", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF/300100590916996", "name": "manufacturerEFF", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF/300100590916996", "name": "manufacturerEFF", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588", "name": "manufacturers", "kind": "item" }, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF/300100590916996/child/ESGscore", "name": "ESGscore", "kind": "collection" }, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF/300100590916996/child/Testcontext", "name": "Testcontext", "kind": "collection" } ] } ], "count": 1, "hasMore": false, "limit": 25, "offset": 0, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF", "name": "manufacturerEFF", "kind": "collection" } ] }
GET the Description of the Manufacturer Extensible Flexfield Attribute Group Context ESGscore
You must do a describe to get the attribute details of Environment Impact, Social Responsibility and so on. These details are required to perform Create or Update operations on certain attributes.
You can get the details of different manufacturer extensible flexfields in the context ESGscore. After getting the names of the extensible flexfields, you can create or update the extensible flexfields.
Example URL:
Example URL
Use this resource URL format:
GET
curl -u username:password "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF/300100590916996/child/ESGscore/describe"
Example Response
{ "Resources" : { "ESGscore" : { "discrColumnType" : true, "properties" : { "FND_ACFF_ApplicationID" : "10011", "FND_ACFF_ApplicationShortName" : "EGP", "FND_ACFF_Delimiter" : "-", "FND_ACFF_ModelID" : "EFF_EGP_EGO_5FMANUFACTURER_5FEFF_EGO_5FMANUFACTURER_5FDL_EGO_5FMANUFACTURER_5FEFF_5FB", "FND_ACFF_Title" : "Manufacturer Extended Attributes", "FND_ACFF_Type" : "EFF" }, "attributes" : [ { "name" : "CategoryCode", "type" : "string", "updatable" : true, "mandatory" : true, "inputRequired" : true, "queryable" : true, "allowChanges" : "always", "precision" : 800, "maxLength" : "800", "properties" : { "DISPLAYHINT" : "Hide" } }, { "name" : "ContextCode", "type" : "string", "updatable" : true, "mandatory" : true, "queryable" : true, "allowChanges" : "always", "precision" : 80, "defaultValue" : "ESG Score", "maxLength" : "80", "properties" : { "DISPLAYHINT" : "Hide" } }, { "name" : "CreatedBy", "type" : "string", "updatable" : true, "mandatory" : true, "queryable" : true, "allowChanges" : "inCreate", "precision" : 64, "maxLength" : "64", "properties" : { "DISPLAYHINT" : "Hide" } }, { "name" : "CreationDate", "type" : "datetime", "updatable" : true, "mandatory" : true, "queryable" : true, "allowChanges" : "inCreate", "properties" : { "DISPLAYHINT" : "Hide" } }, { "name" : "EffLineId", "type" : "integer", "updatable" : true, "mandatory" : true, "queryable" : true, "allowChanges" : "always", "precision" : 18, "hasDefaultValueExpression" : true, "includeInCompactView" : true, "properties" : { "DISPLAYHINT" : "Hide", "fnd:GLOBALLY_UNIQUE" : "true" } }, { "name" : "LastUpdateDate", "type" : "datetime", "updatable" : true, "mandatory" : true, "queryable" : true, "allowChanges" : "always", "properties" : { "DISPLAYHINT" : "Hide" } }, { "name" : "LastUpdatedBy", "type" : "string", "updatable" : true, "mandatory" : true, "queryable" : true, "allowChanges" : "always", "precision" : 64, "maxLength" : "64", "properties" : { "DISPLAYHINT" : "Hide" } }, { "name" : "ObjectVersionNumber", "type" : "integer", "updatable" : true, "mandatory" : true, "queryable" : true, "allowChanges" : "always", "precision" : 9, "properties" : { "DISPLAYHINT" : "Hide" } }, { "name" : "ManufacturerId", "type" : "integer", "updatable" : true, "mandatory" : true, "inputRequired" : true, "queryable" : true, "allowChanges" : "always", "precision" : 18, "properties" : { "DISPLAYHINT" : "Hide" } }, { "name" : "environmentImpact", "type" : "string", "updatable" : true, "mandatory" : false, "queryable" : true, "allowChanges" : "always", "precision" : 4000, "title" : "Environmental Impact", "includeInCompactView" : true, "maxLength" : "4000", "properties" : { "DISPLAYWIDTH" : "28", "FND_ACFF_BI_Disabled" : "Y", "FND_ACFF_EFF_CONTEXT_SEGMENT_CODE" : "EI", "FND_ACFF_EFF_INDEXED_FLAG" : "N", "FND_ACFF_EFF_SEGMENT_ATTRIBUTE" : "true", "FND_ACFF_JavaType" : "java.lang.String", "FND_ACFF_MaximumLength" : "10", "FND_ACFF_MaximumValue" : "10", "FND_ACFF_OpenIdentifier" : "environmentImpact", "FND_ACFF_PreferredDisplayType" : "TEXT_BOX", "FND_ACFF_SegmentName" : "EI", "FND_ACFF_ValueSetInfo" : "10 Characters#FORMAT_ONLY", "TOOLTIP" : "Environmental Impact" } }, { "name" : "socialResponsibility", "type" : "integer", "updatable" : true, "mandatory" : false, "queryable" : true, "allowChanges" : "always", "precision" : 10, "title" : "Social Responsibility", "includeInCompactView" : true, "properties" : { "FND_ACFF_BI_Disabled" : "Y", "FND_ACFF_EFF_CONTEXT_SEGMENT_CODE" : "SR", "FND_ACFF_EFF_INDEXED_FLAG" : "N", "FND_ACFF_EFF_SEGMENT_ATTRIBUTE" : "true", "FND_ACFF_EFF_SEGMENT_SCALE" : "0", "FND_ACFF_JavaType" : "java.math.BigDecimal", "FND_ACFF_MaximumValue" : "9999999999", "FND_ACFF_MinimumValue" : "0", "FND_ACFF_OpenIdentifier" : "socialResponsibility", "FND_ACFF_Precision" : "10", "FND_ACFF_PreferredDisplayType" : "TEXT_BOX", "FND_ACFF_Scale" : "0", "FND_ACFF_SegmentName" : "SR", "FND_ACFF_ValueSetInfo" : "10/Number#FORMAT_ONLY", "TOOLTIP" : "Social Responsibility" } }, { "name" : "governancePractices", "type" : "string", "updatable" : true, "mandatory" : false, "queryable" : true, "allowChanges" : "always", "precision" : 4000, "title" : "Governance Practices", "includeInCompactView" : true, "maxLength" : "4000", "properties" : { "DISPLAYWIDTH" : "28", "FND_ACFF_BI_Disabled" : "Y", "FND_ACFF_EFF_CONTEXT_SEGMENT_CODE" : "GP", "FND_ACFF_EFF_INDEXED_FLAG" : "N", "FND_ACFF_EFF_SEGMENT_ATTRIBUTE" : "true", "FND_ACFF_JavaType" : "java.lang.String", "FND_ACFF_MaximumLength" : "3", "FND_ACFF_OpenIdentifier" : "governancePractices", "FND_ACFF_PreferredDisplayType" : "TEXT_BOX", "FND_ACFF_SegmentName" : "GP", "FND_ACFF_ValueSetInfo" : "3 Characters#FORMAT_ONLY", "TOOLTIP" : "Governance Practices" } } ], "collection" : { "rangeSize" : 25, "finders" : [ { "name" : "EFF_ALT_KEY", "attributes" : [ { "name" : "ContextCode", "type" : "string", "updatable" : true, "mandatory" : true, "queryable" : true, "allowChanges" : "always", "precision" : 80, "defaultValue" : "ESG Score", "maxLength" : "80", "properties" : { "DISPLAYHINT" : "Hide" } }, { "name" : "ManufacturerId", "type" : "integer", "updatable" : true, "mandatory" : true, "inputRequired" : true, "queryable" : true, "allowChanges" : "always", "precision" : 18, "properties" : { "DISPLAYHINT" : "Hide" } } ] }, { "name" : "PrimaryKey", "attributes" : [ { "name" : "EffLineId", "type" : "integer", "updatable" : true, "mandatory" : true, "queryable" : true, "allowChanges" : "always", "precision" : 18, "hasDefaultValueExpression" : true, "includeInCompactView" : true, "properties" : { "DISPLAYHINT" : "Hide", "fnd:GLOBALLY_UNIQUE" : "true" } } ] } ], "links" : [ { "rel" : "self", "href" : "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF/300100590916996/child/ESGscore", "name" : "self", "kind" : "collection" } ], "actions" : [ { "name" : "get", "method" : "GET", "responseType" : [ "application/vnd.oracle.adf.resourcecollection+json", "application/json" ] }, { "name" : "create", "method" : "POST", "requestType" : [ "application/vnd.oracle.adf.resourceitem+json", "application/json" ], "responseType" : [ "application/vnd.oracle.adf.resourceitem+json", "application/json" ] }, { "name" : "upsert", "method" : "POST", "header" : "Upsert-Mode=true", "requestType" : [ "application/vnd.oracle.adf.resourceitem+json", "application/json" ], "responseType" : [ "application/vnd.oracle.adf.resourceitem+json", "application/json" ] } ] }, "item" : { "links" : [ { "rel" : "self", "href" : "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF/300100590916996/child/ESGscore/{id}", "name" : "self", "kind" : "item" }, { "rel" : "parent", "href" : "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF/300100590916996", "name" : "parent", "kind" : "item" }, { "rel" : "canonical", "href" : "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF/300100590916996/child/ESGscore/{id}", "name" : "canonical", "kind" : "item" } ], "actions" : [ { "name" : "get", "method" : "GET", "responseType" : [ "application/vnd.oracle.adf.resourceitem+json", "application/json" ] }, { "name" : "update", "method" : "PATCH", "requestType" : [ "application/vnd.oracle.adf.resourceitem+json", "application/json" ], "responseType" : [ "application/vnd.oracle.adf.resourceitem+json", "application/json" ] }, { "name" : "delete", "method" : "DELETE" } ] }, "links" : [ { "rel" : "self", "href" : "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF/300100590916996/child/ESGscore/describe", "name" : "self", "kind" : "describe" }, { "rel" : "canonical", "href" : "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF/300100590916996/child/ESGscore/describe", "name" : "canonical", "kind" : "describe" } ] } } }
Update the Manufacturer Extensible Flexfield Attributes Environment Impact and Social Responsibility Values
Example URL
Use this resource URL format:
UPDATE
curl -X PATCH -u "username:password" -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" -d 'request payload' "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF/300100590916996/child/ESGscore"
Example Request
Here's an example of the request body in JSON format:
{ "environmentImpact": "70", "socialResponsibility": "60" }
Example Response
Here's an example of the response body in JSON format:
{ "CategoryCode": "ALL_MANUFACTURERS", "ContextCode": "ESG Score", "CreatedBy": "PIMQA", "CreationDate": "2023-12-15T17:39:36+00:00", "EffLineId": 300100590919301, "LastUpdateDate": "2023-12-15T17:39:36.288+00:00", "LastUpdatedBy": "PIMQA", "ObjectVersionNumber": 1, "ManufacturerId": 300100590916996, "environmentImpact": "70", "socialResponsibility": "60", "governancePractices": null, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF/300100590916996/child/ESGscore/300100590919301", "name": "ESGscore", "kind": "item", "properties": { "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178" } }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF/300100590916996/child/ESGscore/300100590919301", "name": "ESGscore", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/manufacturers/00050000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E55850000000EACED00057708000110F09D1E55840000000EACED00057708000110F09D1E5588/child/manufacturerEFF/300100590916996", "name": "manufacturerEFF", "kind": "item" } ] }