HOME / FAQ /

Financial Accounting & Reporting

What’s the difference between Pending and Running status? What does it mean when my report gets “stuck” in one of these two statuses?

  • Pending Status: The pending status is the system’s way of telling you that it has received your report request, but is currently busy processing other requests.

The reporting environment is set up so that only a certain number of reports can run simultaneously. An Oracle product called the Concurrent Manager is employed to manage the simultaneous requests. In order to conserve system resources and to make sure that users’ requests are handled in an organized, equitable manner, the HDW team has set up a set number of reports “queues...

Read more about What’s the difference between Pending and Running status? What does it mean when my report gets “stuck” in one of these two statuses?

What do I do if my reports been in pending or running status longer than expected?

If you think that your reports are in Pending status too long, or reports are taking an inordinate amount of time to run (compared to how long similar reports run during the year), take a look at the “messages” dialogue box on the Financial Reporting Support Year End home page. We will post any known issues there. If you don’t see a message indicating any known issues, feel free to call the Help Desk at 496-2001. They in turn will alert us and we can look into it for you. 

I'm converting a query from the HDWPROD view DWGL_POSTED_ACTUAL_LINES to the HDWUTS/DWCENPRD view DW_TRANSACTION_DETAILS_F_SV and I'm getting budget journals. Why would that be?

In HDWPROD, we have 3 different views for each type of journal, Actual (DWGL_POSTED_ACTUAL_LINES), Budget (DWGL_POSTED_BUDGET_LINES), and Encumbrance (DWGL_POSTED_ENCUMBRANCE_LINES), as well as one view that combines all 3 (DWGL_POSTED_JE_LINES). For this initial release of journal detail to DWCENPRD, we have only provided a single view, DW_TRANSACTION_DETAILS_F_SV, which is comparable to HDWPROD's DWGL_POSTED_JE_LINES view. To eliminate budget journals from your DW_TRANSACTION_DETAILS_F_SV query, pull in the DW_AMOUNT_TYPES_D_V dimension, join the amount_type_keys between the two...

Read more about I'm converting a query from the HDWPROD view DWGL_POSTED_ACTUAL_LINES to the HDWUTS/DWCENPRD view DW_TRANSACTION_DETAILS_F_SV and I'm getting budget journals. Why would that be?