Data loaded to Assignment EFF through spreadsheet loader are not displayed in OTBI report
Summary:
Data loaded to Assignment EFF through spreadsheet loader are not displayed in OTBI report
Content (required):
We have loaded assignment EFF attributes using spreadsheet loader successfully and we are able to view the loaded data on the "Additional Assignment Info" page.
We also can see that records are inserted into table PER_ASSIGNMENT_EXTRA_INFO_M.
However, the OTBI report displays all the EFF column values as blank.
The subject area we use in the report is "Workforce Management - Worker Assignment Real Time".
Note: When we entered data on "Additional Assignment Info" page manually, the OTBI report displayed the manual input data correctly. It does not display any record if it is loaded via spreadsheet loader.