Solved

ORA-01400: cannot insert NULL into ("IFSAPP"."CUSTOMER_INFO_ADDRESS_CFT"."ROWKEY")

  • 8 May 2023
  • 1 reply
  • 266 views

Badge +3

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 CF

SELECT '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_limits
FROM IFSAPP.CUSTOMER_CREDIT_INFO_CUST c
WHERE IDENTITY =  :customer_no) cl
WHERE :objstate IN ('Planned', 'Released', 'Blocked')
AND NOT EXISTS (SELECT 1 FROM IFSAPP.company_site
WHERE contract = :customer_no)

 

In CUSTOMER_INFO_ADDRESS_TAB, Rowkey is set to Nullable FALSE and default value is set to sys_guid().

 

Any idea why this error message occurs?
Appreciate your time.

Version - IFS Apps10 UPD16

icon

Best answer by Vinoy Heshan 9 May 2023, 08:00

View original

1 reply

Badge +3

Issue resolved. The issue was with an integration during invoicing fee lines. 

Reply