My Oracle Support Banner

After 19C Update Crediting Error ORA-01400: cannot insert NULL into (???) (Doc ID 2580304.1)

Last updated on AUGUST 22, 2019

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.19.07.0 and later
Information in this document applies to any platform.

Symptoms

Post 19C upgrade, Crediting process errored out.


ERROR MESSAGE
Unexpected exception
End of determine_logical_batches with error
CN_TP_DIRECT_CREDITS.generate_direct_credits.g_exc_error
CN_TP_CREDIT_TXNS.generate_credits.g_exc_error
Unexpected Error : ORA-01400: cannot insert NULL into (???)
End of cn_tp_credit_txns.generate_credits

 

STEPS
Navigator > Credits and Earnings > Run Crediting
OR
Navigator > Credits and Earnings > Run Crediting And Rollup

NOTE: One of these jobs could be from the jobset Run All Transaction Processes

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.