Export DB.XML via Business Process Automation > Data Export > DB.XML Export errors with an XML error. (Doc ID 1061853.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.1 - Release: 6.1
Information in this document applies to any platform.

Symptoms


When attempting to export data from OTM using DB.XML Export the following error is seen:

<?xml version="1.0" encoding="utf-8" ?>
- <sql2xml>
- <TRANSACTION_SET>
- <!-- DatabaseError error: ORA-00942: table or view does not exist

-->
</TRANSACTION_SET>
</sql2xml>



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

1 - Logged onto and internal 6.1 system.

2 - Navigated to: Business Process Automation > Data Export > DB.XML Export

3 - Set the following:
Db Object Name: OB_ORDER_BASE
Where Clause: DOMAIN_NAME='LEE'

4 - Click Run

5 - The following is displayed:

<?xml version="1.0" encoding="utf-8" ?>
- <sql2xml>
- <TRANSACTION_SET>
- <!-- DatabaseError error: ORA-00942: table or view does not exist

-->
</TRANSACTION_SET>
</sql2xml>



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