5 Replies Latest reply: Jun 20, 2013 9:51 AM by PRaju RSS

    FRM-40657 Record Changed or Deleted by Another User

    PRaju

      Guru,

       

      We are getting the following error message while end_date user's few  responsibility and found note : 1236623.1.

       

      But action plan not clear , please suggest

       

       

       

       

        • 1. Re: FRM-40657 Record Changed or Deleted by Another User
          Hussein Sawwan-Oracle

          Which step is not clear to you?

           

          Did you also review (Can not Remove Responsibility End-Date in Define Users form due to Error FRM-40657 [ID 1273157.1])?

           

          Thanks,

          Hussein

          • 2. Re: FRM-40657 Record Changed or Deleted by Another User
            PRaju

            Hussein,

             

            Thaks for light,

             

            We have created new responsibility , Now we are getting error while END_DATE old responsibility.

             

            Regards,

            Raju

            • 3. Re: FRM-40657 Record Changed or Deleted by Another User
              Hussein Sawwan-Oracle

              Raju,

               

              You mentioned the solution in the doc is not clear to you, so which step are you referring to?

               

              Have you reviewed the other doc?

               

              Thanks,

              Hussein

              • 4. Re: FRM-40657 Record Changed or Deleted by Another User
                PRaju

                From Documment : 1236623.1

                 

                Cause:

                1. Navigation from (Responsibility) System Administrator > Security > User > Define > Query out the responsibility, found responsibility key is <NEW_VALUE>. ..................... This is wrong Navigation

                2. Found value <OLD_VALUE> is included in column role_name of the responsibility under the user by sql statement:......................................................................................... Not sure whats the old Value

                select * from wf_local_user_roles
                where user_name = '<user_name>'
                and role_name like '%<OLD_VALUE>%';

                 

                Solution :

                4. Identify the Role (responsiblity) to be changed, click 'Show' to expand the record, select a date to field 'Active To' to provide an end date to this role assignment. ..... Not sure how to get role for particular responsibility.

                 

                From Document : 1273157.1

                We have created new responsibility , But now we are getting error while END_DATE old responsibility.

                New Responsiblity name : BPC-160 DC Staff-New

                Old : BPC-160 DC Staff

                • 5. Re: FRM-40657 Record Changed or Deleted by Another User
                  PRaju

                  We have ran the following update statemnt for mismatch record followed by "Workflow Directory Services User/Role Validation" request , However issue not resolved.

                   

                  UPDATE WF_USER_ROLE_ASSIGNMENTS set effective_end_date = to_date(null)

                  where rowid in (select ura.rowid

                  from wf_local_user_roles ur, wf_user_role_assignments ura

                  where ur.user_name = ura.user_name

                  and ur.role_name = ura.role_name

                  and ura.relationship_id = -1

                  and ((ur.effective_start_date is null or ur.effective_start_date <>ura.effective_start_date)

                  or (ur.effective_end_date is null or ur.effective_end_date <>ura.effective_end_date)));

                   

                  Please suggest if any solution.