DOR - Error flexfields not appear in page document records
Hello team
could help us
We are having problems with document records flexfields
we have a flexfields that returns the employee's category type information for some reason it stopped returning this data
We have already deleted and included this flexfields again and still do not return the value
I will post screenshots of the page and the flexfields configuration
SELECT
A.MEANING
FROM
PER_ALL_ASSIGNMENTS_M E,
FND_LOOKUP_VALUES A
WHEREE.PERSON_ID = :{PARAMETER.PERSONID}
AND E.ASSIGNMENT_TYPE = 'E'
AND SYSDATE BETWEEN E.EFFECTIVE_START_DATE AND E.EFFECTIVE_END_DATE
AND E.EFFECTIVE_LATEST_CHANGE = 'Y'