This content has been marked as final. Show 9 replies
Pl post details of OS, database and Discoverer versions
The EBS upgrade process does not touch or change Discoverer objects - as part of this upgrade, did you also upgrade Discoverer ? What was your Discoverer configuration before the upgrade, and what is it now ?
Hi,1 person found this helpful
The folder items are stored in the eul5_expressions table and so the following query will show you the visiblity of all the person_id items in the EUL.
If you re-imported the eBS business areas then the visibility would be reset to the default value.
select eo.obj_name folder_name, ex.exp_name item_name, ex.it_hidden visible from eul5_expressions ex , eul5_objs eo where ex.it_obj_id = eo.obj_id and ex.exp_type = 'CO' and ex.exp_name = 'Person Id'
We got a new test instance and noticed the following:
1. Upgraded Oracle Apps 11i instance to R12
2. Tested the discoverer reports and did not see any issue
3. Upgraded Discoverer version from 10g to 11g
4. Tested the same discoverer report and got the above error (BIB - 10310...)
So now I understand that the issue is because of discoverer upgrade. But could you please suggest me how to progress on this? I'm not sure how many such attributes' properties are affected by this.
Is Discoverer installed on the same server as EBS ? If so, this MOS Doc may be relevant
Opening Workbook In Discoverer 10g/11g Viewer Fails with Error: Unable To Open The Worksheet Requested. BIB-10310 [ID 1331330.1]
We are also facing the same issue.
Our Discoverer and apache are installed on differerent boxes.
The discoverer and EBS are installed on different servers. Any thoughts?
Have you enabled tracing to see if it can help pinpoint the issue ?
How To Create An E-Business Suite Connection Trace For Discoverer 10g / 11g Plus / Viewer [ID 370800.1]
Thanks for your help.
I had raised an SR for this issue and was discussing with them for last few weeks. Though they said that some of the properties could have been changed as part of EBS upgrade, I have not been provided with the list of such changes. When requested I was told that I can find the change by comparing eex files before and after upgrade.
As an alternative we are planning to write some scripts which picks up data from the following tables:
EUL4_US.EUL5_BAS - Business Areas
EUL4_US.eul5_objs - Folders in Business Areas
EUL4_US.eul5_ba_obj_links - Link between business areas and folders
EUL4_US.eul5_expressions - Item's under a folder
But I have a small question, what does exp_type in the expressions table denote... I was trying to google and learnt that it could be one of these :
'CI' , 'CO' , 'JP' , 'FIL' , 'PAR'
But not sure what each of them denotes? Please suggest.
what does exp_type in the expressions table denoteCI = Hierarchy
CO = Database column or calculation
FIL = Filter
JP = Join Predicate
Not sure about PAR, it's not in my notes.