Extract Run is failing with ORA-01400: cannot insert NULL into (???)

Team,

We ran our custom extract, which is failing and not generating any output, including XML. The log file is attached. If anyone has any ideas on fixing this issue, please share your inputs.

The error we're getting in the log file is:

Begin inside second_stats -- Set the reason.

Exception inside second_stats -- Task_instance_id proc : ORA-01400: cannot insert NULL into (???)

Begin inside second_stats -- After Payroll Run

Exception inside second_stats -- After Payroll Run Error : ORA-01403: no data found