Business Validation for Partner Load Fails With ORA-01400 Error (Doc ID 2739705.1)

Last updated on JULY 25, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Business Validation for Partner load fails with the below error.

@0PACKAGE_ERROR@1ORA-01400: cannot insert NULL into ("RDC01"."SVC_ADMIN_UPLD_ER"."ROW_SEQ")@2DC_PARTNER_SQL.PROCESS

Steps to reproduce:
-------------------

Perform partner load in such a way that, for a partner there is record present in the partner file but no record in address file or there is record present in address file, but no record in partner file.
Perform business validation for the load.
Note the business validation fails with

	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

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