You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

TOWN_OR_CITY Length Mismatch in Oracle fusion and EBS

edited Sep 29, 2025 12:55PM in Human Capital Management 1 comment

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!