Hi ,
I am using a custom account for user provisioning and responsibilities update via oracle EBS Connector. This account has following permissions --
GRANT CREATE SESSION TO "SRVACCOUNT"
GRANT EXECUTE ON "APPS"."FND_WEB_SEC" TO "SRVACCOUNT"
GRANT EXECUTE ON "APPS"."FND_USER_PKG" TO "SRVACCOUNT"
GRANT EXECUTE ON "APPS"."FND_LOAD_UTIL" TO "SRVACCOUNT"
GRANT EXECUTE ON "APPS"."FND_CORE_LOG" TO "SRVACCOUNT"
But Upon attempting user provisioning, The Adhoc projection jobs gets frozen with error--
[1777219] Error executing synchronization step (oRA-Account)!
[1777004] Method (Create new object (Insert)) could not be executed successfully.
[2604004] Object CN=xxxxx,O=ORA-Account,O=ORA-System,DC=xxxx.xxx.com not commited or checked (Error Error executing function Insert. (Message ORA-00942: table or view does not exist
ORA-06512: at "APPS.FND_CORE_LOG", line 45
ORA-06512: at "APPS.FND_CORE_LOG", line 462
ORA-06512: at "APPS.FND_WEB_SEC", line 47
ORA-06512: at "APPS.FND_USER_PKG", line 1312
ORA-06512: at "APPS.FND_USER_PKG", line 1599
ORA-06512: at "APPS.FND_USER_PKG", line 1718
ORA-06512: at line 2)
The User- Responsibilities update/insert job to insert new responsibility with user's ebs account in target system is also failing with similar error-
[1777219] Error executing synchronization step (userInRESPDirect)!
[1777004] Method (Create new object (Insert)) could not be executed successfully.
[2604004] Object UR=5617,O=UserInRespDirect,RP=0,O=ORA-RESP,RE=55555,O=ORA-Responsibility,AP=540,O=ORA-Application,O=ORA-System,DC=xxx.xxx.com not commited or checked (Error Error executing function Insert. (Message ORA-00942: table or view does not exist
ORA-06512: at "APPS.FND_USER_PKG", line 3188
ORA-06512: at line 2)
).
Is this a permission issue ? Please suggest where am i missing.
