My Oracle Support Banner

Supplier Message Integration Failure When Processing RFI_SUPP_CONTACTS_STAGE.TITLE Column (Doc ID 2883041.1)

Last updated on JULY 14, 2022

Applies to:

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

Symptoms

Cloud Financials (CFIN) side HZ_ORG_CONTACTCS.JOB_TITLE is mapped to Oracle Retail Financial Integration (RFI) side RFI_SUPP_CONTACTS_STAGE.TITLE column. First is having the length of varchar2 (100) whereas later is defined with varchar2(30) limit only and resulting in below kind of failures when processing a Supplier message with <JobTitle> containing more than 30 characters.

Error:
[[ACTIVE] ExecuteThread: '19' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR SupplierExportOutboundBean - Supplier loading into staging tables failed, Marking supplier XYZ as error.
....
Caused by: java.sql.SQLException: ORA-12899: value too large for column "CFIN_RFI_INT"."RFI_SUPP_CONTACTS_STAGE"."TITLE" (actual: 34, maximum: 30)
...
Caused by: oracle.jdbc.OracleDatabaseException: ORA-12899: value too large for column "CFIN_RFI_INT"."RFI_SUPP_CONTACTS_STAGE"."TITLE" (actual: 34, maximum: 30)

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.