Project Accruals Stuck in Interface Table
Hi All-
After month-end close, we upload project accruals via WebADI and we've never had any major issues with the upload process until now. Our user uploaded just under 200 rows from a spreadsheet and she received the little green smiley confirmation. Normally when that process finishes, she can see the transactions in Expenditure Inquiry or, if there are errors, they appear in the Review Transactions form.
This month, although she received the green smileys, the transactions aren't showing up in either Expenditure Inquiry or Review Transactions. I looked in PA_TRANSACTION_INTERFACE_ALL and sure enough, they're all in there. When I query select * from PA_TRANSACTION_INTERFACE_ALL where ACCRUAL FLAG = 'Y', I can see them all.