This discussion is archived
9 Replies Latest reply: Nov 9, 2012 1:33 PM by RodWest RSS

BIB-10310 An unknown exception occurred

794864 Newbie
Currently Being Moderated
Hi All,

We are using discoverer with our oracle apps environment and we have recently updgraded to 12.1.3 from 11i (Oracle Apps version).

After our recent upgrade, we get the following error in many reports:

Unable to open the worksheet requested.
- OracleBI Discoverer was unable to find the worksheet that was requested.
- BIB-10310 An unknown exception occurred.
- Person Assignment (base).Person Id

We debugged and found that in many discoverer folders, some properties' visible property has been reset to No after upgrade which was causing the above error.
For e.g. in the above error,the Person Id attribute's Visible property was set to No in " Person Assignment (base)" folder. (This was Yes before we applied the upgrade patches)

Now my question is, how can we find out how many such attribute's values are changed? Can someone tell me the table name where these details are stored so that I can compare the data between our old and new system?

Regards,
Pradeep
  • 1. Re: BIB-10310 An unknown exception occurred
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    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 ?

    HTH
    Srini
  • 2. Re: BIB-10310 An unknown exception occurred
    RodWest Guru
    Currently Being Moderated
    Hi,

    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.
    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'
    If you re-imported the eBS business areas then the visibility would be reset to the default value.
    Rod West
  • 3. Re: BIB-10310 An unknown exception occurred
    794864 Newbie
    Currently Being Moderated
    Hi Guys,

    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.

    Regards,
    Pradeep
  • 4. Re: BIB-10310 An unknown exception occurred
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    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]

    HTH
    Srini
  • 5. Re: BIB-10310 An unknown exception occurred
    user13847399 Newbie
    Currently Being Moderated
    Hi,

    We are also facing the same issue.

    Our Discoverer and apache are installed on differerent boxes.

    Regards
  • 6. Re: BIB-10310 An unknown exception occurred
    794864 Newbie
    Currently Being Moderated
    Hi Srini,

    The discoverer and EBS are installed on different servers. Any thoughts?
  • 7. Re: BIB-10310 An unknown exception occurred
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    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]

    HTH
    Srini
  • 8. Re: BIB-10310 An unknown exception occurred
    794864 Newbie
    Currently Being Moderated
    Hi All,

    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.
  • 9. Re: BIB-10310 An unknown exception occurred
    RodWest Guru
    Currently Being Moderated
    Hi,
    what does exp_type in the expressions table denote
    CI = Hierarchy
    CO = Database column or calculation
    FIL = Filter
    JP = Join Predicate

    Not sure about PAR, it's not in my notes.

    Rod West

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points