My Oracle Support Banner

Validation Check Job Submission is Failing with ORA-01400 (Doc ID 3070465.1)

Last updated on FEBRUARY 18, 2025

Applies to:

Oracle Life Sciences Data Management Workbench - Version 3.4.0.1 and later
Information in this document applies to any platform.

Symptoms

VC job submission is failing in Development life cycle with the below error.

Initiating source code execution. :: <date time>
Job failed with error(s). :: <date time>
ORA-01400: cannot insert NULL into ("<Schema>"."<table>"."<Key column>_<number>")
ORA-06512: at "<Schema>.<Package>", line <line number>
ORA-06512: at "<Schema>.<Package>", line <line number>
ORA-06512: at "<Schema>.<Insert Trigger>", line <line number>
ORA-04088: error during execution of trigger '<Schema>.<Insert Trigger>'
ORA-06512: at "<Schema>.<Package>", line <line number>
ORA-06512: at line 1

Changes

 The VC was copied from a template study.

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!

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