Support JSON Format and Serial Number Tracking in Item Input Interface
To process data accurate and smoothly, we now use Stage Tables for all input types like JSON, XML, and Flat Files in Oracle Warehouse Management Cloud. We have introduced a new JSON format that lets you customize sample files while still following required fields.
Now, all data goes through Stage Tables, allowing you to catch multiple errors, provide better tracking with GET support, and drill-down views for Required Serials. We’ve also updated the API to follow lgf guidelines and added new options to handle different data flows, including asynchronous processes. You can now track how each order is received, and we make sample JSON files available through the input interface for easier setup.
JSON FORMAT SUPPORT FOR ITEM INTERFACE
Item Interface now supports JSON format through a new API. This API loads item data into stage tables, maintaining the current extraction process. You can process JSON payloads either synchronously or asynchronously, depending on the API parameters. With JSON support, the Item Interface becomes more efficient and scalable.
SERIAL NUMBER TRACKING LEVEL IN JSON
A new field, Serial Number Tracking Level (serial_number_tracking_level), has been introduced in the Item JSON file. The system accepts the following values:
Serial Number Tracking Level | Description |
---|---|
0 | No Serial Tracking |
1 | Track at Packing Level |
2 | End-to-End Tracking |
If any other value is provided, the system throws an error. Blank values are allowed for backward compatibility.
Please refer to: Control Serialization at the Item Level.
Also, the new API includes an async parameter to control processing mode.
URL
POST.../wms/lgfapi/v10/stage/item
Parameters:
Parameter | Type | Required | Description |
---|---|---|---|
async_flg | Boolean | No | Runs the interface asynchronously (true) or synchronously (false). Defaults to false. |
The ‘serial_nbr_tracking_level’ flag is now supported in the JSON interface. You can configure serial tracking levels with various values to manage item tracking effectively.
NOTE:
-
When the company parameter is set to '0', '1', or '2' and serial_nbr_tracking_level is '0', the system does not allow configuring serial tracking for an item.
-
If an invalid configuration occurs, the system throws the error: "Cannot configure serial number tracking level for a non-serial item."
Steps to Enable
You don't need to do anything to enable this feature.