Re: failed when upgrade from 12.2.8 to 12.2.9

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/failed-when-upgrade-from-12-2-8-to-12-2-9-tp8797p8810.html

I think, there is a seed data problem.
Maybe you skip some of the patches, during EBS 12.2.7 upgrade.
Please check the section named "Section 5: Apply Consolidated Seed Table Upgrade Patch (Required)" in "Oracle E-Business Suite Release 12.2.7 Readme (Doc ID 2230783.1)" and ensure that you applied the patches that need to be applied. Also ensure that you did all the post installation tasks of those patches. (if there are some post install tasks for them ofcourse)

Gathered info from the log files:

  Error loading seed data for DESC_FLEX:  APPLICATION_SHORT_NAME = CSD, DESCRIPTIVE_FLEXFIELD_NAME = CSD_DC_DOMAINS,  ORA-20001: Synonym does not point to a seed data table: FND_COMPILED_DESCRIPTIVE_FLEXS
  Error loading seed data for DESC_FLEX:  APPLICATION_SHORT_NAME = CSD, DESCRIPTIVE_FLEXFIELD_NAME = CSD_DIAGNOSTIC_CODES_B,  ORA-20001: Synonym does not point to a seed data table: FND_COMPILED_DESCRIPTIVE_FLEXS

Similar error reported in the following MOS note ->

12.2 E-Business Suite FNDLOAD Command Fails for a Concurrent Program ldt with error 'ORA-20001: Synonym does not point to a seed data table: FND_COMPILED_DESCRIPTIVE_FLEXS' (Doc ID 2162023.1)