My Oracle Support Banner

FA: SCM: SCP: Trading Partner Collections Ending in Error for Target Collection ORA-00001 ORA-06512 (Doc ID 2629957.1)

Last updated on AUGUST 27, 2020

Applies to:

Oracle Fusion Planning Central Cloud Service - Version 11.13.19.10.0 and later
Information in this document applies to any platform.

Symptoms

Load Entity job ended in below error for Trading Partner Collections

JobDefinition://oracle/apps/ess/scm/advancedPlanning/collection/configuration/LoadEntity

ERROR
-----------------------
SUPPLIER_SITES : ORA-00001: unique constraint (FUSION.MSC_LOC_ASSOCIATIONS_U1) violated

STEPS
-----------------------

The issue can be reproduced at will with the following steps:

  1. Navigate to Plan Inputs > Collections
  2. Run collections for Supplier entities.

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
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.