Hi Gurus,
I am using JDeveloper 11.1.2.4.0.
I have 3 EOs. Employees (master) , dependent (detail) , dependent_doc (detail table of dependent).
emp_no is the primary key in Employees table, emo_no + dpendent_no is the primary key in dependent table and emp_no +dependent _no+doc_no is primary key in dependent_doc table.
These EOs kave foreign key relation in DB and associations.
As per my applications requirement emp_no generation is depends upon a configuration specified in a config table so can't make it as a sequence.
So i am generating emp_no in the BEFORE INSERT ROW trigger of Employees table.
For properly updating emp_no in child table i given refresh on insert for emp_no attribute in these 3 EOs and in associations i selected Composition Association and Cascade update Key attributes .
So i am expecting by these settings emp_no in all 3 table get updated accurately.
When i tested my application module i found that
1) emp_no generated from trigger and updated in Employees and dependent tables as expected.
2) But for the third level child table (dependent_doc) table the emp_no is not getting updated even though there is refresh on insert/update option and Cascade update Key attributes in association.
Can any body say why cascade update not working in 3rd level child ?
Do i have to do any other settings ?
awaiting helpful response from all of you.
Thanks & regards,
Gijith.