Position showing in pending approval but not able to find any pending transaction

Summary:

Hello everyone,

When we are searching for a position in My client group > work force structure > search employee. It is showing the below message.

However, when we checked transactions for this position, all transactions are in complete status.

We ran the below query

SELECT POST.*

FROM HR_ALL_POSITIONS_F_TL POST,HR_ALL_POSITIONS_F POS

WHERE POS.POSITION_CODE = 'XYZ'

AND POST.POSITION_ID = POS.POSITION_ID

The same position is present in NL language however we are not finding any transactions in NL language.

We have checked transactions from year 2000 using the date range as well.