Jump to

• Request
• Response
• Examples

Update one lot

patch

/fscmRestApi/resources/11.13.18.05/inventoryItemLots/{inventoryItemLotsUniqID}

Request

Path Parameters

• inventoryItemLotsUniqID(required): string
  This is the hash key of the attributes which make up the composite key--- OrganizationId, InventoryItemId and LotNumber ---for the Inventory Item Lots resource and used to uniquely identify an instance of Inventory Item Lots. The client should not generate the hash key value. Instead, the client should query on the Inventory Item Lots collection resource with a filter on the primary key values in order to navigate to a specific instance of Inventory Item Lots.
  
  For example: inventoryItemLots?q=OrganizationId=<value1>;InventoryItemId=<value2>;LotNumber=<value3>

Header Parameters

• Metadata-Context:
  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".
• REST-Framework-Version:
  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.

Supported Media Types

• application/json

Request Body - application/json ()

Root Schema : schema

Type: object

Show Source

• ActiveLot: string
  Maximum Length: 80

  Value that indicates the status of the lots. A list of accepted values is defined in the lookup ORA_INV_LOT_ACTIVE. The default value is Yes.
• ActiveLotCode: string
  Maximum Length: 30

  Default Value: 2

  Abbreviation that indicates the status of the lot. A list of accepted values is defined in the lookup ORA_INV_LOT_ACTIVE. The default value is 2.
• Disabled: string
  Value that indicates whether or not the lot number is disabled. Contains one of the following values: Yes or Null. If Yes, then the lot number is disabled. If Null, then the lot number isn't disabled. The default value is Null.
• DisabledCode: string
  Maximum Length: 1

  Default Value: N

  Abbreviation that identifies the current usage of the lot number. A list of accepted values is defined in the lookup YES_NO. The default value is null.
• ExpirationAction: string
  Title: Description

  Maximum Length: 80

  Expiration action.
• ExpirationActionCode: string
  Title: Expiration Action

  Maximum Length: 32

  Abbreviation that identifies the expiration action.
• ExpirationActionDate: string (date-time)
  Title: Expiration Action Date

  Date when the warehouse performed the expiration action.
• ExpirationDate: string (date-time)
  Title: Expiration Date

  Date when the warehouse expired the lot.
• Grade: string
  Title: Grade

  Maximum Length: 150

  Abbreviation that identifies the grade of the item.
• HoldUntilDate: string (date-time)
  Title: Hold Until Date

  Date when the hold expires.
• lotAttributeDFF: array Flexfields for Lot Attributes
  Title: Flexfields for Lot Attributes

  A flexible data field that includes all the inventory item lot attribute flexfields.
• lotStandardDFF: array Flexfields for Lots
  Title: Flexfields for Lots

  A flexible data field that includes all the inventory item lot flexfields.
• MaturityDate: string (date-time)
  Title: Maturity Date

  Date when the item matures.
• OriginationDate: string (date-time)
  Title: Origination Date

  Date when the warehouse created the lot.
• RetestDate: string (date-time)
  Date when the lot is retested. This attribute is based on the lot origination date and the retest interval.
• StatusCode: string
  Title: Material Status

  Maximum Length: 80

  Abbreviation that identifies the status of the item.
• StatusId: integer (int64)
  Title: Material Status

  Default Value: 1

  Value that uniquely identifies the material status.
• supplierLotNumbers: array Supplier Lot Numbers
  Title: Supplier Lot Numbers

  A supplier lot number associated with a lot.
• UniqueDeviceIdentifier: string
  Maximum Length: 150

  Value that uniquely identifies the device.

{
    "type":"object",
    "properties":{
        "UniqueDeviceIdentifier":{
            "maxLength":"150",
            "type":"string",
            "description":"Value that uniquely identifies the device.",
            "nullable":true
        },
        "ActiveLot":{
            "maxLength":"80",
            "type":"string",
            "description":"Value that indicates the status of the lots. A list of accepted values is defined in the lookup ORA_INV_LOT_ACTIVE. The default value is Yes.",
            "nullable":true,
            "x-hints":{
                "controlType":"choice"
            }
        },
        "Grade":{
            "title":"Grade",
            "maxLength":"150",
            "type":"string",
            "description":"Abbreviation that identifies the grade of the item.",
            "nullable":true,
            "x-hints":{
                "controlType":"choice"
            }
        },
        "MaturityDate":{
            "title":"Maturity Date",
            "type":"string",
            "description":"Date when the item matures.",
            "format":"date-time",
            "nullable":true
        },
        "StatusCode":{
            "title":"Material Status",
            "maxLength":"80",
            "type":"string",
            "description":"Abbreviation that identifies the status of the item.",
            "nullable":true,
            "x-hints":{
                "controlType":"choice"
            }
        },
        "lotStandardDFF":{
            "title":"Flexfields for Lots",
            "type":"array",
            "description":"A flexible data field that includes all the inventory item lot flexfields.",
            "items":{
                "$ref":"#/components/schemas/inventoryItemLots-lotStandardDFF-item-patch-request"
            },
            "x-cardinality":"1"
        },
        "DisabledCode":{
            "maxLength":"1",
            "type":"string",
            "description":"Abbreviation that identifies the current usage of the lot number. A list of accepted values is defined in the lookup YES_NO. The default value is null.",
            "nullable":true,
            "default":"N",
            "x-hints":{
                "controlType":"choice"
            }
        },
        "supplierLotNumbers":{
            "title":"Supplier Lot Numbers",
            "type":"array",
            "description":"A supplier lot number associated with a lot.",
            "items":{
                "$ref":"#/components/schemas/inventoryItemLots-supplierLotNumbers-item-patch-request"
            }
        },
        "OriginationDate":{
            "title":"Origination Date",
            "type":"string",
            "description":"Date when the warehouse created the lot.",
            "format":"date-time",
            "nullable":true
        },
        "ExpirationDate":{
            "title":"Expiration Date",
            "type":"string",
            "description":"Date when the warehouse expired the lot.",
            "format":"date-time",
            "nullable":true
        },
        "ExpirationActionDate":{
            "title":"Expiration Action Date",
            "type":"string",
            "description":"Date when the warehouse performed the expiration action.",
            "format":"date-time",
            "nullable":true
        },
        "lotAttributeDFF":{
            "title":"Flexfields for Lot Attributes",
            "type":"array",
            "description":"A flexible data field that includes all the inventory item lot attribute flexfields.",
            "items":{
                "$ref":"#/components/schemas/inventoryItemLots-lotAttributeDFF-item-patch-request"
            },
            "x-cardinality":"1"
        },
        "ExpirationActionCode":{
            "title":"Expiration Action",
            "maxLength":"32",
            "type":"string",
            "description":"Abbreviation that identifies the expiration action.",
            "nullable":true
        },
        "ExpirationAction":{
            "title":"Description",
            "maxLength":"80",
            "type":"string",
            "description":"Expiration action.",
            "nullable":true,
            "x-hints":{
                "controlType":"choice"
            }
        },
        "HoldUntilDate":{
            "title":"Hold Until Date",
            "type":"string",
            "description":"Date when the hold expires.",
            "format":"date-time",
            "nullable":true
        },
        "RetestDate":{
            "type":"string",
            "description":"Date when the lot is retested. This attribute is based on the lot origination date and the retest interval.",
            "format":"date-time",
            "nullable":true
        },
        "ActiveLotCode":{
            "maxLength":"30",
            "type":"string",
            "description":"Abbreviation that indicates the status of the lot. A list of accepted values is defined in the lookup ORA_INV_LOT_ACTIVE. The default value is 2.",
            "nullable":true,
            "default":"2",
            "x-hints":{
                "fnd:APPLCORE_SETID_LOOKUP_TYPE":"INV_YES_NO_NUMERIC",
                "fnd:APPLCORE_VIEW_APPLICATION_ID":"0"
            }
        },
        "StatusId":{
            "title":"Material Status",
            "type":"integer",
            "description":"Value that uniquely identifies the material status.",
            "format":"int64",
            "nullable":true,
            "default":"1",
            "x-hints":{
                "precision":"18"
            }
        },
        "Disabled":{
            "type":"string",
            "description":"Value that indicates whether or not the lot number is disabled. Contains one of the following values: Yes or Null. If Yes, then the lot number is disabled. If Null, then the lot number isn't disabled. The default value is Null.",
            "nullable":true,
            "x-hints":{
                "controlType":"choice"
            }
        }
    }
}

Nested Schema : Flexfields for Lot Attributes

Type: array

Title: Flexfields for Lot Attributes

A flexible data field that includes all the inventory item lot attribute flexfields.

Show Source

• Array of: object inventoryItemLots-lotAttributeDFF-item-patch-request

{
    "title":"Flexfields for Lot Attributes",
    "type":"array",
    "description":"A flexible data field that includes all the inventory item lot attribute flexfields.",
    "items":{
        "$ref":"#/components/schemas/inventoryItemLots-lotAttributeDFF-item-patch-request"
    },
    "x-cardinality":"1"
}

Nested Schema : Flexfields for Lots

Type: array

Title: Flexfields for Lots

A flexible data field that includes all the inventory item lot flexfields.

Show Source

• Array of: object schema

{
    "title":"Flexfields for Lots",
    "type":"array",
    "description":"A flexible data field that includes all the inventory item lot flexfields.",
    "items":{
        "$ref":"#/components/schemas/inventoryItemLots-lotStandardDFF-item-patch-request"
    },
    "x-cardinality":"1"
}

Nested Schema : Supplier Lot Numbers

Type: array

Title: Supplier Lot Numbers

A supplier lot number associated with a lot.

Show Source

• Array of: object inventoryItemLots-supplierLotNumbers-item-patch-request

{
    "title":"Supplier Lot Numbers",
    "type":"array",
    "description":"A supplier lot number associated with a lot.",
    "items":{
        "$ref":"#/components/schemas/inventoryItemLots-supplierLotNumbers-item-patch-request"
    }
}

Nested Schema : inventoryItemLots-lotAttributeDFF-item-patch-request

Type: object

Show Source

• __FLEX_Context: string
  Title: Context Value

  Maximum Length: 30

  Descriptive flexfield context name for lot attributes.
• __FLEX_Context_DisplayValue: string
  Title: Context Value

{
    "type":"object",
    "properties":{
        "__FLEX_Context_DisplayValue":{
            "title":"Context Value",
            "type":"string",
            "nullable":true,
            "x-hints":{
                "updateable":"false",
                "DISPLAYHINT":"Hide",
                "FND_ACFF_IsReadOnly":"true",
                "FND_ACFF_AkaRealSegmentAttrName":"__FLEX_Context",
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_ListDisplayAttrName":"Name",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"HIDDEN"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            }
        },
        "__FLEX_Context":{
            "title":"Context Value",
            "maxLength":"30",
            "type":"string",
            "description":"Descriptive flexfield context name for lot attributes.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "FND_ACFF_ValueSetInfo":"_FLEX_ContextValueSet_Internal#INDEPENDENT",
                "controlType":"choice",
                "FND_ACFF_AkaAttrName":"__FLEX_Context_DisplayValue",
                "includeInCompactView":true,
                "FND_ACFF_IsDiscriminator":"true",
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"HIDDEN"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            }
        }
    }
}

Nested Schema : schema

Type: object

Show Source

• __FLEX_Context: string
  Title: Context Value

  Maximum Length: 30

  Descriptive flexfield context name for lot standards.
• __FLEX_Context_DisplayValue: string
  Title: Context Value

{
    "type":"object",
    "properties":{
        "__FLEX_Context_DisplayValue":{
            "title":"Context Value",
            "type":"string",
            "nullable":true,
            "x-hints":{
                "updateable":"false",
                "DISPLAYHINT":"Hide",
                "FND_ACFF_IsReadOnly":"true",
                "FND_ACFF_AkaRealSegmentAttrName":"__FLEX_Context",
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_ListDisplayAttrName":"Name",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"HIDDEN"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            }
        },
        "__FLEX_Context":{
            "title":"Context Value",
            "maxLength":"30",
            "type":"string",
            "description":"Descriptive flexfield context name for lot standards.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "FND_ACFF_ValueSetInfo":"_FLEX_ContextValueSet_Internal#INDEPENDENT",
                "controlType":"choice",
                "FND_ACFF_AkaAttrName":"__FLEX_Context_DisplayValue",
                "includeInCompactView":true,
                "FND_ACFF_IsDiscriminator":"true",
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"HIDDEN"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            }
        }
    }
}

Nested Schema : inventoryItemLots-supplierLotNumbers-item-patch-request

Type: object

Show Source

{
    "type":"object",
    "properties":{
    }
}

Back to Top

Response

Supported Media Types

• application/json

Default Response

The following table describes the default response for this task.

Headers

• Metadata-Context:
  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".
• REST-Framework-Version:
  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 : inventoryItemLots-item-response

Type: object

Show Source

• ActiveLot: string
  Maximum Length: 80

  Value that indicates the status of the lots. A list of accepted values is defined in the lookup ORA_INV_LOT_ACTIVE. The default value is Yes.
• ActiveLotCode: string
  Maximum Length: 30

  Default Value: 2

  Abbreviation that indicates the status of the lot. A list of accepted values is defined in the lookup ORA_INV_LOT_ACTIVE. The default value is 2.
• Disabled: string
  Value that indicates whether or not the lot number is disabled. Contains one of the following values: Yes or Null. If Yes, then the lot number is disabled. If Null, then the lot number isn't disabled. The default value is Null.
• DisabledCode: string
  Maximum Length: 1

  Default Value: N

  Abbreviation that identifies the current usage of the lot number. A list of accepted values is defined in the lookup YES_NO. The default value is null.
• ExpirationAction: string
  Title: Description

  Maximum Length: 80

  Expiration action.
• ExpirationActionCode: string
  Title: Expiration Action

  Maximum Length: 32

  Abbreviation that identifies the expiration action.
• ExpirationActionDate: string (date-time)
  Title: Expiration Action Date

  Date when the warehouse performed the expiration action.
• ExpirationDate: string (date-time)
  Title: Expiration Date

  Date when the warehouse expired the lot.
• Grade: string
  Title: Grade

  Maximum Length: 150

  Abbreviation that identifies the grade of the item.
• GradeDescription: string
  Title: Description

  Read Only: true

  Maximum Length: 240

  Value that describes the grade of the item.
• HoldUntilDate: string (date-time)
  Title: Hold Until Date

  Date when the hold expires.
• InventoryItemId: integer (int64)
  Value that uniquely identifies the inventory item.
• ItemDescription: string
  Title: Item Description

  Read Only: true

  Maximum Length: 240

  Description of the inventory item.
• ItemNumber: string
  Maximum Length: 300

  Name of the inventory item.
• ItemPrimaryImageURL: string
  Title: Primary Image URL

  Read Only: true

  Maximum Length: 4000

  URL for the primary image of the inventory item.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• lotAttributeDFF: array Flexfields for Lot Attributes
  Title: Flexfields for Lot Attributes

  A flexible data field that includes all the inventory item lot attribute flexfields.
• LotNumber: string
  Title: Lot

  Maximum Length: 80

  Number that identifies the lot.
• lotStandardDFF: array Flexfields for Lots
  Title: Flexfields for Lots

  A flexible data field that includes all the inventory item lot flexfields.
• LotStatusMeaning: string
  Read Only: true

  Maximum Length: 255

  Value that displays the Enabled or Disabled status of the lookup meaning of the lot status. The default value is Enabled.
• MaturityDate: string (date-time)
  Title: Maturity Date

  Date when the item matures.
• OrganizationCode: string
  Maximum Length: 18

  Abbreviation that identifies the organization.
• OrganizationId: integer (int64)
  Value that uniquely identifies the organization.
• OrganizationName: string
  Maximum Length: 240

  Name of the organization.
• OriginationDate: string (date-time)
  Title: Origination Date

  Date when the warehouse created the lot.
• OriginationType: string
  Maximum Length: 80

  Value that identifies the origination type of the lots. A list of accepted values is defined in the lookup INV_LOT_ORIGINATION_TYPE. The default value is Lot master.
• OriginationTypeCode: string
  Title: Origination Type

  Maximum Length: 30

  Default Value: 0

  Abbreviation that identifies the origination type of the lots. A list of accepted values is defined in the lookup INV_LOT_ORIGINATION_TYPE. The default value is 0.
• ParentLotNumber: string
  Title: Parent Lot

  Maximum Length: 80

  Number that identifies the parent lot.
• RetestDate: string (date-time)
  Date when the lot is retested. This attribute is based on the lot origination date and the retest interval.
• StatusCode: string
  Title: Material Status

  Maximum Length: 80

  Abbreviation that identifies the status of the item.
• StatusId: integer (int64)
  Title: Material Status

  Default Value: 1

  Value that uniquely identifies the material status.
• supplierLotNumbers: array Supplier Lot Numbers
  Title: Supplier Lot Numbers

  A supplier lot number associated with a lot.
• UniqueDeviceIdentifier: string
  Maximum Length: 150

  Value that uniquely identifies the device.

{
    "type":"object",
    "properties":{
        "OrganizationName":{
            "maxLength":"240",
            "type":"string",
            "description":"Name of the organization.",
            "nullable":false,
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "UniqueDeviceIdentifier":{
            "maxLength":"150",
            "type":"string",
            "description":"Value that uniquely identifies the device.",
            "nullable":true,
            "x-queryable":true
        },
        "ParentLotNumber":{
            "title":"Parent Lot",
            "maxLength":"80",
            "type":"string",
            "description":"Number that identifies the parent lot.",
            "nullable":true,
            "x-queryable":true
        },
        "OrganizationId":{
            "type":"integer",
            "description":"Value that uniquely identifies the organization.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "ItemDescription":{
            "title":"Item Description",
            "maxLength":"240",
            "type":"string",
            "description":"Description of the inventory item.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "StatusCode":{
            "title":"Material Status",
            "maxLength":"80",
            "type":"string",
            "description":"Abbreviation that identifies the status of the item.",
            "nullable":true,
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "LotStatusMeaning":{
            "maxLength":"255",
            "type":"string",
            "description":"Value that displays the Enabled or Disabled status of the lookup meaning of the lot status. The default value is Enabled.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "DisabledCode":{
            "maxLength":"1",
            "type":"string",
            "description":"Abbreviation that identifies the current usage of the lot number. A list of accepted values is defined in the lookup YES_NO. The default value is null.",
            "nullable":true,
            "default":"N",
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "supplierLotNumbers":{
            "title":"Supplier Lot Numbers",
            "type":"array",
            "description":"A supplier lot number associated with a lot.",
            "items":{
                "$ref":"#/components/schemas/inventoryItemLots-supplierLotNumbers-item-response"
            }
        },
        "GradeDescription":{
            "title":"Description",
            "maxLength":"240",
            "type":"string",
            "description":"Value that describes the grade of the item.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "ItemNumber":{
            "maxLength":"300",
            "type":"string",
            "description":"Name of the inventory item.",
            "nullable":false,
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "lotAttributeDFF":{
            "title":"Flexfields for Lot Attributes",
            "type":"array",
            "description":"A flexible data field that includes all the inventory item lot attribute flexfields.",
            "items":{
                "$ref":"#/components/schemas/inventoryItemLots-lotAttributeDFF-item-response"
            },
            "x-cardinality":"1"
        },
        "ExpirationAction":{
            "title":"Description",
            "maxLength":"80",
            "type":"string",
            "description":"Expiration action.",
            "nullable":true,
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "HoldUntilDate":{
            "title":"Hold Until Date",
            "type":"string",
            "description":"Date when the hold expires.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "RetestDate":{
            "type":"string",
            "description":"Date when the lot is retested. This attribute is based on the lot origination date and the retest interval.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "OriginationType":{
            "maxLength":"80",
            "type":"string",
            "description":"Value that identifies the origination type of the lots. A list of accepted values is defined in the lookup INV_LOT_ORIGINATION_TYPE. The default value is Lot master.",
            "nullable":true,
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "OrganizationCode":{
            "maxLength":"18",
            "type":"string",
            "description":"Abbreviation that identifies the organization.",
            "nullable":true,
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "ItemPrimaryImageURL":{
            "title":"Primary Image URL",
            "maxLength":"4000",
            "type":"string",
            "description":"URL for the primary image of the inventory item.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "Disabled":{
            "type":"string",
            "description":"Value that indicates whether or not the lot number is disabled. Contains one of the following values: Yes or Null. If Yes, then the lot number is disabled. If Null, then the lot number isn't disabled. The default value is Null.",
            "nullable":true,
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "LotNumber":{
            "title":"Lot",
            "maxLength":"80",
            "type":"string",
            "description":"Number that identifies the lot.",
            "nullable":true,
            "x-queryable":true
        },
        "InventoryItemId":{
            "type":"integer",
            "description":"Value that uniquely identifies the inventory item.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "ActiveLot":{
            "maxLength":"80",
            "type":"string",
            "description":"Value that indicates the status of the lots. A list of accepted values is defined in the lookup ORA_INV_LOT_ACTIVE. The default value is Yes.",
            "nullable":true,
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "Grade":{
            "title":"Grade",
            "maxLength":"150",
            "type":"string",
            "description":"Abbreviation that identifies the grade of the item.",
            "nullable":true,
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "MaturityDate":{
            "title":"Maturity Date",
            "type":"string",
            "description":"Date when the item matures.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "OriginationTypeCode":{
            "title":"Origination Type",
            "maxLength":"30",
            "type":"string",
            "description":"Abbreviation that identifies the origination type of the lots. A list of accepted values is defined in the lookup INV_LOT_ORIGINATION_TYPE. The default value is 0.",
            "nullable":true,
            "default":"0",
            "x-hints":{
                "fnd:APPLCORE_SETID_LOOKUP_TYPE":"INV_LOT_ORIGINATION_TYPE",
                "fnd:APPLCORE_VIEW_APPLICATION_ID":"0"
            },
            "x-queryable":true
        },
        "lotStandardDFF":{
            "title":"Flexfields for Lots",
            "type":"array",
            "description":"A flexible data field that includes all the inventory item lot flexfields.",
            "items":{
                "$ref":"#/components/schemas/inventoryItemLots-lotStandardDFF-item-response"
            },
            "x-cardinality":"1"
        },
        "OriginationDate":{
            "title":"Origination Date",
            "type":"string",
            "description":"Date when the warehouse created the lot.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "ExpirationDate":{
            "title":"Expiration Date",
            "type":"string",
            "description":"Date when the warehouse expired the lot.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "ExpirationActionDate":{
            "title":"Expiration Action Date",
            "type":"string",
            "description":"Date when the warehouse performed the expiration action.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "ExpirationActionCode":{
            "title":"Expiration Action",
            "maxLength":"32",
            "type":"string",
            "description":"Abbreviation that identifies the expiration action.",
            "nullable":true,
            "x-queryable":true
        },
        "ActiveLotCode":{
            "maxLength":"30",
            "type":"string",
            "description":"Abbreviation that indicates the status of the lot. A list of accepted values is defined in the lookup ORA_INV_LOT_ACTIVE. The default value is 2.",
            "nullable":true,
            "default":"2",
            "x-hints":{
                "fnd:APPLCORE_SETID_LOOKUP_TYPE":"INV_YES_NO_NUMERIC",
                "fnd:APPLCORE_VIEW_APPLICATION_ID":"0"
            },
            "x-queryable":true
        },
        "StatusId":{
            "title":"Material Status",
            "type":"integer",
            "description":"Value that uniquely identifies the material status.",
            "format":"int64",
            "nullable":true,
            "default":"1",
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : Flexfields for Lot Attributes

Type: array

Title: Flexfields for Lot Attributes

A flexible data field that includes all the inventory item lot attribute flexfields.

Show Source

• Array of: object inventoryItemLots-lotAttributeDFF-item-response

{
    "title":"Flexfields for Lot Attributes",
    "type":"array",
    "description":"A flexible data field that includes all the inventory item lot attribute flexfields.",
    "items":{
        "$ref":"#/components/schemas/inventoryItemLots-lotAttributeDFF-item-response"
    },
    "x-cardinality":"1"
}

Nested Schema : Flexfields for Lots

Type: array

Title: Flexfields for Lots

A flexible data field that includes all the inventory item lot flexfields.

Show Source

• Array of: object inventoryItemLots-lotStandardDFF-item-response

{
    "title":"Flexfields for Lots",
    "type":"array",
    "description":"A flexible data field that includes all the inventory item lot flexfields.",
    "items":{
        "$ref":"#/components/schemas/inventoryItemLots-lotStandardDFF-item-response"
    },
    "x-cardinality":"1"
}

Nested Schema : Supplier Lot Numbers

Type: array

Title: Supplier Lot Numbers

A supplier lot number associated with a lot.

Show Source

• Array of: object inventoryItemLots-supplierLotNumbers-item-response

{
    "title":"Supplier Lot Numbers",
    "type":"array",
    "description":"A supplier lot number associated with a lot.",
    "items":{
        "$ref":"#/components/schemas/inventoryItemLots-supplierLotNumbers-item-response"
    }
}

Nested Schema : link

Type: object

Show Source

• href: string
  Title: hyperlink reference

  The URI to the related resource.
• kind: string
  Title: kind

  Allowed Values: [ "collection", "item", "describe", "other" ]

  The kind of the related resource.
• name: string
  Title: name

  The name of the link to the related resource.
• properties: object properties
• rel: string
  Title: relation

  Allowed Values: [ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]

  The name of the relation to the resource instance. Example: self.

{
    "type":"object",
    "properties":{
        "kind":{
            "title":"kind",
            "type":"string",
            "description":"The kind of the related resource.",
            "enum":[
                "collection",
                "item",
                "describe",
                "other"
            ]
        },
        "rel":{
            "title":"relation",
            "type":"string",
            "description":"The name of the relation to the resource instance.  Example: self.",
            "enum":[
                "self",
                "lov",
                "parent",
                "canonical",
                "child",
                "enclosure",
                "action",
                "custom"
            ]
        },
        "name":{
            "title":"name",
            "type":"string",
            "description":"The name of the link to the related resource."
        },
        "href":{
            "title":"hyperlink reference",
            "type":"string",
            "description":"The URI to the related resource."
        },
        "properties":{
            "type":"object",
            "properties":{
                "changeIndicator":{
                    "type":"string",
                    "description":"Change indicator or the ETag value of the resource instance."
                }
            }
        }
    }
}

Nested Schema : properties

Type: object

Show Source

• changeIndicator: string
  Change indicator or the ETag value of the resource instance.

{
    "type":"object",
    "properties":{
        "changeIndicator":{
            "type":"string",
            "description":"Change indicator or the ETag value of the resource instance."
        }
    }
}

Nested Schema : inventoryItemLots-lotAttributeDFF-item-response

Type: object

Show Source

• __FLEX_Context: string
  Title: Context Value

  Maximum Length: 30

  Descriptive flexfield context name for lot attributes.
• __FLEX_Context_DisplayValue: string
  Title: Context Value
• InventoryItemId: integer (int64)
  Value that uniquely identifies the inventory item.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• LotNumber: string
  Title: Lot

  Maximum Length: 80

  Number that identifies the lot.
• OrganizationId: integer (int64)
  Value that uniquely identifies the organization.

{
    "type":"object",
    "properties":{
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "OrganizationId":{
            "type":"integer",
            "description":"Value that uniquely identifies the organization.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true,
                "precision":"18"
            },
            "x-queryable":true
        },
        "LotNumber":{
            "title":"Lot",
            "maxLength":"80",
            "type":"string",
            "description":"Number that identifies the lot.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true
            },
            "x-queryable":true
        },
        "__FLEX_Context_DisplayValue":{
            "title":"Context Value",
            "type":"string",
            "nullable":true,
            "x-hints":{
                "updateable":"false",
                "DISPLAYHINT":"Hide",
                "FND_ACFF_IsReadOnly":"true",
                "FND_ACFF_AkaRealSegmentAttrName":"__FLEX_Context",
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_ListDisplayAttrName":"Name",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"HIDDEN"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            },
            "x-queryable":true
        },
        "InventoryItemId":{
            "type":"integer",
            "description":"Value that uniquely identifies the inventory item.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true,
                "precision":"18"
            },
            "x-queryable":true
        },
        "__FLEX_Context":{
            "title":"Context Value",
            "maxLength":"30",
            "type":"string",
            "description":"Descriptive flexfield context name for lot attributes.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "FND_ACFF_ValueSetInfo":"_FLEX_ContextValueSet_Internal#INDEPENDENT",
                "controlType":"choice",
                "FND_ACFF_AkaAttrName":"__FLEX_Context_DisplayValue",
                "includeInCompactView":true,
                "FND_ACFF_IsDiscriminator":"true",
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"HIDDEN"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            },
            "x-queryable":true
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : inventoryItemLots-lotStandardDFF-item-response

Type: object

Show Source

• __FLEX_Context: string
  Title: Context Value

  Maximum Length: 30

  Descriptive flexfield context name for lot standards.
• __FLEX_Context_DisplayValue: string
  Title: Context Value
• InventoryItemId: integer (int64)
  Value that uniquely identifies the inventory item.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• LotNumber: string
  Title: Lot

  Maximum Length: 80

  Number that identifies the lot.
• OrganizationId: integer (int64)
  Value that uniquely identifies the organization.

{
    "type":"object",
    "properties":{
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "OrganizationId":{
            "type":"integer",
            "description":"Value that uniquely identifies the organization.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true,
                "precision":"18"
            },
            "x-queryable":true
        },
        "LotNumber":{
            "title":"Lot",
            "maxLength":"80",
            "type":"string",
            "description":"Number that identifies the lot.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true
            },
            "x-queryable":true
        },
        "__FLEX_Context_DisplayValue":{
            "title":"Context Value",
            "type":"string",
            "nullable":true,
            "x-hints":{
                "updateable":"false",
                "DISPLAYHINT":"Hide",
                "FND_ACFF_IsReadOnly":"true",
                "FND_ACFF_AkaRealSegmentAttrName":"__FLEX_Context",
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_ListDisplayAttrName":"Name",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"HIDDEN"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            },
            "x-queryable":true
        },
        "InventoryItemId":{
            "type":"integer",
            "description":"Value that uniquely identifies the inventory item.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true,
                "precision":"18"
            },
            "x-queryable":true
        },
        "__FLEX_Context":{
            "title":"Context Value",
            "maxLength":"30",
            "type":"string",
            "description":"Descriptive flexfield context name for lot standards.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "FND_ACFF_ValueSetInfo":"_FLEX_ContextValueSet_Internal#INDEPENDENT",
                "controlType":"choice",
                "FND_ACFF_AkaAttrName":"__FLEX_Context_DisplayValue",
                "includeInCompactView":true,
                "FND_ACFF_IsDiscriminator":"true",
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"HIDDEN"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            },
            "x-queryable":true
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : inventoryItemLots-supplierLotNumbers-item-response

Type: object

Show Source

• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• OrganizationId: integer (int64)
  Read Only: true

  Value that uniquely identifies the organization.
• SupplierLotNumber: string
  Read Only: true

  Maximum Length: 150

  Value that uniquely identifies the supplier lot number.

{
    "type":"object",
    "properties":{
        "SupplierLotNumber":{
            "maxLength":"150",
            "type":"string",
            "description":"Value that uniquely identifies the supplier lot number.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "OrganizationId":{
            "type":"integer",
            "description":"Value that uniquely identifies the organization.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Links

lotAttributeDFF

Operation: /fscmRestApi/resources/11.13.18.05/inventoryItemLots/{inventoryItemLotsUniqID}/child/lotAttributeDFF

Parameters:

• inventoryItemLotsUniqID: $request.path.inventoryItemLotsUniqID

A flexible data field that includes all the inventory item lot attribute flexfields.

lotStandardDFF

Operation: /fscmRestApi/resources/11.13.18.05/inventoryItemLots/{inventoryItemLotsUniqID}/child/lotStandardDFF

Parameters:

• inventoryItemLotsUniqID: $request.path.inventoryItemLotsUniqID

A flexible data field that includes all the inventory item lot flexfields.

supplierLotNumbers

Operation: /fscmRestApi/resources/11.13.18.05/inventoryItemLots/{inventoryItemLotsUniqID}/child/supplierLotNumbers

Parameters:

• inventoryItemLotsUniqID: $request.path.inventoryItemLotsUniqID

A supplier lot number associated with a lot.

Back to Top

Examples

This example describes how to update one lot.

Example cURL Command

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

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

Example 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 updates.

{
	"OriginationDate":"2018-12-05"
}

Example Response Body

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

{
	"OrganizationId": 207,
	"OrganizationCode": "M1",
	"OrganizationName": "Tall Manufacturing",
	"InventoryItemId": 663914,
	"ItemNumber": "INV-101",
	"ItemDescription": "Lot Item",
	"LotNumber": "SF20181206_1",
	"ParentLotNumber": null,
	"ActiveLotCode": "2",
	"ActiveLot": "Yes",
	"OriginationTypeCode": "0",
	"OriginationType": "Lot master",
	"StatusId": 1,
	"StatusCode": "Active",
	"Grade": null,
	"ExpirationActionCode": null,
	"ExpirationAction": null,
	"OriginationDate": "2018-12-05T00:00:00+00:00",
	"ExpirationDate": null,
	"MaturityDate": "2018-12-06T20:30:11+00:00",
	"ExpirationActionDate": null,
	"HoldUntilDate": "2018-12-06T20:30:11+00:00",
	"RetestDate": null,
	"links": [
	{
		"rel": "self",
		"href": "https://servername/fscmRestApi/resources/version/inventoryItemLots/00030000000EACED0005770800000000000000CF0000000EACED0005770800000000000A216A0000000C534632303138313230365F31",
		"name": "inventoryItemLots",
		"kind": "item",
		"properties": {
			"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000278"
		}
	},
	{
		"rel": "canonical",
		"href": "https://servername/fscmRestApi/resources/version/inventoryItemLots/00030000000EACED0005770800000000000000CF0000000EACED0005770800000000000A216A0000000C534632303138313230365F31",
		"name": "inventoryItemLots",
		"kind": "item"
	},
	{
		"rel": "lov",
		"href": "https://servername/fscmRestApi/resources/version/inventoryItemLots/00030000000EACED0005770800000000000000CF0000000EACED0005770800000000000A216A0000000C534632303138313230365F31/lov/ActiveLotLookupVA",
		"name": "ActiveLotLookupVA",
		"kind": "collection"
	},
	{
		"rel": "lov",
		"href": "https://servername/fscmRestApi/resources/version/inventoryItemLots/00030000000EACED0005770800000000000000CF0000000EACED0005770800000000000A216A0000000C534632303138313230365F31/lov/ItemVA",
		"name": "ItemVA",
		"kind": "collection"
	},
	{
		"rel": "lov",
		"href": "https://servername/fscmRestApi/resources/version/inventoryItemLots/00030000000EACED0005770800000000000000CF0000000EACED0005770800000000000A216A0000000C534632303138313230365F31/lov/AccessibleOrganizationVA",
		"name": "AccessibleOrganizationVA",
		"kind": "collection"
	},
	{
		"rel": "lov",
		"href": "https://servername/fscmRestApi/resources/version/inventoryItemLots/00030000000EACED0005770800000000000000CF0000000EACED0005770800000000000A216A0000000C534632303138313230365F31/lov/LotExpirationActionVA",
		"name": "LotExpirationActionVA",
		"kind": "collection"
	},
	{
		"rel": "lov",
		"href": "https://servername/fscmRestApi/resources/version/inventoryItemLots/00030000000EACED0005770800000000000000CF0000000EACED0005770800000000000A216A0000000C534632303138313230365F31/lov/OriginationTypeLookupVA",
		"name": "OriginationTypeLookupVA",
		"kind": "collection"
	},
	{
		"rel": "lov",
		"href": "https://servername/fscmRestApi/resources/version/inventoryItemLots/00030000000EACED0005770800000000000000CF0000000EACED0005770800000000000A216A0000000C534632303138313230365F31/lov/LotGradeVA",
		"name": "LotGradeVA",
		"kind": "collection"
	},
	{
		"rel": "lov",
		"href": "https://servername/fscmRestApi/resources/version/inventoryItemLots/00030000000EACED0005770800000000000000CF0000000EACED0005770800000000000A216A0000000C534632303138313230365F31/lov/InventoryStatusVA",
		"name": "InventoryStatusVA",
		"kind": "collection"
	},
	{
		"rel": "child",
		"href": "https://servername/fscmRestApi/resources/version/inventoryItemLots/00030000000EACED0005770800000000000000CF0000000EACED0005770800000000000A216A0000000C534632303138313230365F31/child/lotStandardDFF",
		"name": "lotStandardDFF",
		"kind": "collection"
	},
	{
		"rel": "child",
		"href": "https://servername/fscmRestApi/resources/version/inventoryItemLots/00030000000EACED0005770800000000000000CF0000000EACED0005770800000000000A216A0000000C534632303138313230365F31/child/lotAttributeDFF",
		"name": "lotAttributeDFF",
		"kind": "collection"
	}
	],
}

Back to Top