Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Descriptive flexfield saved data is not appearing on UI
Summary:
Position descriptive flexfield value has been saved in HR_ALL_POSITIONS_F table but not appearing on UI.
Content (required):
Have created a Position Descriptive flexfield of type number. which is a list of value. Value set is based on below query
select hapf.ATTRIBUTE_NUMBER1 + 1
from HR_ALL_POSITIONS_F hapf where
TRUNC (SYSDATE) BETWEEN hapf.effective_start_date AND hapf.effective_end_date AND hapf.ACTIVE_STATUS = 'A'
and hapf.ATTRIBUTE_NUMBER1 = (select max(hapf1.ATTRIBUTE_NUMBER1) from HR_ALL_POSITIONS_F hapf1 where TRUNC (SYSDATE) BETWEEN NVL ( hapf1.effective_start_date, SYSDATE) AND NVL ( hapf1.effective_end_date, SYSDATE) AND hapf1.ACTIVE_STATUS = 'A'
Tagged:
1