12 Replies Latest reply on Sep 10, 2012 8:03 AM by Helios-GunesEROL

    Why responsibility is not show for my user?

    Ted xu
      Hi experts,

      Recently i need to enable one responsibility(named as R below) for my user. As i examined, R is already assigned to the user but
      it's expired, so i set the end date as null. Further more, i found that R itself has an expiration date and it has arrived, so i set it as null too.

      Till now, i re-login my user and expect R shown on the left tree of home page. But it doesn't exist, really.

      I guess there should be a concurrent request need be run but i can't figure this out. Appreciate your help.

      Thanks,
      ted
        • 1. Re: Why responsibility is not show for my user?
          Hussein Sawwan-Oracle
          Recently i need to enable one responsibility(named as R below) for my user. As i examined, R is already assigned to the user but
          it's expired, so i set the end date as null. Further more, i found that R itself has an expiration date and it has arrived, so i set it as null too.

          Till now, i re-login my user and expect R shown on the left tree of home page. But it doesn't exist, really.

          I guess there should be a concurrent request need be run but i can't figure this out. Appreciate your help.
          Please see if (Unable to See Responsibilities after End Date Is Removed on ATG RUP6 [ID 727638.1]) helps.

          Also, please see old threads for similar discussion -- https://forums.oracle.com/forums/search.jspa?threadID=&q=Missing+AND+Responsibilities&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

          Thanks,
          Hussein
          • 2. Re: Why responsibility is not show for my user?
            chen_7733
            run request"Synchronize Workflow LOCAL Tables"
            • 3. Re: Why responsibility is not show for my user?
              Ted xu
              hi,

              don't know why, it doesn't work for me.
              • 4. Re: Why responsibility is not show for my user?
                Ted xu
                Hi Hussein,

                Examined your link, still not get a clue. I am totally new at ebs wf aspect.

                Further more, i did some testing on another env with the same user&resp and it did work.
                I guess there must be some configuration issue which leads to some actions not taken and caused
                my trouble.
                • 5. Re: Why responsibility is not show for my user?
                  Hussein Sawwan-Oracle
                  Examined your link, still not get a clue. I am totally new at ebs wf aspect.
                  Have you bounced Apache and Workflow Agent Listener services?
                  Further more, i did some testing on another env with the same user&resp and it did work.
                  I guess there must be some configuration issue which leads to some actions not taken and caused
                  my trouble.
                  Please run these concurrent programs and check then:

                  "Sync responsibility role data into the WF table."
                  "Synchronize WF LOCAL tables"
                  "Workflow Directory Services User/Role Validation"

                  Thanks,
                  Hussein
                  1 person found this helpful
                  • 6. Re: Why responsibility is not show for my user?
                    Ted xu
                    Hi Hussein, thanks for your reply.
                    Have you bounced Apache and Workflow Agent Listener services?
                    Yes, i bounced the "Workflow Agent Listener services" through "Concurrent > Manager > Administer". It's verified
                    that this concurrent manager matters, because i did some testing on another env, after it's deactivated, the change
                    to user-resp didn't take effects.
                    Please run these concurrent programs and check then:

                    "Sync responsibility role data into the WF table."
                    "Synchronize WF LOCAL tables"
                    "Workflow Directory Services User/Role Validation"
                    Output:
                    1, Sync responsibility role data into the WF table.
                    Error:
                    --Routine fdpsql cannot read the file $APPL_TOP/fnd/12.0.0/sql/affurg02.sql.
                    --Check if the file exists under correct product directory.
                    2, Synchronize WF LOCAL tables
                    Normal
                    3, Workflow Directory Services User/Role Validation
                    Error:
                    --ORA-08103: object no longer exists

                    But request results are the same on both envs, so this won't be the reason why the change
                    to user-resp doesn't take effects.

                    Thanks,
                    Ted
                    • 7. Re: Why responsibility is not show for my user?
                      Hussein Sawwan-Oracle
                      1, Sync responsibility role data into the WF table.
                      Error:
                      --Routine fdpsql cannot read the file $APPL_TOP/fnd/12.0.0/sql/affurg02.sql.
                      --Check if the file exists under correct product directory.
                      If you are on R12, please see (Concurrent Processing - Concurrent Program "Sync Responsibility Role Data Into The WF Table" errors: Cannot Find File affurg02.sql [ID 727534.1]).
                      2, Synchronize WF LOCAL tables
                      Normal
                      3, Workflow Directory Services User/Role Validation
                      Error:
                      --ORA-08103: object no longer exists
                      Please post the contents of the concurrent request log file here.

                      Thanks,
                      Hussein
                      • 8. Re: Why responsibility is not show for my user?
                        Ted xu
                        If you are on R12, please see (Concurrent Processing - Concurrent Program "Sync Responsibility Role Data Into The WF Table" errors: Cannot Find File affurg02.sql [ID 727534.1]).
                        R12 is the EBS version i am using. From the note 727534.1, this concurrent program is obsolete and replaced by "Workflow Directory Services User/Role Validation".
                        Please post the contents of the concurrent request log file here.
                        Log for "Synchronize WF LOCAL tables"
                        ---------------------------------------------------------------------------
                        Application Object Library: Version : 12.0.0

                        Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

                        FNDWFLSC module: Synchronize WF LOCAL tables
                        ---------------------------------------------------------------------------

                        Current system time is 09-SEP-2012 03:35:33

                        ---------------------------------------------------------------------------

                        **Starts**09-SEP-2012 03:35:33
                        **Ends**09-SEP-2012 03:37:49
                        ---------------------------------------------------------------------------
                        Start of log messages from FND_FILE
                        ---------------------------------------------------------------------------
                        ---------------------------------------------------------------------------
                        End of log messages from FND_FILE
                        ---------------------------------------------------------------------------


                        ---------------------------------------------------------------------------
                        Executing request completion options...

                        Output file size:
                        0

                        ------------- 1) PRINT   -------------
                        Disabling requested Output Post Processing. Nothing to process. The output of the request is zero byte.
                        --------------------------------------


                        Finished executing request completion options.

                        ---------------------------------------------------------------------------
                        Concurrent request completed successfully
                        Current system time is 09-SEP-2012 03:37:51

                        ---------------------------------------------------------------------------
                        Log for "Workflow Directory Services User/Role Validation"
                        ---------------------------------------------------------------------------
                        Application Object Library: Version : 12.0.0

                        Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

                        FNDWFDSURV module: Workflow Directory Services User/Role Validation
                        ---------------------------------------------------------------------------

                        Current system time is 09-SEP-2012 03:36:03

                        ---------------------------------------------------------------------------

                        **Starts**09-SEP-2012 03:36:04
                        **Ends**09-SEP-2012 03:36:31
                        ORA-08103: object no longer exists
                        ---------------------------------------------------------------------------
                        Start of log messages from FND_FILE
                        ---------------------------------------------------------------------------
                        ---------------------------------------------------------------------------
                        End of log messages from FND_FILE
                        ---------------------------------------------------------------------------


                        ---------------------------------------------------------------------------
                        Executing request completion options...

                        Output file size:
                        0


                        Finished executing request completion options.

                        ---------------------------------------------------------------------------
                        Concurrent request completed
                        Current system time is 09-SEP-2012 03:36:31

                        ---------------------------------------------------------------------------
                        Thanks,
                        Ted
                        • 9. Re: Why responsibility is not show for my user?
                          Hussein Sawwan-Oracle
                          Log for "Synchronize WF LOCAL tables"
                          ---------------------------------------------------------------------------
                          Concurrent request completed successfully
                          The log file shows "Concurrent request completed successfully" for "Synchronize WF LOCAL tables".

                          Thanks,
                          Hussein
                          • 10. Re: Why responsibility is not show for my user?
                            Hussein Sawwan-Oracle
                            Ted,

                            Please follow all the steps in (Troubleshooting Missing Responsibilities For A User [ID 429852.1]).

                            Thanks,
                            Hussein
                            1 person found this helpful
                            • 11. Re: Why responsibility is not show for my user?
                              Ted xu
                              Hussein Sawwan wrote:
                              Ted,

                              Please follow all the steps in (Troubleshooting Missing Responsibilities For A User [ID 429852.1]).

                              Thanks,
                              Hussein
                              Hi Hussein,

                              Thanks for your time and patience. 429852.1 is an amazing article which lets me know why the responsibility is missing and
                              how to solve the problem.

                              Even the problem is still not fixed yet, but i know howto. Thanks again.
                              • 12. Re: Why responsibility is not show for my user?
                                Helios-GunesEROL
                                Hi;
                                Hi Hussein,

                                Thanks for your time and patience. 429852.1 is an amazing article which lets me know why the responsibility is missing and
                                how to solve the problem.
                                This is Hussein Sawwan job here, I mean  to share his fabulous knowledge&experience with  metalink notes ;)
                                Even the problem is still not fixed yet, but i know howto. Thanks again.
                                I suggest also revirew:     Missing responsibilities in R12.1.3 [ID 1423432.1]

                                Regard
                                Helios