Hello,
I have two pages, one with an Interactive Report and the other a Form. Clicking the Edit button beside any report item links to the Form page, where I'd like to be able to edit the item.
When I get to the form page though, most fields are blank despite being populated in the table. I've got the target Set Items for the 3 primary keys of the table (in apex), but not the rest of the fields. This is how it was done in another app I assisted on but did not build myself, so I assume this is the correct way to do it. If I add literally every field to the Set Items section, they are populated but I'm getting a data not found error, so it doesn't seem like its identifying the row I'm trying to update at all.
One thing to note - the actual primary key (not the 3 I set in APEX) is a unique ID field that is populated from the DB side upon item creation. If I try to add this field to APEX in any capacity though, I get an "ORA-32795: cannot insert into a generated always identity column" error, even if the item is hidden and not being submitted. If I could get this into APEX I assume some of my problems might be solved.
Any help is appreciated!