What is the impact when renaming a custom field?
Custom fields, Oracle Service Cloud, May 2016
Important! It is the best to rename or modify custom fields during off-peak hours. When custom fields are edited, update statements must be performed against the corresponding database table. During the time of the updates, the records in the table are inaccessible. As a result, your staff members will not be able to open or save records associated with the table that is locked.
In order to rename a custom field:
1. Click the Configuration button on the navigation pane;
2. Double-click Custom Fields under Database. The content pane displays the Custom Fields tree;
3. In case you want to change the Name of the custom field, please note that the Label will also be updated; Each language can have a different label. In interfaces that have the same language as the primary interface, the Label field will always match the menu item Name field.
4. In case you want to change the Column Name your database will be updated as per your changes. You cannot use spaces or punctuation, and the value cannot start with a number. The column name in the database will be appended with the prefix c$. For example, if you add a custom field with the column name calling_plan, it will appear in the database as c$calling_plan.
The impact on your site depends on the fields you are trying to rename. For example:
- If you will rename the Name/ Label of a custom field used in workspaces, the field will be automatically updated and the new name will be displayed in workspaces.
- If you will rename the Column Name, having in view that this requires a database update, the custom field will be removed from workspaces and will be necessary to add it again manually.
For additional information, refer to the 'Add or edit custom fields' section in online documentation for the version your site is currently running. To access Oracle Service Cloud manuals and documentation online, refer to the Documentation for Oracle Service Cloud Products.