Issue with reporting National ID information in Advanced reporting.
There are 3 Nationality field has been configured " Nationality 1, Nationality 2,Nationality 3 ' respectively however in Advance Reporting for Nationality 2 and for Nationality 3 fields, the Label and External name filed is missing but for Nationality 1 I can see Label and external code . attached is the screen shot.(Attached screen shot). RELOAD Might fix the issue.
National ID card type filed is pulling Field id not the Value and not label
Is Primary values are not correct, reported 't' rather 'Yes' in same table.
Reproducing the Issue
Navigate to advance reporting.
Select the National Id Portlet:
Drag and drop the complete table:
You can find the discripency in all the fields mentioned above.
The cause of the issue is inappropiate Configuration settings from module side and missing joins becaise of same confusion.
- Nationality Field
There is a metadata update that will be going out this weekend after which we can refresh the Personal Information view in order to generate the auto links for Nationality 2 and Nationality 3.
- National ID Card Type
As Sam mentioned, this labels for this field aren't supported yet.
- Is Primary
The data that is being shown in reporting for this field is being pulled from the table itself i.e. it is the data that is stored in the table (I did reload EMP_NATIONAL_ID_CARD to ensure this is correct). In order to show the values "Yes"/"No", I believe a picklist will have to be configured in the data model for this field to show the desired values.
National Id Card Type National Id , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Problem