From MITI: We have modified the HCM query called M_BUDGET_ACTUALS so you can look for inactive positions that still have encumbrances or pre-encumbrances. We have also developed a new HCM query called M_POSITION_DATA_AND_DBT to help you identify inactive positions with active DBTs. These are now available for your use.
This is an existing query that was updated. It lists encumbrances and pre-encumbrances by employee/position. This update allows you to use the M_BUDGET_ACTUALS query to find inactive positions with encumbrances or pre-encumbrances in HCM.
The existing M_BUDGET_ACTUALS query was updated as follows:
This is a new query. Use this query to identify inactive positions with active DBTs (Department Budget Table). It lists positions and their DBT including the status of the position as well as the DBT. Filter the data in Excel to identify inactive positions with active DBT, and vice versa.