This discussion is archived
4 Replies Latest reply: Oct 9, 2012 1:27 AM by Cvele_new_account RSS

ADF BC table ordering for SQL operation

Pola Newbie
Currently Being Moderated
Oracle: 11g
JDev version: 11.1.1.6.0

Have 3 tables
1. EMP_TAB      
2. EMP_DEP_MAP_TAB          
3. DEP_TAB

Data Model:
-- EMP_TAB
-- DEP_TAB
-----EMP_DEP_MAP_TAB

User Flow:
1. Navigate to Department page
2. It will display Employee Name
3. 'Assign Employee' button is provided to assign employess to department
4. When user clicks 'Assign Employee' button, popup is shown with Empoyee detaills and a check box to select. Even user can add/delete Employess in Popup

When user does selection of already saved Employees, there is no issue. But when user tries to add and assign to department, sometimes it works and some times throws "ORA-02291: integrity constraint (EMP_DEP_MAP_TAB_FK) violated - parent key not found"

Question: Can we provide order like first insert EMP_TAB and then EMP_DEP_MAP_TAB

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points