C Patel wrote:
The collection is truncating, but why isn't P3_RECORDS_UPDATED resetting to 0? It still displays the total from a past load. I have tried adding an a refresh action to this dynamic action to refresh P3_RECORDS_UPLOADED but nothing happens. Any suggestions?
Firstly, decide what the item is called: is it P3_RECORDS_UPDATED or P3_RECORDS_UPLOADED? When that's clear, ensure that's the name used in the PL/SQL block to reset the item session state, and include it in the Page Items to Return dynamic action property to update the value in the browser.
My fault, I updated the original post to indicate P3_RECORDS_UPLOADED. I've verified that my code referenced this name as well. As you suggested, I've added it to Page Items to Return and it works! Thank you!