Apex 20.2
have to Schemas A01, A02.
A02 has all actual tables and other objects and A01 has Views with all permissions.
my workspace has schema A01.
created a Master-Detail (Drill Down) on a View
it inserts my test data, showing on IR ( first page ), but when trying to Edit this row it is showing error " ora_sqlerrm: ORA-01403: no data found ORA-06512: at ", i checked with SQL Command window, i queried max(empno) it is showing 10245 and IR shows my last entered row with empno 10246? is it showing from within session, cache etc. so, where is that row goes when it showed me Record saved message.
what i am doing wrong or missing? this is my first attempt to create page on a View which is based on a table in another schema but with all privileges.
please help.
regards
