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.
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.
"File generation failed with error code: 1. IB123 - ORA-00932: inconsistent datatypes: expected - got NCLOB".
where IB123 = th Shipment number
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".
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