My Oracle Support Banner

R12.2: PA: 12.2.7適用時にORA-00001: Unique Constraint Violated (PA.PA_PROJECT_STATUSES_U2)でエラーが発生する (Doc ID 2391999.1)

Last updated on APRIL 27, 2018

適用範囲:

Oracle Project Foundation - バージョン 12.2.7 以降
この文書の内容はすべてのプラットフォームに適用されます。

現象

12.2.7 へのアップグレードパッチ適用時の問題:

12.2.7 へのアップグレードパッチを適用すると、ワーカー内で次のエラーが発生します。 ORA-00001: unique constraint (PA.PA_PROJECT_STATUSES_U2) violated

Dumped the batch (PA_PROJECT_STATUSES APPROVED PROJECT , PA_PROJECT_STATUSES 1000 OPEN_ASGMT ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Uploading seed data for PA_PROJECT_STATUSES: PROJECT_STATUS_CODE = 1000, STATUS_TYPE = OPEN_ASGMT, Translatable column PROJECT_STATUS_NAME value changed to Possible(1)
  Uploading seed data for PA_PROJECT_STATUSES: PROJECT_STATUS_CODE = 1000, STATUS_TYPE = OPEN_ASGMT, Translatable column DESCRIPTION value changed to Possible Requirement(1)
  Uploading seed data for PA_PROJECT_STATUSES: PROJECT_STATUS_CODE = 1000, STATUS_TYPE = OPEN_ASGMT, Translatable column PROJECT_STATUS_NAME value changed to Possible(2)
  Uploading seed data for PA_PROJECT_STATUSES: PROJECT_STATUS_CODE = 1000, STATUS_TYPE = OPEN_ASGMT, Translatable column DESCRIPTION value changed to Possible Requirement(2)
  Uploading seed data for PA_PROJECT_STATUSES: PROJECT_STATUS_CODE = 1000, STATUS_TYPE = OPEN_ASGMT, Translatable column PROJECT_STATUS_NAME value changed to Possible(3)
  Uploading seed data for PA_PROJECT_STATUSES: PROJECT_STATUS_CODE = 1000, STATUS_TYPE = OPEN_ASGMT, Translatable column DESCRIPTION value changed to Possible Requirement(3)
  Error loading seed data for PA_PROJECT_STATUSES: PROJECT_STATUS_CODE = 1000, STATUS_TYPE = OPEN_ASGMT, ORA-00001: unique constraint (PA.PA_PROJECT_STATUSES_U2) violated
ORA-01403: no data found
 

変更点

 

原因

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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