With the release of Oracle Fusion CRM, if you’re an application developer and you’re sick of hearing, “Why can’t this field hold more than 40 characters?”, you will not hear that anymore. No longer will you have to make excuses for the limitations. Not only are text fields changing, new field types have been added.
Some of the changes to the fields are as follows
| R19 | Fusion | |
| Text | Text fields use a single-line text field. However, different fields use different lengths. Maximum Length 100 characters | Users can enter a combination of letters, number, or symbols and is limited to 254 characters |
| Long Text | Text fields use a single-line text field. However, different fields use different lengths. Maximum Length 255 characters | Users can enter a combination of letters, number, or symbols and is limited to 32000 characters |
| Dynamic Choice List | N/A | Users can select from a list of values, populated from another object’s set of records |
| Formula | N/A | A field that is calculated in the runtime CRM application using the Groovy-based expression included in the formulas field’s definition. This is a read-only field that users in the runtime application do not update. However, the application logic that you write can update these fields directly. |
Another addition is the use of ‘Help text’ for a field. The help text displays when users hover over the field in the runtime application. Oracle recommends an 80 character maximum length although no maximum length is actually enforced. This field property is available for all field types.
If your organization is using Books of Business in CRM On Demand, if the required fields are not set up correctly either in the company profile or the user records, the users will not be able to select a book.
In order for the users to be able to select books to change the reporting visibility on records, the ‘Historical Subject Areas’ needs to be set to ‘Full Visibility’. If the Company Profile has a value in the field and the user records are left blank, the company default value will be used. For example, if you would like the majority of users to have access to the data that they own as well as data where they are on a team, simply set the company profile to ‘Team Visibility’ for Reporting Subject Areas and Historical Subject Areas. In order for users to be able to view the data based on a book, just change their Historical Subject Area to Full Visibility. While doing that, you might want to set the Default Book for Analytics in the user record to the book that the user will use when running reports.
