My Oracle Support Banner

ExcelToCI: CI_PERSONAL_DATA Inserting Blank Rows Into PS_NAMES table When Uploading Only Address Information (Doc ID 2568388.1)

Last updated on JULY 24, 2019

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
When uploading address information in Personal Data using Excel2CI(delivered CI: CI_Personal_Data), BLANK rows are getting inserting into PS_NAMES table.

EXPECTED BEHAVIOR
-----------------------
BLANK rows shouldn't get inserted into NAMES table.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an Excel2CI template with delivered CI: CI_Personal_Data
2. In Template sheet, include address fields along with phone fields, email address and name information by selecting to submit the data.
3. In the Data Input sheet, provide Emplid and address information and left other fields like phone fields, email address and name information BLANK.
4. Click on 'State Data for Submission' from Data Input sheet.
5. Click on Submit Data from 'Staging & Submission' sheet.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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