13 Replies Latest reply: Nov 21, 2012 11:54 AM by Hussein Sawwan-Oracle RSS

    R12.1.3 workflow error

    DBAKamal
      Hello,

      I set up R12.1.3 (upgrade from R12.1.1) I when I Started up the application and got connected to the Application using the user sysadmin,

      I received too much workflow errors woth no access to the Oracle Applications to create users and responsibilities

      What could be the solution to clean those errors ? could I missed a patch to apply ?

      Here are the steps :

      -set up R12.1.1 .
      - set up french NLS.
      - upgrade to R12.1.3
      - upgrade french NLS.


      BR
        • 1. Re: R12.1.3 workflow error
          Hussein Sawwan-Oracle
          I received too much workflow errors woth no access to the Oracle Applications to create users and responsibilities
          What kind of errors? Please post them here.

          Thanks,
          Hussein
          • 2. Re: R12.1.3 workflow error
            DBAKamal
            Hello,

            Here are the errors displayed by the home page when connected by sysadmin:
            N.B: This a vision demo environnement.


            Transaction Workflow     Error in Workflow PARMATRX/10044 ORA-01400: cannot insert NULL into ("PA"."PA_FORECAST_ITEMS"."PROJECT_ID")     24-Jul-2003     27-Jul-2003

            *     HR     System Error in Workflow. Error item type: HRSSA. Error item key: 10967.     27-Sep-2006     02-Oct-2006*

            *     HR     System Error in Workflow. Error item type: HRSSA. Error item key: 10988.     29-Sep-2006     04-Oct-2006*

            *     HR     System Error in Workflow. Error item type: HRSSA. Error item key: 11297.     08-Jan-2007     13-Jan-2007*

            *     HR     System Error in Workflow. Error item type: HRSSA. Error item key: 10986.     06-Feb-2007     11-Feb-2007*

            *     HR     System Error in Workflow. Error item type: HRSSA. Error item key: 12261.     09-Feb-2007     14-Feb-2007*

            *     HR     System Error in Workflow. Error item type: HRSSA. Error item key: 12284.     09-Feb-2007     14-Feb-2007*

            *     HR     System Error in Workflow. Error item type: HRSSA. Error item key: 12832.     21-Aug-2007     26-Aug-2007*

            *     HR     System Error in Workflow. Error item type: HRSSA. Error item key: 12892.     22-Aug-2007     27-Aug-2007*

            *     HR     System Error in Workflow. Error item type: HRSSA. Error item key: 12908.     22-Aug-2007     27-Aug-2007*

            *     HR     System Error in Workflow. Error item type: HRSSA. Error item key: 12991.     23-Aug-2007     28-Aug-2007*

            *     HR     System Error in Workflow. Error item type: HRSSA. Error item key: 12993.     23-Aug-2007     28-Aug-2007*

            *     HR     System Error in Workflow. Error item type: HRSSA. Error item key: 12992.     23-Aug-2007     28-Aug-2007*

            *     HR     System Error in Workflow. Error item type: HRSSA. Error item key: 12994.     23-Aug-2007     28-Aug-2007*

            *     HR     System Error in Workflow. Error item type: HRSSA. Error item key: 12956.     24-Aug-2007     29-Aug-2007*

            *     System: Error     Error in Workflow ECXERROR/WF5239778 3120: Activity 'ECXERROR/733228' has no performer.     29-Aug-2008     29-Aug-2008*

            *     System: Error     Error in Workflow ECXERROR/WF5033143 3120: Activity 'ECXERROR/733228' has no performer.     29-Aug-2008     29-Aug-2008*

            *     System: Error     Error in Workflow ECXERROR/WF5033141 3120: Activity 'ECXERROR/733228' has no performer.     29-Aug-2008     29-Aug-2008*

            *     System: Error     Error in Workflow EPBCYCLE/Netherlands Budget-2163-5-GENERATE_TEMPLATE-07/14/2005-09-23-45 ORA-01688: unable to extend table APPLSYS.WF_ITEM_ACTIVITY_STATUSES_H partition WF_ITEM22 by 16 in tablespace APPS_TS_TX_DATA     29-Aug-2008     29-Aug-2008*

            *     System: Error     Error in Workflow EPBCYCLE/Netherlands Budget-2163-5-GENERATE_TEMPLATE-07/15/2005-14-33-49 ORA-01688: unable to extend table APPLSYS.WF_ITEM_ACTIVITY_STATUSES_H partition WF_ITEM22 by 16 in tablespace APPS_TS_TX_DATA     29-Aug-2008     29-Aug-2008*

            *     HR     System Error in Workflow. Error item type: HRSSA. Error item key: 12932.     25-Aug-2008     30-Aug-2008*

            *     Expenses     Expense W33356 (791.00 GBP)     29-Aug-2008     01-Sep-2008*

            *     Expenses     Expense W33336 (611.00 GBP)     29-Aug-2008     01-Sep-2008*

            *     Expenses     Expense W33316 (676.00 GBP)     29-Aug-2008     01-Sep-2008*

            *     System: Error     Error in Workflow ECXERROR/WF5240479 3120: Activity 'ECXERROR/733228' has no performer.     25-Sep-2008     25-Sep-2008*


            BR
            • 3. Re: R12.1.3 workflow error
              Hussein Sawwan-Oracle
              Are you getting those notifications in the Worklist? If yes, please refer to (How To Remove Error Notifications From The Worklist [ID 357904.1]) to remove them.

              Thanks,
              Hussein
              • 4. Re: R12.1.3 workflow error
                DBAKamal
                Hello,

                Yes I'm getting them in worklist.

                But even I executed the plsql program giver in the note, they don't get deleted when I reopen a connection.

                I did it also with application done, but the result is the same .


                Declare
                cursor c_item_keys is
                select act.item_type , act.item_key
                from wf_item_activity_statuses act
                +,wf_notifications n+
                +,wf_items itm+
                where act.notification_id = n.notification_id
                and act.item_type = itm.item_type
                and act.item_key = itm.item_key
                and itm.end_date is null
                and act.item_type = 'FTEPSUPD' -- value returned in step 1
                and act.activity_status in ('ERROR','NOTIFIED')
                and n.status = 'OPEN'
                and act.assigned_user = 'SYSADMIN';
                counter number;
                Begin
                counter := 1 ;
                for item in c_item_keys loop
                wf_engine.abortprocess(item.item_type,item.item_key);
                counter := counter 1 ;+
                if counter > 1000 then
                counter := 1 ;
                commit;
                end if;
                end loop;
                commit;
                End;
                +/+

                BR
                • 5. Re: R12.1.3 workflow error
                  DBAKamal
                  Hello,

                  The errors disappear only when I Open them by clicking errors one by one :) But there's a lot of errors.
                  And there keeping me out of using the Applications correclty.


                  BR.
                  • 6. Re: R12.1.3 workflow error
                    Kashif M
                    Did you followed point no 3 as per MOS Note ?
                    thanks
                    • 7. Re: R12.1.3 workflow error
                      DBAKamal
                      Hello,

                      I can't lanuch that concurrent request allowing the purge of workflow obsolete data, because I don't have access to use application.
                      When I'm logged in using sysadmin, I get the errors in the worklist and this preventing me to use the applications corectly to launch requests and so on ...

                      BR
                      • 8. Re: R12.1.3 workflow error
                        Hussein Sawwan-Oracle
                        DBAKamal wrote:
                        Hello,

                        I can't lanuch that concurrent request allowing the purge of workflow obsolete data, because I don't have access to use application.
                        When I'm logged in using sysadmin, I get the errors in the worklist and this preventing me to use the applications corectly to launch requests and so on ...

                        BR
                        What is the error you get? The worklist should not stop you from using the application or opening forms.

                        Was this working before? If yes, any changes been done recently?

                        Please run AutoConfig and make sure it completes successfully.

                        Also, please post the output of: adopmnctl.sh status

                        If you still have the same issue, please check Apache log files along with the application.log file for details.

                        Thanks,
                        Hussein
                        • 9. Re: R12.1.3 workflow error
                          DBAKamal
                          hello ,

                          - Yes in my case these errors are preventing me access the applications !! I dont find any other link to access :) no one !!!
                          -Yes this was working before upgrading oracle application from R12.1.1 to R12.1.3. IT was also working after setting up the NLS PAtch (french).

                          - Here is the out put of script :
                          $ ./adopmnctl.sh status

                          You are running adopmnctl.sh version 120.6

                          Checking status of OPMN managed processes...
                          /visionr12/r12app/inst/apps/VIS_pvuxf262/ora/10.1.3/opmn/bin/opmnctl[31]: unlimited: 0403-009 The specified number is not valid for this command.

                          Processes in Instance: VIS_pvuxf262.pvuxf262.netphos.com
                          --------------------------------------------------------------+---------
                          ias-component | process-type | pid | status
                          --------------------------------------------------------------+---------
                          OC4JGroup:default_group | OC4J:oafm | 174327~ | Alive
                          OC4JGroup:default_group | OC4J:forms | 238553~ | Alive
                          OC4JGroup:default_group | OC4J:oacore | 9634030 | Alive
                          HTTP_Server | HTTP_Server | 157287~ | Alive


                          adopmnctl.sh: exiting with status 0

                          adopmnctl.sh: check the logfile /visionr12/r12app/inst/apps/VIS_pvuxf262/logs/appl/admin/log/adopmnctl.txt for more information ...


                          BR
                          • 10. Re: R12.1.3 workflow error
                            Hussein Sawwan-Oracle
                            If you are not seeing your responsibilities, please refer to:

                            Missing SYSADMIN Responsibility After Upgrade To 12.1.3 [ID 1246824.1]
                            Troubleshooting Missing Responsibilities For A User [ID 429852.1]

                            Thanks,
                            Hussein
                            • 11. Re: R12.1.3 workflow error
                              DBAKamal
                              Hello,

                              It seems that I was sleepy all the day :D apologise for this.

                              The problem is that I can't personnalize the Main menu.
                              I can't show all The responsibilities. when I click Apply I don't get the Responsibilities displayed.

                              BR
                              • 12. Re: R12.1.3 workflow error
                                DBAKamal
                                Hello,

                                I set up the patches :

                                p9817770

                                p9966055
                                This resolved the problem

                                But I can't start forms !!!!

                                I can access the forms from the URL:
                                http://pvuxf262.netphos.com:8000/forms/frmservlet?form_params=+config=VIS.dbc

                                but not from the main home page of oracle.

                                What could be the problem ? thanks

                                BR,
                                • 13. Re: R12.1.3 workflow error
                                  Hussein Sawwan-Oracle
                                  DBAKamal wrote:
                                  Hello,

                                  I set up the patches :

                                  p9817770

                                  p9966055
                                  This resolved the problem

                                  But I can't start forms !!!!

                                  I can access the forms from the URL:
                                  http://pvuxf262.netphos.com:8000/forms/frmservlet?form_params=+config=VIS.dbc

                                  but not from the main home page of oracle.

                                  What could be the problem ? thanks

                                  BR,
                                  Is this related to your other thread? -- Re: Can't launch forms in R12.1.3

                                  If yes, please update the other thread instead of this one.

                                  Thanks,
                                  Hussein