My Oracle Support Banner

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

Last updated on JANUARY 08, 2021

Applies to:

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

Symptoms

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:
-------------------

  1. 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.
  2. Perform business validation for the load.
  3. Note the  business validation fails with 

 

 

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!

In this Document
Symptoms
Cause
Solution
References


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