P2T Refresh – Requisitions Visible in UI but IRC_REQUISITIONS_VL Table is Empty
Actual Behavior:
Following the recent P2T refresh completed last weekend, we observed that the IRC_REQUISITIONS_VL
table is currently empty. However, requisitions are still visible in the UI across various stages (e.g., Draft, Open, Filled).
Expected Behavior:
No requisitions should be visible in the UI, as all transactional data was expected to be purged during the P2T refresh.
Steps to Reproduce:
Please provide the navigation steps where requisitions are visible in your environment. In our case, we observed them via:
- Navigate to My Client Groups > Hiring > Requisitions
- Filter by status (e.g., Open, Draft)
- Requisitions are displayed despite the table being empty in BI/SQL
0