Were you able to solve the issue you were having?

Hi Ritesh, What's the update from your end?

I'll suggest you read up on how to deploy .war file using this link https://docs.oracle.com/cd/E27119_01/doc.11113/e23126/installationandupgradeguideprintable23.html

See this link https://docs.oracle.com/cd/E24179_01/doc.1111/e23378/deployingoia.htm#OIAIN145

Make sure that your connection is working. no available router to destination. Check the thread below. OBIEE 12C Post Installation Issue

Have you try just stopping your agent and listener? Then restart them and try to see if you'll get email after?

I believe it's best if you ask your question on Informatica forum https://network.informatica.com/thread/18677

I'll suggest your go through this MOSC DOC: OBIA 11g: Error:ODI-10182: Uncategorized Exception During Repository Access. ORA-00001: Unique Constraint (Doc ID 2016069.1)

This thread might help;

Check to make sure that apps.OPI_OBIA_BOMPEXPL_WRAPPER_P.TRUNCATE_W_BOM_HEADER_DS('OPI') exists. Error: MESSAGE:::ORA-06576: not a valid function or procedure name

I'll suggest you read this article for some insight. http://www.ateam-oracle.com/how-to-understand-and-diagnose-odi-connectivity-issues/

You said you used: I suspect it is because of my earlier parameter "localhost" which I had given during RCU process of OBIA. It's possible that that's the cause of your issue. Did you change it from something else?