Output Interfaces

  • ASN verification
  • Parcel Manifest shipment confirmation
  • LTL Shipment confirmation
  • Inventory Summary
  • Inventory History
    Note: For more details on each interface, please refer to the Interface Specifications.
Note: To access the latest Interface Specifications, go to the Oracle WMS Cloud Information Center. From the top of the page, click on the Documentation tab, then click the link under Current Documentation.

Configure Output Interfaces Generation In UI Through Output Interface Configuration Screen

You can configure Ouput Interfaces generation and targets in UI through Output Interface Configuration Screen

for following files:
  • Container Outbound Load Export
  • Custom Inventory Summary Export
  • Data Extract

  • Distribution Info

  • Iblpn Info

  • Iblpn Report

  • Inbound Shipment Verifications Export

  • Inventory History Export

  • Inventory Summary Export

  • LPN Inventory

  • OBLPN Shipping Info

  • Order Outbound Load Export

  • Order Verification Export

  • Outbound Loads Export

  • Outbound Manifest

  • Output Item Export

  • Output Item Facility Export

  • Pallet Shipping Info

  • Route Instruction

  • Wave Pick Info

  • Web Report

SOLUTIONS:

Considerations - 1

On completing this configurations, WMS will automatically send the interface to the output target(s). In Output Interface Configuration screen, you have the option to select following Interface Formats (if available for the interface type):

  • Header/Detail
  • Hierarchical
  • One Line
  • XML

Once an interface is generated, you can check the delivery status in Output Interface screen, download, or re-send it.

Consideration - 2

Send files to an external SFTP:

1. Go to Output Interface Configuration UI screen

2. Select the Interface Type that you wish to configure

3. Click on the “Output Interface Target” icon which is located next to the search icon at the top-left.

4. Select the only line available and click on the “Edit” icon. Complete as shown bellow:
  • Sequence Nbr:1
  • MHE System: blank
  • Interface Protocol *: External SFTP
  • URL: blank
  • FTP Host: Your SFTP Host
  • FTP Port: Your SFTP Port
  • Target Directory: The SFTP directory you want the file to be located
  • Username: Your SFTP user
  • Password: Your SFTP password
  • Encrypt File: unchecked
  • Encrypt Recipient: blank
  • Send Acknowledgment Email: unchecked
  • Max Retries: 3
  • Retry Delay (Seconds): 10
  • Send Failure Email: Check if you want to receive an email when it fails
  • Custom Integration: unchecked
  • Enabled: checked

5. Repeat steps for other interface types

Consideration -3

Send files through REST Web Service

1. Go to Output Interface Configuration UI screen

2. Select the Interface Type that you wish to configure

3. Click on the “Output Interface Target” icon which is located next to the search icon at the top-left.

4. Select the only line available and click on the “Edit” icon. Complete as shown bellow:

  • Sequence Nbr:1
  • MHE System: blank
  • Interface Protocol *: External SFTP
  • URL: Web Service URL
  • FTP Host: blank
  • FTP Port: blank
  • Target Directory: blank
  • Username: Your Web Service user
  • Password: Your Web Service password
  • Encrypt File: unchecked
  • Encrypt Recipient: blank
  • Send Acknowledgment Email: unchecked
  • Max Retries: 3
  • Retry Delay (Seconds): 10
  • Send Failure Email: Check if you want to receive an email when it fails
  • Custom Integration: unchecked
  • Enabled: checked

5. Repeat steps for other interface types

Consideration - 5

Output Interface Criteria

Here, you can configure criterias to make WMS select an output target depending on the interface’s content. For example, you can have an interface delivered to TARGET-A (SFTP) if the interface contains ITEM-A, or TARGET-B (Web Service) if the interface contains ITEM-B.

1. Go to Input Interface Configurations screen.

2. Select the required interface and click on “Output Interface Target”.

3. Configure more than 1 target with difference sequence numbers (as explained in previous steps).

4. Click on each and click on “output_interface_target_criteria”.

5. Click on add (+) and complete, for example:
  • Column name: Shipment Type
  • Sql operator: =
  • Column value: SHIPMENT-A

6. Configure criteria for other targets