Is there a way to loop through the results of a SQL query without having to specify the actual name of the column For Example; If there is a SQLQuery node that returns a bunch of results. I know inside of the SQLNode loop I can do something like: SQLQuery3040_1 SQLQuery3040_2 SQLQuery3040_3 To get the data returned in column 1,2,3 but as soon as I try to build the SQLQuery counter SQLQuery3040_testCounter I can't seam to get the data out of the SQLQuery Node. My Code (Note tha...

I am executing a lawson delivered Process Flow, ChangeRelToOrg and the flow gets to the user action, reject, approve or return.  The user will select an action, but the flow does not execute the node.  The proceed action will commence when 'any one recipient takes an action'.  The work assignment ID is HR administrator we are running IPA version 10.0.4.0.5739 Any suggestions

Hi, I have a flow, PF1, that gets triggered when a user voids a check in CB80.  This flow captures key data info and writes it to a csv file.  This csv file serves as input to another flow, PF2, which puts the invoices associated with this check on hold.  Between PF1 and PF2, AP190 needs to run to reinstate the invoices before they can be put on hold. My question is:  how do I call AP190 from PF1 Thanks, Ludy

I am trying to move our PFI to LPA.  I am getting an error on W TX The system configuration is the following main checked use rmi RMI Host is from bpm.properties RMI Port is from bpm.properties rmi extension - aix time out 60 This is the error message I am receiving: Executing TX Activity TXAdapter7440... TX Activity TXAdapter7440 - Map: GovCustAR Activity TXAdapter7440: java.rmi.NotBoundException: DTXRMIServer Variables:         lastOutputData(Type=Object) =         lastRe...

Is there a way of resetting the _nextPosition in a Data Iterator I have an IPA that reads in two variables that are passed in from another IPA flow that represents two separate but similarly formatted files. I have a generic variable 'inputFileName' in my IPA that I set to the first of the two incoming file variables (e.g. inputFileName = FileA.txt) At the end of the FileA.txt file processing I use a branch to see what the inputFileName is set to in order to see if it is already set t...

I am new to Lawson and we just implemented LTM.  I would like to create an IPA process flow to delete completed action requests and move completed work units to history in LTM.  The problem is that I do not know where to start.  I have modified several canned user action process flows but have not done anything across the 'system'.  One post suggests using the custom activity node.  Does that require calling externally created custom code or are there canned processes I can call to accomplish th...

I am trying to create a process flow (in LPA) that will create a csv file with employee info (name, email, direct manager, address info).  I have a different landmark query node for each object I need to get data from (Employee, HROrganizationUnit, EmployeeContact, EmployeeAddress).  The first node which gets the employee number and name works.  In the subsequent queries, I was trying to use the employee number variable from the first query to select the data for the specific employee.  If I u...

I see thta user actions can be specified as a role or as a specific user. Assuming I'm working with a giant table of the world that lists all approval chains by department, is there a way to dynamically(sp) assign the user to the node

We are new to IPA and we're trying to fix some of our PFI converted flows that used to use a query node to pull workunit information from the Logan WFVariable table. I've replaced the qry node with the Landmark Transaction node and we're reading the 'PFIWorkUnitVariable' table. The node successfully reads the table and pulls the WU information. However, There are other Lawson Query nodes in the flow that reference certain variable values. In PFI you could simply reference the WFVariable v...

I am trying to send a form to employees when they change either their address1 or their city and live in PA.  I do not want the form to be sent if they’ve only changed their phone number. I have this formula in the Condition Expression Builder but it is sending the form even when it is only a phone number change.   (qEMP_PROCESS_LEVEL==30 &&qEMP_STATE =='PA' &&oldAddr1!=qEMP_ADDR1) || (qEMP_PROCESS_LEVEL==30 &&qEMP_STATE =='PA' &&oldCity!=qEMP_CITY)     Does anyone know how I can make this...

We are having an issue connecting to a SQL Server 2008 Database that now requires connecting via an SSL connection.  We are using the SQL Server Query node and in the past we connected fine using the sqljdbc4.jar file to our SQL Server 2008 databases but now when they turn on 'Force Encryption' on the SQL server we get the error 'SQLException: Connection reset'.  We did add the URL parameter 'trustServerCertificate=true' and the flow runs ok locally but we get this error when it runs on the Serv...

When a new position is created in S3, I want to grab that information and get it into the POSITION table in GHR.  I see two IPA processflows.  One puts the new position data in a table called POSITIONIMPORT and one puts it in POSITIONIMPORTLITE. My question is how does it get from either of these tables into the POSITION table  Should I change the flow I want to use and add the position directly into the POSITION table  Thank you.

I have a need to do an external call (Web Service) and return a potentially complex HTML string for use in a email. I would like to be able to encoding the string on the webservice side and decode it on the flow side before applying it to the email. It seems like the Custom Activity node does but every test I've run returns the same string out as goes in. My settings are: Activity: Encoding Action: convertStringToCharEncodingBytes charEncoding: input: charEncodnign: input:  ou...

Hello. I'm new to this. Has anyone ever created a custom trigger for processflow

Am trying to configure properties in the Grid for my JDBC.jar files.  The help documentation in Landmark is good but this is all new to me.  The particular doc I am looking at is entitled 'Configuing Grid and other properties for Infor Process Automation'.  It mentions 2 properties called grid.app.classpath and grid.app.dataareas.  I cannot locate those properties and am unsure of whether I need to add them and where they would go.  Any ideas Thanks in advance.

We have a custom DS Portal Page that runs a DME query to get ProcessFlow workunit information from the LOGAN database.  Now that we are beginning to use Infor Process Automation the workunits reside on a Landmark server.  Does anyone know if it is possible to query Landmark from a DS Portal Page

Here's our scenario: Some of our suppliers charge our corporate credit card immediately when an item is ordered from them.  (we provide some of our suppliers our CC b/c we get $ back on purchases).  Once our CC statement is available, these charges only show who the supplier is, but does not reference any PO number that we sent them (nor Invoice they sent us).  We are trying to find a way to match these charges to the orders.  I spoke with a Lawson business consultant and she said the bes...

Hi everybody, When I try to attach a file on a remote server in a MAIL node, the system sends emails without attachment. I want to know if this is a configuration problem or a limitation of the PFI. In this exemple, i set two attached file, the first one is local, and the second one is on a remote server. when i execute the flow, only the local file appear in email . BR, Hicham

I am running process flow and it can access tables in BN when using a Query Node.  However, it can't access any HR tables, such as EMDEPEND and EMPLOYEE. Th Query node returns nothing but does not generate an error message. Is this a issue of the permissions on the ID that is accessing Lawson  Any help would be appreciated. Patricia

I am able to create an html email using variables etc and email to recipient. I have a similar project where I would like to deliver a similar document to a printer or to the users inbasket. I would like the user to then be able to mail this document to the customer. PDF or some other format would be great. Is this possible via process flow. Thanks.

We are migrating from PFI to IPA and our inbaskets appear as it they are not enforcing the filtering rules. If we turn the filter on, users see no transactions. When turned off, they see all. Has anyone else run into this issue  Can you share how you fixed it, please Thanks.

One of our client(prospect) asked a very interesting question that if Lawson provides a facility where bulk approvals can be approved in a single click (for the same flow). I Haven't come across such a scenario in Lawson as of now  because  there can be different workuinits from different flows resting in  the inbasket at a time Does Lawson provides such facility (either on PFA or PFI)

I have a CSV file being delivered by an outside agency. It is a CSV file in that commas separate the fields, but they are also putting the ALPHA fields wrapped in double quotes. A typical record might look like this: 12345,'Terry','Pickering','this, that and others' I'm using standard data iterator activity to parse out each field. I also can remove the 'quote' characters. The problem is when I encounter a record where they have embedded the comma in a field surrounded by quotes. The parse...

I am adding users from Processflow using the Resource Update Activity Node. The users are being added to LSF9 Security. The RM Information is added correctly. The Identities information is added correctly. The Lawson Environment Information is not added. The user cannot log into Portal until a security administrator goes to the user record in Lawson Security Administrator and adds the Lawson Environment Information. Is this correct behavior or should I be able to fully add the user form the Reso...

Hello, I have created my first PF to capture assets from the AMASSET table and dispose the asset if a condition is met. I added an email message to include the asset number disposed. I would also like to build into my email message the number of transactions processed. I am using xxxxxx_RECORC_COUNT but it always returns 0 not the actual number processed. Any suggestions would be greatly appreciated on how to return the actual record count of transactions processed.