ODI Error: Create view on source (LKM BIAPPS SQL to Oracle (Multi Transport))

Question

Hi,

I have moved one mapping from UAT to SIT environment in ODI.

I regenerated the scenario and run the scenario.

The mapping is failed for below error.

I have done the normal export not the Smart export.

Kindly suggest,

Thanks,

Lalit

LCDavis-Oracle · Accepted Answer

Hello Lalit.

Thank you for asking your question in the Oracle Analytics Community. This question requires additional customer specific context and detailed analysis. Please open a Service Request for the OBIA product through My Oracle Support so we can better assist you.

In the SR, please ensure the ODI logs as suggested:

Note 1991621.1 - SRDC: Collecting Diagnostic Information for an OBIA ETL Issue

Best Regards.