This content has been marked as final. Show 12 replies
I think no need to create Recon profile while creating new GTC, hope it will create automatically, anyhow I have created recon profile manually, did purge and restarted the server too but getting the same exception again.
I'm trying to fetch new/updated records from DB(trusted) to OIM using OOTB Application table connector.
Displayname (custom field) --> Displayname
is my current mappings.
@Gyanprakash : I have one key field in my mappings and that field is there in recon rule too
@User7609 : I have created new fileds in recon staging table and mapped to respective fields in oim.
How did you fixed that issue?
1. provide the userlogin constant and lets see how it work.
go to process definition-> field mapping-> map the key field wih literal value(hope userlogin is the key field)
if above works can try below
2. update the rule as case Insensitive : (normally oim store userlogin in Caps and the incomming data may be in small one)
even mark key field mapping as case insensitive
whenever make anay changes on mapping make sure you click on "Create Reconciliation profile"
As per my requirement,I kept other field as Key field and it holds only numbers, also I have checked userlogin as case insensitive. Eventhough I have made Userlogin field as literal and hardcode the userlogin in caps and created reconciliation profile. But getting the same exception.
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
ORA-06512: at "TST_OIM.OIM_SP_RECONBLKUSERCRUD", line 3925
ORA-06512: at "TST_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 71
ORA-06512: at line 1
Edited by: S.K.N on Jul 18, 2012 12:26 PM