Field "address4" can't be returned: Please make sure that the external code for picklist

[apederiva]

Hello everybody,

we implemented the employee replication from EC to HCM using HCI prep. content.

Our EC consultant changed parameterization of the address field "address4" from picklist to normal field.

Now when we execute query from HCI we have this log:

<message_text>Field "address4" can't be returned: Please make sure that the external code for picklist "PROVINCE_NLD" with option ID "12" is valid. If this is a migrated picklist, please maintain missing non-unique external codes for this picklist.</message_text>

It's just a warning but in the data extraction we don't see the field "address4":

any suggestion?

 <address_information>

<address1>EXTRA</address1>
        <address2>LOCA</address2>
        <address3>STREET</address3>
        <address5>APRTME</address5>
        <address_type>home</address_type>
        <city>cITY</city>
        <country>NLD</country>

[ricardocandeias]

export your picklist and check if there is an externalcode in optionid 12

[former_member24508]

Hi Did you manage to solve this one i'm facing a similar issue 🙂