ORA - 02291 Error coming

[smrutiranjannayak]

Hi All Gurus ,

I am doing a job where the following scenario is there .

There is 1 source table (table 1)and one look up table (table 2) .

These tables are joined on a key . Now in out put i am trying to update the same look up table (table 2) putting "Update or insert records" in SQL prompt in OCI stage .

The problem i am facing is :
Error :
"jbLdIndTermFCChg..sOciibicfcPayFinder_Update: ORA-02292: integrity constraint (FC_COMP.IP_PAY_DEAL_RECORD_FK) violated - child record found"

I have even tried putting a hash file instead of table 2(look up table ). But still getting same error .

Please suggest ?

[chulett]

Talk to your DBA, they can explain exactly what you are doing wrong that would violate a foreign key constraint like that.

[Sankaranandam Selvaraj]

Nayak,

I think the key used for lookup is different from the foreign key and you are trying to update the lookup table including the foreign key which is reffered by a child record from other table.

Thanks,

Sankaranandam. Selvaraj

Hi All Gurus ,

I am doing a job where the following scenario is there .

There is 1 source table (table 1)and one look up table (table 2) .

These tables are joined on a key . Now in out put i am trying to update the same look up table (table 2) putting "Update or insert records" in SQL prompt in OCI stage .

The problem i am facing is :
Error :
"jbLdIndTermFCChg..sOciibicfcPayFinder_Update: ORA-02292: integrity constraint (FC_COMP.IP_PAY_DEAL_RECORD_FK) violated - child record found"

I have even tried putting a hash file instead of table 2(look up table ). But still getting same error .

Please suggest ?