Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid Table Name in ODI XML Model

2709933Jun 15 2017

Hi,

I am trying to load XML file into tables.

I have created XML topology for this, using external DB (XML_USER), and based on this topology i have created Model.

After done reverse engineer, all respective tables are loaded into Model, then created interface.

When i ran that interface i am getting "ora-00903 Invalid Table" Error in LKM source side (XML_USER).

When I was tested the XML topology connection, its looks good and tables are loaded into XML_USER, But all tables are loaded like XML_USER_<Table_Name> ( XML_USER_Book)

But from LKM its selecting table like ".<Table_Name> ( select * from .book@XML_USER), But in XML_USER schema tables are loaded like XML_USER_Book.

Could you please let me know where am i doing mistake.

pastedImage_1.png

pastedImage_2.png

pastedImage_4.png

pastedImage_6.png

pastedImage_7.png

pastedImage_8.png

Thanks in Advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2017
Added on Jun 15 2017
#business-intelligence-applications, #data-integrator, #system-management-and-integration
0 comments
268 views