|
|
|
|
|
|
2 Replies and 1125 Views
Use IPA to query IFS 1125 2
Started by AndyG
Since IFS syncs with our 5 sub-domains, we would like to read/query the user information, to later use in the IPA.
Can IPA query IFS user information What node How Has anyone done this Thank you in advance.
|
|
|
|
2 |
1125 |
by AndyG 09/16/2020 11:47 AM |
|
11 Replies and 5623 Views
LPA- Default work title for UA 5623 11
Started by Lynne
Hi-
I need to modify some of the inbasket work titles and can't figure out where I can see what the default title is. If I look at the UA, work title, it is blank. But, when the inbasket generates there is a title that displays. Is there a default title that is used if you don't enter anything in the Work tab Work Title field of the UA node Thanks!
|
|
|
|
11 |
5623 |
by B Ledet08/10/2020 10:20 AM |
|
2 Replies and 1328 Views
Using Web Service in IPD 10.1.1 1328 2
Started by HDAustin13
Hello,
I am trying to use the Web Service node in IPD 10.1.1 to connect to a web service but not sure on how to start.Does anyone have any guildeline on how to make it works If so, can you please share. Thank you in advance.
|
|
|
|
2 |
1328 |
by HDAustin1303/03/2020 4:19 PM |
|
10 Replies and 6024 Views
Create export files from SQL code via IPA or crystal and LBI? 6024 10
Started by Joan Herzfeldt
I'd like to pick a few brains please. I'm trying to determine if IPA is a viable option for running SQL code and FTP'g the file or moving it to a directory. Most of my Lawson exports are created via a SQL View. So the next step just pulls the entire view (select * from LawsonView).
Currently in order to get the file into csv, tab, excel, etc... I have to create a crystal report and schedule it via LBI which exports it to a specific directory. My network team have t...
|
|
|
|
10 |
6024 |
by FireGeek2101/24/2019 7:09 PM |
|
5 Replies and 2335 Views
IPA Batch Job Montioring after WebRun node kicks it off 2335 5
Started by Deb Roberts
When we kick off a batch job with the WebRun node in IPA, is there a way to delay the flow from moving to the next node until the job successfully completes Or do we have to use a Wait node and determine how long the job usually takes to run
Thanks in advance for your help!
|
|
|
|
5 |
2335 |
by dmcdougald12/27/2018 9:23 AM |
|
1 Replies and 1311 Views
Email Node - High Importance Option 1311 1
Started by agersh
Does anyone know if the Email node for IP Designer V10.1.1.9.4205 provides an option to send emails as an High Importance email
|
|
|
|
1 |
1311 |
by JimY06/29/2018 12:12 PM |
|
2 Replies and 1791 Views
Calling Jobrun.exe to submit jobs 1791 2
Started by Deleted User
Hi,
We can submit jobs via Webrun node in Process Flow which internally calls jobrun.exe to execute jobs. Can we call the jobrun.exe to execute jobs using our own written desktop application just like LID
|
|
|
|
2 |
1791 |
by Deleted User03/12/2018 9:37 AM |
|
1 Replies and 3166 Views
FTP Node – Retrieve latest file from remote source folder 3166 1
Started by agersh
Using the FTP node I am trying to build a process that file transfers the latest file of a list of files located on a remote source folder. Has anyone written a process that searches a remote folder for that latest file then transfers the file using the FTP node
|
|
|
|
1 |
3166 |
by Kyle Jorgensen02/20/2018 1:25 PM |
|
|
1 |
2004 |
by brox0709/11/2017 4:07 PM |
|
2 Replies and 2537 Views
Convert TXT to PDF 2537 2
Started by PD
I have a formatted txt file that is converted to pdf using the bldxffiles utility, but the pdf does not look as nice as the formatted txt file. Can someone give me pointers on how to make that happen
I use a MsgBuilder node to create the file and tab is used for spacing.....see attached files for comparison
|
|
|
|
2 |
2537 |
by PD05/19/2017 12:57 PM |
|
9 Replies and 8580 Views
javascript functions in processflow 8580 9
Started by Maynard F.
Hello. I would like to see some of the custom functions that PFI users have developed. Specifially, I am wanting a function that will format a numeric field into an alpha numeric field complete with currency sign, commas and a decimal point. Any other functions will be appreciated. Please reply or post the code and tell me where to find it. Thank you.
|
|
|
|
9 |
8580 |
by Joan Herzfeldt08/16/2016 8:04 AM |
|
5 Replies and 2891 Views
Use Javascript to format Rate of Pay and FTE values from database table to include decimals 2891 5
Started by agersh
I am working on a ProcessFlow that uses an SQL Query Node to query the PERSACTION table. Two of the New_Value_ fields the query is referencing are the values for Rate of Pay and FTE. The values are stored in the table without decimals. For example Rate of Pay is stored as 000000000032050000 and FTE as 000000000000900000 . Using Javascript I am trying to find a way to format these values so that my ProcessFlow could use these values in their valid/correct decimal format.
A...
|
|
|
|
5 |
2891 |
by Dave Curtis07/28/2016 12:48 PM |
|
3 Replies and 4393 Views
Email Node - Include a picture in email content 4393 3
Started by agersh
Is it possible to include a pictures/graphics in the email content area of the Email node I am assuming that the content type will need to ne HTML.
|
|
|
|
3 |
4393 |
by Corvette Jim06/01/2016 1:16 PM |
|
|
1 |
2350 |
by Shane Jones05/10/2016 2:28 PM |
|
2 Replies and 3029 Views
Having trouble determining the HR15.1 PageDown AGS Call 3029 2
Started by agersh
I am working on a process to delete specific User Fields (User Field Values) from an employee. Using the following HR15.1 ags transaction call I am able to inquire the first page of HR15.1 for the employee. But I seem to be unable to successfully build the ags call to PageDown to the next page of user fields.
&91;Inquire&93;
_PDL=PROD&_TKN=HR15.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=I&HEU-COMPANY=1&HEU-EMPLOYEE=299&HEU-EFFECT-DATE=&_DELIM...
|
|
|
|
2 |
3029 |
by agersh02/02/2016 4:04 PM |
|
9 Replies and 4720 Views
Parse CSV Comma Delimited File with Quotes and Embedded Comma 4720 9
Started by agersh
Using the Data Iterator node I've been trying to figure out how I can parse the following CSV file/row, Comma Delimited with Quotes and Embedded Comma.
'1375','Annual','GRETA','GOLD','082189','Yes','REGINA','BRONZ','01/21/2014','BRONZ, REGINA;FRANKEN, JANET','TRANSCRIPTIONIST PATHOLOGY','12354','Yes','No','Yes','','','Submitted to HR','','','','2.03','01/21/2014','01/21/2014','0.00','0.00','0.00','','','01/21/2014'
Has anyone else come across this situation
|
|
|
|
9 |
4720 |
by GeoffTSJY08/04/2015 4:23 PM |
|
1 Replies and 5247 Views
ActiveX Component can't create object when trying to run wizard 5247 1
Started by jocelyn
I've been using LPA for about a year now, and wanted to develop a new flow that includes a Lawson Transaction node. When I click 'Build' to build the transaction, I get the following error:
Run-time error '429': ActiveX component can't create object.
I've written flows before that utilize the Lawson Transaction and Lawson Query nodes and have used the Build wizards to create the transaction/query strings. Suddenly I cannot. However, the big...
|
|
|
|
1 |
5247 |
by Woozy07/01/2014 9:15 AM |
|
23 Replies and 20384 Views
Installing and Configuring MSSQL JDBC for ProcessFlow Integrator 20384 23
Started by John Henley
Using SQL Update (as well as the SQL Query) nodes require locating/downloading and then installing/configuring JDBC drivers for your desired database(s) (e.g., Oracle, SQL Server, DB2, etc.) on your development workstation as well as your Lawson LSF9/ProcessFlow Server. You will also need some knowledge of JDBC connection string syntax. None of this is well-documented by Lawson (nor is configuration support provided by GSC).
Here are instructions for installing/configuring MSSQL JDBC for Proc...
|
|
|
|
23 |
20384 |
by masonp03/13/2012 11:07 AM |
|
9 Replies and 11390 Views
Someone - please share your PFlow Trigger form.... 11390 9
Started by Shane Jones
I am looking for a simple form that an HR user could access to trigger a processflow. I was going to just schedule the flow but they need to be able to trigger the flow their schedule. I do NOT want to give them access to Process Flow Administrator. I have heard others say that they have created a form that triggers a processflow. Is anyone willing to share their form (My other option is to create a flow that is connected to a PA52 action and then have the user enter a personnel action...
|
|
|
|
9 |
11390 |
by JeffR06/01/2010 12:13 PM |
|
87 Replies and 46902 Views
Migrating 8.0 Flows to 9.0 46902 87
Started by Joe O'Toole
We have some flows written in designer V 8.036 and they reference RD30. Is there a migration utility to move these to LSF 9 and will it move the flows even though the RD30 logan objects no longer exist
|
|
|
|
87 |
46902 |
by Shane Jones09/01/2009 1:58 PM |
|
6 Replies and 1076 Views
IPA 1 GB memory limit error 1076 6
Started by Quarantine
Infor recently instituted a 1 GB memory limit warning message on Cloudsuite MT that comes as a error in the workunit logs.It has then been hastily updated to 100 GB but it is impacting flows that are used as extract flows out of Landmark.
Ways to reduce the memory load other than reducing the number of assign nodes and writing to messagebuilder and then ftping to file at every 100 records or so.
The memory consumed in Landmark calls is huge. any way to reduce that
|
|
|
|
6 |
1076 |
by Robert09/01/2020 5:20 PM |
|
0 Replies and 229 Views
email authentication 229 0
Started by Ragu Raghavan
We have flows that send out emails with buttons, so users can approve/reject without logging on to Lawson. Has been working for many years.
Recently, the site changed their authentication from SAM to UPN. This seems to have broken something. Users are now forced to login to Lawson to take action.
The system property "emailActionAuthenticationRequired" was not there. tried creating it and setting it to true/false. No effect.
One theory floated is that the email server still use...
|
|
|
|
0 |
229 |
08/26/2020 9:14 AM |
|
6 Replies and 6855 Views
REST Calls in Infor Process Automation 6855 6
Started by Ethan
We are working on a new interface where the vendor provided a REST API. Is it possible to interact with a REST API through an Infor Process Automation We typically deal with flat files, this is our first project using the REST API. We will basically need to pull some data through the API, do an AGS call to load the data into a PA52 action, and then post some data back through the REST API. Any guidance would be appreciated.
|
|
|
|
6 |
6855 |
by HDAustin1308/19/2020 4:50 PM |
|
8 Replies and 899 Views
Triggering WFWK after a PR140 job run 899 8
Started by Preston Burdwell
Any suggestions as to how to trigger the IPA after PR140 I could add a WebRun node with PR140 submission, but wanted to see if you all know of other options. No Design Studio, and we are on a Single Tenant, Hybrid instance of S3
|
|
|
|
8 |
899 |
by B Ledet08/04/2020 11:19 PM |
|
0 Replies and 322 Views
using a flow to change LBI bookmarks 322 0
Started by Karen Sheridan
We use LBI dashboards for ESS functions. During the 2 days of payroll processing we need to disable/hide the direct deposit bookmarks. What I&39;d really like to do is swap for a flat page that says something about calling the payroll department or wait until Thursday. I know folks disable different forms/tokens during their payroll processing. What is the best way to handle Can I use a flow to swap the 2 pages out during those days
TIA - Karen
|
|
|
|
0 |
322 |
08/04/2020 8:44 AM |
|
2 Replies and 1206 Views
Automation for disabling active Directory 1206 2
Started by Utsav
Hello, is it possible to construct a automation workflow in lawson Infor Process designer (IPD) for disabling the employees from Active Directory when they get disabled from Infor
|
|
|
|
2 |
1206 |
by Kristi_ANTHC08/03/2020 12:23 PM |
|
2 Replies and 344 Views
Flow submitting a single job multiple times?? 344 2
Started by LauraPat
I have a fairly simple flow. A user places a file in a specific location - a File/Channel in Rich Client detects the file, passes it to the LSF server and then a Lawson job is kicked off (via webrun node) to process the file. It&39;s a CSV file with vendor numbers - the batch program they are being passed to is doing an invoked of AP10 to inactivate the vendors.
I ran it with 10 records, 100 records and 1000 records and it worked perfectly. I then decided to drop 50,000 rec...
|
|
|
|
2 |
344 |
by Karen Sheridan07/30/2020 2:28 PM |
|
2 Replies and 302 Views
Array values from Rich Client 302 2
Started by Karen Sheridan
I need to pass a list of employee status codes into the flow and put them in a simple array.
From the log:
FromStatusCodes = A1,A2,A3,A4,A5,A6,A7,A9,MD,ML,RW,WC - this list was hard coded in the start node of the flow &91;"A1","A2","A3","A4","A5","A6","A7","A9","MD","ML","RW","WC"&93; - field is defined as array
testInt1 = A2 - from FromStatusCodes&91;1&...
|
|
|
|
2 |
302 |
by Karen Sheridan07/30/2020 10:28 AM |
|
2 Replies and 329 Views
Error with Landmark Admin node 329 2
Started by Scooter
Below is from Log file with LM Admin error message.
Cannot find info on errorCode = 32. Infor Support has not provided solution yet. Your assistance is much appreciated. - Scott Kelley
ImportData_errorCode = 32
ImportData_informationCode = 0
ImportData_returnMessage = Landmark Admin ImportData: Command dbimport failed with error com.lawson.bpm.coreutils.PFIException: Landmark Admin ImportData: E...
|
|
|
|
2 |
329 |
by Quarantine07/28/2020 1:40 AM |
|
2 Replies and 522 Views
Capture joblog in IPA for Email Node? 522 2
Started by LauraPat
I have a custom batch program submitted through IPA in webrun node. The custom program displays total records processed and errored in joblog output in job scheduler. Is there a way to capture that and include in an email to the users (email node is part of the flow already) TIA
|
|
|
|
2 |
522 |
by Karen Sheridan07/08/2020 11:08 AM |
|
3 Replies and 923 Views
MT IPA: Getting Employee Audit History in IPA 923 3
Started by Quarantine
How do you get employee audit records into IPA if you are on MT We need to check each employee if he was full time at any point in the year to check if he is eligible for benefits. What is the best way to get all employee audit records for a particular employee in IPA for things like relationshipstatus, payrate , hourly or salary or SSN for a full year.
I am not looking at as of date values . i am looking for all audit records in a calendar year for an employee for particul...
|
|
|
|
3 |
923 |
by David Williams06/11/2020 8:58 PM |
|
8 Replies and 1326 Views
Sorting and summarising a csv file in IPA 1326 8
Started by Quarantine
As part of our migration to Cloudsuite we need to convert a 4GL program that reads a CSV file, sorts it by certain fields like company and accounting unit and then passes the summarized data for that company and accounting unit etc as journal entries into Cloudsuite. This was very simple in 4GL but not sure how to do this in IPA. Any other way using a Infor provided tool that can do this like application studio or birst is also welcome.
|
|
|
|
8 |
1326 |
by Quarantine06/08/2020 9:29 AM |
|
1 Replies and 384 Views
IPA Web Service to MS Exchange (Soap) 384 1
Started by Karen Sheridan
Has anyone used an IPA to check an email box, read subject and/or body, and process an attachment (save it to a file server)
Microsoft publishes the service reference (example below).
https://docs.microsoft.com/en-us/ex...achmentids
IPA/IPD 10.1; S3 applications
We are currently doing this with a .net application. The business requirements are changing for 2020 so I have to touch the .net application. If I could move the whole process to IPA that would be much ...
|
|
|
|
1 |
384 |
by David Williams05/27/2020 3:22 PM |
|
2 Replies and 505 Views
Data manipulation and Emails in IPA 505 2
Started by Joan Herzfeldt
I need some advice on the best way to send an individual email to multiple people with different data.
Info: IPA triggered when receive a file. Comes multiple times a day. Has less then 50 records.
Each file will contain multiple records for the same SA, however the file is in a random order. I need to send One email to each SA containing information about each record processed for them. The email can be sent for each file or once a day.
I&39;ve consided:
1. creating a...
|
|
|
|
2 |
505 |
by Joan Herzfeldt05/18/2020 3:25 PM |
|
4 Replies and 675 Views
Lawson Query doesn't like a space. 675 4
Started by Joan Herzfeldt
I have a very simple Lawson Query to look up a code I&39;m providing and see if it exists on the PA16 for specific user. I send the company, employee, and code and it mostly works fine. Unless there is a space in the code (ie: A SECADM). The lawson query wants to send the look up request as "ASECADM" instead of the space. I&39;ve validated the node works without a space. I&39;ve validated that the record I&39;m using DOES have the A SECADM code. ...
|
|
|
|
4 |
675 |
by Joan Herzfeldt05/15/2020 3:09 PM |
|
5 Replies and 766 Views
Best way to create a lookup table in IPA 766 5
Started by Quarantine
How do we create a lookup table in IPA I am basically trying to store a cross reference between GHR and S3 employees for the 100 odd employees that have different values in GHR for a multitude of flows that we already developed over S3 HR. Basically I plan to store the pfixrefvalue in a Javascript array and then refer that rather than making a landmark transaction call again and again. However I need to store both company and employee fields as an index in the array. Any ideas. Is object ...
|
|
|
|
5 |
766 |
by Quarantine05/13/2020 4:49 AM |
|
8 Replies and 1587 Views
Dynamically assigning users to useraction 1587 8
Started by Quarantine
Hi
We have a requirement where the user may require to dynamically reassign a pending user action to another user. We are already using the TimeOut functionality to reassign after 3 days but that is also predefined users or tasks. Is there a way a user can be passed as a variable value to a useraction.
I was thinking if it would be possible to send the user actor name as the value in reason comments and pass it as a value in next useraction node which will be used to reassign t...
|
|
|
|
8 |
1587 |
by Bob Canham05/06/2020 7:50 PM |
|
0 Replies and 7796 Views
Adding Form URL link in Email 7796 0
Started by Scooter
We want to add "Receipt Inspection Entry" URL link to UserAction "Notify" email, and have fields: Company, Receiver , Inspection Date populated when User clicks on URL link.
Want to add to UserAction on "Notify" email.
We are on CloudSuite v11.
Anybody know how to do this Thanks for your assistance.
|
|
|
|
0 |
7796 |
05/06/2020 10:43 AM |
|
10 Replies and 1757 Views
XML Node parse and assign 1757 10
Started by Steph76
Hello,
I need to create a PF to update the date fields for a job. I have a Lawson Transaction Node to Inquire on the job and an XML Node to parse the output from it so I can get the current settings. I do not have an XSD. I noticed some of the fields have a dash in the name and I'm having a problem when trying to assign the value to a variable. Fields without a dash return a value. For example, XML9300_output.AR580&91;0&93;.COMPANY, returns the Company. When trying to get the process lev...
|
|
|
|
10 |
1757 |
by David Williams04/27/2020 11:15 AM |
|
4 Replies and 2588 Views
IPA-REST API (web run) 2588 4
Started by Lan Henry
Does anyone have an example of a WebRun node to NEOGOV Their setup is REST API. Content type is json. I&39;m trying to post department data to NEOGOV and not sure what info I need to include in the header box of the webrun node.
I&39;m fairlly new at this, So far I have them as individual line. Not sure if they are correct.
===========================
POST /request HTTP/1.1
Host: https://api.uat.neogov.org/rest/departments
Accept: ...
|
|
|
|
4 |
2588 |
by Lan Henry04/24/2020 2:33 PM |
|
6 Replies and 1665 Views
ESS and IPA 1665 6
Started by thanef
We are LSF with IPA in Landmark.
We are testing some ESS Home Address Changes in our Test system. We are getting emails successfully sent to the email address listed on HS07.
HS23 has Process Flow enabled and html option. Where is the work unit I do not see it listed where our Work Units are for our scheduled IPAs.
|
|
|
|
6 |
1665 |
by thanef04/08/2020 6:06 PM |
|
1 Replies and 1313 Views
Encrypt a file in IPD flow 1313 1
Started by HDAustin13
Hello All,
I need to encrypt an outgoing csv file with the PGP key the vendor provided in the IPD tool but not sure on how to start.
Does anyone have done that before If so, can you please share the guide or a sample flow.
Thank you very much in advance,
HDao
|
|
|
|
1 |
1313 |
by John Henley04/03/2020 12:56 PM |
|
6 Replies and 1201 Views
Update configuration settings via IPD 1201 6
Started by Steph76
Hello,
I have a pf where with a starting payment number that I need to keep track of and increment each time the pf runs. I created a variable in my configurations on LM and I&39;m using a Landmark Transaction node to update it. I get the value of the configuration property and set it to a local value and increment by 1. Then I try to set the configuration property to the local variable value. I get the following error when trying to run it.
Activity Error com.lawson.rdtech.type.ViewExcep...
|
|
|
|
6 |
1201 |
by FireGeek2103/31/2020 1:39 PM |
|
5 Replies and 916 Views
Javascript error .. invalid XML character 916 5
Started by Joan Herzfeldt
Error processing flow configuration: org.mozilla.javascript.EcmaError: TypeError: Character reference "&3" is an invalid XML character. (initJavaScriptContext1)
All of a sudden we are getting the above error in our TEST system for ALL of our process flows. (we are still on v10 IPA and Landmark and LSF.) I was testing something new and found the problem but it started on the 18th of March. Apparently we put a windows update, etc... in place that night. My SysA...
|
|
|
|
5 |
916 |
by David Williams03/26/2020 2:55 PM |
|
0 Replies and 814 Views
MA60.3 Transaction Query 814 0
Started by AC_Slater
I am currently running into an issue where the transaction node is not performing as expected for the MA60.3. I want to choose a specific receipt line item, mark it to be selected, and then perform the special action "Select".
Unfortunately, although the XML for the transaction query appears to reflect what I&39;m looking for it to do, the receipt line item remains unselected (does not have an "X" for the FC).
Admittedly, I haven&39;t had to utilize flag c...
|
|
|
|
0 |
814 |
03/02/2020 5:15 PM |
|
7 Replies and 1156 Views
Req Item Rec Service Definition 1156 7
Started by Joan Herzfeldt
I&39;m trying to set up my first Trigger (previous ones have been set up by consultants). According to the "IPA Services for Infor Lawson Reference Guide (v10.0.5)" documentation the PO Receiving (PO30) has a trigger for each time a req line item is received. Service = Req Item Rec.
I set up the trigger (per instuctions) in Process Server Administrator -> Scheduling -->Service Triggers
I added my Process Definition &39;Receive_Req_Item&39; to the ReqItemRec Serv...
|
|
|
|
7 |
1156 |
by Joan Herzfeldt02/20/2020 10:22 AM |
|
5 Replies and 1576 Views
IPA - reading CSV file 1576 5
Started by Scooter
Can IPA read a CSV file from a laptop C: drive We are on Cloud v11.
Or, must CSV file reside in another directory Landmark
Thanks.
|
|
|
|
5 |
1576 |
by Todd Mitchell01/09/2020 2:38 PM |
|
2 Replies and 1376 Views
V11 Inbasket displays for User Actions 1376 2
Started by Scooter
On version 11, where are User Action inbasket display files (i.e. HTML, etc.) reside
Are they configured in Infor Rich Client If so, where
Do they reside on a Landmark drive if so, where
Thanks for your assistance.
|
|
|
|
2 |
1376 |
by Scooter12/27/2019 9:29 AM |
|
4 Replies and 2691 Views
File move/copy from within IPA (Processflow) 2691 4
Started by SWilkins
Lawson environment 10 LSF on one windows 2012 VM and Landmark on another windows 2012 VM. IPA (Processflow) running on the Landmark VM. Using designer 10.1.1.48 and using the SysCommand node to run a COPY or MOVE command. The flow works fine if the source and destination for the file location is either the C or D drives of the LSF server (D is where LSF is installed). But if we want IPA to move the file to a network location it fails, even if we map a network drive on the...
|
|
|
|
4 |
2691 |
by John Henley12/02/2019 3:22 PM |
|
5 Replies and 1757 Views
Array size limit 1757 5
Started by Ragu Raghavan
In my flow, I need to lookup a custom table outside the Lawson schema for each transaction. The SqlQry takes a long time. I wonder, if I can do a single qry at the beginning and load the results of the Sqlqry into an Array, avoiding the multiple lookups. Catch is that there are likely to be 50,000 records in the custom table. Will that cause the LM server to crash Are there any limits to how big the array can be Thanks.
|
|
|
|
5 |
1757 |
by Ragu Raghavan11/29/2019 4:30 PM |
|
1 Replies and 987 Views
Deleting UserIDs from Landmark Security 987 1
Started by Scooter
We are creating a flow to delete User IDs from Landmark Security.
I'm building the code with Landmark Transaction Builder.
Does anyone know the 'Data area', 'Module', 'Object Name' values to use
Thanks.
|
|
|
|
1 |
987 |
by Scooter11/27/2019 11:05 AM |
|
1 Replies and 1323 Views
IPA performance 1323 1
Started by Thiago Corredor
Hello everyone !
Do you know how where can we check if exist any IPA running for more than 3 or 4 hours long
Some IPA tables or GRID can help
Thanks !
|
|
|
|
1 |
1323 |
by JimY11/22/2019 6:47 AM |
|
3 Replies and 1463 Views
WriteAttach via WebRun 1463 3
Started by Steph76
Hello,
I'm trying to use a WebRun node in IPD to add an attachment to an invoice. I want to attach a URL. I tried following the documentation and other posts I saw, but I'm still having problem. When I set the content type to text/html the Work Unit shows as Completed in Rich Client, but the log shows this:
ERROR key='UNKNOWN_ERROR' level='1'
!&91;CDATA&91; An unknown error occurred. Please contact your system admin. &93;&93;
!&91;CDATA&91; Check IOS logs for details. &93...
|
|
|
|
3 |
1463 |
by TomED11/21/2019 4:44 PM |
|
9 Replies and 3316 Views
Modifying Lawson Environment Info from a Flow 3316 9
Started by Deleted User
I've created a flow to build new Resource records for my portal users using the Resource Update node.&160; However, I don't see a way to update the Lawson Environment settings (as seen in LSA) from my flow --&160;specifically,&160;I need to update&160;the Data Area/ID field.&160; As a result, my newly defined user is unable to log in to portal until the Data Area&160;gets populated and causes a GEN\USER record to be created.&160;
Is there a way to add or update the Lawson Environment set...
|
|
|
|
9 |
3316 |
by Adam11/20/2019 10:10 AM |
|
0 Replies and 929 Views
Referencing Business Tasks in an IPA Flow 929 0
Started by Tony
Hello, I was wondering if anyone has experience triggering a business task in a custom IPA flow. Specifically, I am looking to trigger the EMail Executor business task at the end of the flow, but to only process the emails that have gone into the 'New' status that same day. As context, I recently built a custom flow to trigger a 'reminder' action for our Health Module components but the emails are getting put into the 'New' status in the Email Queue. We've found that the temporary solution...
|
|
|
|
0 |
929 |
11/18/2019 2:09 PM |
|
0 Replies and 944 Views
QUEUEDJOBS WebRun 944 0
Started by Scooter
I'm running a Webrun to return any job in 'Needs Recovery' status and want to know how to pull certain output fields, like jobOwner, jobName. How do I pull those 2 output fields from the Webrun Output results
Here's the Webrun code.
/lawson-ios/action/ListQueuedJobsfilter=jobStatus20EQ20needsRecovery
Below is Webrun Output results, i.e.
jobOwner='u0003035' token='BN320' jobName='BN320TEST' jobQueue='**********' jobStepType='application' jobNumber...
|
|
|
|
0 |
944 |
11/13/2019 4:08 PM |
|
3 Replies and 1042 Views
Web Run Node - File Upload 1042 3
Started by Chad Dirst
We are successfully using IPA to call various REST API web services via the Web Run node. In one of the calls we need to transmit a file and am having issues getting this working. Has anyone had experience will successfully transferring files via an IPA Web Run node
|
|
|
|
3 |
1042 |
by David Williams11/08/2019 2:10 PM |
|
2 Replies and 1497 Views
Resource Update Node - Remove specific Role or Group 1497 2
Started by Nabil
Hi All,
I'm trying to delete a specific Group from the existing list. I only want to delete 'Manager Self Serve' but instead it deletes all group the user has.
In the Group value, here is what I have:
|
|
|
|
2 |
1497 |
by JimY10/21/2019 5:31 AM |
|
1 Replies and 930 Views
Issue with JavaScript Date 930 1
Started by tommyg-006
Good Afternoon All,
I am hoping somebody else has run into this issue before. I seem to be having with a JavaScript calculation in IPA. We are trying to take today's date (i.e 10/15/2019) and move it forward to December so the date range starts at 12/01/2019. However, when the script runs it returns a date of 00/01/2020. The script works for every other month in the calendar except for 12/1. Below is the script that we have in IPA:
Evaluating JavaScript ex...
|
|
|
|
1 |
930 |
by David Williams10/15/2019 3:22 PM |
|
2 Replies and 804 Views
Effective Date in a flow/form 804 2
Started by weeoooohhhh
Hey guys, so I need to obtain the Effective Date within the Transfer Flow. There is a caveat to this though. I have the node looking up the Effective Date variable from the PFIWorkUnitVariable table which works great. However, once the flow gets into the HROPs inbasket, they may end up changing the Effective Date at this point within the flow. Once that happens the PFIWorkUnitVariable table does not get updated with the new Effective Date so I can't re-look it back ...
|
|
|
|
2 |
804 |
by weeoooohhhh10/11/2019 10:29 AM |
|
7 Replies and 1574 Views
Batch job monitoring with ProcessFlow 1574 7
Started by Scooter
I'm creating a processflow to monitor Batch jobs completion.
Using SQL node to query 'GEN' table QUEUEDJOB.
When testing query, field STATUS returns values like &91;Bf106b0
First, is this correct table to monitor batch jobs
If yes, how can we determine if job went to recovery or completed successfully when
STATUS has values like &91;Bf106b0 What am I missing
Below job PA102 ...
|
|
|
|
7 |
1574 |
by Scooter10/02/2019 2:22 PM |
|
3 Replies and 1004 Views
IPA and ADFS issues 1004 3
Started by Joan Herzfeldt
We just switched to ADFS and my IPA inbasket is requesting the user to Login again in order to see the detail of the requisition/workunit.
The User Action node is set up with a display type of HTML and uses File Id: recsum.htm (see attached print screen).
Where is the connections between the user who’s already logged in and viewing their inbasket (with the general information) to see detail.
My basic understanding is... the system is displaying the general detai...
|
|
|
|
3 |
1004 |
by Joan Herzfeldt10/02/2019 12:18 PM |
|
|
10 |
3006 |
by Scooter09/05/2019 9:06 AM |
|
4 Replies and 1091 Views
System Command node 1091 4
Started by Scooter
for example:
cd /Lawson/
cp fileA fileB
|
|
|
|
4 |
1091 |
by steve finger09/04/2019 9:05 AM |
|
|
8 |
2150 |
by David Williams08/21/2019 11:38 AM |
|
5 Replies and 1565 Views
Removing Identities with IPA 1565 5
Started by Scooter
We want to remove employee's Identities from Infor Rich Client.
Our test flow is removing the employee's userid and passwords from each Identity
but, the flow is not deleting the Identity name (e.g. SSOP) from Infor Rich Client when we view the employee, after flow is run.
We are using a WebRun node with code that works on our PROD environment.
What could be missing from our 'test' flow that stops it from deleting the employee's Identities
Thanks for your assistance. ...
|
|
|
|
5 |
1565 |
by Scooter08/15/2019 4:29 PM |
|
2 Replies and 1028 Views
How to calculate last day of current month 1028 2
Started by Scooter
In processflow, we need the last day of current month.
This last day of month value will be used in batch pgm parm date, i.e. BN100, Thru-Date=20190831
Has anyone does this before Is there an Infor PF date function that can do this
|
|
|
|
2 |
1028 |
by Scooter08/14/2019 4:01 PM |
|
5 Replies and 1084 Views
IPA Data Iterator node cannot find input file. 1084 5
Started by Scooter
IPA Data Iterator node cannot find input file. Need your assistance to identify issue with Data Iterator node.
Error message is 'File 'https://lawtestv10.dart.org/lawson02/univ2/dartipa/appload.CSV' does not exist.'
We've confirmed file (appload.CSV) exists on this directory (/lawson02/univ2/dartipa/ and server (lawtestv10.dart.org).
Below error message was copied from workunit log file:
Activity nameI1 id:1 started 08/12/2019 03:41:24.578 PM
Executing Data Iterator Activity DI1 ...
...
|
|
|
|
5 |
1084 |
by Scooter08/13/2019 4:19 PM |
|
0 Replies and 812 Views
IPA Email Node when SMTP Server is Unavailable 812 0
Started by jmartin
We’ve had issues lately with our on-premises Exchange server and found that emails failed from IPA when SMTP was unavailable. We were hoping they would be able to queue... like magic. Unfortunately, we are unable to simply restart the work units to resend the email notifications.
How do you handle situations where the SMTP server may be unavailable but the jobs need to continue to run and emails need to send/queue
Do you setup an error conne...
|
|
|
|
0 |
812 |
08/12/2019 5:12 PM |
|
13 Replies and 1639 Views
Records returned in IPA using lawson query node 1639 13
Started by steve finger
when i do a lawson query from IPA, when the number of records specified in the query string is reached (512 by default i believe), the query seems to 'skip' a large number of records before the next record returned by the query. for example...if the 'MAX' value is set to 512, the first 512 records are returned....then a number or records are skipped before the next record is returned.
pretend i'm querying the apvenmast... i have 10,000 vendors numbered sequentially from 1 to 10,...
|
|
|
|
13 |
1639 |
by steve finger08/08/2019 7:28 AM |
|
8 Replies and 1701 Views
IPA - Webrun used to update Landmark 1701 8
Started by Scooter
I would have used Landmark Transaction node to update user's profile.
Not sure why previous developer coded like this. See below code string and this is only a small part of entire code string.
If anyone can explain why it was coded this way, please reply.
I don't see advantage and this code is very difficult to maintain.
WebRun Code (partial string) - code is executed from a WebRun node.
/scwebadminapp/ResourceManagementServletTASKTYPE=PROVISIONING&OBJECTTYP...
|
|
|
|
8 |
1701 |
by JimY08/08/2019 6:15 AM |
|
2 Replies and 1036 Views
Setting up IPA Service Process in new IPA environment 1036 2
Started by Kert490
I set up the Infor Process in the Rich Client in the new environment exactly as it is currently setup in our production environment, but the form is unable to communicate with the Service I setup in the Rich client.
This is the error that is generated after I run the GL146 process from Lawson:
Processing GL146 - Batch Journal Control
java.lang.NoClassDefFoundError: com/lawson/bpm/eprocessserver/interfaces/mingle/MingleRequest
at java.lang.Class.getDeclaredMethods0(Native Method)
at java.l...
|
|
|
|
2 |
1036 |
by Kert49007/31/2019 10:04 AM |
|
0 Replies and 853 Views
powershell script vs for loop w/IPA nodes 853 0
Started by Joan Herzfeldt
I need some advice with a new IPA process We have Lawson S3 v10 and IPA v10.1.1.58 I am creating an IPA that automatically update the PA16 The file I'm receiving can not be sorted or changed before I get it. The records are random, meaning there are multiple PA16's to be updated for the same person, but the records are NOT grouped together they can be 3rd record, 12th record and 22nd record. I want to update Each Employee's PA16 screen once. So I need to order the file or loop through a...
|
|
|
|
0 |
853 |
07/10/2019 3:17 PM |
|
1 Replies and 691 Views
Server Timed Out 691 1
Started by ScottCT
We get these time out errors on some of our processes, is there a way to increase the timeout time And which server would this setting be located, on the IPA or in M3
|
|
|
|
1 |
691 |
by steve finger07/10/2019 10:30 AM |
|
0 Replies and 748 Views
Updating PO20.2 using Transaction Node 748 0
Started by AC_Slater
Good morning,
I am currently working on a process flow to update a single field on the PO20.2 (PCR-PO-USER-FLD-5) using the Lawson Transaction Node. My original thought was that I would be able to take the header information that is on the top of the PO20.2 screen to select the correct record and then perform a “C” FC on the form. I isolated all of the header fields (pcr-company, pcr-buyer-code, pcr-po-date, pcr-po-number, pcr-vendor, pcr-purch-fr-loc, pcr-lcatio...
|
|
|
|
0 |
748 |
07/08/2019 11:05 AM |
|
0 Replies and 785 Views
Landmark transaction query results 785 0
Started by mrabas
We are implementing GHR so I am starting to learn how to use the Landmark Transaction nodes to query data.
In S3, with a Lawson Query node we could access a specific row from a query like so:
EmpQry_3_EMPLOYEE
Which would return the EMPLOYEE field for the third result of the query. Accessing the results outside of the query loop allowed us to speed up the processing considerably.
Is there any way to access the full query results from the Landmark Transaction node...
|
|
|
|
0 |
785 |
06/20/2019 3:36 PM |
|
9 Replies and 1514 Views
Parsing CSV with double quotes 1514 9
Started by AC_Slater
Hi All,
I'm hoping someone else might have had to tackle a similar issue, and seeing as though my regex skills are pretty rusty, I thought I'd reach out.
I am currently using the Data Iterator to go through a CSV file to break up the file by line. Normally, I would use a second data iterator to go through and break up the fields by their delimiter, which is a comma, but unfortunately some of the fields have valid commas within their data:
For instance:
1234,Cake,,'Smith,John',,'Status:...
|
|
|
|
9 |
1514 |
by steve finger06/18/2019 12:49 PM |
|
0 Replies and 873 Views
Cannot activate or deactive a File Channel in Rich Client 873 0
Started by LauraPat
I use File Channel/Receiver to initiate a process flow. It's been working fine until we had a problem with our system and the process hung due to bad data and an enormous file. To prevent it from kicking off again - I tried to deactivate the File Receiver. I didn't realize until now that the deactivation failed). I've tried to deactivate it again and I get an error that the receiver is not active. If I try to reactivate it - I get the error 'Receiver must be in activated failed or inactive or fa...
|
|
|
|
0 |
873 |
06/01/2019 4:29 AM |
|
16 Replies and 2535 Views
Is this possible? 2535 16
Started by Ronnie
We currently have a server that has a scheduled task on it to run an executable. That executable takes files from one directory and moves them to another.
Is there a way that a process flow can be written that can take files and move them from one directory to another
I know there is a file access node that can be used to check a location to see if a file exists, but what about moving files
|
|
|
|
16 |
2535 |
by steve finger05/29/2019 7:50 PM |
|
0 Replies and 853 Views
LWSNTXN Node padding with '' 853 0
Started by LauraPat
I have a process flow that is running a SQL query and the output from that query is the run group out of GLTRANSREL. I update the run group in my GL165 job through the LWSNTXN node, using that run group, and then the job is submitted via the WebRun Node. But when I update the job using the output from the query (which is in a string) - the run group in the job parameters is being padded to the right with '' instead of spaces so GL165 ends up not finding the run grou...
|
|
|
|
0 |
853 |
05/22/2019 1:40 PM |
|
11 Replies and 2917 Views
Wondering your thoughts on IPA and Lawson 10 or Cloudsuite 2917 11
Started by Erik G.
Good Afternoon all,
My hospital moved from Lawson 9 to Lawson 10 late last year and we are having conversations with Infor about moving to Cloudsuite. Some of the things they have shown our materials and accounting staff revolve around using IPA which we don't currently use. And as you might have guessed, they loved what they see and they want it right now.
My question to all of you what are your thoughts on IPA
Are you using i...
|
|
|
|
11 |
2917 |
by David Tashima05/03/2019 12:18 PM |
|
1 Replies and 897 Views
WebRun example for SmartyStreets 897 1
Started by Garry Ferwerda
Does anyone have an example of using a WebRun node with SmartyStreets street address API Is so would you be interested in sharing it
Thanks
|
|
|
|
1 |
897 |
by Dave Curtis04/24/2019 3:33 PM |
|
13 Replies and 1873 Views
PA52 - error pending action does not exist 1873 13
Started by PD
I first do a PA52 inquire and based on a condition then proceed to do a PA52 change which is to update the EFFECTIVE date. I get an error message 'pending action does not exist' while trying to do the PA52 change. Not really sure what that means....any ideas!
_TKN=PA52.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&PCT-ACTION-CODE=TERM&_HK&_IMMEDIATE_ACTION=1&PCT-COMPANY=0100&PCT_NEW_EFFECT_DATE=20190511&PCT-EMPLOYEE=382723&PC...
|
|
|
|
13 |
1873 |
by PD04/22/2019 10:50 AM |
|
2 Replies and 1020 Views
Documentation 1020 2
Started by PD
I've been trying to code a process flow using LWSNTxn node to first delete a record and then add to PA52. Can someone please refer me to any available docs that might help me with this I feel like I am shooting in the dark and time is being wasted for something that should be straight forward....I think.
Thanks
|
|
|
|
2 |
1020 |
by Dave Curtis04/19/2019 3:36 PM |
|
2 Replies and 769 Views
Performing taks timeouts in separate flow 769 2
Started by Gene B.
We are looking to create reminders and timeouts to auto approve certain personnel actions based on varying period end dates (dependent on process levels). So the timers in hours or days on the user action node would not be set at all.
So far, creating a flow to read PERSACTION and calculate when to send reminder emails works. In order to auto approve after a similar calculation I was going to use a call to PA53 to approve. That is still leaving the task in the users inbasket. How do I rem...
|
|
|
|
2 |
769 |
by Gene B.04/18/2019 10:35 AM |
|
1 Replies and 712 Views
LMTxn node - Updating user field 712 1
Started by PD
I need a bit of guidance on how to update the Alpha field in the USERFIELD_STORAGE table using a LMTxn. I am not exactly sure what _module, _objectname, _actionName and _actionType to select.
Thanks
|
|
|
|
1 |
712 |
by PD04/18/2019 10:14 AM |
|
7 Replies and 1630 Views
Best way to format HTML email 1630 7
Started by Chris Beecy
I am wondering how other IPD developers format the HTML message of an Email node. I tried to create a formula/variable with to simulate a CSS style sheet but it 'sorta' worked but not completely. I have had luck using inline styles but that spreads the formatting around (as I build the message) AND cannot be reused. What I'm hoping for is a way to define a CSS Style Sheet in a variable (or global configuration) and reuse for all flows that need to send an email that conform to a single standard....
|
|
|
|
7 |
1630 |
by Chris Beecy04/16/2019 6:36 AM |
|
0 Replies and 942 Views
Error 143 on importdb in IPA 942 0
Started by LauraPat
Anybody know what error code 143 is on importdb I can run the command from the command prompt and the data imports into GMDISTREL without issue. I can run other GMDISTREL files using the same PF and they load without issue using IPA. But I have a file that keeps throwing the 143 error through IPA but not when I run the importdb from the command line. Any ideas I've been struggling with this all morning. Thanks in advance - Laura
|
|
|
|
0 |
942 |
03/12/2019 11:25 AM |
|
0 Replies and 1000 Views
How can we trigger the Employee ID auto number via IPA? 1000 0
Started by FireGeek21
We are working on implementing security automation for AD and other applications for contractors. They are not, at this point, being entered into LTM but for other reasons the organization would like to enter them into LTM. An option that is being pushed rather strongly is that the point of data entry for these contractors is external to LTM and that a data feed would be sent to LTM to update the 'employee table'.
My concern is how to get the employee number generated. Can the...
|
|
|
|
0 |
1000 |
03/01/2019 9:10 AM |
|
0 Replies and 954 Views
Update HR155 strange error 954 0
Started by Lance Jurgensen
I am running a flow that will update an employee group, I need to update the HR155 job prior to running it.
I get an error on field 'TC', but there is no error message.. Anyone seen this
&91;Debug - Feb 18, 2019 8:30:32 AM CST&93; Process resumed
Activity started: LwsnTxn6 (Run Id: 7)
S3 Transaction LwsnTxn6: Calling transaction server https://***redacted***.org:1443 with string _PDL=LAWPROD&_TKN=HR155&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&...
|
|
|
|
0 |
954 |
02/18/2019 8:37 AM |
|
2 Replies and 1661 Views
Managing Flows --Release VS Restart 1661 2
Started by tambrosi
Hello All,
Have a question that I cannot find no doc on. When using the Info Rich Client, there is a Release and Restart option available. I am trying to find out what the Restart option would be used for.
IE: If a flow that has multiple nodes ends up failing for some reason, and goes to failed status, Will the restart pick up at the failed point or does it go back and execute the flow from the beginning
Thanks...
|
|
|
|
2 |
1661 |
by LisaC02/13/2019 4:34 PM |
|
1 Replies and 882 Views
SQL Transaction Node MERGE - Stopped Working 882 1
Started by FireGeek21
We have a process flow whereby the final SQL Transaction seems to have stopped working. We can execute the UPDATE function via SQL Mgmt Studio but it will not function in the process flow. The flow doesn't have any errors in the log file. All columns are in the right order. I have replaced the node. I have rewrote the whole flow. Nothing seems to work.
Thoughts
MERGE dbName.dbo.tblTarget as T
USING dbName.dbo.tblSource as S
ON (T.PeopleID ...
|
|
|
|
1 |
882 |
by FireGeek2102/13/2019 3:58 PM |
|
6 Replies and 1409 Views
WFWK 1409 6
Started by ALW
How do I give a Lawson user access to the WFWK form I am a Lawson user with the Admin role and I can access the form without a problem. Another user who tries to access the WFWK for gets the following error:
|
|
|
|
6 |
1409 |
by edison02/13/2019 11:43 AM |
|
5 Replies and 1048 Views
Running Stored Procedure From IPA 1048 5
Started by Rkapoor
I am trying to run the stored procedure using sql query node and selecting run sql procedure.
When I click on select button, it connects me to the sql server, all I see is user ids defined in that database, I don't see the list of Stored procedures. any suggestions why I can't see the stored procedures... I don't have access to sql server.
I can run the sql query on this sql server, no issue there.
I can run the stored procedure if I select type sql query,build, other(no...
|
|
|
|
5 |
1048 |
by Rkapoor02/13/2019 11:06 AM |
|
9 Replies and 3065 Views
FTP node 3065 9
Started by Srini Rao
How do I use the FTP node in IPA I'm not finding the place for FTP URL ,USER and password etc
|
|
|
|
9 |
3065 |
by Jeremy02/12/2019 8:22 PM |
|
6 Replies and 1121 Views
SQL query to list all of work units in Rich Client 1121 6
Started by HDAustin13
Hello All, I need to write a sql query to list of all work units that have been ran on the system (those that are shown in the Work Units, Rich Client tool) including all status of Completed, Failed, Cancelled, etc. Can any one please advise which database tables that I can use for this query Thanks in advance. Han
|
|
|
|
6 |
1121 |
by HDAustin1302/11/2019 7:07 AM |
|
6 Replies and 920 Views
Dynamic Date Trigger Variables from Process Trigger 920 6
Started by PP
I have a Process Trigger created for an Process Flow with 2 date trigger variables. I am trying to schedule this IPA to run everyday. I want the date variables to dynamically populate with the respective date of the day it is running. For example, if it kicks off today the 2 trigger variables should be today's date, tomorrow it should be tomorrow's date and so on and so forth. Attached is the image of what I am trying to do. What should I put in the value of the Trigger variables CheckBeginDate ...
|
|
|
|
6 |
920 |
by Bob Canham02/08/2019 9:43 AM |
|
5 Replies and 1339 Views
How can a user easily pass dynamic parameters to a ProcessFlow Process 1339 5
Started by Kert490
I am trying to find an easy was that a user can easily pass 3 dynamic parameters to a Process flow and initiate the process. I created jobs before that wait for a file and then read it, but I would like to do it from a custom Form if possible. I'm not finding what I need so far. Any ideas
|
|
|
|
5 |
1339 |
by Kert49002/04/2019 4:02 PM |
|
2 Replies and 1049 Views
Spooling Delimited pipe text output file 1049 2
Started by HDAustin13
Hello everyone,
I am trying to create an IPA flow that generates an output as the 'delimited text' output file (as shown below) but keep having an issue of it does not spool the output file even thought it said so in the log file.
Sample Delimited text which begin and end of each with double tildes (~~) and separate each column with the pipe (|):
~~ContractNumber|ContractName|Location~~
Does any one know if this possible to get done in IPD version 10.1.1.78
Here is how I di...
|
|
|
|
2 |
1049 |
by HDAustin1301/28/2019 7:09 AM |
|
5 Replies and 1136 Views
Process Flow and Proxy Users 1136 5
Started by pops
We Designed a Process Flow that has a Submitter and an Approver. Sometimes, one of the users go on Vacation so I create a Proxy User for the person going on Vacation. However, when running the Process Flow, the email that states that 'this needs to be approved' goes to the person on vacation not to the Proxy User. Same thing for submitting a file to be processed by the processflow (workflow). Any emails that would go to the Submitter should go to the Proxy user but they s...
|
|
|
|
5 |
1136 |
by pops01/22/2019 3:46 PM |
|
0 Replies and 1047 Views
Proxy User 1047 0
Started by pops
We have a workflow that has a submitter and an approver. Instead of me being the submitter and approver, I made a proxy user for both. The file was submitted and goes through the workflow. The proxy user gets the file in his inbasket to approve or reject but I am getting the email not him. Is there something we must do in order for him to get the email instead of me We want to use this feature for when people are on vacation or out of the office for an extended per...
|
|
|
|
0 |
1047 |
01/22/2019 2:38 PM |
|
2 Replies and 1121 Views
Set oCatValue with multiple Filter Values 1121 2
Started by Kert490
I have setup the users Filters in IPA so that the Filter Values correspond to 'Submitter' and and 'Approver' that will get emailed. Currently I set the oCatValue to the Filter Value and get back the Email addresses associate with the users with that Filter Value.
The requirements want us to allow multiple Filter Values, so I would like to do something like oCatValue = '3602402355,3601403355' where 3602402355 and 3601403355 are different filter values and get back all emails for users...
|
|
|
|
2 |
1121 |
by Kert49001/22/2019 1:51 PM |
|
5 Replies and 1294 Views
Cant delete file on Remote Server - V11 1294 5
Started by Tre
A file gets created on a completely separate server. I do work with the file, then I need to delete it from the remote server . . . Im using the File Access node to delete it, but it is not finding the path, actually doesnt even find the server.
I have the server, user and password already in Richclient (sys config) under the FileTransfer tab (don't see spot to create one under FileAccess tab).
Any Help
|
|
|
|
5 |
1294 |
by Tre01/21/2019 10:02 AM |
|
8 Replies and 1693 Views
Send query results to delimited text file (*.txt) 1693 8
Started by HDAustin13
Hello All,
I am working on a project that requires an IPA to send query results to a format of delimited text file (*.txt) which use special characters like (|,~, ^) to separate each record.
Can any one please advise on how it can be done in IPA (IPD Designer CU70)
Thanks in advance,
Han
|
|
|
|
8 |
1693 |
by David Williams01/10/2019 9:11 AM |
|
3 Replies and 2630 Views
USPS Address Validation API Through IPA 2630 3
Started by Dave Curtis
Anyone using IPA to do validation of address
USPS has an API that allows the use of XML calls and returns address validation through their API. Was wondering if anyone has done this.
Dave
|
|
|
|
3 |
2630 |
by Ja'Tia Brown01/09/2019 10:40 AM |
|
7 Replies and 1846 Views
Lawson IPA Javascript Arrays 1846 7
Started by Kert490
I am developing a IPA workflow to import data from a spreadsheet and then create Lawson Transactions from each record in the spreadsheet. I am using a double dimension array in javascript to store the lines and columns from the spreadsheet before I validate and then import the data with Lawson Transaction nodes.
When I run the process on the development server, it runs fine and the Transaction nodes insert the data in the database with no errors. When I deploy to the develop...
|
|
|
|
7 |
1846 |
by Kert49001/07/2019 3:42 PM |
|
1 Replies and 1655 Views
ListAttachments, ReadAttachment 1655 1
Started by Garry Ferwerda
I am in the process of modifying some flows and converting the CGI getattachment processing to the ListAttachments service. I am having trouble getting the ATTACHMENT-NAME and ATTACHMENT-TEXT values. I am able to access orther values such as LIST numRecords value. I took a XML file returned from a call to the service in a browser and created an .xsd file from it. I don't know if the issue I am having is with the xsd or how I am trying to access the values in the flow.&nbs...
|
|
|
|
1 |
1655 |
by Ragu Raghavan12/20/2018 1:04 PM |
|
6 Replies and 1610 Views
AGS call to HR13.1 1610 6
Started by Lance Jurgensen
Hello,
I have been looking and trying everything I have found but still can not get past the Ok to continue prompt. Is there documentation somewhere on these for each form
My AGS call to update the STUDENT flag to N
_PDL=HRDEV&_TKN=HR13.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&EMD-COMPANY=15&EMD-EMPLOYEE=123456&EMD-SEQ-NBR=2&EMD-STUDENT=N&VERIFY-DATE=&EFFECT-DATE=20181210&CREATE-TRANS=N&_DELIM=09&_OUT=XML&_EOT=TRUE
I'm...
|
|
|
|
6 |
1610 |
by Lance Jurgensen12/10/2018 1:29 PM |
|
16 Replies and 4493 Views
Full Audit Log 4493 16
Started by Richard Lyons
For my current client, I have been requested to extract employee termination history to show why the employee was terminated. I can easily do this in S3, but I am not sure where to look in the Landmark database. Can anyone point me in the right direction In S3, the reason code I need was stored in the PERSACTHST table. I am hoping there is an easy way to extract the data I need out of the Audit Log.
|
|
|
|
16 |
4493 |
by HDAustin1312/06/2018 3:15 PM |
|
8 Replies and 1922 Views
BN32 update specific line? 1922 8
Started by Lance Jurgensen
I am trying to update BN32.1 lines but it always wants to update line 1. The query brings back the DC plans that do not have a stop date for terminated employees. Is there a way to determine what line a record is on In my example I have Benefit Type = DC and in the form the inquire brings back 3 lines, a DC04, DC02 and a DC05.
My transaction string is as follows and I'm guessing I need to do something on the highlighted entry below
_PDL=&_TKN=BN32.1&_EVT=CHG&_RTN=DATA&_...
|
|
|
|
8 |
1922 |
by Lance Jurgensen11/05/2018 3:31 PM |
|
1 Replies and 1354 Views
Remove Requester Identity with IPA 1354 1
Started by SaraP
I have an automated flow to disable my users but I am stuck on the process to remove the Requester Identity. I currently am trying to use a Resource Update node, but it deletes the entire user profile. Any help is truly appreciated!!
|
|
|
|
1 |
1354 |
by AnnH11/01/2018 9:02 AM |
|
0 Replies and 1089 Views
Hide Lawson Ribbon Bar In Custom Inbasket Display 1089 0
Started by Rkapoor
I have created a custom design studio page for inbasket display exec, the page shows up fine in user's task, but it also displays the Lawson grey ribbon as well with options of Help and User's preferences.
Is there way to hide this ribbon, see attaché screen shot...
Thanks
|
|
|
|
0 |
1089 |
10/22/2018 12:32 PM |
|
3 Replies and 4876 Views
Update user's attributes in AD 4876 3
Started by Rkapoor
Goal - Capture employee changes from Lawson and update AD attributes with new changes, such as phone number/Manager's info/Activate/Deactivate user.
I am planning to read HRHistory table to capture the changes at end of the day into CSV file, then update AD with new information.
Is it possible to use sycmd node to run power-shell script to update AD
|
|
|
|
3 |
4876 |
by TBonney10/01/2018 9:03 AM |
|
3 Replies and 1395 Views
Change the sys cmd user to pfuser? 1395 3
Started by NHBB
We have a system command node configured to invoke Windows PowerShell on the application server and run a PowerShell script file. We need to use the PowerShell Active Directory module to update Active Directory. Currently pfuser is the account that can update Active Directory. The system command node runs as Lawson so we get a security violation when the PowerShell script runs. Can the system command node be configured to run as a different user Configuring the Sys Cmd t...
|
|
|
|
3 |
1395 |
by Joan Herzfeldt08/15/2018 7:58 AM |
|
12 Replies and 5992 Views
Data Iterator Question 5992 12
Started by Brian Berenger
I'm using the data interator to input a file.&160;&160; The file is comma seperated.&160; The fields are 'Name', 'ID', 'Email','Company', etc.
I have four variables, varName, varID, varEmail, varCompany
What I want to do is simply loot is through the file and assign each of the fields to its corresponding variable in an assignment node that is nested within the data iterator loop.&160; I do not want to have to read the whole line into one variable and then use code to parse the line into i...
|
|
|
|
12 |
5992 |
by Dave Curtis07/30/2018 2:09 PM |
|
0 Replies and 1286 Views
Lp51 Trigger - Pull Employee Information 1286 0
Started by tommyg-006
Hello,
I am working on a flow that is triggered from LP51. I am running into an issue though if there are multiple people that have the leave in a pending status. For example I have an employee EE 202065 that has a personal leave entered, but the flow has stopped on a User Action Node to determine the employee's eligibility. Then I put in a leave request for EE 200367 (myself), however, when the flow runs it is pulling the employee with the higher number. ...
|
|
|
|
0 |
1286 |
07/17/2018 2:15 PM |
|
7 Replies and 1488 Views
Effective Date of Action From A User Action Node 1488 7
Started by tommyg-006
Hello,
I am working on a flow in IPA for Leave of Absence Processing. In the flow there is a User Action Node where the end user choose one of the following actions:
Employee Returned from Leave
Employee Failed to Return (Terminate)
Extend Employee Leave
I need a way to get the effective date of the action, but this may not be the same date as when the User Action was completed. Lawson recommended having the end-user put in the date as a message on the action, wh...
|
|
|
|
7 |
1488 |
by tommyg-00607/17/2018 1:58 PM |
|
0 Replies and 1102 Views
IPA Proxies - Trigger on Creation 1102 0
Started by Bob Canham
We recently upgraded to v11 Landmark (v10 LSF) and we want to revisit the proxy functionality now that it will proxy tasks rather than roles. One concern that has come up is if someone were to assign a proxy to someone who is not of the appropriate leadership level (i.e. a Director setting up a manager under them as a proxy). One way I was thinking to avoid this would be if I could trigger a flow when someone creates a proxy record that would check if the person is of the appropriate...
|
|
|
|
0 |
1102 |
07/10/2018 3:43 PM |
|
|
2 |
1322 |
by David Williams07/07/2018 7:40 AM |
|
3 Replies and 957 Views
Data Transformation Node 957 3
Started by cpaine216
Has anyone used the Data Transformation node in IPA...WE are trying to figure out the data transformation node mapping file....
|
|
|
|
3 |
957 |
by John Henley07/05/2018 9:06 AM |
|
2 Replies and 2763 Views
File Channel Receiver _inputData 2763 2
Started by Kyle Jorgensen
We're just starting our PFI-to-IPA upgrade project. We're going from a local AIX PFI installation to a remote Windows IPA installation. LSF is still on AIX/DB2.
In PFI ScanFileClient. when the 'batch' option is set to true it passes the fully qualified path for the trigger file as '_inputData'.
In IPA File Channel Receiver, when the 'Data' option is set to 'File Name' it only passes the file name as '_inputData'. It doesn't include the full path.
Is there a setting that can ...
|
|
|
|
2 |
2763 |
by Joseph Van Denburg06/22/2018 11:56 AM |
|
4 Replies and 1422 Views
Looping through S3 reports 1422 4
Started by Bob Canham
I am looking at ways to loop through the content from an S3 report such as BN101 and then to perform an action on each record. One way is to use bldxffiles to turn it into a pipe-delimited csv and then iterate through that. While that will work, I want to see if anyone has instead converted a report to XML and then used the For Each to iterate through the nodes successfully. I attempted it earlier today, and ran into issues first because there aren't any published schemas for t...
|
|
|
|
4 |
1422 |
by Bob Canham06/05/2018 8:43 AM |
|
4 Replies and 1372 Views
Check if value in array 1372 4
Started by Nabil
Hello,
I query a table and add values to a Message Builder array (var1) then run another SQL to check if the value is part of 'var1'.
I'm using a Branch to determine if I need to add or remove Security access. My branch condition is
var1.includes(SQLQuery8410_POSITIONCODE);
The problem is it skips it, even if the POSITIONCODE is in the var1 array.
Any ideas how I can tackle this
Thank you!
|
|
|
|
4 |
1372 |
by Nabil05/30/2018 5:04 PM |
|
|
4 |
1522 |
by agersh05/24/2018 12:20 PM |
|
2 Replies and 1575 Views
ProcessFlow inventory - nodes used 1575 2
Started by Joseph Van Denburg
I'm looking to create a list of our active ProcessFlows and the node types utilized in each flow - or a list of unique node types used in each flow.
I was thinking of using a Landmark transaction to find a list of active flows and the current version, a second Landmark node to query the version to pull the FlowXML.
Not sure how to parse the xml to leave me just with a list of the node types.
Any ideas
Thanks
Joe
|
|
|
|
2 |
1575 |
by JimY04/16/2018 7:05 AM |
|
2 Replies and 1409 Views
Employee Audit Information via Landmark Transaction Node 1409 2
Started by Randall
Hi all,
Hopefully this isn't a duplicate as I've been looking all over for an answer to this.
I've been working with a Multi-Tenant instance of LTM. If you're not aware, in this configuration, you're not able to use the SQL Query node to retrieve information from the database. This is posing a bit of a problem when attempting to get at the audit data behind the Employee record.
In short, I'm attempting to get when the Relationship Status and Work Type chang...
|
|
|
|
2 |
1409 |
by Randall04/09/2018 10:34 AM |
|
7 Replies and 1981 Views
IPA Installation Guide 1981 7
Started by JonA
Anyone have the latest IPA install guide Infor Extreme is useless for finding documentation. I'm really looking for the list of Infor provided IPA flows and their descriptions. I'm thinking I've seen them in the install guide.
|
|
|
|
7 |
1981 |
by JonA04/06/2018 9:40 AM |
|
1 Replies and 1128 Views
Inbasket view in S3 1128 1
Started by Casy
We had a custom approval flow created for our RQC approvals. Users typically click a link in a notification email that launches the S3 Portal application for them to view their inbasket. After approving a requisition, occasionally the screen will revert to the users task list and what they call 'nonsensical' data. They are unable to easily get back to their inbasket to approve additional requisitions and is causing some confusion. Has anyone else had this occur Try...
|
|
|
|
1 |
1128 |
by kflores0104/05/2018 8:42 AM |
|
5 Replies and 2045 Views
Javascript 2045 5
Started by Jeff
I am new to IPA and javascripting but so I was wondering if anyone can help me on how to create a fixed length field for use in an Assign node. I have a field that can vary in length that I need to include it in a flat file interface
I have been able to use 'addTrailingSpaces' but this wont work when the data in the field are different lengths.
Probably an easy solution but I cant seem to find anything that works...Thanks in advance for any assistance you can provide!
|
|
|
|
5 |
2045 |
by Jeff03/30/2018 1:47 PM |
|
4 Replies and 1441 Views
Cannot configure M3 Transactions in Process Designer 1441 4
Started by ScottCT
Whenever I attempt to configure an M3 Transaction node in the Process Designer application, I am given an error upon clicking 'Build' in the properties pane.
After clicking OK the M3 Program Query Wizard does launch, but there are no M3 programs/transactions available to choose from. The program should have a list of available APIs, and when selected the available transactions for the selected program should populate.
Here is the console
|
|
|
|
4 |
1441 |
by ScottCT03/26/2018 3:07 PM |
|
|
0 |
1336 |
03/07/2018 8:23 AM |
|
5 Replies and 1662 Views
PFI Schedule 1662 5
Started by FireGeek21
What database/table is the PFI Schedule details stored in Looking to do a quick dump as a reference using SQL if possible but cannot seem to locate the table where this information is stored.
Thanks!
|
|
|
|
5 |
1662 |
by FireGeek2102/25/2018 11:27 AM |
|
1 Replies and 1610 Views
Employee's last Lawson sign in 1610 1
Started by TBonney
Does anyone have a simple flow to determine when an employee last signed into the Lawosn application (that they would be willing to share as a ample/point of reference)
At this time of year, we get inundated with numerous help desk calls that users are unable to log into Lawosn. Often times ,we investigate, find nothing wrong with their profil and leave messages for the user to contact us back. However, they frequently do not respond, thereby leaving us to waste our time chasing them down befo...
|
|
|
|
1 |
1610 |
by edison02/15/2018 11:11 AM |
|
1 Replies and 1270 Views
French characters not loading correctly with Ags call 1270 1
Started by Todd Mitchell
I have a New Hire process flow that uses PA31 as one of the Lawson activity Nodes. The data being processed comes from a flat file and occasionally contains French characters. When I review the log from the work unit I can follow the flow and see where the French character is displaying correctly right up to the point where PA31 stores the data. Here is the AGs call:
https://lawsonsitapp10.gfs.com with string _PDL=S100&_TKN=PA31.1&_EVT=ADD&_RTN=DATA&_LFN=ALL&am...
|
|
|
|
1 |
1270 |
by Kwane McNeal02/15/2018 7:52 AM |
|
20 Replies and 5369 Views
Sending Results of Query to a csv file 5369 20
Started by Brad Schauer
New to creating ProcessFlows. I created a flow that has three queries, the result of which I can use MsgBuilder and an Email node to send the results via e-mail. I am trying to figure out how to send the results to a csv file. I have tried using the file access node 'write to file' but my results come back on one line. For example if I am returning ID and Name into a txt file, I want to see: ID,Name 1,Tom 2,Mary What is being written to the file is: 1,Tom,2,Mary Can anyone po...
|
|
|
|
20 |
5369 |
by Orlando Gray02/13/2018 5:37 PM |
|
1 Replies and 1147 Views
ipa sending duplicate email notifications 1147 1
Started by FireGeek21
We have an approval process sending duplicate email notifications to all users through the User Action node. We checked the User Configuration and confirmed the users are not duplicated in there. Any ideas on how to stop/prevent this
Thanks!
|
|
|
|
1 |
1147 |
by kflores0102/12/2018 8:12 AM |
|
4 Replies and 2496 Views
Custom Java Trigger API for IPA 2496 4
Started by Kyle Jorgensen
We are experimenting with creating our own custom java trigger API for Infor Process Automation (as described in the 'Creating a Custom Java Trigger API for Infor Process Automation' section of the Landmark InfoCenter).
We've been able to use the brief example in the InfoCenter to create a proof-of-concept custom java trigger API, but now we want to take it to the next level. We want to be able to set and pass the flow name/value pairs, set category keys and category values as well as the input...
|
|
|
|
4 |
2496 |
by Kyle Jorgensen02/08/2018 1:35 PM |
|
2 Replies and 1344 Views
getRMQuery 1344 2
Started by Ludy
Does anyone know what file is being accessed by the method getRMQuery
Thanks,
Ludy
|
|
|
|
2 |
1344 |
by Ludy02/08/2018 8:18 AM |
|
7 Replies and 2344 Views
scheduling flows 2344 7
Started by Ragu Raghavan
I have a need to schedule a IPA flow to run every 15 minutes. Simple flow that checks for some condition and does an AGS call to a GL Screen to change status, Most of the time it will just kick off, find condition not met and end. The sysadmin is concerned that just running it 96 times daily and the WU's created and other overheads will bring the landmark server to its knees. V10. Anybody does this kind of high frequency scheduling Thanks.
Ragu
|
|
|
|
7 |
2344 |
by Randy02/05/2018 2:18 PM |
|
3 Replies and 1610 Views
Check For File modified date 1610 3
Started by Jessi
I need to access a file in IPA and check for it's last modified date. Based on the modified date I'd perform different options. What's the best way to access the modified date of the file
|
|
|
|
3 |
1610 |
by John Henley01/23/2018 9:44 AM |
|
0 Replies and 1043 Views
ActorID and AgentID 1043 0
Started by PD
When a user with their ID goes into Infor MyHR, she sees someone else's name and information and that person has a completely different ID. Terminated employee seems to be the thread, on all three cases thus far, the terminated employee ID has been the common thread......we just went live on cloud v10.
How do I query the ERP (or IPA flow) to catch other records
|
|
|
|
0 |
1043 |
01/09/2018 2:35 PM |
|
2 Replies and 3318 Views
Security violation 3318 2
Started by PD
I am using a LwsnTxn and WebRun node for a PR295 job. I then reference the bldxffiles utility to convert the PR295.prt to a csv file. The csv is not being created because the .prop and .grp files are not being generated neither from the job or the utility. Might anyone be knowledgeable on how to generate the .prop and .grp files with the prt job or
I am using this command:
bldxffiles -SCp 382396 D:\lsenv\law/print/INFORBC_382396/pr295-ju/1 PR295.prt
I am ...
|
|
|
|
2 |
3318 |
by PD01/02/2018 8:00 AM |
|
2 Replies and 1817 Views
Trigger WFWK.1 in a non-Design Studio form 1817 2
Started by Roger French
I've got a custom htm form I am using for a customization. It's working. It's not a Design Studio form. Design Studio is not available on this environment.
So question, I've tried the 'normal' method of using the portalWnd.AGSPath in the call to WFWK, but, in the html form, it does not work.
I've spent alot of time debugging why it won't work. There isn't any error messages, but the javascript function does not like the method of
var s = portalWnd.AGSPath .....
So qu...
|
|
|
|
2 |
1817 |
by Roger French12/22/2017 7:16 AM |
|
2 Replies and 1566 Views
Where do SQL Procs go??? 1566 2
Started by dcasper70
IPD v11.0.1.43, single tenant, cloud, SQL Server.
A developer had created a SQL Procedure using the 'Create/Update SQL Procedure' option.
Now that proc is available to me in the 'Run SQL Procedure' option -> Select -> 'SQL Procedure Selector' window.
Original developer then deleted that SQL node from his original flow. The proc exists, but we don't have a copy of the original source.
Is there any way for us to view the SQL behind that proc
Does it actually create ...
|
|
|
|
2 |
1566 |
by dcasper7012/21/2017 9:38 AM |
|
3 Replies and 1562 Views
Create a field of spaces 1562 3
Started by FireGeek21
I am using process flow to build a fixed field .txt file. Several of the fields require a specific number of spaces because no value is being passed. In SQL it is quite easy to use space(10) for a field with 10 spaces. How can I do this in an Assign node maybe with javascript I have tried the addtrailingspaces(' ', 10 but the spaces appear as 202020... instead of true spaces. Using ' ' is out of the question because the h...
|
|
|
|
3 |
1562 |
by FireGeek2112/12/2017 11:15 AM |
|
2 Replies and 1382 Views
Encryption Node 1382 2
Started by Jessica M
I need to encrypt an outgoing file to a 3rd party vendor using the PGP key they provided. Do I need to provide that key to Cloud Services to install in our system Is that where I get the 'service name' for the encrypt node
I would greatly appreciate any assistance.
Thanks,
Jessica
|
|
|
|
2 |
1382 |
by Jessica M12/12/2017 10:57 AM |
|
4 Replies and 1870 Views
Add Approval History to Email Notification 1870 4
Started by JonA
One of our medical center presidents asked if he could see who has approved a requisition before him in the email notification. He's at the top level (level 5) so he would like to see who approved at levels 1-4. I've been able to add the history to the notification email by adding this...
Which looks like this
APPROVER ACTIONS
Level 1 approved by M123450
Level 2 approved by A95687
Level 3 approved by&nbs...
|
|
|
|
4 |
1870 |
by Kat V12/05/2017 1:39 PM |
|
1 Replies and 1334 Views
How to bypass AGS error prompt? 1334 1
Started by Lance Jurgensen
I am trying to delete an employee group - HR55.1 and when that group contains employees the system prompts you to hit Delete again to confirm. Anyone know how to bypass that in the AGS call
LwsnTxn5370_errorCode = 5
LwsnTxn5370_informationCode = 197
LwsnTxn5370_returnMessage = Warning-Employees in group; okay to delete
|
|
|
|
1 |
1334 |
by John Henley12/01/2017 4:34 PM |
|
4 Replies and 2168 Views
Webrun /lawsion-ios/action/AddAttachment 2168 4
Started by Lance Jurgensen
I am attempting to add a Delivery comment to the POLINE. One of the things I do not understand and can not find documentation on is what the K1 through K5 should be. I am guessing here on these settings from running this ListAttachment in the browser and looking at the values it spits out.
The editor is killing the text I'm trying to put here, please see attachment
|
|
|
|
4 |
2168 |
by Lance Jurgensen12/01/2017 8:26 AM |
|
1 Replies and 1361 Views
Dynamically change SQL Proc in IPD? 1361 1
Started by dcasper70
IPD v11.0.1.43, single tenant, cloud, SQL Server.
Business has about a dozen or so bonus programs. Each program has different criteria, run dates/frequencies, and payout amounts.
We're attempting to use a single flow to create the EmployeeSpecialIncentivePayout (ESIP) business class records for the desired program. We figure that all the ESIP entries can be done in one Landmark transaction node, and all that we need to vary is the SQL that runs to get the peop...
|
|
|
|
1 |
1361 |
by dcasper7011/28/2017 4:26 PM |
|
2 Replies and 1803 Views
SQL Count not showing as variable 1803 2
Started by Nabil
Hi All,
I'm running a SQL query and doing a count which should determine how the flow would proceed, however, when I try to pull the Count on my Branch Node, I'm failing to see it.
Any ideas why this is happening
Here is the SQL
SELECT
PAY.APCOMPANY
,PAY.INVOICE
,PAY.VENDOR
,PAY.INVOICEURL
,to_char(cast(PAY.USTIMESTAMP as date),'DD-MM-YYYY') as UPDATE_TIME
,PAY.CREATIONDATE
,PAY.USTIMESTAMP
,API.INVOICE
,API.L_INDEX
,URL.L_INDEX
,COUNT(URL.L_INDEX)
...
|
|
|
|
2 |
1803 |
by Nabil11/16/2017 4:52 PM |
|
2 Replies and 1808 Views
AddAttachment via process flow 1808 2
Started by Nabil
Hello,
Has anyone implemented the AddAttachment that's supposedly replacing writeattachrec.exe
SERVER: PORT/lawson-ios/action/AddAttachment
Lawson documentation has this as an example POST data but I haven't been able to get it to work. I'm looking to add Invoice comments to APINVOICE from our Landmark Financial suite.
Attaching a KB article (1937446) that talks about the replacements for writeattach
Thanks,
Nabil
|
|
|
|
2 |
1808 |
by Nabil11/13/2017 11:37 AM |
|
15 Replies and 4374 Views
processflow trigger 4374 15
Started by edison
Apologies for the very basic question;
We're migrating from v9 to v10. I need to have a process flow execute when a user changes their address in ESS.
I'm just assuming that the EMSSAddrChg service is the key to running the process flow (that's what I saw in our v9 bpm/menu.do.)
I made a very simple processflow that just sends an email and upload it.
Then on Process Server Administrator > Configuration > Service Definitions
Double click on EMSSAddrChg
Click t...
|
|
|
|
15 |
4374 |
by edison11/09/2017 1:10 PM |
|
0 Replies and 1166 Views
Trigger flow on data change 1166 0
Started by Kidd Kasper
Process flows are uploaded to the server in a few different PFI tables. I have a flow that will query those tables, create a summary document, email the developer, etc. It's easy enough to schedule my process flow to run every hour to look for any other flow that was uploaded in the past hour.
However, I would love to be able to trigger my flow based on a new record in these PFI tables (new flow having been uploaded). Anyone aware that this is even possible
|
|
|
|
0 |
1166 |
11/07/2017 11:52 AM |
|
0 Replies and 1134 Views
S3 Adapter 1134 0
Started by Lynne
Hello-
I am looking for some help on the S3 Adapter node in IPA. The manual says to run process FormFldLoad to get the fields loaded in rich client for my form. Does anyone know where to find it or how to run it I found a rich client form that has some of the S3 form fields built out. Do I have to add all my fields manually Thanks!
|
|
|
|
0 |
1134 |
11/07/2017 9:31 AM |
|
3 Replies and 1850 Views
PATCH web API triggered from IPA flow 1850 3
Started by brox07
I'm trying to run a web API, using the PATCH method, that our web dev team developed. I set up a webrun node with the information that I needed but it's returning an 'Invalid HTTP method: PATCH' error. I tried using 'POST' with 'X-HTTP-Method-Override: PATCH' in the Post String with no luck. Has anyone had any experience with this Any information would be greatly appreciated.
|
|
|
|
3 |
1850 |
by David Williams11/04/2017 8:47 AM |
|
1 Replies and 1540 Views
po30 - PO Overshipment not trigger 1540 1
Started by PD
In Po30, when the quantity received is greater than what was ordered, it should create a work unit with the 'has buyer message'.
The buyer message is created but it does not trigger a work unit through 'PO Overshipment' Service definition. What is my problem
Thanks
|
|
|
|
1 |
1540 |
by Kat V10/30/2017 2:44 PM |
|
3 Replies and 2417 Views
SysCommand Node - Landmark Command 2417 3
Started by Maestro
I have tried to search for the answer prior to asking this but unfortunately when trying to go past page one of posts i'm getting an error. I'm sure this is relatively simple answer. When using SysCommand node how can i reference a landmark command like dbupdatelobs and wait for it to finish
Thanks
Michael
|
|
|
|
3 |
2417 |
by JimY10/30/2017 7:01 AM |
|
1 Replies and 1647 Views
IPA Enhancements 1647 1
Started by ALB
Our version of Landmark is 10.0. We will be engaging ICS to update our environment. The suggested version of Landmark is 10.1.1.42. I remember about a year ago there was a webinar about the various CUs and the impact on IPA. I believe CU 48 had many performance enhancements. When I look at the Infor technology blogs, it appears that the webinar is no longer there as Landmark version 11 is available for LSF 10.0.9. Does anyone have any suggested CUs ...
|
|
|
|
1 |
1647 |
by David Williams10/25/2017 8:06 AM |
|
0 Replies and 1120 Views
XML Output of Lawson Transaction Activity 1120 0
Started by Layne.Ingle
I was wondering if you might could help with something. This is XML output from a Lawson transaction. I need the value called REQUEST-NBR, so I would want 1153 returned. What can I use to extract this into a variable so I can use it.
Thanks
LSAPPSPD10.1TRUEPD10.1AGCSGreenville County Schools>11530NewCard CompaniesNT00005704212350Mickey Mouse106134Terese McSharrytmcsharrgreenville.k12.sc.usGCS 0000000000001153Add Complete -...
|
|
|
|
0 |
1120 |
10/24/2017 9:04 AM |
|
4 Replies and 1751 Views
Landmark: Provisioning - Account Disabled Flag 1751 4
Started by Bob WCHN
In ISA, on the Landmark Tab, there is an Account Disabled checkbox. I can't find a means of setting this flag with a Landmark Transaction Activity Node.
I’ve tried setting the IsActorDisabled and AccountLockout.IsAccountDisabled Flags for the Actor and tried doing a ‘DisableActor’ update, but the checkbox still is unchecked.
Then, I thought that maybe the flag is a reflection of the DELETEFLAG value (off for 0, on when the DeleteFlag has a non-zero value) in the GEN ACTOR Tab...
|
|
|
|
4 |
1751 |
by Bob WCHN10/19/2017 10:40 AM |
|
12 Replies and 3012 Views
Creating excel xlsx file instead of csv 3012 12
Started by HDAustin13
Hello All,
I have a flow that using SQL to produce an output to CSV file but the vendor keeps having an issue of opening it. In order to successfully open it, he has to rename the file extension from .csv to .xlsx each time. Does any know if IPA can produce an output excel file to .xlsx instead of .csv file Can you please advise
Thanks, Han
|
|
|
|
12 |
3012 |
by jamesraceson10/10/2017 7:34 AM |
|
2 Replies and 1688 Views
sending email-smtp settings 1688 2
Started by edison
Hello,
I'm very new to lawson. I started this job last month and we're converting from v9 to v10. Still getting to figure out all the terms.
I've been tasked to convert our old process flow in v9 to the v10 Infor Process Designer(IPD)
I created a test processflow that just sends email. I could not get this to work.
I always get an authentication failure. Our sysadmin has supplied me with the username/password for the smtp server.
There is an online tool called 'Process Server Ad...
|
|
|
|
2 |
1688 |
by edison10/04/2017 3:23 PM |
|
4 Replies and 1542 Views
Workload Manager Tools 1542 4
Started by Kyle Jorgensen
Is anyone using Control-M (a cross-application and cross-platform workload management tool) with Lawson and/or Landmark
If not Control-M, any other workload management tool
Thanks in advance,
Kyle Jorgensen
|
|
|
|
4 |
1542 |
by Kyle Jorgensen10/03/2017 8:04 AM |
|
1 Replies and 2088 Views
IPA Inbasket user guide 2088 1
Started by Karen Ploof
I cannot find anything on the Infor site that would help us understand what all the bells and whistles in the InBasket do. It's taking us a while to play around with each and I'm hoping someone out there has some kind of documentation. So far Infor helpdesk has not come up with anything.
|
|
|
|
1 |
2088 |
by heartland09/22/2017 10:40 AM |
|
5 Replies and 2012 Views
PA Reviews notification via email from IPA 2012 5
Started by Julia
We are trying to create emails to send to supervisors for their upcoming reviews. I have the query written to gather the data to send and have it is a action node in a message, but I am have trouble determining the best way to parse that data and send to the supervisors their rows of data. Should I be putting this information into a file and parsing that way, should I be able to loop through the email node with using the variables. I am self taught and have be...
|
|
|
|
5 |
2012 |
by Julia09/21/2017 2:52 PM |
|
4 Replies and 1805 Views
Process flow performance issues in Cloud - possible grid issues??? 1805 4
Started by Jessica M
We are getting ready to go live in the cloud on 9/22/17. Our grid was tuned in the spring and our process flow performance was better in the cloud than our on-prem version as of mid summer. Now, all of the sudden, our performance has gotten worse. Flows are running anywhere from 30 minutes more to 4 hours longer than they previously were in the cloud.
We are not getting anywhere with our project team and the support personnel they have assigned. At this poi...
|
|
|
|
4 |
1805 |
by Jessica M09/20/2017 1:40 PM |
|
4 Replies and 2887 Views
Intercept Action in custom inbasket 2887 4
Started by MarkH2002
I am trying to figure out how I can intercept the action being taken on an inbasket workunit and perform a test. If the test = true the action will be taken, if false show an alert. Similar to what you would do in design studio with OnBeforeTransaction.
|
|
|
|
4 |
2887 |
by Ragu Raghavan09/13/2017 9:02 PM |
|
8 Replies and 3276 Views
IPA Scheduler Not Working 3276 8
Started by Roger French
This is a new instance. Win/SQL.
LSF 10.0.9, Landmark 10.1.1.51.
LSF and Landmark have been running for a few months. IPA's have been installed, configured and running OK.
Trying to schedule an existing IPA flow using Rich Client. The IPA runs fine and OK for a manual schedule meaning 'Start'. It runs fine in IPD too.
The issue is that if I create a schedule in My Actions, Schedule for any type of periodic schedule for the IPA to run (one a day, once a week, etc.) it fails to launch. I'm log...
|
|
|
|
8 |
3276 |
by Roger French09/11/2017 4:26 PM |
|
0 Replies and 1382 Views
Negative or zero dollar payment 1382 0
Started by Todd Mitchell
We are currently working on a project in which a customer has the ability to pay their invoices via credit card. On some occasions, the amount of credits could be the same or exceed the amount of invoices, resulting in a zero dollar payment or a negative payment. In the Lawson EFT world (AR115), Lawson creates a debit memo to offset the amount of the negative payment and then interjects a zero dollar payment into the payment table.
Has anyone had to create a similar situation and if...
|
|
|
|
0 |
1382 |
09/11/2017 2:28 PM |
|
0 Replies and 1140 Views
Sys Cmds Returning Unreadable Log 1140 0
Started by ehuso
Hello,
When we issue a system command, the response is completely unreadable regardless of if the process completes or it fails. This is especially an issue with our FTP manager. After IPA creates a file, our FTP client on the iSeries performs the FTP. The FTP manager needs the file to be generated with a CCSID of 37. In the attributes, it is shown as 37 but when the hex of the file is examined, the true CCSID is not 37.
I noticed in our process flow logs that this occurs for all system comman...
|
|
|
|
0 |
1140 |
09/07/2017 1:28 PM |
|
16 Replies and 3531 Views
Create PO via PO23.1 in PF 3531 16
Started by Lynne
I am attempting to create a PO via PO23.1 in my PF. I would prefer to do it this way as opposed to running a PO100 job from PF. My problem is that I have to inquire on the PO23.1 before doing an 'Add'. I have read some posts about this same problem on different forms and have not been able to get mine to work. On one it said that you had to have _EVT=CHG. I've tried that and _EVT=ADD. I also saw where you had to have the hidden key, _HK, set. I also trie...
|
|
|
|
16 |
3531 |
by PFlowNerd09/07/2017 11:28 AM |
|
3 Replies and 2058 Views
WFWK call to LMRK Service failing 2058 3
Started by Vikram Raghava Reddy
Hello,
We are upgrading from V9 to V10. I am trying to call a Landmark service using AGS call over WFWK form. Service on the Landmark side is enabled and I am passing all the required parameters (Criteria, Variables and Prodline). When I checked the LPS log under $GENDIR/bpm/, the last message in the log is 'isLPSServiceExistAndEnabled(), sending socket message for isLPSServiceExistAndEnabled'. I assume that there is no response back to the S3 server for the socket call. I checked the BPM servi...
|
|
|
|
3 |
2058 |
by jdever08/28/2017 10:47 AM |
|
2 Replies and 1849 Views
How to Disable Landmark User ? 1849 2
Started by Bob WCHN
I'm doing analysis to design a Process Flow to disable terminated employees. When looking at a User Account in ISA, I see there is an 'Account Disabled' checkbox on the Landmark Tab.
I haven't been able to find a way to set that in my searching of the available functions in the Landmark Transaction or Resource Update activity Nodes.
Is there a way to set that flag from a Process Flow
|
|
|
|
2 |
1849 |
by Bob WCHN08/15/2017 9:33 AM |
|
0 Replies and 1158 Views
POST DATE ISSUE for AR130 1158 0
Started by vishwanath
We are facing issue with the post date for job AR130. The deposit date is getting applied to the post date instead of posting date i.e user selected date or current date when we try to apply the payments after submitting the AR130 job. Please let me know the solution for this issue.
|
|
|
|
0 |
1158 |
08/01/2017 4:25 AM |
|
0 Replies and 1038 Views
WFEVTSERV ? 1038 0
Started by timbomom
Migrating to V10 from V9, where can I find equivalent IP-ADDRESS and PORT-NUMBER from WFEVTSERV in V10
Thanks,
Pat
|
|
|
|
0 |
1038 |
07/26/2017 9:32 AM |
|
0 Replies and 1314 Views
PFI to IPA - WFMETRICS and WFUSERCAT tables 1314 0
Started by timbomom
Working at client to covert PFI to IPA. Have some flows that make extensive use of WFMETRICS table in PFI.
The conversion scripts muck up the IPA conversion. Anybody have any samples of WFMETRICS to PFIMETRICS
I have a file mapping from for PFI to IPA but it's not much help for WFMETRICS.
The V9 node is:
PROD=LOGAN&FILE=WFMETRICS&INDEX=WMESET8&KEY==2=&FIELD=WORKUNIT;PROCESS-ID;END-DATE;END-TIME;STATUS;WF-RM-ID;TASK;ACTIVITY-ID;OPERATION;COMMENT;START-DATE...
|
|
|
|
0 |
1314 |
07/18/2017 10:37 PM |
|
2 Replies and 1552 Views
PFI table/column listing 1552 2
Started by timbomom
Hi.. I'm looking for a table column listing of PFI tables. I need a detailed description of how to convert a WFMETRICS v9 node in a flow to the corresponding PFI table. The landmark node build function in ipd is very confusing and unclear to use.
The v9 node has this code:
PROD=LOGAN&FILE=WFMETRICS&INDEX=WMESET8&KEY==2=&FIELD=WORKUNIT;PROCESS-ID;END-DATE;END-TIME;STATUS;WF-RM-ID;TASK;ACTIVITY-ID;OPERATION;COMMENT;START-DATE;DUE-DATE&OUT=CSV&DELIM=~
&n...
|
|
|
|
2 |
1552 |
by timbomom07/18/2017 4:00 PM |
|
10 Replies and 2294 Views
IPD Designer - Custom Function 2294 10
Started by Roger French
IPD Designer version 10.1.1.49
Windows 2012, Landmark 10.x
So I want to add a custom function to utilize in designer.
I've added the custom code in pflow.js in \system\LPS
I stopped/restarted all services in Landmark and LSF.
Exited and logged back into Process Designer. I still can't see the custom function I just created in the drop down of any assignment node.
I rechecked everything. Still the custom function doesn't appear.
Yes, I'm using this in the header part of the pflow.js. I eve...
|
|
|
|
10 |
2294 |
by John Henley07/18/2017 9:38 AM |
|
8 Replies and 2616 Views
IPA-Adding OS (Environment) Identity 2616 8
Started by Roger French
So, attempting to add the OS Identity using the Resource Update node. This is Landmark on Windows 10.1.1.51
LSF 10.x
So in the IPA is working and the Basic LSF Security record using the Resource Update node. The SSOP and the EMSS identities are also added correctly.
The OS Environment identity is not. Here is a snippet from the error log of the work unit. The SID is not an attribute to populate in the build in the Resource Node, and thus it can't be manually added. I've already confirmed that...
|
|
|
|
8 |
2616 |
by JimY07/12/2017 10:55 AM |
|
4 Replies and 2368 Views
Trigger Process Flow 2368 4
Started by FireGeek21
Is it possible to trigger a process flow (PFI, Lawson S3 v9) if a file is present in a specific folder
|
|
|
|
4 |
2368 |
by John Henley07/12/2017 8:45 AM |
|
1 Replies and 2265 Views
Trigger Node in IPA 2265 1
Started by Gok87
So below is what i am trying to do
1. Submit an action request
2. have a trigger node an trigger a process flow which has an user action in it.
3. Try view the details (actually i want to edit some details) and approve.
In the user action under display tab > i confugured as action request.
When i try to open the workunit in the Inbasket i get an error saying
ViewException:
Class Name: null
Stack Trace:
com.lawson.rdtech.opf.OPFNoSuchElementException
at com.law...
|
|
|
|
1 |
2265 |
by NHBB06/27/2017 10:49 AM |
|
2 Replies and 2139 Views
IPA - Req Approval Flow w/ Logic on who to notify 2139 2
Started by Remi
We have a Req Approval flow on our system that was built for us by a Lawson Consultant several years ago. Most recently, our Purchasing department is interested in seeing how this process flow works in hopes of implementing it for their requisition approval process.
There's a portion in the flow that is supposed to get the object ID of the items on the req., account number, and sub account number from the reqline, and from there, determine who in our organization to send th...
|
|
|
|
2 |
2139 |
by Remi06/20/2017 10:27 AM |
|
0 Replies and 1195 Views
Terminate flow: Find Actor from DirectSupervior 1195 0
Started by TimC
The action: FindMergedTerminate is called against the Employee biz class. I need to find out the Actor from the DirectSupervisor or from the 'requestor' submitting the flow (which could be the same person). What biz class do I search to find this out
|
|
|
|
0 |
1195 |
06/19/2017 8:30 AM |
|
1 Replies and 4089 Views
Generate WorkAssignmentExport rows via automation 4089 1
Started by TimC
We are using POSITION.SHORTDESCRIPTION for a JOBCODE for an external provider. However, if that field should change, we need all related workassignments to be caused to write a WORKASSIGNMENTEXPORT record. How do we cause that to happen
|
|
|
|
1 |
4089 |
by TimC06/15/2017 9:55 AM |
|
2 Replies and 2686 Views
PFI to IPA Landmark transaction 2686 2
Started by Daniel
Here is the current Landmark transaction node: it returns no data
_dataArea='LSAPPS' & _module='pfi' & _objectName='PfiUserCategory' & _actionName='Find' & _actionOperator='NONE' & _actionType='MultipleRecordQuery' & _runAsUser='' & _setName='ByTaskCategoryValueUser' & PfiUserProfile & PfiTask.TaskName='Level1;Level2;Level3' & PfiFilterKey='Req Loc' & PfiUserCategory=''
and here is our PFI query
PROD=LOGAN&FILE=WFUSERCAT&INDEX=WFTSET3&...
|
|
|
|
2 |
2686 |
by John Henley06/13/2017 2:28 PM |
|
|
3 |
1808 |
by Kyle Jorgensen06/13/2017 9:03 AM |
|
2 Replies and 1633 Views
Using SysCommand instead of .bat file 1633 2
Started by FireGeek21
I have the following in a .bat file but we are moving to the cloud and cannot use .bat files. How can I do the same thing using a syscommand node Or is there a different node/combination of nodes I should use to count the number of a certain type of files in a folder
echo off
setlocal enableextensions
set count=0
for x in (\\servername\appprodline\foldername\*.RQ500) do (set /a count=1 > nul)
echo count
endlocal
Thanks!
|
|
|
|
2 |
1633 |
by FireGeek2106/06/2017 8:59 AM |
|
2 Replies and 2012 Views
IPA File Channels 2012 2
Started by Vikram Raghava Reddy
Hey Guys,
I have an issue with File channel. The file on the FTP server is getting deleted after the 'Scan Now' action. The WU getting created successfully. Can someone tell what could be reason for the file deletion
Thanks,
Vikram
|
|
|
|
2 |
2012 |
by John Henley06/05/2017 5:59 PM |
|
|
15 |
5147 |
by mthedford06/05/2017 5:20 PM |
|
0 Replies and 1227 Views
File Locking - Incrementing a value 1227 0
Started by Steven.Morales
Essentially, I am trying in increment CPY-LAST-BATCH by 1, but I don't think there is any file/record locking in place to prevent two programs from reading the same value before they have a chance to write it.
Is there something I can do to make this work properly
|
|
|
|
0 |
1227 |
06/05/2017 1:24 PM |
|
7 Replies and 3558 Views
Positive Pay (PR170) flow 3558 7
Started by Joan Herzfeldt
We have to create a positive pay file process flow rather quickly. I'm still learning the complicated pieces of IPA and wondering if anyone had this flow or parts of it already created and were willing to share Or some advice on the best ways to create the different pieces (see below).
Thanks - Joan
Some additional information/questions:
Our current production flows are inbound into Lawson, so what is the best way to get data from Lawson if a Service/trigger does NOT already exis...
|
|
|
|
7 |
3558 |
by Joan Herzfeldt06/02/2017 2:00 PM |
|
1 Replies and 4441 Views
Audit Log Table - Landmark 4441 1
Started by TimC
What table is the 'audit log' for workassignment and employee in landmark v10
|
|
|
|
1 |
4441 |
by TimC05/25/2017 10:09 AM |
|
3 Replies and 1536 Views
Launch flow from URL 1536 3
Started by TimC
I would like to allow the user to run a flow on demand from a URL. It does an extract and will send them an email. How do I launch a PFlow from a URL
|
|
|
|
3 |
1536 |
by TimC05/22/2017 11:55 AM |
|
11 Replies and 2727 Views
Help with SQL code for IPA flow 2727 11
Started by Brooks Saunders
Pulling in Data for use two fields. Once I added the TRIM expression to the selection, I was receiving undefined when I reviewed my data in a text document. If I leave the expressions out of the selection code, the fields are blank where I have null values (which is expected but I need to TRIM those fields). Can anyone shed light to as why my COALESCE works for my POLINE.DESCRIPTION but does not work for APINVOICE.PO_NUMBER (Keep in mind ISN...
|
|
|
|
11 |
2727 |
by Bob Canham05/12/2017 3:12 PM |
|
1 Replies and 2017 Views
IPA S3 Commands 2017 1
Started by Srini Rao
Hello, We run LSF and Landmark on windows. I'm trying to get the record count using count command in syscommand node. But IPA is not recognizing the count command.
My syscommand node has following command..
count test EMPLOYEE.
Error: 'count' is not recognized as internal or external command.
Any recommendations
|
|
|
|
1 |
2017 |
by Srini Rao05/05/2017 6:38 AM |
|
0 Replies and 1113 Views
Help with Landmark JMSChannel 1113 0
Started by Kyle Jorgensen
We're trying to add a JMS channel in Landmark to connect to our corporate JMS. We use RabbitMQ as our JMS.
The technical documentation is lacking (surprise!) and we're running into all sorts of dead-ends. Any help would be appreciated.
Has anyone been successful with creating a JMS channel in Landmark (connecting to RabbitMQ would be a bonus)
Thanks in advance,
Kyle
|
|
|
|
0 |
1113 |
05/03/2017 9:55 AM |
|
1 Replies and 1544 Views
Wrong array length 1544 1
Started by PD
I have this Property (RPT_022_ Div and Value ('One, 'Two', 'Three') declaration in system Config Interface. I then reference it as type Array in the Start Node and the array length.
In Debug mode, the Array elements show up OK as the value above but the array.length returns 1 as oppose to 3, what am I missing
|
|
|
|
1 |
1544 |
by PD05/01/2017 3:22 PM |
|
8 Replies and 2545 Views
Data Files with LineFeeds and Carriage Returns Importdb 2545 8
Started by JasonP
I'm planning on doing any importdb on a file that contains both a line feed and a carriage return at the end of each record and that doesnt seem compatible with the importdb command. when I use notepad and change the EOL to UNIX which leaves just the line feeds, the importdb works fine. Any ideas on how to remove those Carriage returns easily is there some param on importdb Im missing
|
|
|
|
8 |
2545 |
by JasonP04/27/2017 2:33 PM |
|
0 Replies and 1395 Views
Mobile Inbasket 1395 0
Started by Roger French
Has anyone got the Mobile Inbasket to actually work completely
I've got MIB 9.1.1.55 installed, with a V10 LSF and Landmark all Windows installed.
IPA is running and requisitions flow is installed and running using IPA.
The desktop inbaskets are working, but the Mobile Inbasket isn't. On either Android or Iphone, after logging in, and navigating to the Task Folder, and clicking inside of the Task folder, the message says 'No inbasket items found.' Actually there are several work units in pro...
|
|
|
|
0 |
1395 |
04/26/2017 11:08 AM |