R12: Payment Workbench Error: ORA-01400 primary key or mandatory (NOT NULL) column is missing or NULL during insert (APXPAWKB.FMB) (Doc ID 1311240.1)

Last updated on JUNE 15, 2016

Applies to:

Oracle Payables - Version 12.0.3 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Form:APXPAWKB.FMB - Payment Workbench


Symptoms

The purpose of this note is to explain known causes of the "ORA-01400 primary key or mandatory (NOT NULL) column is missing or NULL during insert" database error in the EBS Payables module, payment workbench.  This note attempts to step the reader through all known setup issues as well as known bugs that can cause this error to occur. 

Cause

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 hundreds of Community platforms