Interfaces

Oracle Warehouse Management Cloud supports multiple standard communication mechanisms in addition to client specific custom ones. Standard data formats are XML and flat files. Standard communication methods are Web Services (XML data) or secure FTP (SFTP) for XML or flat files.

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 at the top, then click the link under Current Documentation.

Note: WMS Cloud no longer hosts an SFTP site, though it has the capability to get and put files from and to an external SFTP site via scheduled jobs.

The following table lists the supported Ciphers, Key Exchange Algorithms, Digests and Host Key Algorithms:

Supported Options in SFTP Output Interface

Ciphers	Key Exchanges	Digests	Host Keys
aes128-ctr	[e-mail]	hmac-sha2-256	ssh-ed25519
aes192-ctr	ecdh-sha2-nistp256	hmac-sha2-512	ecdsa-sha2-nistp256
aes256-ctr	ecdh-sha2-nistp384	[e-mail]	ecdsa-sha2-nistp384
aes128-cbc	ecdh-sha2-nistp521	[e-mail]	ecdsa-sha2-nistp521
aes192-cbc	diffie-hellman-group16-sha512	hmac-sha1	ssh-rsa
aes256-cbc	diffie-hellman-group-exchange-sha256	hmac-md5	ssh-dss
3des-cbc	diffie-hellman-group14-sha256	hmac-sha1-96	rsa-sha2-512
	diffie-hellman-group-exchange-sha1	hmac-md5-96	rsa-sha2-256
	diffie-hellman-group14-sha1
	diffie-hellman-group1-sha1

Note:

1. The host key types "rsa-sha2-512" and "rsa-sha2-256" are additionally supported from 23C onwards.
2. The cipher "blowfish-cbc" is not supported.

REST WebService XML Payload Size: We recommend XML payloads no larger than 10MB, and preferably less than 5MB, to minimize performance issues. You can achieve this by splitting a data payload into multiple requests. Multiple interface requests can be made in parallel, but we recommend less than 10 simultaneously. The size of output interface payloads sent via REST WebServices can be controlled via the data filtering feature in output interfaces config. Payload limits on the output side, are more dictated by the target system, however there is a hard limit of 20MB in WMS Cloud and it is recommended that payloads be no larger than 10MB.

All languages are supported. We recommend that you use Web Services rather than SFTP as it offers several advantages. It is recommended that UTF-8 encoding is used for data in order to have the widest language compatibility, but other encodings are supported as well such as latin-1 (for western European languages only).

Whichever encoding is chosen must be configured in the Oracle Warehouse Management Cloud system so that data is interpreted accurately. If you have further question please contact The Oracle Warehouse Management Cloud services and support team.