Error during RPC's patches - ORA-00001: unique constraint (APPLSYS.WF_USER_ROLE_ASSIGNMENTS_U1) viol
We are in the process of applying hundreds of RPC's along with RUP patches. We merged 2 sets patches based on the pre-req and co-req and we kept most of the RUP to be applied separately. So during our first set of merged patches we are facing the error as belowsqlplus -s APPS/***** @/oracle/apps/oapptech/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/wfdspifx.sql &un_fnd &batchsize
Connected.
DECLARE
*
ERROR at line 1:
ORA-00001: unique constraint (APPLSYS.WF_USER_ROLE_ASSIGNMENTS_U1) violated
ORA-06512: at line 70
Since we are having very tight dealine we need to finish this patching activity ASAP to DEV and move to PROD in 10 days. So pls assist to resolve this error soon.
Tagged:
0