My Oracle Support Banner

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.

Symptoms

On : 9.0.0 version, Input and Output Interfaces

When attempting to insert into interface from SFTP., the following error messages is raised:

ERROR
-----------------------

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.


1)
13387127
Excp creating ORDER: new row for relation "order_hdr" violates check constraint "order_hdr_dest_cust"
DETAIL: Failing row contains (....).

2)

_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,,,,)


STEPS
-----------------------
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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.