Import Object Ignores Field Read Only Field Bc User Property While Importing Records from Excel (Doc ID 2924434.1)

Last updated on FEBRUARY 27, 2023

Applies to:

Symptoms

When importing records from excel using import functionality, the field values of read only fields are overridden by the new values.

STEPS
The issue can be reproduced at will with the following steps:
1. In the Contact BC, added user property Field Read Only Field: Preferred Communications with value as PrefCommReadOnly.
2. Created calculated field PrefCommReadOnly with value as Y
3. Deliver or Inspect the workspace.
4. In the Application go to Contact List View and check the List applet.
5. Find the field Contact Method.
6. Click on the field and you will find that the field is read only.
7. Export a record.
8. In the output excel modify the Contact Method field value to Phone.
9. Save the file.
10.Import the excel using Import Menu Command.
11.The record is imported and the Contact Method is updated to Phone.

Cause

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