ORA 1445 error on Forms
Hello,
I am developing a new form for Oracle EBS form. It has a master detail block and both blocks are based on a database views.
The view in master block is based on several tables where only one table has primary key. The view is also selecting ROWIDs.
Now, due to that , I am getting following error on the form.
ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
SO, as a remediation measures, I removed alll ROWIDs, and created a PK index in one of the table, but still the error is persistent.
I am developing a new form for Oracle EBS form. It has a master detail block and both blocks are based on a database views.
The view in master block is based on several tables where only one table has primary key. The view is also selecting ROWIDs.
Now, due to that , I am getting following error on the form.
ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
SO, as a remediation measures, I removed alll ROWIDs, and created a PK index in one of the table, but still the error is persistent.
0