This discussion is archived
2 Replies Latest reply: Feb 15, 2013 4:43 AM by GregGaszewski RSS

ODI do not see some views

GregGaszewski Newbie
Currently Being Moderated

I have particular issue (all inside Oracle 11 database):

Using user XXINT i need to reverse engineer views I have in schema APPS. I configured the physical schema and now I am facing this:

Two of views I need to reverse are called:
1. xx_tkw_dane_o_prod
2. xx_tkw_mpk_v

In SQL developer I can run querries:
select * from apps.xx_tkw_mpk_v
select * from apps.xx_tkw_dane_o_prod

And both give me results. However when I try to reverse engineer this schema I get only xx_tkw_mpk_v view (also in selective reverse engineering I see only that one).
When I create datastore for xx_tkw_dane_o_prod manualy I can View Data inside with ODI. However when I open this datastore and use Reverse Engineer nothing happens (columns are not being added).

Have anyone faced sth like that?

Best regards,


  • Correct Answers - 10 points
  • Helpful Answers - 5 points