"unknown Token: <XML SCHEMA NAME>" or "user lacks privilege or object not found: <TABLE NAME>" Received in ODI 12c when Unique Names Mechanism is Used with XML
(Doc ID 2709742.1)
Last updated on SEPTEMBER 11, 2020
Applies to:Oracle Data Integrator - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
The following error is encountered intermittently when executing an Oracle Data Integrator (ODI) 12c Mapping that uses the Unique Names mechanism, and writes data to XML:
In the ODI Studio > Topology > definition of XML Technology > "Advanced" tab, set the "Maximum Table Name Length" to any value.
Execute the Mapping, and observe that the execution succeeds without any error message.
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