2020 W4 Patches -- PR530 Issue

Has anyone had problems loading time records with PR530 after applying these patches. We are trying to test but get an Oracle error on the last record complaining that the Contract Year is non-numeric. Where is this field? Please see below:

*** begin oradb11 error message ***

Fri Jun 26 10:57:03 2020 - program 'PR530', User 'OSID:727913', RMId '727913' Driver Version '10.0.8.0.1031 2015-07-19 04:00:00'

ENDDBTRANS() error on file 'ACACCTCAT' in 'APPS10'

FlushPendingInserts(LAWSON."TIMERECORD")

OCIStmtExecute() returned OCI_ERROR code 1722 parse offset 191627264 (

ORA-01722: invalid number

)

The field it seems to be having an issue with is CONTRACT_YEAR:

"CONTRACT_YEAR" (Type: NUMERIC) ='000P'

Find more posts tagged with

Infor Lawson Human Resources Group - Discussion

Accepted answers

unknown

Thank you!! terri.baker@hhsys.org

All comments

unknown

We had an issue, but ours was in relation to the date format. Go into LID and look at the jobdef on your PR530. You may be able to change the field type for Contract Year from Numeric to String.

unknown

CONTRACT-YEAR is way at the end of the file also, so once you access the file layout in lid and know where this field is supposed to start, you can check to make sure you haven't got unprintable or garbage characters in there that you can clean up in your input file process. I tried to put a copy of the PRFL spreadsheet here for you so you could use that instead of lid, but I have not been able to find it in the concierge

unknown

Thank you both. LID is not my friend so it may take a bit to find, but I really appreciate both of your answers!

unknown

Found it!!! Hope you are on vsn 10. But I can't figure out how to attach it here. If you send me your email, I can send it to you.

WorldCup2018.png

unknown

Thank you!! terri.baker@hhsys.org

Copyright © 2025 Infor. All rights reserved.