Has anyone gotten the DB2 JDBC connector to work with PFI We are using PFI 9.05 and are trying to use the jdbc connecotrto connect to DB2.  I opened a case with Lawson and they toldme that they don' t support the DB driver.  An info would be appreciated.

_PDL=LOGAN_TKN=WF21.2_EVT=ADD_RTN=DATA&_LFN=ALL_TDS=IGNORE&FC=Add&WFF-WORKUNIT=WFF-SEQ-NBR=1WFF-KEY-STRING=WFF-ATTACH-BY=processflowWFF-DOCUMENT-ID=FORMWFF-FORM=RQ10.1WFF-FILE-NAME=Requisition Maintenance&_DELIM=09_OUT=TEXT_EOT=TRUE I am trying to convert This aggs call to 9.0. webrun. Can I use BUILD for this or What would the  sintax be. Any help would be appreciated

Has anyone been able to access custom files from a process flow in the 8.0.3 version

Hi all, We are using ProcessFlow 8.03 Pro and j2sdk1.4.2_16. In the Start node, I declared a variable var_date as type Date and tried to assign the function Date=pfDate(var1,'mm/dd/yyy'). However I am getting an error 'Cannot assign non-date expression to Date type variable'. If I declare a string variable, this function gets assigned! I am revising a processflow (from another company) that was able to assign function Date=pfDate(var1,'mm/dd/yyy') to a date variable. What do I need to do ...

I want a flow that will be run weekly and will create a PA52.1 for each employee (meeting a certain criteria) with an action code of Sep-Final which will change the status (which I hope is New-Value-31) to I1 (or one of a list of others).  PA100 is run daily. _PDL=PROD&_TKN=PA52.1&_EVT=ADD&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=A&PCT-COMPANY=1&PCT-EMPLOYEE=&PCT-ACTION-CODE=SEP-FINAL&PCT-EFFECT-DATE=&PCT-NEW-VALUE-31=I1&_DELIM=09&_OUT=XML&_EOT=TRUE This says record does not exist which is true.  ...

Testing LSF9.0.0.5.138 apps 803 we found out that workunits that have been approved or rejected are not being purged and still remains with a DISP-STATUS of 2 in WFWUQUEUE. Is there some CTPs that is needed. I created AUTO-PURGE=Y in WFCONFIG and still same result. Any help on this is greatly appreciated. It is my understanding that that the delivered product has AUTO-PURGE default to yes!

I need to send a notification email whenever a new account is setup on GL00.1.  I'm able to find what i need using this query since it is marked on curr-control field by accounting when it is setup. PROD=&FILE=GLCHARTDTL&INDEX=GDTSET1&KEY=ABC;DEF&FIELD=ACCOUNT;SUB-ACCOUNT;ACCOUNT-DESC;CHART-NAME;SUMRY-ACCOUNT.ACCOUNT-DESC&SELECT=CURR-CONTROL=1&OUT=CSV&DELIM=~ The problem i run into is updating the field CURR-CONTROL back to NO with an AGS call since GL00.4 does not let me choose a method t...

Converted 8.0.3 to 9.0 Not able to get category name to pass on  Trigger properties NAME is NOT on 9.0  catergory value is.  1. Is this a another Webrun   wf20 thing.   2. What Web Run do I need  wf25 wf22 all the elements in usercat seems to have converted ok

Is it possible for the Webrun node to call multiple Post Strings Specifically, I am trying to load user tasks into PF Admin.  I have the web call established and it works, but it only does one user task at a time, which isn't any real time/effort savings.

I need to to start a flow when order comes to OE10 form. There will be several different orders, but I am interested in one specific type of order. When this specific type of order released to OE10 form I need to start the flow with order number as input value to the flow. There is lot of documentation on triggers, services and work units. I could not find any example on triggers and process flow. I am using 9.0 version. Thanks. Latha.

In previous articles in this series, we've looked at high-level integration concepts using ProcessFlow Integrator. We've also explored some of the nodes which come with ProcessFlow for basic control of flows (e.g. branching) as well as querying and updating Lawson data. We're now looking at the integration aspect of flows, focusing first on file integration, which includes one of my favorite nodes, DataIterator. Read ProcessFlow Integrator, Part 8: The DataIterator Node.

At the core of integration with your Lawson applications is the need to extract, as well as update, data. In this installment of our ProcessFlow Integrator article series, we’ll look at the Query (DME) node, which you use to retrieve Lawson data in ProcessFlow. Read ProcessFlow Integrator, Part 5: The Query (DME) Node.

How do I create job with variable as part of JOB name jobrun.exe will give Security Error if job does not exist Ie rq111 Wh130

We had just purchased PFI and are looking to start creating some new flows that will allow us to be able to import data and be able to transform it before we import it into Lawson.  Does anyone have a recommendation as to what tools may be best suited for this. I am looking to find out should we be using BCI or Ascentia. Our current process is to create custom java code and we want to get away from that process. Any suggestions would be appreciated.

Has anyone approached the WF12 Tasks as a Role instead of Task in the Workflow we are debating whether to create a 'Promotion Action Approver' task and a 'Termination Action Approver' task and assign it to each HR Rep - or just create an 'HR Rep Approver' task that can be used in many work flows.  THe goal is to cut down on WF12 administration and restrict workflow requirements to certain 'standards'. Has anyone else used the WF12 Tasks as Roles

What Flags need to be set to have RSS to send to rq10    Our xml flos work fine when triggered stand via rq10. When rq is created via RSS it goes to need approval but does not go to Pflow. (no work unit created we are using ssh 08.0100.55.04 with 9.0.05

As I am still very new to PFI, my organization is trying to implement employee and manager self serve modules.  We are trying to determine if information that an employee would enter in, could get setup through PFI to first be validated by HR before taking effect.  Any help would be appreciated.  Thanks, April

I'm designing a flow that could be triggered from a custom Lawson portal web page (non-Lawson app such as a RQ10, PA52, etc). This is 8.0.3 apps and environment so we can't use the stuff from 9.0. I'm guessing I'd need to somehow call the Pflow API's to create the trigger. Anyways, has anyone ever done this before in 8.0.3 (i.e. create a trigger outside of Lawson apps, in Portal) Thanks in advance, Roger

I use the message builder node to store data in a flow and then email it all in one email.  I notice in 9.0, i get this message whenever i have data:  Warning: Variable (var1) value more than 250 characters This is the default variable that appears whenever you build a flow.  Has anyone else seen this

We are getting ready to go from Apps 8 to Apps 9. (We have already gone to LSF9.) My bosses are meeting with possible installation partners.  Partners are advocating we use PFI to upgrade our applications.  Unless the partners already have flows written that they use over and over at different customer locations, I don't get writing a flow to do it.  Anytime the subject of interfacing with other systems comes up, the answer from the partners is PFI.  PF is an automation tool for processes.  I...

Trying for some input from others here. We currently have PA42 set up so when a job req is created a new processflow/work unit will be triggered. For another reason, I'm trying to design a process where I have a processflow which will create a new job req in PA42 using the AGS call. But, I don't want it to create a new (second) work unit from that PA42. Is there any way I can set up or call the PA42 from a processflow where it does NOT create a new work unit I thought about creating a copy of...

I am trying to use the addLeadingZeros function to print the leading zeros that are present on Employee field FullEmpID = addLeadingZeros(Employee, 9) FullEmpID is defined as an Integer and assigned an initial value of 0 The result is not left zero-filled

We just installed SP6 on our LSF9 Technology (LSF9.0.0.6 in test (SP4 in prod), Apps 8.0.3 MSP11, Windows, SQL Server, LS for users, LAUA for Admin).  There are two issues so far that I've run into... 1.  Can't assign oCatValue in the start node of designer (duplicate variable error).  There is an easy work around for this...Lawson has created a PT. 2.  Bigger problem...none of our custom inbaket htms display!  There is another PT (180287).  Lawson discovered that it is an issue with pulling...

We have a need to invoke some existing VB executables running on a Windows box from PFI running on an AIX box.  What's the best way to accomplish this One possibility: I can create a Windows .bat file to invoke the executable, but how do I connect to the Windows box and invoke the .bat file from PFI running on AIX

Can anyone recommend any documentation or tutorials on how to get started with the DataStage Tool   Our technical team received PFI training from Lawson but the use of this tool was not covered. We would like to start using this tool with PFI. Any suggestions would be appreciated.