Creating ASN through Interfaces (UI)
You can also create ASNs through an Oracle WMS Cloud Excel template.
Step 1: Preparing the Input Interface file:
To correctly use the Oracle WMS Cloud interface, follow the rules below:
- The filename must start with the letters “ISS” (for hierarchical files).
- Populate the “required” columns specified in the interface specification document.
- Populate [H1] for every distinct ASN number and [H2] for its details (see figure below).
- Populate the correct sequence in the ‘seq_nbr’ field (i.e. no duplicate
values).
The figure above is an example of a file that will create two different ASNs. Users can create multiple ASNs within the same ISS file by using the “headings” column to differentiate one ASN record from another. A ‘[H1]’ value denotes a new ASN Header record, while a ‘[H2]’ value denotes a new ASN Detail record.
Step 2: Uploading the Interface file into Oracle WMS Cloud
- Go to the “Input Interface” screen.
- Use the drop-down to select the appropriate interface to process:
- Click on “Upload Files” and navigate to the file you want to upload.
- When the screen displays the file, click “Run Interface”.
- The system will return a message dialog notifying that the file has been successfully processed.