This content has been marked as final. Show 6 replies
compare the values in database for this form with the visible one.
look at SDK table and verify below
1. if the given win_key is valid in the WIN table
3.SDK_TYPE=P (if this is process form)
Probably corresponding entry in the WIN table is missing... or corrupt...
Obtaing SDK_KEY and search whether there is any valid entry in the WIN table...
Yes i can see the table name both in SDK and WIN
SDK_ORC=1 and SDK_TYPE= p
look at formmetadata.xml
See the following tables... SDK. UWP, WIN, DAV, DOB, SEL...1 person found this helpful
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 table1 person found this helpful
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'