My Oracle Support Banner

12.2 E-Business Suite Error ORA-00904: "ZD_EDITION_NAME": invalid identifier While Applying Patch 17919161 (Doc ID 2022446.1)

Last updated on FEBRUARY 17, 2023

Applies to:

Oracle Workflow - Version 12.2 and later
Oracle Applications DBA - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.2 Applications DBA, Upgrade related issues

 

 

 

 

 

 

On Oracle Applications error while upgrading to 12.2.4 and applying patch 17919161:

Start time for statement above is Thu Jun 11 19:09:20 EDT 2015
End time for statement above is Thu Jun 11 19:09:20 EDT 2015
Error in executing statement ALTER TABLE APPLSYS.WF_WL_LIST_CRITERIA ADD CONSTRAINT "WF_WL_LIST_CRITERIA_PK" PRIMARY KEY ( CRITERIA_KEY , ZD_EDITION_NAME )
Error message is ORA-00904: "ZD_EDITION_NAME": invalid identifier



The following step used to produce the issue:
1. Executing statement:
ALTER TABLE APPLSYS.WF_WL_LIST_CRITERIA ADD CONSTRAINT "WF_WL_LIST_CRITERIA_PK" PRIMARY KEY ( CRITERIA_KEY , ZD_EDITION_NAME )

Changes

 Applying patch 17919161.

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
Changes
Cause
Solution
References


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