9 Replies Latest reply: Nov 9, 2012 3:33 PM by Rod West RSS

    BIB-10310 An unknown exception occurred

    794864
      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
          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
            Rod West
            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
              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
                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
                  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
                    Hi Srini,

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