Not Able To Create Virtual Pk On Nullable Columns (Doc ID 430662.1)

Symptoms

-- Problem Statement:
On 10.2.0.2 in Production:
When attempting to create a Publication Item with a Virtual PK
the following error occurs:

ERROR
ORA-01449 column contains NULL values; cannot alter to NOT NULL


-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
msql <USER>/<PASSWORD> @jdbc:oracle:thin:@<HOST>:PORT:<DB>

create table <TABLENAME> (col1 number, col2 varchar2(100));

insert into <TABLENAME> (col1,col2) values(1,'');

commit;

Start MDW:
create a new Project.

Add the Virtual PK on the Both Columns of the table <USER>.<TABLENAME>.

create the publication Item <PUBLICATION ITEM> in fast refresh mode
select the table <USER>.<TABLENAME> with the two columns -> it will fails with the Error: CONS-10049:
Consolidator Exception: ORA-01449:column contains NULL values; cannot alter to NOT NULL

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.