Transaction Node Error: AGS error: Must inquire on code before adding

Here is ours which works fine. Note that we do not do an "immediate" because ours is inside a work flow. Offhand, I'd say your problem is the missing applicant and effective date which are required fields.

_PDL=&_TKN=PA52.4&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=A&PCT-COMPANY=&PCT-APPLICANT=&PCT-ACTION-CODE=NEW HIRE 1&PCT-EFFECT-DATE=&PCT-EMPLOYEE=&PAT-FLD-NBR-11=50&PCT-NEW-VALUE-1r0=&PAT-FLD-NBR-12=03&PCT-NEW-VALUE-1r1=&PAT-FLD-NBR-13=02&PCT-NEW-VALUE-1r2=&PAT-FLD-NBR-14=155&PCT-NEW-VALUE-1r3=&PAT-FLD-NBR-15=881&PCT-NEW-VALUE-1r4=&PAT-FLD-NBR-16=156&PCT-NEW-VALUE-1r5=&PAT-FLD-NBR-17=879&PCT-NEW-VALUE-1r6=&PAT-FLD-NBR-18=20&PCT-NEW-VALUE-1r7=&PAT-FLD-NBR-19=24&PCT-NEW-VALUE-1r8=&PAT-FLD-NBR-110=126&PCT-NEW-VALUE-1r9=&PAT-FLD-NBR-111=14&PCT-NEW-VALUE-1r10=&PAT-FLD-NBR-112=15&PCT-NEW-VALUE-1r11=&PAT-FLD-NBR-21=19&PCT-NEW-VALUE-2r0=&PAT-FLD-NBR-22=17&PCT-NEW-VALUE-2r1=&PAT-FLD-NBR-23=18&PCT-NEW-VALUE-2r2=&PAT-FLD-NBR-24=56&PCT-NEW-VALUE-2r3=&PAT-FLD-NBR-25=73&PCT-NEW-VALUE-2r4=&PAT-FLD-NBR-26=62&PCT-NEW-VALUE-2r5=&PAT-FLD-NBR-27=64&PCT-NEW-VALUE-2r6=&PAT-FLD-NBR-28=136&PCT-NEW-VALUE-2r7=&PAT-FLD-NBR-29=135&PCT-NEW-VALUE-2r8=&PAT-FLD-NBR-210=106&PCT-NEW-VALUE-2r9=&PAT-FLD-NBR-211=66&PCT-NEW-VALUE-2r10=&PAT-FLD-NBR-212=67&PCT-NEW-VALUE-2r11=&PAT-FLD-NBR-31=05&PCT-NEW-VALUE-31=&PAT-FLD-NBR-32=06&PCT-NEW-VALUE-32=&PAT-FLD-NBR-33=07&PCT-NEW-VALUE-33=&PAT-FLD-NBR-34=08&PCT-NEW-VALUE-34=&PAT-FLD-NBR-35=09&PCT-NEW-VALUE-35=&PAT-FLD-NBR-36=568&PCT-NEW-VALUE-36=&PAT-FLD-NBR-37=13&PCT-NEW-VALUE-37=&PAT-FLD-NBR-38=89&PCT-NEW-VALUE-38=&PAT-FLD-NBR-39=88&PCT-NEW-VALUE-39=&PAT-FLD-NBR-310=63&PCT-NEW-VALUE-310=&PAT-FLD-NBR-311=294&PCT-NEW-VALUE-311=&PAT-FLD-NBR-312=23&PCT-NEW-VALUE-312=&XMIT-HREMP-BLOCK=0001111100&_DELIM=%09&_OUT=XML&_EOT=TRUE&FROM-WORKFLOW=Y

Hi Chris. You need to include the Hidden Key in order to load to PA52.4. the Field Name is HK, and this is how it is built:

Company number (padded to 4 characters with leading zeros)
Applicant Number (padded to 9 characters with leading zeros)
Action Code (padded to 10 characters with trailing spaces)
Effective Date (yyyymmdd format)

Example: Company 50, applicant 9987, Action Code HIRE, Effective 3/13/2014
HK=0050000009987HIRE 20140313

If you concatenate that all together you should get a successful load.

Ah - just realized the variables aren't showing after the paste into this thread. So you probably do have application and effective date variables - they aren't showing in mind here either.

Thank I will try that ASAP

Bob, where should the HK be placed in the AGS call?

Barb, I will review yours as well .... Thanks

I usually put it at the end, but I don't think it is particular. And I forgot to mention that it is _HK

OK, this is driving me crazy ...

I still get the error, do you see anything in the below statement?

_PDL=TEST6&_TKN=PA52.4&_EVT=ADD&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=A&PCT-COMPANY=9009&PCT-APPLICANT=&PCT-EFFECT-DATE=&PCT-ACTION-CODE=XNE-HIREAP&IMMEDIATE-ACTION=Y&PCT-NEW-VALUE-1r0=&PCT-NEW-VALUE-1r1=&PCT-NEW-VALUE-1r2=&PCT-NEW-VALUE-1r3=2&PCT-NEW-VALUE-1r4=NON1&PCT-NEW-VALUE-1r5=0.0001&PCT-NEW-VALUE-1r6=NONEMP&PCT-NEW-VALUE-1r7=NO&PCT-NEW-VALUE-1r8=2080&PCT-NEW-VALUE-1r9=N&PCT-NEW-VALUE-1r10=N&PCT-NEW-VALUE-1r11=Y&PCT-NEW-VALUE-2r0=9009&PCT-NEW-VALUE-2r1=80500&PCT-NEW-VALUE-2r2=609000&PCT-NEW-VALUE-2r3=N&PCT-NEW-VALUE-2r4=N&PCT-NEW-VALUE-2r5=&ORIG-COMPANY=9009&ORIG-APPLICANT=&ORIG-ACTION-CODE=XNE-HIREAP&ORIG-REQUISITION=000000000&ORIG-EFFECT-DATE=20130808&PAT-FLD-NBR-11=15&PAT-FLD-NBR-12=17&PAT-FLD-NBR-13=18&PAT-FLD-NBR-14=63&PAT-FLD-NBR-15=106&PAT-FLD-NBR-16=62&PAT-FLD-NBR-17=136&PAT-FLD-NBR-18=135&PAT-FLD-NBR-19=294&PAT-FLD-NBR-110=66&PAT-FLD-NBR-111=67&PAT-FLD-NBR-112=73&PAT-FLD-NBR-21=288&PAT-FLD-NBR-22=28&PAT-FLD-NBR-23=29&PAT-FLD-NBR-24=287&PAT-FLD-NBR-25=2079&PAT-FLD-NBR-26=14&XMIT-HREMP-BLOCK=0001111100&XMIT-IMMED=1&_DELIM=%09&_OUT=XML&_EOT=TRUE&_HK=90090000XNE-HIREAP20140313

I don't think your hidden key is adequately padded.  See Bob Canham's update for the correct size of each element in the _HK value.

Hi, I'm also experiencing the same issue when trying to add on pa52.5  node on IPA version 10.1.1.30. Below is the code. Please help.

 

_PDL=PROD&_TKN=PA52.5&_EVT=ADD&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=A&PCT-ACTION-CODE=FOCALMERIT&PCT-COMPANY=&PCT-EFFECT-DATE=&PCT-EMPLOYEE=&PCT-NEW-PAY-RATE=&PCT-REASON1=FOCALMERIT&POS-LEVEL=&XMIT-HREMP-BLOCK=&XMIT-PAPEP-BLOCK=100000000&_DELIM=%09&_OUT=XML&_EOT=TRUE&_HK=0001000110528FOCALMERIT01201611060000