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.