My Oracle Support Banner

Supplier Integration Failure When Payment Term Has More Than 25 Characters in Name (Doc ID 2905507.1)

Last updated on OCTOBER 27, 2022

Applies to:

Oracle Retail Integration Cloud Service - Version 19.1 and later
Information in this document applies to any platform.

Symptoms

When integrating Suppliers from CFIN with payment terms having more than 25 characters in name, they are getting failed to process through RFI with below error:

"Error while loading data into RFI_SUPP_STAGEcom.oracle.retail.rfi.common.RFIServerException: Unable to execute ParametricStatement: insert into RFI_SUPP_STAGE
....
Since there was a problem processing Supplier data so SupplierSite data will not get processed.
Since there was a problem processing Supplier data so SupplierSite data will not get processed.
...."


Steps to Reproduce:
1. Create a payment term in CFIN with more than 25 characters in description.
2. Create a supplier which has this payment terms from step#1, assign all pre-requisite fields and publish to RFI.
3. Notice that it gets failed in RFI layer while inserting into RFI_SUPP_STAGE table.
4. Check in RFI logs for error details.

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!

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