My Oracle Support Banner

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:

Oracle Application Access Controls Governor - Version 8.6.5 and later
Information in this document applies to any platform.


- Problem Statement:
On : In Application Access Controls Governor (AACG)GRC- 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:

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(
at com.sunopsis.repository.manager.DDLSessionExecutor.executeDDL(
at com.sunopsis.repository.manager.RepositoryManager.executeXmlAbsoluteFile(
at com.sunopsis.repository.manager.RepositoryManager.designerRepositoryCreation(
... 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.

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


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

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