Export DB.XML via Business Process Automation > Data Export > DB.XML Export errors with an XML error.
(Doc ID 1061853.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Transportation Management - Version 6.1.0 and laterInformation 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>
- <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>
- <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 |