File Format Error ORR_4 Input: File Excp creating ORDER: new row for relation "order_hdr" violates check constraint "order_hdr_dest_cust" From SFTP.
(Doc ID 2431001.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Warehouse Management Enterprise Edition Cloud Service - Version 9.0.0 and later
Information in this document applies to any platform.
On : 9.0.0 version, Input and Output Interfaces
When attempting to insert into interface from SFTP., the following error messages is raised:
Error was ORR_4b34b1b6-93b8-11e8-bb55-eee986631295_20180730052118.tal
File type application/octet-stream format is not supported or mismatch in extension and file type.
Excp creating ORDER: new row for relation "order_hdr" violates check constraint "order_hdr_dest_cust"
DETAIL: Failing row contains (....).
_0f6af468-9167-11e8-bb55-eee986631295_20180727063454|13387127|JHB|For order number ...., either destination customer name must be blank and the destination facility set or the destination facility must be set and the destination customer must be blank. (destina,,,,)
The issue can be reproduced at will with the following steps:
1. Responsibility: Oracle Warehouse Management Enterprise Edition Cloud Service
2. Input and Output Interfaces from SFTP
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document