Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Integration / Customization
IPA/ProcessFlow
Retreiving RM Id via Process Flow
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
LynneB
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5123
People Online:
Visitors:
237
Members:
0
Total:
237
Online Now:
New Topics
Lawson S3 Financials
PO Matched Dollars and Matched Quantity
5/10/2024 6:51 PM
Can anyone share the Lawson calculation to determi
S3 Customization/Development
COBOL CSV file
5/10/2024 2:36 PM
We have a custom Cobol program ZU200 that creates
S3 Systems Administration
Using MFA for Lawson S3 Access
5/8/2024 1:23 PM
Does anyone use Multi Factor Authentication when u
Lawson Landmark
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
IPA/ProcessFlow
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1357
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
IPA/ProcessFlow
Retreiving RM Id via Process Flow
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Chad Dirst
Advanced Member
Posts: 42
10/23/2013 1:35 PM
I have a flow that needs to retreive the RM Id in LDAP using the Company/Employee number.
The flow is currently setup and working, however, it does this for approximately 28K records. The issue I am having is related to run time. This is taking in upwards of 12 hours.
Can anyone offer any assistance on performance enhancments or maybe another solution?
Thank you,
Chad
Woozy
Veteran Member
Posts: 709
10/23/2013 6:52 PM
Hi Chad Dirst,
Wow. The RM lookup is quite slow, so I'm not surprised. There may be some other options, but they could vary based on what you are doing. Can you describe briefly what your flow does? Why does it need to look up the RM records every time? What is your primary data source (file, SQL, S3 Query, etc)?
If your primary data source is a SQL query, then maybe you could create a custom table with Company/Employee/RMID and do an initial load with your existing values. Then join that custom table to your source query, then only do the RMID lookup (and insert into your custom table) if a value isn't found.
If you are getting a source file from elsewhere, could you possibly do something similar to the above and have the source system include the RM info in the file?
I'm just throwing out some ideas. This is a challenging problem.
Chad Dirst
Advanced Member
Posts: 42
10/25/2013 12:46 PM
We utilize Infor T&E SaaS solution. Lawson delivered a connector which is a series of flow to interface to the Infor T&E (XM) system. The root issue is the flows send full data files each time it is run. In addition, our uses wanted to customize the flows to send the RM Id as the XM Login field. Lawson does not deliver that as an alternative.
I understand my alternatives to solve the problem (do not send full files or store the RM Id in a custom table/user field). I just wanted to check if there were any recommendations on configuration properties I should be checking before going down that road.
Thanks.
Chad
Woozy
Veteran Member
Posts: 709
10/25/2013 1:23 PM
I understand. Unfortunately, I can't provide any help with this. Performance is one of the reasons we avoid this like the plague. Sorry I can't help more. Good luck to you.
Kelly
Bob Canham
Veteran Member
Posts: 217
10/25/2013 1:40 PM
We stored our user accounts in a field in HR11 (Clock Number). We did that because we use ProcessFlow to create user accounts, so when our security system creates a user account on the network, it updates the Lawson field right away. Maybe something similar would help?
You are not authorized to post a reply.