My Oracle Support Banner

In ASCP Planning module, ODS job fails with ORA-38802: Edition Does Not Exist (Doc ID 2679440.1)

Last updated on JUNE 13, 2020

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2 version, RDBMS attempting to run a  ASCP Planning ODS run failing due to this error

"ORA-38802: edition does not exist"




The following can be found in fnd_log messages

12-MAY 07:03:00 : tbl_count : 21 . Extending temp PL/SQL tables
12-MAY 07:03:00 : Variable tbl_count : 22
12-MAY 07:03:00 : Truncating v_partTblList and v_tempTblList
12-MAY 07:03:00 : Copying v_partTblList and v_tempTblList, from temp tables
12-MAY 07:03:00 : Table count now is: 22
12-MAY 07:03:00 : Initialized
12-MAY 07:03:00 : <>
12-MAY 07:03:00 : ORA-38802: edition does not exist                           <<<<
12-MAY 07:03:00 : Create_Temp_Tbl failed
12-MAY 07:03:00 : ORA-0000: normal, successful completion
+---------------------------------------------------------------------------+
End of log messages from FND_FILE

Changes

 DBA had created a custom edition manually in the EBS database

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.