invalid value for field show_number reverse terminating ex-apl.cwk (Doc ID 1931115.1)

Last updated on OCTOBER 12, 2017

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP5 and later
Information in this document applies to any platform.

Symptoms

On : 12.1 HRMS RUP5 version, Core HR - General
on production

When attempting to query APL.CWK person after reverse terminating their application
the following error occurs.

ERROR
-----------------------
FRM-40212: Invalid value for field SHOW_NUMBER
You can also see that there is no value for 'Identification' fields


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) 01-JUN-2014 People Enter and Maintain People -> Create Applicant
2) People Others Application
Enter at least mandatory fields, save
3) Alter Effective Date = 01-JUL-2014
People Action=Create Contingent Worker
Save
Choose Update option
Person Type is changed (Contingent Worker.Applicant)
Identification:
Contingent Worker 101514
4) People Others End Application Terminate Applicant
Enter Terminated = 30-JUN-2014
Save
5) People – re-query person
Person Type is changed (Contingent Worker.Ex-applicant) -- all OK at this point
6) People Others End Application Terminate Applicant
Reverse Termination clears Terminated Date
7) People – re-query person
Person Type is changed (Contingent Worker.Applicant)
Identification region is blank
FRM-40212: Invalid value for field SHOW_NUMBER massage appears



Cause

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