1. REST API for Oracle Supply Chain Management Cloud
  2. Tasks
  3. Inventory Management
  4. Physical Inventories

Create inventories

post

/fscmRestApi/resources/11.13.18.05/physicalInventories

Request

Header Parameters
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
  • Contains one of the following values: true or false. If true, the server performs an Upsert operation instead of a Create operation. During an Upsert operation, the server attempts to find an existing resource that matches the payload. If a match is found, the server updates the existing resource instead of creating a new one. If not found or false (default), the server performs a Create operation. Note that the Upsert operation isn't supported for date-effective REST resources.
Supported Media Types
Request Body - application/json ()
Root Schema : schema
Type: object
Show Source
  • Value that indicates whether all or specific subinventories must be included in the physical inventory. A list of accepted values is defined in the lookup type INV_SUBINVENTORIES_FLAG. The default value is All.
  • Title: Subinventories to Count
    Maximum Length: 30
    Default Value: 1
    Value that indicates all or specific subinventories included in the physical inventory. A list of accepted values is defined in the lookup type INV_SUBINVENTORIES_FLAG. The default value is 1.
  • Value that indicates if the dynamic tag creation is permitted in the physical inventory. Contains one of the following values: Yes or No. If Yes, then dynamic tag creation is permitted. If No, then dynamic tag creation is not permitted. This attribute does not have a default value.
  • Title: Dynamic tags allowed
    Maximum Length: 30
    Value that indicates if the dynamic tag creation is permitted in the physical Inventory. Contains one of the following values: 1 or 2. If 1, then dynamic tag creation is permitted. If 2, then dynamic tag creation is not permitted. This attribute does not have a default value.
  • Value that indicates the level of approval required to post the physical inventory adjustments. A list of accepted values is defined in the lookup type INV_REQ_APPROVALS. This attribute does not have a default value.
  • Title: Approval Type
    Maximum Length: 30
    Value that indicates the level of approval required to post physical inventory adjustments. A list of accepted values is defined in the lookup type INV_REQ_APPROVALS. This attribute does not have a default value.
  • Title: Negative Quantity Tolerance Percentage
    Percent below the on-hand quantity that the adjustment transaction can vary. If the adjustment transaction exceeds the percent, then the adjustment transaction requires approval. For example, if Negative Quantity Tolerance Percentage is 10, and if the adjustment transaction requires an 11% negative adjustment to on-hand quantity, then the transaction requires approval.
  • Title: Positive Quantity Tolerance Percentage
    Percent above the on-hand quantity that the adjustment transaction can vary. If the adjustment transaction exceeds the percent, then the adjustment transaction requires approval. For example, if Positive Quantity Tolerance Percentage is 10, and if the adjustment transaction requires an 11% positive adjustment to on-hand quantity, then the transaction requires approval.
  • Title: Negative Adjustment Value Tolerance
    Total value of a physical inventory adjustment that is less than the current value of the item. The user specifies this limit.
  • Title: Positive Adjustment Value Tolerance
    Total value of a physical inventory adjustment that is greater than the current value of the item. The user specifies this limit.
  • Title: Description
    Maximum Length: 50
    Description of the physical inventory.
  • Value that indicates if the items with negative on-hand balances are excluded from physical counts. Contains one of the following values: Yes or No. If Yes, then items with negative on-hand balances are excluded from physical count. If No, then items with negative on-hand balances are not excluded from physical count. This attribute does not have a default value.
  • Title: Exclude negative balances
    Maximum Length: 30
    Value that indicates that items with negative on-hand balances are excluded from physical counts. Contains one of the following values: Y or N. If Y, then items with negative on-hand balances are excluded from physical count. If N, then items with negative on-hand balances are not excluded from physical count. This attribute does not have a default value.
  • Value that indicates that items with zero on-hand balances are excluded from physical counts. Contains one of the following values: Yes or No. If Yes, then items with negative on-hand balances are excluded from physical count. If No, then items with negative on-hand balances are not excluded from physical count. This attribute does not have a default value.
  • Title: Exclude zero balances
    Maximum Length: 30
    Value that indicates that items with zero on-hand balances are excluded from physical counts. Contains one of the following values: Y or N. If Y, then items with negative on-hand balances are excluded from physical count. If N, then items with negative on-hand balances are not excluded from physical count. This attribute does not have a default value.
  • Fifth user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. There is no default value for this attribute.
  • Title: Sequence 5
    Maximum Length: 30
    Abbreviation that identifies the fifth sequence that the user defines when the application creates the physical inventory tag.
  • First user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. This attribute does not have a default value.
  • Title: Sequence 1
    Maximum Length: 30
    Abbreviation that identifies the first sequence that the user defines when the application creates the physical inventory tag.
  • Fourth user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. This attribute does not have a default value.
  • Title: Sequence 4
    Maximum Length: 30
    Abbreviation that identifies the fourth sequence that the user defines when the application creates the physical inventory tag.
  • Title: Snapshot Date
    Date when the application no longer allows changes to inventory.
  • Title: Adjustment Date
    Date when the application most recently adjusted the transaction.
  • Title: Starting Default Tag
    Maximum Length: 40
    Next tag number in the sequence of tag numbers that the application creates for this physical inventory.
  • Title: Number of Blank Tags
    Number of empty tags to create.
  • Number of stock keeping units where the application no longer permits changes. These units reside in physical inventory.
  • Abbreviation that identifies the organization.
  • Value that uniquely identifies the organization.
  • Title: Date
    Date when the person physically counted the inventory.
  • Flexfields
    Title: Flexfields
    The Flexfields for Physical Inventories resource manages descriptive flexfields for physical inventories.
  • Value that uniquely identifies the physical inventory.
  • Title: Physical Inventory
    Maximum Length: 30
    Name of the physical inventory.
  • Subinventories
    Title: Subinventories
    The Physical Inventory Subinventories resource manages operations on physical inventory subinventories.
  • Second user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. This attribute does not have a default value.
  • Title: Sequence 2
    Maximum Length: 30
    Abbreviation that identifies the second sequence that the user defines when the application creates the physical inventory tag.
  • Seventh user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. There is no default value for this attribute.
  • Title: Sequence 7
    Maximum Length: 30
    Abbreviation that identifies the seventh sequence that the user defines when the application creates the physical inventory tag.
  • Value that indicates if the dynamic tag creation is permitted in the physical inventory. Contains one of the following values: Yes or No. If Yes, then serial numbers are displayed on physical inventory tags. If No, then serial numbers are not displayed on physical inventory tags. This attribute does not have a default value.
  • Title: Show serial numbers on tags
    Maximum Length: 1
    Value that indicates if the dynamic tag creation is permitted in the physical Inventory. Contains one of the following values: 1 or 2. If 1, then serial numbers are displayed on physical inventory tags. If 2, then serial numbers are not displayed on physical inventory tags. This attribute does not have a default value.
  • Sixth user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. There is no default value for this attribute.
  • Title: Sequence 6
    Maximum Length: 30
    Abbreviation that identifies the sixth sequence that the user defines when the application creates the physical inventory tag.
  • Title: Starting Blank Tag
    Maximum Length: 40
    Starting empty tag number or the next empty tag number to create.
  • Type of physical inventory tags generated when the generate tags action is started. A list of accepted values is defined in the lookup type INV_GENERATE_TAG_TYPE. This attribute does not have a default value.
  • Title: Tag Type
    Maximum Length: 30
    Value that indicates the types of physical inventory tags generated when the generate tags action is started. A list of accepted values is defined in the lookup type INV_GENERATE_TAG_TYPE. This attribute does not have a default value.
  • Third user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. This attribute does not have a default value.
  • Title: Sequence 3
    Maximum Length: 30
    Abbreviation that identifies the third sequence that the user defines when the application creates the physical inventory tag.
  • Total value of all adjustments in physical inventory.
Nested Schema : Flexfields
Type: array
Title: Flexfields
The Flexfields for Physical Inventories resource manages descriptive flexfields for physical inventories.
Show Source
Nested Schema : Subinventories
Type: array
Title: Subinventories
The Physical Inventory Subinventories resource manages operations on physical inventory subinventories.
Show Source
Nested Schema : schema
Type: object
Show Source
Nested Schema : schema
Type: object
Show Source
Back to Top

Response

Supported Media Types

Default Response

The following table describes the default response for this task.
Headers
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Body ()
Root Schema : physicalInventories-item-response
Type: object
Show Source
  • Value that indicates whether all or specific subinventories must be included in the physical inventory. A list of accepted values is defined in the lookup type INV_SUBINVENTORIES_FLAG. The default value is All.
  • Title: Subinventories to Count
    Maximum Length: 30
    Default Value: 1
    Value that indicates all or specific subinventories included in the physical inventory. A list of accepted values is defined in the lookup type INV_SUBINVENTORIES_FLAG. The default value is 1.
  • Value that indicates if the dynamic tag creation is permitted in the physical inventory. Contains one of the following values: Yes or No. If Yes, then dynamic tag creation is permitted. If No, then dynamic tag creation is not permitted. This attribute does not have a default value.
  • Title: Dynamic tags allowed
    Maximum Length: 30
    Value that indicates if the dynamic tag creation is permitted in the physical Inventory. Contains one of the following values: 1 or 2. If 1, then dynamic tag creation is permitted. If 2, then dynamic tag creation is not permitted. This attribute does not have a default value.
  • Value that indicates the level of approval required to post the physical inventory adjustments. A list of accepted values is defined in the lookup type INV_REQ_APPROVALS. This attribute does not have a default value.
  • Title: Approval Type
    Maximum Length: 30
    Value that indicates the level of approval required to post physical inventory adjustments. A list of accepted values is defined in the lookup type INV_REQ_APPROVALS. This attribute does not have a default value.
  • Title: Negative Quantity Tolerance Percentage
    Percent below the on-hand quantity that the adjustment transaction can vary. If the adjustment transaction exceeds the percent, then the adjustment transaction requires approval. For example, if Negative Quantity Tolerance Percentage is 10, and if the adjustment transaction requires an 11% negative adjustment to on-hand quantity, then the transaction requires approval.
  • Title: Positive Quantity Tolerance Percentage
    Percent above the on-hand quantity that the adjustment transaction can vary. If the adjustment transaction exceeds the percent, then the adjustment transaction requires approval. For example, if Positive Quantity Tolerance Percentage is 10, and if the adjustment transaction requires an 11% positive adjustment to on-hand quantity, then the transaction requires approval.
  • Title: Negative Adjustment Value Tolerance
    Total value of a physical inventory adjustment that is less than the current value of the item. The user specifies this limit.
  • Title: Positive Adjustment Value Tolerance
    Total value of a physical inventory adjustment that is greater than the current value of the item. The user specifies this limit.
  • Read Only: true
    Date when the physical inventory was created.
  • Title: Description
    Maximum Length: 50
    Description of the physical inventory.
  • Value that indicates if the items with negative on-hand balances are excluded from physical counts. Contains one of the following values: Yes or No. If Yes, then items with negative on-hand balances are excluded from physical count. If No, then items with negative on-hand balances are not excluded from physical count. This attribute does not have a default value.
  • Title: Exclude negative balances
    Maximum Length: 30
    Value that indicates that items with negative on-hand balances are excluded from physical counts. Contains one of the following values: Y or N. If Y, then items with negative on-hand balances are excluded from physical count. If N, then items with negative on-hand balances are not excluded from physical count. This attribute does not have a default value.
  • Value that indicates that items with zero on-hand balances are excluded from physical counts. Contains one of the following values: Yes or No. If Yes, then items with negative on-hand balances are excluded from physical count. If No, then items with negative on-hand balances are not excluded from physical count. This attribute does not have a default value.
  • Title: Exclude zero balances
    Maximum Length: 30
    Value that indicates that items with zero on-hand balances are excluded from physical counts. Contains one of the following values: Y or N. If Y, then items with negative on-hand balances are excluded from physical count. If N, then items with negative on-hand balances are not excluded from physical count. This attribute does not have a default value.
  • Fifth user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. There is no default value for this attribute.
  • Title: Sequence 5
    Maximum Length: 30
    Abbreviation that identifies the fifth sequence that the user defines when the application creates the physical inventory tag.
  • First user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. This attribute does not have a default value.
  • Title: Sequence 1
    Maximum Length: 30
    Abbreviation that identifies the first sequence that the user defines when the application creates the physical inventory tag.
  • Fourth user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. This attribute does not have a default value.
  • Title: Sequence 4
    Maximum Length: 30
    Abbreviation that identifies the fourth sequence that the user defines when the application creates the physical inventory tag.
  • Title: Snapshot Date
    Date when the application no longer allows changes to inventory.
  • Read Only: true
    Value that indicates the count of included subinventories for the physical inventory.
  • Title: Adjustment Date
    Date when the application most recently adjusted the transaction.
  • Links
  • Title: Starting Default Tag
    Maximum Length: 40
    Next tag number in the sequence of tag numbers that the application creates for this physical inventory.
  • Title: Number of Blank Tags
    Number of empty tags to create.
  • Number of stock keeping units where the application no longer permits changes. These units reside in physical inventory.
  • Abbreviation that identifies the organization.
  • Value that uniquely identifies the organization.
  • Title: Date
    Date when the person physically counted the inventory.
  • Flexfields
    Title: Flexfields
    The Flexfields for Physical Inventories resource manages descriptive flexfields for physical inventories.
  • Value that uniquely identifies the physical inventory.
  • Title: Physical Inventory
    Maximum Length: 30
    Name of the physical inventory.
  • Subinventories
    Title: Subinventories
    The Physical Inventory Subinventories resource manages operations on physical inventory subinventories.
  • Second user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. This attribute does not have a default value.
  • Title: Sequence 2
    Maximum Length: 30
    Abbreviation that identifies the second sequence that the user defines when the application creates the physical inventory tag.
  • Seventh user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. There is no default value for this attribute.
  • Title: Sequence 7
    Maximum Length: 30
    Abbreviation that identifies the seventh sequence that the user defines when the application creates the physical inventory tag.
  • Value that indicates if the dynamic tag creation is permitted in the physical inventory. Contains one of the following values: Yes or No. If Yes, then serial numbers are displayed on physical inventory tags. If No, then serial numbers are not displayed on physical inventory tags. This attribute does not have a default value.
  • Title: Show serial numbers on tags
    Maximum Length: 1
    Value that indicates if the dynamic tag creation is permitted in the physical Inventory. Contains one of the following values: 1 or 2. If 1, then serial numbers are displayed on physical inventory tags. If 2, then serial numbers are not displayed on physical inventory tags. This attribute does not have a default value.
  • Sixth user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. There is no default value for this attribute.
  • Title: Sequence 6
    Maximum Length: 30
    Abbreviation that identifies the sixth sequence that the user defines when the application creates the physical inventory tag.
  • Title: Starting Blank Tag
    Maximum Length: 40
    Starting empty tag number or the next empty tag number to create.
  • Read Only: true
    Maximum Length: 255
    Status of the physical inventory.
  • Read Only: true
    Maximum Length: 255
    Abbreviation that identifies the status of the physical inventory.
  • Type of physical inventory tags generated when the generate tags action is started. A list of accepted values is defined in the lookup type INV_GENERATE_TAG_TYPE. This attribute does not have a default value.
  • Title: Tag Type
    Maximum Length: 30
    Value that indicates the types of physical inventory tags generated when the generate tags action is started. A list of accepted values is defined in the lookup type INV_GENERATE_TAG_TYPE. This attribute does not have a default value.
  • Third user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. This attribute does not have a default value.
  • Title: Sequence 3
    Maximum Length: 30
    Abbreviation that identifies the third sequence that the user defines when the application creates the physical inventory tag.
  • Total value of all adjustments in physical inventory.
Nested Schema : Flexfields
Type: array
Title: Flexfields
The Flexfields for Physical Inventories resource manages descriptive flexfields for physical inventories.
Show Source
Nested Schema : Subinventories
Type: array
Title: Subinventories
The Physical Inventory Subinventories resource manages operations on physical inventory subinventories.
Show Source
Nested Schema : physicalInventories-physicalInventoryDFFs-item-response
Type: object
Show Source
Nested Schema : physicalInventories-physicalInventorySubinventories-item-response
Type: object
Show Source
Links
physicalInventoryDFFs
Parameters:
  • physicalInventoriesUniqID: $request.path.physicalInventoriesUniqID
The Flexfields for Physical Inventories resource manages descriptive flexfields for physical inventories.
physicalInventorySubinventories
Parameters:
  • physicalInventoriesUniqID: $request.path.physicalInventoriesUniqID
The Physical Inventory Subinventories resource manages operations on physical inventory subinventories.
Back to Top

Examples

This example describes how to create inventories.

Example cURL Command

Use the following cURL command to submit a request on the REST resource.

curl -u username:password -X POST -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" -d 'request payload' 
"https://servername/fscmRestApi/resources/version/physicalInventories"

Example 1 cURL Command

Use the following cURL command to submit a request on the REST resource to create a physical inventory along with its subinventories.

curl -u username:password -X POST -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" -d 'request payload' 
"https://servername/fscmRestApi/resources/version/physicalInventories"

Example 1 Request Body

The following example includes the contents of the request body in JSON format. You replace the request payload in the cURL command with the contents of the Example Request Body. The request payload specifies attribute values that the command will use in the record that it creates. 

{
            "OrganizationCode": "M1", 
            "PhysicalInventoryName": "NDSPI-4",
            "Description": "PHYSICAL INVENTORY TO START UP Vision Corporation",
            "PhysicalInventoryDate": "2018-01-22",
            "FreezeDate": null,
            "ApprovalRequired": "If out of tolerance",
            "ApprovalTolerancePositive": 5,
            "ApprovalToleranceNegative": 5,
            "CostVariancePositive": null,
            "CostVarianceNegative": null,
            "AllowAllSubinventories": "Specific",
            "NextTagNumber": "100001",
            "AllowDynamicTags": "Yes",
            "TagTypeCode": "1",
            "TagType": "Default",
            "FirstTagGenerationSequence": "Item",
            "SecondTagGenerationSequence": "Locator",
            "ThirdTagGenerationSequence": "Subinventory",
            "FourthTagGenerationSequence": "Revision",
            "physicalInventorySubinventories": [
                {
                    "Subinventory": "FGI"
                },
                {
                    "Subinventory": "PCSub"
                }
            ]           
}

Example 1 Response Body

The following example includes the contents of the response body in JSON format:

{
  "OrganizationId" : 207,
  "OrganizationCode" : "M1",
  "PhysicalInventoryId" : 300100129350622,
  "PhysicalInventoryName" : "NDSPI-4",
  "Description" : "PHYSICAL INVENTORY TO START UP Vision Corporation",
  "PhysicalInventoryDate" : "2018-03-22",
  "FreezeDate" : null,
  "ApprovalRequiredCode" : "3",
  "ApprovalRequired" : "If out of tolerance",
  "ApprovalTolerancePositive" : 5,
  "ApprovalToleranceNegative" : 5,
  "CostVariancePositive" : null,
  "CostVarianceNegative" : null,
  "AllowAllSubinventoriesCode" : "2",
  "AllowAllSubinventories" : "Specific",
  "NextTagNumber" : "100001",
  "AllowDynamicTagsCode" : "1",
  "AllowDynamicTags" : "Yes",
  "ExcludeZeroBalanceCode" : null,
  "ExcludeZeroBalance" : null,
  "ExcludeNegativeBalanceCode" : null,
  "ExcludeNegativeBalance" : null,
  "TagTypeCode" : "1",
  "TagType" : "Default",
  "ShowSerialNumbersCode" : null,
  "ShowSerialNumbers" : null,
  "StartBlankTagNumber" : null,
  "FirstTagGenerationSequenceCode" : "3",
  "SecondTagGenerationSequenceCode" : "2",
  "ThirdTagGenerationSequenceCode" : "1",
  "FourthTagGenerationSequenceCode" : "4",
  "FirstTagGenerationSequence" : "Item",
  "SecondTagGenerationSequence" : "Locator",
  "ThirdTagGenerationSequence" : "Subinventory",
  "FourthTagGenerationSequence" : "Revision",
  "LastAdjustmentDate" : null,
  "TotalAdjustmentValue" : null,
  "NumberOfSkus" : null,
  "NumberBlankTags" : null,
  "physicalInventorySubinventories" : [ {
    "Subinventory" : "FGI",
    "links" : [ {
      "rel" : "self",
      "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE/child/physicalInventorySubinventories/00030000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE00000003464749",
      "name" : "physicalInventorySubinventories",
      "kind" : "item",
      "properties" : {
        "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
      }
    }, {
      "rel" : "canonical",
      "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE/child/physicalInventorySubinventories/00030000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE00000003464749",
      "name" : "physicalInventorySubinventories",
      "kind" : "item"
    }, {
      "rel" : "parent",
      "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE",
      "name" : "physicalInventories",
      "kind" : "item"
    } ]
  }, {
    "Subinventory" : "PCSub",
    "links" : [ {
      "rel" : "self",
      "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE/child/physicalInventorySubinventories/00030000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE000000055043537562",
      "name" : "physicalInventorySubinventories",
      "kind" : "item",
      "properties" : {
        "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
      }
    }, {
      "rel" : "canonical",
      "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE/child/physicalInventorySubinventories/00030000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE000000055043537562",
      "name" : "physicalInventorySubinventories",
      "kind" : "item"
    }, {
      "rel" : "parent",
      "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE",
      "name" : "physicalInventories",
      "kind" : "item"
    } ]
  } ],
  "links" : [ {
    "rel" : "self",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE",
    "name" : "physicalInventories",
    "kind" : "item",
    "properties" : {
      "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
    }
  }, {
    "rel" : "canonical",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE",
    "name" : "physicalInventories",
    "kind" : "item"
  }, {
    "rel" : "lov",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE/lov/ApprovalLookupVA",
    "name" : "ApprovalLookupVA",
    "kind" : "collection"
  }, {
    "rel" : "lov",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE/lov/YesNoCharLookupVA",
    "name" : "YesNoCharLookupVA",
    "kind" : "collection"
  }, {
    "rel" : "lov",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE/lov/TagGenLookupVA",
    "name" : "TagGenLookupVA",
    "kind" : "collection"
  }, {
    "rel" : "lov",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE/lov/OrganizationVA",
    "name" : "OrganizationVA",
    "kind" : "collection"
  }, {
    "rel" : "lov",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE/lov/YesNoLookupVA",
    "name" : "YesNoLookupVA",
    "kind" : "collection"
  }, {
    "rel" : "lov",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE/lov/TagTypeLookupVA",
    "name" : "TagTypeLookupVA",
    "kind" : "collection"
  }, {
    "rel" : "lov",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE/lov/SubinvFlagLookupVA",
    "name" : "SubinvFlagLookupVA",
    "kind" : "collection"
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE/child/physicalInventorySubinventories",
    "name" : "physicalInventorySubinventories",
    "kind" : "collection"
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0819B63DE/child/physicalInventoryDFFs",
    "name" : "physicalInventoryDFFs",
    "kind" : "collection"
  } ]
}

Example 2 cURL Command

Use the following cURL command to submit a request on the REST resource to create a physical inventory along with its subinventories and flex fields.

curl -u username:password -X POST -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" -d 'request payload' 
"https://servername/fscmRestApi/resources/version/physicalInventories"

Example 2 Request Body

The following example includes the contents of the request body in JSON format. You replace the request payload in the cURL command with the contents of the Example Request Body. The request payload specifies attribute values that the command will use in the record that it creates. 

{
    "OrganizationId": 207,
    "OrganizationCode": "M1",
    "PhysicalInventoryName": "NDPI504",
    "Description": "New PI",
	"PhysicalInventoryDate": "2018-03-03",
    "ApprovalRequiredCode": "3",
    "ApprovalRequired": "If out of tolerance",
    "ApprovalTolerancePositive": 5,
    "ApprovalToleranceNegative": 5,
    "CostVariancePositive": null,
    "CostVarianceNegative": null,
    "AllowAllSubinventoriesCode": "2",
    "AllowAllSubinventories": "Specific",
    "NextTagNumber": "100001",
    "AllowDynamicTagsCode": "1",
    "AllowDynamicTags": "Yes",
    "ExcludeZeroBalanceCode": null,
    "ExcludeZeroBalance": null,
    "ExcludeNegativeBalanceCode": null,
    "ExcludeNegativeBalance": null,
    "TagTypeCode": null,
    "TagType": "Default",
    "ShowSerialNumbersCode": null,
    "ShowSerialNumbers": null,
    "StartBlankTagNumber": null,
    "FirstTagGenerationSequenceCode": "1",
    "SecondTagGenerationSequenceCode": "2",
    "ThirdTagGenerationSequenceCode": "3",
    "FourthTagGenerationSequenceCode": "4",
    "FirstTagGenerationSequence": null,
    "SecondTagGenerationSequence": null,
    "ThirdTagGenerationSequence": null,
    "FourthTagGenerationSequence": null,
    "NumberBlankTags": null,
    "physicalInventorySubinventories" : [ 
        { 
           "Subinventory": "PCSub" 
        }, 
        { 
           "Subinventory": "FGI" 
        }
    ],
	"physicalInventoryDFFs" : [  
	{  
		"gseg1": 23,
		"__FLEX_Context" : "Context1",
    		"c1seg1" : "A"
	}  
	]
}

Example 2 Response Body

The following example includes the contents of the response body in JSON format:

{
  "OrganizationId" : 207,
  "OrganizationCode" : "M1",
  "PhysicalInventoryId" : 300100125676981,
  "PhysicalInventoryName" : "NDPI504",
  "Description" : "New PI",
  "PhysicalInventoryDate" : "2018-03-03",
  "FreezeDate" : null,
  "ApprovalRequiredCode" : "3",
  "ApprovalRequired" : "If out of tolerance",
  "ApprovalTolerancePositive" : 5,
  "ApprovalToleranceNegative" : 5,
  "CostVariancePositive" : null,
  "CostVarianceNegative" : null,
  "AllowAllSubinventoriesCode" : "2",
  "AllowAllSubinventories" : "Specific",
  "NextTagNumber" : "100001",
  "AllowDynamicTagsCode" : "1",
  "AllowDynamicTags" : "Yes",
  "ExcludeZeroBalanceCode" : null,
  "ExcludeZeroBalance" : null,
  "ExcludeNegativeBalanceCode" : null,
  "ExcludeNegativeBalance" : null,
  "TagTypeCode" : "1",
  "TagType" : "Default",
  "ShowSerialNumbersCode" : null,
  "ShowSerialNumbers" : null,
  "StartBlankTagNumber" : null,
  "FirstTagGenerationSequenceCode" : "1",
  "SecondTagGenerationSequenceCode" : "2",
  "ThirdTagGenerationSequenceCode" : "3",
  "FourthTagGenerationSequenceCode" : "4",
  "FirstTagGenerationSequence" : "Subinventory",
  "SecondTagGenerationSequence" : "Locator",
  "ThirdTagGenerationSequence" : "Item",
  "FourthTagGenerationSequence" : "Revision",
  "LastAdjustmentDate" : null,
  "TotalAdjustmentValue" : null,
  "NumberOfSkus" : null,
  "NumberBlankTags" : null,
  "physicalInventorySubinventories" : [ {
    "Subinventory" : "PCSub",
    "links" : [ {
      "rel" : "self",
      "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/child/physicalInventorySubinventories/00030000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5000000055043537562",
      "name" : "physicalInventorySubinventories",
      "kind" : "item",
      "properties" : {
        "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
      }
    }, {
      "rel" : "canonical",
      "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/child/physicalInventorySubinventories/00030000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5000000055043537562",
      "name" : "physicalInventorySubinventories",
      "kind" : "item"
    }, {
      "rel" : "parent",
      "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5",
      "name" : "physicalInventories",
      "kind" : "item"
    } ]
  }, {
    "Subinventory" : "FGI",
    "links" : [ {
      "rel" : "self",
      "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/child/physicalInventorySubinventories/00030000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B500000003464749",
      "name" : "physicalInventorySubinventories",
      "kind" : "item",
      "properties" : {
        "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
      }
    }, {
      "rel" : "canonical",
      "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/child/physicalInventorySubinventories/00030000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B500000003464749",
      "name" : "physicalInventorySubinventories",
      "kind" : "item"
    }, {
      "rel" : "parent",
      "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5",
      "name" : "physicalInventories",
      "kind" : "item"
    } ]
  } ],
  "physicalInventoryDFFs" : [ {
    "OrganizationId" : 207,
    "PhysicalInventoryId" : 300100125676981,
    "gseg1" : 23,
    "__FLEX_Context" : "Context1",
    "__FLEX_Context_DisplayValue" : "Context1",
    "c1seg1" : "A",
    "links" : [ {
      "rel" : "self",
      "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/child/physicalInventoryDFFs/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5",
      "name" : "physicalInventoryDFFs",
      "kind" : "item",
      "properties" : {
        "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
      }
    }, {
      "rel" : "canonical",
      "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/child/physicalInventoryDFFs/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5",
      "name" : "physicalInventoryDFFs",
      "kind" : "item"
    }, {
      "rel" : "parent",
      "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5",
      "name" : "physicalInventories",
      "kind" : "item"
    }, {
      "rel" : "lov",
      "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/child/physicalInventoryDFFs/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/lov/LVVO___FLEX_Context",
      "name" : "LVVO___FLEX_Context",
      "kind" : "collection"
    } ]
  } ],
  "links" : [ {
    "rel" : "self",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5",
    "name" : "physicalInventories",
    "kind" : "item",
    "properties" : {
      "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
    }
  }, {
    "rel" : "canonical",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5",
    "name" : "physicalInventories",
    "kind" : "item"
  }, {
    "rel" : "lov",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/lov/ApprovalLookupVA",
    "name" : "ApprovalLookupVA",
    "kind" : "collection"
  }, {
    "rel" : "lov",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/lov/YesNoCharLookupVA",
    "name" : "YesNoCharLookupVA",
    "kind" : "collection"
  }, {
    "rel" : "lov",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/lov/TagGenLookupVA",
    "name" : "TagGenLookupVA",
    "kind" : "collection"
  }, {
    "rel" : "lov",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/lov/OrganizationVA",
    "name" : "OrganizationVA",
    "kind" : "collection"
  }, {
    "rel" : "lov",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/lov/YesNoLookupVA",
    "name" : "YesNoLookupVA",
    "kind" : "collection"
  }, {
    "rel" : "lov",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/lov/TagTypeLookupVA",
    "name" : "TagTypeLookupVA",
    "kind" : "collection"
  }, {
    "rel" : "lov",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/lov/SubinvFlagLookupVA",
    "name" : "SubinvFlagLookupVA",
    "kind" : "collection"
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/child/physicalInventorySubinventories",
    "name" : "physicalInventorySubinventories",
    "kind" : "collection"
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/physicalInventories/00020000000EACED0005770800000000000000CF0000000EACED00057708000110F0816355B5/child/physicalInventoryDFFs",
    "name" : "physicalInventoryDFFs",
    "kind" : "collection"
  } ]
}
Back to Top