Data Mart Job of 'Oracle Export' Type Generates 'EXP-00011: ZZ_CDR_SI_<ID>.<TABLE_NAME> does not exist' (Doc ID 1451447.1)

Last updated on DECEMBER 28, 2016

Applies to:

Oracle Life Sciences Data Hub - Version 2.2 and later
Information in this document applies to any platform.

Symptoms

On LSH 2.2.0.2 version, when attempting to use the Oracle Export service from a Data Mart, the following error occurs:

ERROR ----------------------- EXP-00011: ZZ_CDR_SI_20002.DATETIMEFMTCHK does not exist

Oracle Export service is defined on both Apps and DB service locations.

Oracle Data Mart Job doesn't export data when the job goes to Database DP server, but exports data when the job goes to Apps DP Server.

Job status shows 'Success' for both the jobs. The only difference between the Database and App server DP servers is Oracle DB version on App server is 10.1.0.5.0 and on DB server is 11.2.0.2.0.

 

STEPS

-----------------------

The issue can be reproduced with the following steps:

1. Submit a Data Mart of type 'Oracle Export' job.

2. When the job goes to DB DP Server:

2.1 Job completes with job status ‘Success’

2.2 Job log file contains the following error:

      EXP-00011: ZZ_CDR_SI_20002.DATETIMEFMTCHK does not exist

2.3 Oracle DB version is 11.2.0.2.0

3. When the job goes to App DP Server:

3.1 Job completes with job status ‘Success’

3.2 Job log doesn’t contain any error. It contains the following message to confirm the data export:

      . . exporting table DATETIMEFMTCHK 9 rows exported

3.3 Oracle DB version is 10.1.0.5.0

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