You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Descriptive flexfield saved data is not appearing on UI

Received Response


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'

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!