Technology Stack - EBS (MOSC)

MOSC Banner

How to force move or force delete or recreate an object that won't move from an old db edition ?

edited Oct 4, 2023 3:16PM in Technology Stack - EBS (MOSC) 4 commentsAnswered

Oracle EBS 12.2.10

Database 19.14

We have those 2 trailing objects(views) stuck in the ORA$BASE edition (OC_CUSTOMERS,OC_CORPORATE_CUSTOMERS)

When trying to CREATE OR REPLACE FORCE EDITIONABLE VIEW....

ORA-04020: deadlock detected while trying to lock object 30x700010076C5C0580x700010076563C200x70001009C686CF8

ORA-21700: l'objet n'existe pas ou va être supprimé

04020. 00000 - "deadlock detected while trying to lock object %s%s%s%s%s"

*Cause:  While trying to lock a library object, a deadlock is detected.

*Action:  Retry the operation later.

==============================================

=           Editioned Objects Per Edition

==============================================


EDITION_NAME    A_VALID A_INVALID  A_TOTAL  S_VALID S_INVALID  S_TOTAL   TOTAL

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