Datasource Synchronization Failed - ORA-38301: can not perform DDL/DML over objects in Recycle Bin (Doc ID 1943493.1)

Last updated on MAY 10, 2024

Applies to:

Symptoms

- Problem Statement:
On : In Application Access Controls Governor (AACG)GRC-8.6.5.5039 version: Access Synchronization

AACG is used to report segregation of duties(SOD) in the business applications. When attempting to run Access Synchronization process, the job errors out and the following error is displayed in the grcc.log file:

ERROR
-----------------------
ORA-38301: can not perform DDL/DML over objects in Recycle Bin

014-10-15 10:25:09,547 ERROR [Thread-86] OdiInstanceManager:690 RepositorySetupException while creating ODI Work repository
oracle.odi.setup.RepositorySetupException: java.lang.RuntimeException: Error while executing create table SNP_SESS_TASK

at com.sunopsis.dwg.xml.DwgXmlSession.execute(DwgXmlSession.java:92)
at com.sunopsis.repository.manager.DDLSessionExecutor.executeDDL(DDLSessionExecutor.java:97)
at com.sunopsis.repository.manager.RepositoryManager.executeXmlAbsoluteFile(RepositoryManager.java:689)
at com.sunopsis.repository.manager.RepositoryManager.designerRepositoryCreation(RepositoryManager.java:650)
at oracle.odi.setup.support.WorkRepositorySetupImpl$1.doAction(WorkRepositorySetupImpl.java:264)
... 11 more
Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-38301: can not perform DDL/DML over objects in Recycle Bin

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Log-in to the application and click on Navigator > Administration and setup
2. Select a datasource and click on Administration > Data Administration > Synchronize > Run now > Access
3. Initiate the synchronization process by responding "OK" to the pop up message.
4. See that the job fails within minutes.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot load Oracle EBS data into AACG.

Cause

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