Noticed that the postal column is null if the postal_add is null in these document views: C_DUNNING_HEADER_V.sql C_DUNNING_HEADER_VT.sql C_INVOICE_HEADER_V.sql C_INVOICE_HEADER_VT.sql C_ORDER_HEADER_V.sql C_ORDER_HEADER_VT.sql DD_ORDER_HEADER_V.sql DD_ORDER_HEADER_VT.sql M_INOUT_HEADER_V.sql M_INOUT_HEADER_VT.sql rv_t_1099extract.sql
Solution si to change the
l.postal || l.postal_add AS postal,
with
COALESCE(l.postal,'') || COALESCE(l.postal_add'') AS postal,
And similar for all address fields in rv_t_1099extract.sql
Environment
None
Activity
Show:
Carlos Ruiz February 16, 2022 at 10:59 AM
NOTE here from my tests.
The problem was just visible in postgresql:
The following SQL statement:
SELECT 'abc'||NULL FROM dual
returns NULL in postgresql, but it returns abc in oracle
Major
Noticed that the postal column is null if the postal_add is null in these document views:
C_DUNNING_HEADER_V.sql
C_DUNNING_HEADER_VT.sql
C_INVOICE_HEADER_V.sql
C_INVOICE_HEADER_VT.sql
C_ORDER_HEADER_V.sql
C_ORDER_HEADER_VT.sql
DD_ORDER_HEADER_V.sql
DD_ORDER_HEADER_VT.sql
M_INOUT_HEADER_V.sql
M_INOUT_HEADER_VT.sql
rv_t_1099extract.sql
Solution si to change the
l.postal || l.postal_add AS postal,with
COALESCE(l.postal,'') || COALESCE(l.postal_add'') AS postal,And similar for all address fields in rv_t_1099extract.sql