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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.