When setting up a OBIEE ODI Lineage RPD you might get the following error:
ODI-50036: Error creating V_LINEAGE_HIERARCHY Table. Check the logs.
The error might fool you. It means that your (work) repository schema doesn’t have the right to create a view.
Ask your DBA to run the following script:
grant create view to snpm1;
grant create view to snpw1;
Till Next Time