CAF: Common Attribute Value Greater Than 20 Characters Shows Blank on Additional Fields After Saving the Associated Page and the Value Saved in CAF_ATTR_VAL is Also Blank on the Associated Record (Doc ID 3049239.1)

Last updated on OCTOBER 01, 2024

Applies to:

Symptoms

When a common attribute is defined with a value longer than 20 characters, the value will display as blank on the page linked to the attribute, and the associated record will also show the field as blank. This behavior is consistently regardless of the page and record linked to the attribute, but a couple common examples are given in the steps below.

The common attribute values should be saving and displaying the same and correctly for any number of characters up to the allowed limit, which is 30 characters.  The field will save and display correctly when the value is 20 characters or less.

The issue can be reproduced with the following steps:

1. Navigate to the common attributes setup page (Set Up SACR > Common Definitions > Common Attributes Setup > Common Attribute)
2. Create a new common attribute name and description. For the attribute type, pick List of Values
3. Create New CAF values
4. When creating new attribute values, set the attribute value to anything greater than 20 characters. The field length is 30 characters.
5. Enter a formal description. This field length is 100 characters.
6. Tie that attribute to record ADM_APPL_DATA
7. Go to application staging (Student Admissions > Application Transaction Mgmt > Application Transaction) and pull up any non-posted staging application transaction.
8. On the Application Data tab, under the Application data section, click on Additional Fields
9. Click on the LOV that you created that is longer than 20 characters that you created in the attribute values and click OK.
10. Click Save on the application data page.
11. Go back to the Additional Fields page and note the field from step 9 shows blank.
12. Query the associated record  SAD_APL_CAF_STG and note the SCC_CAF_ATTR_VAL shows blank instead of the defined value.

The issue is also seen with Maintain Applications and can be reproduced with the following steps:

1. Navigate to Maintain Applications page (Main Menu > Student Admissions > Application Maintenance > Maintain Applications and retrieve a student.
2. Click on the Application Data tab and click on ‘Additional Fields’
3. On the LOV CAF field, select the field that has the attribute value set to greater than 20 characters and click save.
4. Click Save on the application data page.
5. Go back to the additional fields page and query SAD_APPL_CAF and note the value is blank in both cases.

Cause

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