PA52.4 Tax Authority does not exist for county

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

Todd Mitchell

Veteran Member Send Private Message

Posts: 87

3/14/2016 4:44 PM

i am getting this error in a flow within PA52.4:

Tax Authority does not exist for county

Using the same "New Values" using Portal, the transaction is added. Any ideas why Portal works but the flow kicks out this error? Here is my AGS call in IPA:

_PDL=&
_TKN=PA52.4&
_EVT=ADD&
_RTN=DATA&
_LFN=ALL&
_TDS=IGNORE&
FC=A&
PCT-COMPANY=&
PCT-APPLICANT=&
PCT-ACTION-CODE=&
PCT-ACTION-NBR=&
PCT-EFFECT-DATE=&
ORIG-COMPANY=&
ORIG-APPLICANT=&
ORIG-ACTION-CODE=&
ORIG-EFFECT-DATE=&
PCT-ACTION-NBR-K=&
IMMEDIATE-ACTION=&
ASSIGN-EMPLOYEE-NBR=Y&
PCT-UPDATE-BENEFIT=N&
PCT-UPD-ABS-MGMT=Y&
PCT-UPDATE-REQ-DED=Y&
PCT-EDM-EFFECT-DT=&
PAT-FLD-NBR-11=&
PAT-FLD-NBR-12=&
PAT-FLD-NBR-13=&
PAT-FLD-NBR-14=&
PAT-FLD-NBR-1Ar3=&
PAT-FLD-NBR-15=&
PAT-FLD-NBR-16=&
PAT-FLD-NBR-17=&
PAT-FLD-NBR-18=&
PAT-FLD-NBR-19=&
PAT-FLD-NBR-110=&
PAT-FLD-NBR-111=&
PAT-FLD-NBR-112=&
PAT-FLD-NBR-21=&
PAT-FLD-NBR-22=&
PAT-FLD-NBR-23=&
PAT-FLD-NBR-24=&
PAT-FLD-NBR-25=&
PAT-FLD-NBR-26=&
PAT-FLD-NBR-27=&
PAT-FLD-NBR-28=&
PAT-FLD-NBR-29=&
PAT-FLD-NBR-210=&
PAT-FLD-NBR-211=&
PAT-FLD-NBR-212=&
PAT-FLD-NBR-31=&
PAT-FLD-NBR-32=&
PAT-FLD-NBR-33=&
PAT-FLD-NBR-34=&
PAT-FLD-NBR-35=&
PAT-FLD-NBR-36=&
PAT-FLD-NBR-37=&
PAT-FLD-NBR-38=&
PAT-FLD-NBR-39=&
PAT-FLD-NBR-310=&
PAT-FLD-NBR-311=&
PAT-FLD-NBR-312=&
PCT-NEW-VALUE-1r0=&
PCT-NEW-VALUE-1r1=&
PCT-NEW-VALUE-1r2=&
PCT-NEW-VALUE-1r3=&
PCT-NEW-VALUE-1r4=&
PCT-NEW-VALUE-1r5=&
PCT-NEW-VALUE-1r6=&
PCT-NEW-VALUE-1r7=&
PCT-NEW-VALUE-1r8=&
PCT-NEW-VALUE-1r9=&
PCT-NEW-VALUE-1r10=&
PCT-NEW-VALUE-1r11=&
PCT-NEW-VALUE-2r0=&
PCT-NEW-VALUE-2r1=&
PCT-NEW-VALUE-2r2=&
PCT-NEW-VALUE-2r3=&
PCT-NEW-VALUE-2r4=&
PCT-NEW-VALUE-2r5=&
PCT-NEW-VALUE-2r6=&
PCT-NEW-VALUE-2r7=&
PCT-NEW-VALUE-2r8=&
PCT-NEW-VALUE-2r9=&
PCT-NEW-VALUE-2r10=&
PCT-NEW-VALUE-2r11=&
PCT-NEW-VALUE-31=&
PCT-NEW-VALUE-32=&
PCT-NEW-VALUE-33=&
PCT-NEW-VALUE-34=&
PCT-NEW-VALUE-35=&
PCT-NEW-VALUE-36=&
PCT-NEW-VALUE-37=&
PCT-NEW-VALUE-38=&
PCT-NEW-VALUE-39=&
PCT-NEW-VALUE-310=&
PCT-NEW-VALUE-311=&
PCT-NEW-VALUE-312=&
XMIT-DEDDAT=1&XMIT-IMMED=1&XMIT-REQDED=1&XMIT-ACTEXISTS=1&XMIT-HREMP-BLOCK=1000000000&
_HK=&
_DELIM=%09&_OUT=XML&_EOT=TRUE

pbelsky

Veteran Member Send Private Message

Posts: 80

3/14/2016 5:54 PM

You might have to initialize some of the fields that you want to set to spaces. Here is the code that is throwing the error (HREMPPD)

134200 IF (HREMP-TAX-COUNTY NOT = SPACES)
134300 AND (HREMP-TAX-COUNTY NOT = EMP-TAX-COUNTY)
134400 MOVE HREMP-TAX-COUNTY TO DB-TAX-ID-CODE
134500 PERFORM 840-FIND-PRXSET1
134600 IF (PRTAXAUTH-NOTFOUND)
134700 OR (PRX-TAX-AUTH-TYPE NOT = "CN")
134800 MOVE 125 TO CRT-ERROR-NBR
134900 MOVE HREMP-TAX-COUNTY-FN TO CRT-FIELD-NBR
135000 IF (HREMP-BATCH-PROGRAM = "Y")
135100 PERFORM 2600-BATCH-ERROR
135200 THRU 2600-END
135300 ELSE
135400 GO TO 2400-END.

Todd Mitchell

Veteran Member Send Private Message

Posts: 87

3/15/2016 12:22 PM

All the address information is filled in, nothing to blank out. I do see that my cut and paste of the information does not reflect the variable names. Here is a "different" view:

_PDL=&
_TKN=PA52.4&
_EVT=ADD&
_RTN=DATA&
_LFN=ALL&
_TDS=IGNORE&
FC=A&
PCT-COMPANY=&
PCT-APPLICANT=&
PCT-ACTION-CODE=&
PCT-ACTION-NBR=&
PCT-EFFECT-DATE=&
ORIG-COMPANY=&
ORIG-APPLICANT=&
ORIG-ACTION-CODE=&
ORIG-EFFECT-DATE=&
PCT-ACTION-NBR-K=&
IMMEDIATE-ACTION=&
ASSIGN-EMPLOYEE-NBR=Y&
PCT-UPDATE-BENEFIT=N&
PCT-UPD-ABS-MGMT=Y&
PCT-UPDATE-REQ-DED=Y&
PCT-EDM-EFFECT-DT=&
PAT-FLD-NBR-11=&
PAT-FLD-NBR-12=&
PAT-FLD-NBR-13=&
PAT-FLD-NBR-14=&
PAT-FLD-NBR-1Ar3=&
PAT-FLD-NBR-15=&
PAT-FLD-NBR-16=&
PAT-FLD-NBR-17=&
PAT-FLD-NBR-18=&
PAT-FLD-NBR-19=&
PAT-FLD-NBR-110=&
PAT-FLD-NBR-111=&
PAT-FLD-NBR-112=&
PAT-FLD-NBR-21=&
PAT-FLD-NBR-22=&
PAT-FLD-NBR-23=&
PAT-FLD-NBR-24=&
PAT-FLD-NBR-25=&
PAT-FLD-NBR-26=&
PAT-FLD-NBR-27=&
PAT-FLD-NBR-28=&
PAT-FLD-NBR-29=&
PAT-FLD-NBR-210=&
PAT-FLD-NBR-211=&
PAT-FLD-NBR-212=&
PAT-FLD-NBR-31=&
PAT-FLD-NBR-32=&
PAT-FLD-NBR-33=&
PAT-FLD-NBR-34=&
PAT-FLD-NBR-35=&
PAT-FLD-NBR-36=&
PAT-FLD-NBR-37=&
PAT-FLD-NBR-38=&
PAT-FLD-NBR-39=&
PAT-FLD-NBR-310=&
PAT-FLD-NBR-311=&
PAT-FLD-NBR-312=&
PCT-NEW-VALUE-1r0=02092016&
PCT-NEW-VALUE-1r1=002HR&
PCT-NEW-VALUE-1r2=HRR02&
PCT-NEW-VALUE-1r3=US&
PCT-NEW-VALUE-1r4=SA VAC1&
PCT-NEW-VALUE-1r5=503&
PCT-NEW-VALUE-1r6=2076&
PCT-NEW-VALUE-1r7=MI-WYOMI08&
PCT-NEW-VALUE-1r8=H&
PCT-NEW-VALUE-1r9=1&
PCT-NEW-VALUE-1r10=12&
PCT-NEW-VALUE-1r11=1&
PCT-NEW-VALUE-2r0=N&
PCT-NEW-VALUE-2r1=WKLY&
PCT-NEW-VALUE-2r2=N&
PCT-NEW-VALUE-2r3=N&
PCT-NEW-VALUE-2r4=T&
PCT-NEW-VALUE-2r5=1&
PCT-NEW-VALUE-2r6=HRR02&
PCT-NEW-VALUE-2r7=7400&
PCT-NEW-VALUE-2r8=50&
PCT-NEW-VALUE-2r9=S&
PCT-NEW-VALUE-2r10=GR OFFICE&
PCT-NEW-VALUE-2r11=45333&
PCT-NEW-VALUE-31=24960.00&
PCT-NEW-VALUE-32=132 TEST&
PCT-NEW-VALUE-33=SUITE 400&
PCT-NEW-VALUE-34=LOWELL&
PCT-NEW-VALUE-35=MI&
PCT-NEW-VALUE-36=49331&
PCT-NEW-VALUE-37=KENT&
PCT-NEW-VALUE-38=&
PCT-NEW-VALUE-39=&
PCT-NEW-VALUE-310=&
PCT-NEW-VALUE-311=&
PCT-NEW-VALUE-312=&
XMIT-DEDDAT=1&XMIT-IMMED=1&XMIT-REQDED=1&XMIT-ACTEXISTS=1&XMIT-HREMP-BLOCK=1000000000&
_HK=&
_DELIM=%09&_OUT=XML&_EOT=TRUE

pbelsky

Veteran Member Send Private Message

Posts: 80

3/15/2016 6:46 PM

Hey Todd, I just noticed your other note about PA52.4. Are you receiving this error in test, where you had the other problem? If so, you might want to try moving the source code from PROD into TEST and recompiling, since it sounded from your other note like someone might have accidentally fat-fingered your source in TEST.

pbelsky

Veteran Member Send Private Message

Posts: 80

3/15/2016 6:55 PM

Also, you checked that your PRTAXAUTH has a row with TAX_ID_CODE of 'KENT' with TAX_AUTH_TYPE of 'CN' , right?

Todd Mitchell

Veteran Member Send Private Message

Posts: 87

3/15/2016 7:15 PM

I found the problem.

I didn't have the right PADICT field number mapped in the Update step:

PAT-FLD-NBR-11=24&

PAT-FLD-NBR-12=14&

PAT-FLD-NBR-13=15&

PAT-FLD-NBR-14=769& --> inquiry comes back with 783 not 769

PAT-FLD-NBR-15=16&

PAT-FLD-NBR-16=19&

PAT-FLD-NBR-17=18&

PAT-FLD-NBR-18=17&

PAT-FLD-NBR-19=64&

PAT-FLD-NBR-110=63&

PAT-FLD-NBR-111=62&

PAT-FLD-NBR-112=65&

PAT-FLD-NBR-21=73&

PAT-FLD-NBR-22=106&

PAT-FLD-NBR-23=164&

PAT-FLD-NBR-24=67&

PAT-FLD-NBR-25=66&

PAT-FLD-NBR-26=288&

PAT-FLD-NBR-27=28&

PAT-FLD-NBR-28=29&

PAT-FLD-NBR-29=50& --> inquiry comes back with 30 not 50

PAT-FLD-NBR-210=59&

PAT-FLD-NBR-211=46&

PAT-FLD-NBR-212=47&

PAT-FLD-NBR-31=75&

PAT-FLD-NBR-32=39&

PAT-FLD-NBR-33=40&

PAT-FLD-NBR-34=41&

PAT-FLD-NBR-35=42&

PAT-FLD-NBR-36=43&

PAT-FLD-NBR-37=551&

PAT-FLD-NBR-38=891&

PAT-FLD-NBR-39=2055&

PAT-FLD-NBR-310=2056& --> inquiry comes back with 2065 not 2056

PAT-FLD-NBR-311=2048& --> inquiry comes back with 2041 not 2048

PAT-FLD-NBR-312=&

pbelsky

Veteran Member Send Private Message

Posts: 80

3/15/2016 7:23 PM

I'm glad you found it!