SCR 64701 ENH - BPM Data Directive - SysTask Table
Enhancement request to add SysTask table to list of tables for BPM DataDirective in E9
Enhancement request to add SysTask table to list of tables for BPM DataDirective in E9
--- In vantage@yahoogroups.com, "dansirow" <dansirow@...> wrote:
>
> In E9, SysTask table is also not available for a Data Diretive BPM (fired like a BAM on a data field change). But SysTask table is available within BPMs, but you would need something to trigger the BPM.
>
> But the SysLock table is available to trigger a BAM or Data Directive BPMs.
> Description from Data Dictionary Viewer:
> * Lock Indicator Table. Used to establish a lock condition for specific functions. Ex: Building Suggested Orders. There should be one record per company/function that is locked whenever a user is running the "dedicated" function.
>
> This might work! There is probably a record in the SysLock table while MRP is running.
>
> Dan Sirow
> Independent Components Corp
>
> --- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@> wrote:
> >
> > Damn..your right..not a table able to be monitored by a bam..how
> > disappointing..
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of Vic Drecchio
> > Sent: Friday, June 19, 2009 12:50 PM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] MRP Complete Notification
> >
> >
> >
> >
> >
> > OK, that's along the lines that I was thinking and I am SQL so I'll
> > probably just use SQL tools to do this. Thank you very much!
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf
> > Of Rob Bucek
> > Sent: Friday, June 19, 2009 1:22 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] MRP Complete Notification
> >
> > I should have added that task status would be useful too...active,
> > complete, error, etc...
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf
> > Of Rob Bucek
> > Sent: Friday, June 19, 2009 12:17 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] MRP Complete Notification
> >
> > Vic, I have an interest in this as well but haven't gotten around
> > shaking it out yet. The course I was thinking on following was using a
> > BAM to monitor the Systask table and watch for the description field to
> > equal process MRP, and when a change was made (or in this case entered)
> > into the end date or end time, fire off an email. It seems fairly sound
> > anyhow...let me know if this helps..
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ] On
> > Behalf
> > Of Vic Drecchio
> > Sent: Friday, June 19, 2009 11:44 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] MRP Complete Notification
> >
> > Does anyone out there have a means to notify via email when MRP is
> > completed?
> >
> > I'd like to get an email sent to me upon completion so I can ensure it
> > ran.
> >
> > Thank you in advance.
> >
> > Vic Drecchio
> > ERP Administrator
> >
> > TIMCO Aviation Services
> > Greensboro, NC
> > Email: vic.drecchio@ <mailto:vic.drecchio%40timco.aero>
> > <mailto:vic.drecchio%40timco.aero>
> > <mailto:vic.drecchio%40timco.aero>
> > Mobile: 704.530.3092
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > <http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>