My Oracle Support Banner

PRC:POZ:Import Supplier Process In Status RETRYING And Taking Too Long To Complete (Doc ID 2495426.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Fusion Purchasing Cloud Service - Version 11.13.18.05.0 and later
Oracle Fusion Purchasing - Version 11.13.18.05.0 and later
Oracle Fusion Supplier Model - Version 11.13.18.05.0 and later
Oracle Fusion Supplier Model Cloud Service - Version 11.13.18.10.0 and later
Information in this document applies to any platform.

Symptoms

Import Supplier process

After user submit the Import Supplier Process, the status changes to RETRYING and it is taking too long to complete.
Process log reports a generic data error:

ERROR
-----------------------
Import Suppliers with InterfaceId = <number> is rejected due to error occured during updateSupplier.
## Import Suppliers with VendorInterfaceId = XXXXXX is rejected. Please see Rejection Table for details.
## There is no validation exception but rejection list is not empty.
## Exception stacktrace:
oracle.jbo.TxnValException: JBO-27023: Failed to validate all rows in a transaction.
## getState RUNNING
## Application module null is released.

but the process ends with status = succeeded and the Suppliers Import Report file shows that all 5 records were imported.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate Import Supplier template file
2. Execute Import Supplier process
3. Review log file and Suppliers Import Report


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.