My Oracle Support Banner

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

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
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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