Custom Objects Created On Sales Do No Appear In Manage Import Data Activities (Doc ID 2029141.1)

Last updated on AUGUST 27, 2015

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.9.2.0 version, Sales, Sales Catalog

ACTUAL BEHAVIOR
---------------
In the stage environment, after creating 3 Custom Objects under the Sales application, when going to task Manage File Import Activities, the object don't appear listed under the Object dropdown. Also ran the Generate artifacts under Sales application for Imports and Exports.

After the CRM Domain bounce, the generation of artifacts is giving error:

Error Message: ODI-10143: Error while accessing the UNKNOWN repository. Exception [EclipseLink-5006] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.OptimisticLockException Exception Description: The object [oracle.odi.domain.project.OdiPackage MOO_AttachmentCustExtnPKG] cannot be updated because it has changed or been deleted since it was last read. Class> oracle.odi.domain.project.OdiPackage Primary Key> 5,503 :Error cause: javax.persistence.OptimisticLockException: Exception [EclipseLink-5006] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.OptimisticLockException Exception Description: The object [oracle.odi.domain.project.OdiPackage MOO_AttachmentCustExtnPKG] cannot be updated because it has changed or been deleted since it was last read. Class> oracle.odi.domain.project.OdiPackage Primary Key> 5,503 ::Error message: null :Error cause: oracle.jbo.service.errors.ServiceException: oracle.odi.core.repository.ConcurrencyFailureException: ODI-10143: Error while accessing the UNKNOWN repository. Exception [EclipseLink-5006] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.OptimisticLockException Exception Description: The object [oracle.odi.domain.project.OdiPackage MOO_AttachmentCustExtnPKG] cannot be updated because it has changed or been deleted since it was last read. Class> oracle.odi.domain.project.OdiPackage Primary Key> 5,503

EXPECTED BEHAVIOR
-----------------------
The Custom Objects should appear listed under the import task.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create 3 Custom Objects under the Sales application in Application Composer.
2. Generate artifacts under Application Composer
3. Go to Setup and Maintenance task: Manage File Import Activities

Cause

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 hundreds of Community platforms