Error: gm.process_batch_detail; ORA-01400: cannot insert NULL into (PBDS.TRIB_NOTIFICATION_EXCLUDE.TRIBUTE_SEQ) - when checking gm_error_log for a batch that failed to post with Contact System Adminstrator message

A batch fails to post and the log shows an error message that says "Contact System Administrator".

So you run the following query to get the detailed error message:
 
SELECT * 
FROM   PBDS.GM_ERROR_LOG
WHERE  BATCH_NUMBER = [Batch number]
      AND ERROR_LEVEL = 'E';

The error message in this case is:
 
gm.process_batch_detail; ORA-01400: cannot insert NULL into ("PBDS"."TRIB_NOTIFICATION_EXCLUDE"."TRIBUTE_SEQ") 
The root cause is not known at this time but you can resolve it by going to the Batch Sequence specified in GM_ERROR_LOG table, zooming in on the Tribute, and deleting the recurring Tribute with the exclude box checked. You can add the recurring Tribute again after posting this batch.

Steps to Duplicate


Was this article helpful?