I am just curious to know if there is a rule of thumb on when to use the SQL Query and Query node.  I am bias towards SQL Query, however, most of the time, Query node code is shorter and you do not have to figure out the table/file relations specially if you build the code using the Query builder. On the other hand, I can write SQL with no tool assistance (very experienced). This thought came about when I am creating a query on tables EMPLOYEE, PAEMPLOYEE, POSITION, JOBCODE. Thanks, Jude

I am thinking this is a configuration issue but I am not sure where to look. Is all I am doing is using the id variable I have to select the RM to return the email address to be used in an email node.  I have getting an error about false Boolean.

I am trying to setup a backup administrator but keep getting the user does not have Process Flow Administrative privileges. In LSF9 user has SuperAdminRole and has Process Flow role, setup same as myself. In LID he is sysadmin again same setup as myself. In PF Admin his user profile is the same as mine. He can run flows locally no problem but when we try to run the flow on the server he gets the privilege error. The PF Config file does has only the lawson user in it so my id is not there. What a...

Hi all, Plz i need to know if there is a screen allowing pfi users to change their passwords, as we aren't using adam authentication in M3 BR, Hicham

Is the Application Filtering button on the user action node the way to do category filtering now in IPA/IPD Trying to find any documentation on the field and I keep coming up empty.

I am trying to convert a String Date with a format of mm/dd/yyyy received from a query of a table into an AGS format of yyyymmdd. I have tried a number of DATE to string and String to DATE functions but none of them are working. Could there be something wrong with one of our LPA setup functions  Has anyone else been having Date conversion issues

Getting numerous Variable Undefined results when I try to use the ctrl space to put a value from a returned query into the results.  Is there some trick  Wonder if I have a problem with the IPD client version I am using

my client is running on 10.1 and trying to get hold of some RPG samples which uploading sales order from their eCommerce to M3 through API. Could you please help to share with me

Is there a way to write a DME Query result to a FileAccess node without writing it field by field.  For example, if I query the Employee table for Company, Employee, LastName, is there a way to write the 3 fields to the FileAccess node without defining them as query_Company, query_Employee, query_LastName  It would be nice to just write out the entire line or the entire file like query_* Thanks for any help in advance. Shawn

We are on LSF 9.0.1.10, LMK 10.0.4, IPA 10.0.4, Windows 2008 R2 using LSF security.   We have a requisition approval flow built that sometimes works and sometimes does not.  After a couple of weeks worth of digging I've not been able to figure out what is going on.   I have a user action node that is trying to create the inbasket work for some users and failing with the error message below.  We have gone through all of our user set up to make sure that all approvers have the correct security, th...

Good morning, I am having difficulty trying to figure out how to obtain the user names for the approvers for a reqApproval process flow.  Since we have the scenario were requesters can also be approvers our flow needs to determine if the requester is equal to the approver and if so then the process  needs to bump up to the next lvl.   The approvers are set up in the tasks/filters in the Infor Rich Client (LTM).  Is there any way that I can pull that information to be used in a branch Thanks, ...

Declaring arrays in start node a tarray new Array() or tarray2 new Array(2). Setting array values in assign node and in assign node javascript. Have other start node variables of other types, string, integer, boolean. Notice that the array variables do not persist through a user action node but the other variable types do persist. Is this a bug I can not find documentation on this. Suggestions

We are creating a process flow and we need to concatenate a set of jobs, so that after the first job is completed the second one starts, and the third one starts after the second and so on... Now we are creating a process flow and passing each job as a system command node, then putting a user action node after it so that it checks if the job is still active (with a web run).  The entire flow is working fine except that we have to wait at least one hour from one job to the next as the time out i...

I am working on a pflow that will run a multistep job using the WEBRUN node.  If this multistep job has 16 steps and I use the &WAIT=true is there a danger of process flow timing out waiting for the WEBRUN node to complete  The 16 steps run fairly quickly but if there is a higher volume of transactions I'm not sure if pflow will timeout and stop the workunit

Some time ago I submitted a topic that discussed how to create custom javascript functions without modifying the 'pflow.js' file. What I learned is that there is an undocumented (or poorly documented) feature where you can create a 'pflow_user.js' file and fill it full of your favorite custom javascript functions. It's awesome and we quickly started creating several custom functions and began using them throughout out flows. We're beginning to explore upgrading from PFI to IPI (IPA). ...

I am having issues in my production system with programs such as RQ10 trying to trigger workunits after converting from PFI to LPA.  I see log file entries containing the message I will include below.  There is a little more verbiage in the LPSforLSF_7034.log file in $GENDIR/bpm.  Here is an example - apparently at the point where the program is checking to see if Processflow is enabled, service is enabled, etc. [2013-12-18 21:17:01] [LPSJNIUtil] Exception encountered while calling Java, stac...

I need to create email and user action notification message bodies that are very dynamic. Using email attachments is not a real option per the requitements I have. As far as I can tell my choices are to use Msgbuilder or import pre created text from a file. What I was wondering was could I use javascript to create the html content at run time

Can anyone provide any insight to what language process flow uses  We are trying to make changes to existing flows and copying them for revisions to create new flows.  It's a Frankenstein operation! If anyone could give us some insight into the type of code or what some of the numberic/symbol combinations mean, it would be appreciated.  Any information, we would be so happy for! Lauren

I have set up several flows to run once daily.  Some are supposed to run at night, some in early morning.  It looks like the first iteration of each of these ran when it was supposed to, but all subsequent runs are running at midnight.  I am sure I missed something in my schedule setup, but I don't know what.  Can someone provide a little guidance  Thanks in advance.

Sending email notifications for invoice and req Approvals (Approve button) from a User Action in  a process flow to Employee A.  (client wants to do approvals via email).  During UAT, had Employee A forward the approval email to Employee B (Employee B is not an approver).  In the forwarded email, Employee B pressed 'Approve' button and the approval goes through as Employee A.  Is there any way to prevent this

Has anyone implemented Process Automation with multiple Product Lines  The IPA Product Line has to match the LSF Product Line.  You can install multiple instances of IPA, for each Product Line, but LSF appears to only link to one IPA Product Line.  The LSF bpm.properties has a variable called lpsDataArea, that is set to the IPA Product Line.  I'm assuming this means you can only trigger services from this one Product Line.  Can you link LSF to multiple IPA Product Lines Thanks for any infor...

I am trying to add an Infor Lawson Form to an inbasket.  The Token and Productline fields are no problem filling those in.  What format should the values be in for the key fields   Is it simply , Or something else Thanks!

We are interfacing Lawson to their Inofr XM T&E product. I have a flow that is suppose to update the Vendors. it errors during the second Assign node. Here is the JAVA if (ACTION == 'D')  localActiveStatus = 0 else  if (VEN_VENDOR_STATUS == 'A')   localActiveStatus = 1  else   localActiveStatus = 0 Here is the error ErrorLog in Process : XM_ExpOneVendor_V03 Workunit : 2820, ActivityType=ASSGN, ActivityName=Assign2440, ActivityId=ASSGN13 Date:01/27/2014 Time:09:20:28.035 Exception...

WHen we try to run a flow no matter the system commad we are doing ... Something as simple as 'whoami'. getting the message cannot su to lawson. No where have we tried to su to lawson. when we logon we are logging in as lawson.. any ideas

Hello again, UNIX/AIX 6.1 - LCT 9.0.1.8/MSP6 When running command pfserv ping all I'm getting: Process flow RMI Server is running Event Manger is not running ProcessFlow Serve ris nto running Process Flow Scheduler is not running I have stopped and started websphere, bpm, pfserv stop all, pfserv kill all, to no avail. any suggestions would be appreciated. Thank you