Hi All,
Another confusing one for you all, hoping someone has an idea….
I have an interactive grid that gets populated once the user selects from a LOV on the page.
This all works fine, they make the selection and the grid populates (PL/SQL populates the table under the grid and then the grid is refreshed).
The issue is coming on the save of this grid. If the user updates something that is in the grid and saves we're all good, but when they add a row, my PLSQL that processes the table to send the data to the API endpoint isn't seeing the new data that was saved.
The “save” button is calling javascrip that will invokes the save on the region/widget, and then the plsql block is fired:
“New” is the standard interactive grid save
callAPI is selecting the data from the table that the grid is based on and then building the API call. This PL/SQL Action is not seeing the data that should have been saved in the prior step. The sequences are correct, but I seem to be missing something.
Thanks!
Andrew