I know similar questions have been asked and answered many times, but I am unable to find a solution that works for me.
I am working in APEX 20.1
We have table API's on all tables for insert/update/delete. In APEX I have a pretty basic Interactive Grid based on a table with 5 columns. For processing I am using Interactive Grid - Automatic Row Processing - Target Type PL/SQL Code.
In the PL/SQL code I set up the record to be passed to the table api to be processed. Once the record is set up it is passed to the table correct package to process this record. The package returns an error if there are any validations or other issues during the processing. This seems to be working correctly, the message is displayed when there are errors.
The issue comes in when a new record is inserted, the record is inserted correctly into the table and all is good. The problem is when the processing comes back, the success message is displayed correctly, but the grid does not refresh.
From the research I have done it appears that for the insert you need to have a "returning into" to set the value for the returning primary key which then causes the refresh (I think). I changed the process to do a straight insert with a returning into clause (instead of calling the package) and the page refreshed as expected.
Is there a way after the package has completed with success to set the primary key similar to what the "returning into" does so the grid will refresh.
Any suggestions for how to solve this would be appreciated.
Thanks
Tillie