HCM Bundle 14 11.1.9.2 Patch 22529705 Failing With JBO-FND:::FND_VS_INVALID_ENABLE_COL_TYPE Error (Doc ID 2175352.1)

Last updated on AUGUST 26, 2016

Applies to:

Oracle Fusion General Ledger - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Goal

HCM Bundle Patch fails with the following error message.

[2016-08-20T11:06:34.946-04:00] [apps] [ERROR] [] [oracle.apps.fnd.applseed.rt.loader.core] [tid: 10] [ecid: 0000LQcTCeD7i48Lrio2yY1Ni6zH000002,0] oracle.apps.fnd.applseed.rt.loader.exception.SDLoaderException: Loading failed with a JboException: JBO-FND:::FND_VS_INVALID_ENABLE_COL_TYPE: <MESSAGE><NUMBER>FND-2786</NUMBER><TEXT>In the HRX_US_PRIMARY_ADDRESS value set, the data type for the enabled setting of the value set must be VARCHAR2(1).</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>.[[
Detailed Messages: JBO-FND:::FND_VS_INVALID_ENABLE_COL_TYPE: <MESSAGE><NUMBER>FND-2786</NUMBER><TEXT>In the HRX_US_PRIMARY_ADDRESS value set, the data type for the enabled setting of the value set must be VARCHAR2(1).</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>

at oracle.apps.ad.worker.AdJavaWorker.invokeUtility(AdJavaWorker.java:757)
at oracle.apps.ad.worker.AdJavaWorker.main(AdJavaWorker.java:451)
Caused by: oracle.jbo.RowValException: JBO-FND:::FND_VS_INVALID_ENABLE_COL_TYPE: <MESSAGE><NUMBER>FND-2786</NUMBER><TEXT>In the HRX_US_PRIMARY_ADDRESS value set, the data type for the enabled setting of the value set must be VARCHAR2(1).</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>
at oracle.jbo.rules.AbstractValidator.createRowException(AbstractValidator.java:1900)

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms