IPA upload HR11 userfields

Hello,

I created a flow that updates a user field via SQLTxn on HREMPUSF and in test it worked flawlessly. I perform the same action in PROD and receive the following error (I realize it says unique constraint, but it is inserting anyway and when I run the insert statement in SQL Developer there is no error):

lastOutputData = java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<PRODLINE>.HEUSET1) violated

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:933)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1640)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1603)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:308)
at com.lawson.bpm.processflow.workFlow.flowGraph.FgSQL.executeUpdate(FgSQL.java:1249)
at com.lawson.bpm.processflow.workFlow.flowGraph.FgSQL.executeUpdate(FgSQL.java:1479)
at com.lawson.bpm.processflow.workFlow.flowGraph.FgaSQLUpdate.startActivity(FgaSQLUpdate.java:53)
at com.lawson.bpm.processflow.workFlow.flowGraph.FgActivity.execute(FgActivity.java:920)
at com.lawson.bpm.processflow.workFlow.flowGraph.FgProcess.run(FgProcess.java:2485)
at com.lawson.bpm.designer.runtime.LocalFlowRunner.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

If anyone has any other ideas on how to populate HR11 user fields from IPA I'd be glad to hear them. I tried using HR15 via LWSNTXN but couldn't get that to work.

Find more posts tagged with

Process Automation (IPA) - General Discussions

Comments

lrjurgen

We update the HR11 EMP-BSI-GROUp via IPA so it should be similar. We use the Lawson Transaction node. Here is a sample:

_PDL=<!appProdline>&_TKN=HR11.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&EMP-COMPANY=<!emp_COMPANY>&EMP-EMPLOYEE=<!emp_EMPLOYEE>&EFFECT-DATE=<!sysdate>&POS-LEVEL=1&EMP-BSI-GROUP=EGTRRA2001&_DELIM=%09&_OUT=XML&_EOT=TRUE

unknown

Thanks! - I had looked at HR11.1 before but not as much as I should have! I was able to find the userfield information under that token. Can I ask what your date format looks like? I've tried several different formats and none seems to be working correctly for me.

lrjurgen

For the EFFECT_DATE field, I am using a variable and the expression for it is "todayAGS()"

unknown

Kyle, do you mind sharing your transaction node string that you got to work. I keep running into Change Complete - Continue, but nothing is updated.

0911060553270289.pdf

unknown

Hi Chris, just FYI we created a personnel action to update user fields and then do a Lawson txn with PA52 in a flow to load the those fields. You could also create an HR515 input file and submit HR515 in a flow as well.

unknown

I didn't see this till now - here is what I used to get it to work: _PDL=LPRD10&_TKN=HR11.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&EFFECT-DATE=<!SysDate>&EMP-COMPANY=1&EMP-EMPLOYEE=<!Employee>&HRU-FIELD-KEYr0=55&WS-LINE-FC24=C&WS-VALUE24=<!Value>&XMIT-HREMP-BLOCK=1000000000&WS-FLD-NBR24=2055&_DELIM=%09&_OUT=XML&_EOT=TRUE

SysDate = todayAGS()

WS-LINE-FC24 can be either C or A depending on whether or not there is already a value.

Copyright © 2025 Infor. All rights reserved.