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.
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.
[[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)
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