We are trying to configure Oracle E-Business application using OOTB Oracle E-Business connector using Non APPS user. But while provisioning, We are facing error.
Error: ORA-20001: Custom user name validation in subscription to event oracle.fnd.user.name.vali date failed. ORA-06512: at “APPS.APP_EXCEPTION”, line 72 ORA-06512: at “APPS.FND_USER_PKG”, line 4207 ORA-06512: at “APPS.FND_USER_PKG”, line 1328 ORA-06512: at “APPS.FND_USER_PKG”, line 1599 ORA-06512: at “APPS.FND_USER_PKG”, line 1718 ORA-06512: at line 1
Not a very helpful answer, but when looking for cases related to this error message, I found one where the resolution was to double check the permissions - unfortunately the case didn’t state specifically which permissions.
We executed the queries provided in the documentation and noticed that for some tables, there is a “#” at the end of the table name when running the “select table_name, privilege from dba_tab_privs where grantee = ‘’ order by table_name, privilege” query to check the privileges assigned to the role
For instance, while the SailPoint-related document refers to the table as FND_USER, the result set of the query showed it as “FND_USER#”.
We would appreciate your feedback regarding any differences and potential conflicts, as SailPoint may expect FND_USER instead of FND_USER#.