This discussion is archived
13 Replies Latest reply: Nov 21, 2012 9:54 AM by Hussein Sawwan-Oracle RSS

R12.1.3 workflow error

DBAKamal Newbie
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    Did you followed point no 3 as per MOS Note ?
    thanks
  • 7. Re: R12.1.3 workflow error
    DBAKamal Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points