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.

Symptoms

Problem Statement
OE_TRANSACTION_TYPES_V becomes invalid due to ORA-01445

Error
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

Cause

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
Symptoms
Cause
Solution


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