Supplier Import Completes with Error - TxnValException: JBO-27023: Failed to validate all rows in a transaction

(Doc ID 1512585.1)

Last updated on APRIL 10, 2017

Applies to:

Oracle Fusion Supplier Model - Version 11.1.4.0.0 and later
Oracle Fusion Supplier Model Cloud Service - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.4.0.0 version, Manage Supplier Information-Manage Supplier Profiles

When attempting to import Supplier the following error occurs.

ERROR
-----------------------

## Invoking invokeImportMethod..
## In method invokeImportMethod...
## Parameters - importRequestId: 1340 ,prcBuId: null ,importOptions: ALL ,jobSelected: ImportSupplier ,reportExpOnly: N
## Creating instance of SupplierImportAM...
## Import job selected is: ImportSupplier
## Invoking supplierImportAM.importSuppliers...
## Exception stacktrace:
 oracle.jbo.TxnValException: JBO-27023: Failed to validate all rows in a transaction.
 oracle.jbo.server.DBTransactionImpl.validate(DBTransactionImpl.java:4599)
 oracle.apps.prc.poz.suppliers.protectedModel.supplierImport.applicationModule.SupplierImportAMImpl.importSuppliers(SupplierImportAMImpl.java:3664)
 oracle.apps.prc.poz.supplierImport.ess.program.ImportScheduler.invokeImportMethod(ImportScheduler.java:212)
 oracle.apps.prc.poz.supplierImport.ess.program.ImportScheduler.execute(ImportScheduler.java:156)
 oracle.apps.fnd.applcp.request.exec.ExecutableWrapper.executeHelper(ExecutableWrapper.java:94)
 oracle.apps.fnd.applcp.request.exec.ExecWrapperBase.execute(ExecWrapperBase.java:150)
 oracle.apps.fnd.applcp.request.exec.ExecutableWrapper.execute(ExecutableWrapper.java:81)
 oracle.as.scheduler.rp.JavaSysExecWrapper$1.run(JavaSysExecWrapper.java:353)
 oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
 oracle.security.jps.internal.jaas.AccActionExecutor.execute(AccActionExecutor.java:74)
 oracle.security.jps.internal.jaas.CascadeActionExecutor$SubjectPrivilegedExceptionAction.run(CascadeActionExecutor.java:83)
 weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
 weblogic.security.Security.runAs(Security.java:61)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate the Supplier Import Interface tables.
2. Login to Supplier Workbench as Buyer
3. Click on the Import drop down box on the upper right hand corner and choose Supplier Import
4. Notice that the Program completes with error.



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