Post stopped due to "Poster: 15033 - Failed to execute SQL on table "OWNER"."TABLE_NAME": ORA-014 (4260569)

Post stopped due to the following:

Poster: 15033 - Failed to execute SQL on table OWNER.TABLE_NAME: ORA-01400: cannot insert NULL into OWNER.TABLE_NAME.COLUMN). (posting from SID1, queue queue_name, to SID2) [module opo]

Post is trying to insert NULL into a column that has a constraint NOT NULL defined on it.

One reason can be that on source table there is no NOT NULL constraint on the column in question whereas on the target table the constraint is enabled. So when Post tries to insert a NULL, it fails. If this is the case, the workaround is to disable the NOT NULL constraint on the column in question and restart Post. If this is not the case, then Support needs to be conferred for any other issues/bugs, etc.

The workaround is:

1.Disable the NOT NULL constraint, the following SQL needs to be performed on the target table by a user with appropriate privileges:
SQL>alter table <tablename> modify <column name> null;
2.Start Post.
3.At a later time ascertain that the column can contain null values on both source and target or correct the constraint on source and/or target table as appropriate.

The solution applies to a particular scenario. There could be other reasons for receiving the error. Contact Support if the situation described above is not applicable.

Here are details on the Oracle error ORA-01400:

Oracle Error :: ORA-01400

cannot insert NULL into (string)

Cause:

An attempt was made to insert a NULL into the column USER.TABLE.COLUMN.

Action:

Retry the operation with a value other than NULL.