Oracle error-20001:APP-FND-01972:Error in FND_USER_RESP_GROUPS_API. Update_ Assignment. Cannot update this row because thee is no direct assignment of the user XXX to the role

Error:-

When attempting to add or remove an end_date  for a responsibility that is assigned to a user an error occurs.

Oracle error-20001:APP-FND-01972:Error in FND_USER_RESP_GROUPS_API. Update_ Assignment.
Cannot update this row because thee is no direct assignment of the user XXX to the role FND_RESP\CSM\OMFS_PLAM\STANDARD in the workflow user/Role table.
has been detected in FND_USER_RESP_GROUP_API.UPDATE_ASSIGNMENT.

Cause:-

The problem was caused by invalid data in the workflow user/Role table.

Solution:-

To implement the solution, please execute the following steps:

1. Go into the responsibility: System administrator.

2. Navigate to Requests > Run

3. Select request ''Workflow Directory Services User/Role Validation' and submit
    1. Run the program " Workflow Directory Services User/Role Validation" once with the following parameters:

        Fix Dangling User/Roles

            Default Batchsize=10000
            Fix Dangling User/Roles=Yes
            Add Missing User/Role Assignments=No

    2. After it completes, Add Missing User/Role Assignments

            Default Batchsize=10000
            Fix Dangling User/Roles=No
            Add Missing User/Role Assignments=Yes

4. Retest the issue by trying to update the responsibility..

5. Migrate the solution as appropriate to other environments.

ORA-01031 occurs during Post Install / De-install steps [or] Oracle DB componenet JAVAVM becomes invalid after patching

While running db post install steps running into below issues and the OJVM component becomes invalid.
 
Error:-

SQL> BEGIN
  2
  3      initjvmaux.drop_sros();
  4
  5      EXECUTE IMMEDIATE 'create or replace java system';
  6
  7      update dependency$
  8        set p_timestamp=(select stime from obj$ where obj#=p_obj#)
  9        where (select stime from obj$ where obj#=p_obj#)!=p_timestamp and
10              (select type# from obj$ where obj#=p_obj#)=29  and
11              (select owner# from obj$ where obj#=p_obj#)=0;
12
13  -- Check the validity of JAVAVM and let the registry be updated accordingly.
14
15      initjvmaux.validate_javavm;
16
17  -- Add a row in registry$history to indicate this script was run.
18
19      EXECUTE IMMEDIATE 'insert into registry$history
20                         (action_time, action, namespace, version, id, comments)
21                         values(SYSTIMESTAMP, ''jvmpsu.sql'', ''SERVER'',
22                                ''11.2.0.4.1OJVMBP'', 0, ''APPLIED jvmpsu.sql'')';
23
24  END;
25  /
BEGIN
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.INITJVMAUX", line 535
ORA-06512: at line 3

Solution:-


cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dv_off
cd $ORACLE_HOME/bin
relink all

REP-3000: Internal error starting Oracle Toolkit

Scenario:

=========

Active Users concurrent request Errored out.

Log file shows the following error:

==================================

APPLLCSP Environment Variable set to :

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

American_America.UTF8

'.,'

Enter Password:

REP-3000: Internal error starting Oracle Toolkit.

REP-3000: Internal error starting Oracle Toolkit.

REP-0069: Internal error

REP-57054: In-process job terminated:Terminated with error:

REP-3000: Internal error starting Oracle Toolkit.

Following things needs to be checked :

====================================

Check $CONTEXT_FILE display variable. If this is correct we can ignore this and if there is any change then run autoconfig.

Now check the reports.sh file inside the apps $ORACLE_HOME/bin

Display variable to set DISPLAY=192.168.1.20:1.0; export DISPLAY

If still issue persists then follow the below step.

Solution:

=========

1. From Unix Run the following command:

$ /usr/lpp/X11/bin/xinit /usr/lpp/X11/bin/mwm -multiscreen -- :1 -vfb -force -x abx -x dbe -x GLX &

2. Bounce the Applications service/report server to take effect.