My Oracle Support Banner

Inbound Shipment Verification File Not Generated. Error Code:1. SHIPMENT_NUMBER - ORA-00932 (Doc ID 2591634.1)

Last updated on SEPTEMBER 30, 2019

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

On : 19.3 version, Performance Issues



When attempting to do the Shipment Verification on the ASN tab an error is displayed/
"IB123" is the shipment number.

Very important to notice that this is only occurring with Shipment types called "IB".

The ASN is verified correctly, but the file is not generated.

ERROR
-----------------------
"File generation failed with error code: 1. IB123 - ORA-00932: inconsistent datatypes: expected - got NCLOB".
where IB123 = th Shipment number


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to "ASN" tab.
2. Choose an ASN of the "IB" Shipment Type and Click on the "Verify" Button.
3. Then, you will see the following message: "File generation failed with error code: 1. IB123 - ORA-00932: inconsistent datatypes: expected - got NCLOB".

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
Cause
Solution
References


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