My Oracle Support Banner

OE_TRANSACTION_TYPES_V Becomes Invalid Due to Ora-01445 (Doc ID 2617652.1)

Last updated on DECEMBER 10, 2019

Applies to:

Oracle Order Management - Version 12.2.8 and later
Information in this document applies to any platform.


Problem Statement
OE_TRANSACTION_TYPES_V becomes invalid due to ORA-01445

ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table

Steps to Reproduce

  1. This issue happens during upgrading from 11.5.10 to 12.2.8
  2. Adadmin step


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.