Hi,I get the following oracle error message in ‘Customer Invoices with errors’ window since 3rd May. ”ORA-01400: cannot insert NULL into ("IFSAPP"."CUSTOMER_INFO_ADDRESS_CFT"."ROWKEY")” I have added a new custom field to CustomerOrder LU on the same day. Only CUSTCOLDEB (debit collective invoices) shoots out this error.Code in new CFSELECT 'Företag - Återstående limit' || CHR(13) || CHR(10) || cl.comp_limits AS "Företag och återstående limit"FROM (SELECT LISTAGG(COMPANY || ' - ' || CASE WHEN CREDIT_BLOCK = 'TRUE' THEN 'STOPPAD' ELSE TO_CHAR(ROUND(NVL((SELECT remain_credit1 FROM IFSAPP.customer_credit_collection_qry q WHERE q.identity = c.identity AND q.company = c.company), CREDIT_LIMIT)), 'FM999G999G999') END, CHR(13) || CHR(10)) WITHIN GROUP (ORDER BY COMPANY) comp_limitsFROM IFSAPP.CUSTOMER_CREDIT_INFO_CUST c
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.