Inbound EDI x12 856 transmission is received and translated into JDEdwards One World DB2 tables (F47031/F4706/F47032)
We are trying to translate the data in F47031/F4706/F47032 however there is an null field error. The JDBC generated error does not indicate the table or field.
EXTOL error message:
SQL exception error while attempting to perform SQL insert -- [SQL0407] Null values are not allowed in column or variable
In the EBI Auditor we did a search for '><'. When we performed the search, like the example below, we were able to find where there was a null value being passed.
By: Sean Hoppe on