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 MARCH 13, 2019

Applies to:

Oracle Transportation Management - Version 6.1.0 and later
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>

<transaction_set>


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


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