Above mentioned Issue has been resolved. Bug 19292474 - MANUAL_FIX_STEPS:BI Apps Customization methodology

Anyone Kindly help us to fix the above issue. We are struck and unable to move from here. Thanks in Advance

We did not export/Import all three schema which is not recommended after installation. - BIACOMP - we created few missing synonym - DW - Exported all the table / sequences to Prod DW - ODI REPO - No changes made. Everything was fine.

HI, Sorry for delay in reply! The actual problem in my case was the usage of old BI Apps RCU version. We then manually imported the all objects(w/o data) using DB scripts from Test to Prod environment fixed the issue. Though the suggestions mentioned above also will be possible fix for this type of error. Thanks a lot…

Hello Wagner, Thanks a lot for your reply. As mentioned above: 1. We completed Post Installation steps. Also test connection was successful under XX_BIACM_IO schema in topology. 2. Also we checked those work_dir files once after applying patches. Though we will review again for confirmation. Examining the SQL query in…