Analytics Software

Hello, one and all.

I have recently upgraded from 11i to r12 Oracle financial application server, after much patching and testing we finally came to the Discoverer application server.

Most workbooks open fine, however it seems that some of them (about 3%) reference columns that no longer exist in r12, for example, SET_Of_BOOKS_ID has become LEDGER_ID in r12 on the gl.gl_je_lines table.

This causes any workbook that references that business area to return an error 'Database Error - ORA-00904: " O974567"."SET_OF_BOOKS_ID": invalid identifier.

Well and good; I think that that's caused by the EUL not being refreshed after the upgrade, so I go to the Discoverer administrator and refresh the general ledger Business area. This unfortunately renames several objects inside the business area, including SET_OF_BOOKS_ID to LEDGER_ID, so instead of that error, we now get several 'Missing item or condition' errors until the workbook will not open at all with an 'Item dependency "" not found in the EUL.' error. This i assume is because the workbooks still reference the old items.

I'm guessing that several Business areas and objects therein have been renamed since nearly none of the workbooks will open now. I have restored the EUL from a backup (imported all the *.eex files) however I was wondering if anyone had faced this issue.

I apologize as I have very little understanding of Discoverer and this might be a simple fix, but I'm at this point willing to try anything for help.

Thanks!