This content has been marked as final. Show 6 replies
See the following tables... SDK. UWP, WIN, DAV, DOB, SEL...
There must be something missing somewhere....
SELECT * FROM SDK WHERE WIN_KEY=242;
SELECT * FROM UWP WHERE WIN_KEY=242;
SELECT * FROM WIN WHERE WIN_KEY=242;
SELECT * FROM DAV WHERE DOB_KEY=182 ;
SELECT * FROM DOB WHERE DOB_KEY=182 ;
SELECT * FROM DVT WHERE DOB_KEY=182 ;
SELECT * FROM SEL WHERE DOB_KEY=182 ;
SELECT * FROM WIN WHERE DOB_KEY=182 ;
verify entries in FUG table
below tables are being used for process form
If you are unable to resolve. delete the entries from all these tables for the SDK_KEY=<your process form SDK_key>. verify using SDK table and delete one by one. wherever, it shows the constraint violation just remove child table first and then restart oim. Now you can create new form using same form name
for locating all the linked table, login to oimdb using oim user and run below query
select * from user_tab_cols where column_name like 'SDK_KEY'