This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Maximo 6.2.6, weblogic, sql server
Had an interesting problem with Workflow this morning. . .I made a Workflow for the PR app (the name of my Workflow is "PR") and when I manually started the Workflow on the PR, it worked as intended. Also if I set the Workflow to automatically initiate it worked as intended.
We have inventory done/running live in Maximo on only a couple of storerooms. We reorder for these storerooms on Tuesdays. Last week, reorder ran and they did NOT automatically start into Workflow. I realized I forgot to go to Organizations and set it there to have my Workflow run automatically on Reorder, so I set it, and manually started the Workflow for the PR's Reorder generated. No problem.
I come to work this morning and find there are NO PR's for this week. Strange, I think, so I manually preview the Reorder process and find that it should have ordered several items. I run reorder, I get a box that says:
Process PR started
Process PR started
Process PR started
Process PR started
Process PR started
and then a box telling me the PR numbers. . .but there were no PR numbers! So then I go check the PR app and sure enough there are no PRs. I go take that setting off of the Organizations --> Workflow options and run Reorder again. This time I get 5 PR's (that's why the earlier box told me 5 times that "Process PR started" -- because there should have been 5 PRs generated).
Anyhow, anyone have any ideas why the PRs vanished? They totally disappeared -- they weren't cancelled, more like deleted. In the sequential numbering of the PRs, there's now a gap in the numbering where the PRNums for the Reorder that ran overnight and the first Reorder I did manually should be.
Travis Herron
The logs for this go to my Purchasing Agent and thankfully he still had them. It said it could not start the Workflow because it required user interaction.
The VERY FIRST step in my design is to have it check to see if this PR was generated by the Reorder process or not. If it is, it does a couple of SETVALUE actions and goes to a task node. If it is not, then that should mean a user is entering it manually (we're not using Desktop Requisitioning) and it does go to a user interaction node.
So if I start the Workflow manually, it works correctly. If I set the Workflow option in Organizations, it does not work correctly.
This is my condition expression for checking if it is from Reorder:
:priority = '0' and :description like 'Generated%Reorder%' and :prnum not in (select prnum from mrline where prnum is not null) and prid = :prid
Can anyone offer a better way for me to detect that the PR came from Reorder? We have our Reorder Cron Tasks running under the context of the storeroom supervisor -- so the Requested By and the User credited in the PRStatus table with creating the PR is that user (not, say, maxadmin).
I'm guessing it fired so quickly it didn't correctly pick up the description.
Travis Herron
--- In MAXIMO@yahoogroups.com, "Travis Herron" <therron@...> wrote:
>
> Maximo 6.2.6, weblogic, sql server
>
> Had an interesting problem with Workflow this morning. . .I made a Workflow for the PR app (the name of my Workflow is "PR") and when I manually started the Workflow on the PR, it worked as intended. Also if I set the Workflow to automatically initiate it worked as intended.
>
> We have inventory done/running live in Maximo on only a couple of storerooms. We reorder for these storerooms on Tuesdays. Last week, reorder ran and they did NOT automatically start into Workflow. I realized I forgot to go to Organizations and set it there to have my Workflow run automatically on Reorder, so I set it, and manually started the Workflow for the PR's Reorder generated. No problem.
>
> I come to work this morning and find there are NO PR's for this week. Strange, I think, so I manually preview the Reorder process and find that it should have ordered several items. I run reorder, I get a box that says:
>
> Process PR started
> Process PR started
> Process PR started
> Process PR started
> Process PR started
>
> and then a box telling me the PR numbers. . .but there were no PR numbers! So then I go check the PR app and sure enough there are no PRs. I go take that setting off of the Organizations --> Workflow options and run Reorder again. This time I get 5 PR's (that's why the earlier box told me 5 times that "Process PR started" -- because there should have been 5 PRs generated).
>
> Anyhow, anyone have any ideas why the PRs vanished? They totally disappeared -- they weren't cancelled, more like deleted. In the sequential numbering of the PRs, there's now a gap in the numbering where the PRNums for the Reorder that ran overnight and the first Reorder I did manually should be.
>
> Travis Herron
>