Custom Value Set not working after Upgrade from 11i to R12
We are in the process of upgrading from EBS 11.5.10 to R12.1.3Custom Value sets with a certain characteristics are not working in R12.
The characteristics is if multiple "Value" shares the same "ID" then an error is being raised.
Steps to Reproduce (A simplified scenario):
create table skr_tab1 (f1 varchar2(10), f2 varchar2(10))
insert into skr_tab1 values('A', 'A1');
insert into skr_tab1 values('A', 'A2');
Create Value Set:
Value Set Name : SKR_VS1
Format Type=Char, Maximum Size=10
Validation Type=Table
Edit Information:
Table Name=SKR_TAB1
Table Column Value = F2 (Varchar2 10)
Table ID Value = F1 (Varchar2 10)
The characteristics is if multiple "Value" shares the same "ID" then an error is being raised.
Steps to Reproduce (A simplified scenario):
create table skr_tab1 (f1 varchar2(10), f2 varchar2(10))
insert into skr_tab1 values('A', 'A1');
insert into skr_tab1 values('A', 'A2');
Create Value Set:
Value Set Name : SKR_VS1
Format Type=Char, Maximum Size=10
Validation Type=Table
Edit Information:
Table Name=SKR_TAB1
Table Column Value = F2 (Varchar2 10)
Table ID Value = F1 (Varchar2 10)
2