Question:
Why does the Formulary Matrix display an incomplete table in Veeva CRM?
Answer:
The online Formulary Matrix displays a table of Benefit Design Line data on an Account, organized by Product rows and Benefit Design columns.
If there is invalid data in the Benefit Design Line records that make up the Formulary Matrix, the display of the table may abort partway through rendering, and not display all cells or rows. The last displayed Matrix cell will be blank. This blank cell is where Veeva CRM encountered invalid data.
Find the Benefit Design Line record for this blank cell by reviewing the Benefit Design Lines for the specific Benefit Design (column) and Product (row) of the blank cell. Review all data for this Benefit Design Line, including the Picklist values for Status and Restrictions.
Review the Picklist selections on the Benefit Design Line for the blank cell in the Formulary Matrix, then compare the selections to the current list of valid Picklist options for those fields on the Benefit_Design_Line_vod object. If any Picklist selections on the Benefit Design Line were deactivated or deleted after the record was saved, that results in invalid data that will cause the rendering of the Formulary Matrix to abort.
Note: You may need to click Edit to verify what Picklist values have been selected.
If a Picklist selection from the Benefit Design Line is no longer an active available value, either select a currently valid Picklist value on the Benefit Design Line record or modify the active Picklist values for the proper field on the Benefit_Design_Line_vod object to re-enable that selection. If you recreate a deleted Picklist value, you will also need to reselect the Picklist value on the Benefit Design Line record.
Once the data on the Benefit Design Line record has been fixed and is valid, the Formulary Matrix will render that cell, and continue rendering until the table is complete, or until another cell with invalid data is found.
Related Documentation:
CRM Help Documentation: The Formulary Matrix