E1: 07: Check Control Numbers Duplicating - R07250
Last updated on JULY 12, 2017
Applies to:JD Edwards EnterpriseOne US Payroll - Version 9.1 and later
Information in this document applies to any platform.
Check Control Numbers Duplicating
When there are large numbers of employees paid in weekly payrolls so CKCN is used frequently, if the check digit is used, there are only 9,999,999 CKCN's. When the CKCN starts over it is possible the same CKCN could be used. When the CKCN is reused the F07186 is not updated correctly. The F07186 has a single primary key that uses CKCN and Line number. If the same CKCN is used there is a duplicate key issue, and any line number that for the CKCN with a record in the table is not inserted. This causes issues with history and the P07186 app.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms