ESFO 9.2: Warning And Error Messages About National ID When Trying To Save Personal Data From Staffing Applicant (Doc ID 2076262.1)

Last updated on MARCH 01, 2023

Applies to:

Symptoms

ISSUE:

Whenever a User is entering a new Staffing Applicant into the system, should any changes be made, or new information defined, at the Personal Data page (FO_APP_PERS_DATA2), if the National ID field is blank, and the National ID Type defined is different than the one configured as the default one for the selected Country, the system issues a Warning Message with incorrect indications. It is not taking into consideration the National ID Type selected for the Staffing Applicant, but only displaying guidelines and descriptions of the default National ID Type configured in the main set up pages.

Additionally, if a value is entered into the National ID field, while the National ID Type value selected is not the default one, the system will throw an Error Message as well.

REPLICATION STEPS:

     - Log into the FSCM Online Application as User ID VP1
     - Navigate to: Set Up Financials/Supply Chain > Product Related > Staffing > Resources > National ID Types
     - Perform a search for Country ID USA
     - Once at the National ID Types page (NID_TYPE_TABLE), create a new row with the below settings:
          - ID Type = GCS
          - Default = N
          - Description = GCS National ID
          - Short Description = GCS ID
          - National ID Format = 99-9999999
          - NID As Stored = 999999999
     - Navigate to: Staffing > Resources > Applicants > Applicants
     - Define a new Applicant ID value, and click on ADD button
     - Fill in all the needed information within the Contact information tab (Person Name, Contact Address, Phone Numbers, Email Addresses, etc...)
     - At the Personal Data tab (Page FO_APP_PERS_DATA2), also fill in all the required data, but in the National ID section, make sure to place the following values:
          - Country = USA
          - National ID Type = GCS (Modified from default PR)
          - National ID = (Leave it in Blank)
          - Primary ID = Y
     - Save the changes
     - Issue #1: The system is throwing a Warning Message stating that Social Security Number is needed (SSN, which is for National ID Type PR, not GCS as the one that was selected for this Applicant)
     - Proceed to enter a value into the National ID Field (NID_SPECIAL_CHAR), according to the format defined for National ID Type GCS, and save the changes
     - Issue #2: The system throws new Error Message

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ERROR MESSAGES:

   + Issue #1 - Warning Message:

      " Warning -- Social Security Number should be entered for US Employees (1000,835) "

   + Issue #2 - Error Message:

      " Invalid decimal value -- 56-. (180,106) FUNCLIB_STAFF.NATIONAL_ID.FieldFormula Name:CheckNID_USA PCPC:21495 Statement:491
        Called from:FUNCLIB_STAFF.NATIONAL_ID.FieldFormula Name:Check_NID Statement:670
        Called from:FO_APPLICANT.GBL.FO_APP_NID.SaveEdit Statement:9
        The specified string is an invalid decimal value.
        If necessary, run a PeopleCode trace (SHOW_FETCH) to determine the reason for failure. "

BUSINESS IMPACT:

Whenever the User is entering data for the new Staffing Applicant, the Warning Message is asking to get the Social Security Number information (National ID Type PR), which is not the ID Type selected, which is confusing. Additionally, even if a proper National ID value is entered, following the defined format for the National ID Type selected (Not SSN - PR), the Error Message thrown by the system prevents the User from properly saving any changes performed.

EXPECTED BEHAVIOR:

The system should be able to distinguish which National ID Type has been selected for the current Staffing Applicant, and issue any proper Warning Messages with the correct Description of National ID Type, not the system default one. Validations should be in place that any values entered into the National ID field respect the format in the configurations, and if not, throw an informative Error Message stating how the system is expecting the format to be entered.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.