TOWN_OR_CITY Length Mismatch in Oracle fusion and EBS
We have an integration system set up to synchronize address information from Oracle Fusion to EBS. Recently, we’ve observed that this integration is failing. After conducting a detailed investigation, we discovered that the issue stems from a mismatch in the character length allowed in one of the fields. Specifically, in the Oracle Fusion table PER_ADDRESSES_F, the TOWN_OR_CITY field is defined as VARCHAR2(60), allowing for up to 60 characters. In contrast, in the EBS table PER_ADDRESSES, the same field is defined as VARCHAR2(30), permitting only 30 characters.
This discrepancy in character limits is causing the synchronization process to fail. We are seeking a solution to resolve this issue. Could you please assist us?
Tagged:
0