Hello guys,
I have a table / IG where the primary key is populated via sequence in "before insert" trigger. When I want to create a new row, I get ORA-01400 that null value can't be populated to the field.
To be honest I checked with that sample application and all the settings / attributes seem to be set in the same way; ID field is marked as primary column and is hidden, process seems fine too. When I insert data manually to the table and then update/delete process is processing rows correctly.
- Type: Interactive Grid - Automatic Row Processing (DML
- (Settings) -> Target Type = Region Source
- Prevent Lost Updates, Lock Row and Return Primary Key after Insert are set to Yes
- Editable Region is my Interactive Grid Region
Apex version is 5.1
Any suggestions what I might be doing wrong?
Any help is appreciated. Thank you.