Oracle Forms (MOSC)

MOSC Banner

ORA 1445 error on Forms

edited Aug 4, 2012 10:03AM in Oracle Forms (MOSC) 3 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center