6 Replies Latest reply: Jan 3, 2013 11:19 PM by prAshANT17 RSS

    Need Bug Information

    prAshANT17
      Hi all,

      Does anybody know more about............. bug 13966114-presentation variable lost in 2nd level report navigation


      thanks in advance
        • 1. Re: Need Bug Information
          Srini VEERAVALLI
          This got fixed in 11.1.1.6.5 and 11.1.1.6.6 Patch Sets.

          what you are expecting?

          If helps pls mark
          • 2. Re: Need Bug Information
            prAshANT17
            what you are expecting?

            I knw that but i want more information about his bug..
            Why this happens and when in previous versions


            thanks

            Edited by: prAshANT17 on Jan 3, 2013 2:27 PM
            • 3. Re: Need Bug Information
              Srini VEERAVALLI
              The bug content is available at
              http://obi9.blogspot.com/2013/01/bug13966114.html

              If helps pls mark as correct
              • 4. Re: Need Bug Information
                prAshANT17
                Please suggest if found any other info
                • 5. Re: Need Bug Information
                  SunilSharma
                  Bug 13966114 : RUP3ST5CDRM: PRESENTATION VARIABLE IS LOST IN 2ND LEVEL REPORT NAVIGATION

                  Abstract: RUP3ST5CDRM: PRESENTATION VARIABLE IS LOST IN 2ND LEVEL REPORT NAVIGATION

                  *** 04/16/12 07:01 am ***
                  -----------------------------------------------------
                  n/a

                  What were you trying to do?
                  ---------------------------
                  trying to drill down from child report.

                  What should have happened?
                  --------------------------
                  no error should be raised.

                  What actually did happen?
                  -------------------------
                  the presentation variable lost its context at 2nd level of drill down

                  What are the symptoms of the problem?
                  -------------------------------------
                  error

                  What changes have been made to the technical environment recently?
                  ------------------------------------------------------------------
                  latest build

                  Generic/Port-specific findings:
                  -------------------------------
                  generic

                  Did you test with the latest version?
                  -------------------------------------
                  yes

                  Reproducible Case
                  -----------------
                  http://slcac705.us.oracle.com:10217/analytics

                  finuser1/Welcome1


                  Navigator->Tools->Reports and Analytics->shared Folders->Financials->General
                  Ledger->Account Analysis->Account Analysis Report->View

                  select 'Vision Operations (USA)' for ledger and tab out. It will default
                  values for account and period.
                  then select currency type as ;Total' and account
                  '01-000-1210-0000-000;01-000-2210-0000-000' and accounting period 'Oct-10'
                  and ledger currency as 'USD'
                  and click on apply.
                  then click on any amount in period net activity and journals details.
                  it will open the drill down. then click on any value in journal batch name
                  and you will see the following error:

                  Error
                  View Display Error
                  Error generating view. Error getting cursor in GenerateHead
                  Error Details
                  Error Codes: OAMP2OPY:E7JI73LX
                  A numeric value was expected (received "SELECT "Account"."General Ledger Code
                  Combination Identifier" FROM "General Ledger - Transactional Balances Real
                  Time" where ("Ledger"."Ledger Name" = '@{p_ledger}' or '@{p_ledger}{$$$}'=
                  '$$$') and "Account"."Concatenated Segments" = '@{p_account}'").
                  Return - Edit - Refresh


                  Select the values as uploaded in screenshot

                  Testcase Location and Restore Instructions
                  ------------------------------------------
                  as above

                  Workarounds (if any):
                  ---------------------

                  Related Bugs
                  ------------

                  24 Hour Contact Information For P1 Bugs:
                  ----------------------------------------

                  Impact Date
                  -----------

                  Additional Information (if any):
                  --------------------------------

                  *** 04/16/12 07:02 am ***
                  *** 04/16/12 07:03 am ***
                  *** 04/16/12 07:04 am ***
                  *** 04/16/12 07:04 am ***
                  *** 04/16/12 07:05 am ***
                  *** 04/16/12 11:08 am ***
                  *** 04/16/12 11:09 am ***
                  *** 04/16/12 11:14 pm *** (CHG: Sta->30)
                  *** 04/16/12 11:14 pm ***
                  *** 04/16/12 11:15 pm ***
                  *** 04/17/12 12:17 am *** (CHG: Sta->11)
                  *** 04/17/12 12:17 am ***
                  yes this is a 2nd navigation, but 1st and 2nd drill uses the same filter
                  variables.
                  (1) this was working fine in earlier build rup3 st3 before friday's patch4fa
                  application.

                  patch details.

                  oracle_common     
                  ps5rc4/oracle_common/generic/SOACOMMON_RUP3B7_13893692.zip
                  ps5rc4/oracle_common/generic/JDEVADF_RUP3MLR4.2RT_13899639.zip

                  BI/Generic     
                  ps5rc4/biappsshiphome/generic/atglite_RUP3MLR4.2_13885216.zip
                  ps5rc4/biappsshiphome/generic/RTD_11_1_1_6_2_GENERIC_120327_1635_13887566.zip
                  ps5rc4/biappsshiphome/generic/atglite_rup3mlr4.2_13905542.zip --Skipped
                  post steps per Aman in bug13952733
                  ps5rc4/biappsshiphome/generic/fscore_ps5rc4rup3b4_13894878.zip
                  ps5rc4/biappsshiphome/generic/fsmlite_rup3_13791429.zip
                  ps5rc4/biappsshiphome/generic/BIINST_11_1_1_6_2_GENERIC_120405_1901_13932572.z
                  ip
                  ps5rc4/biappsshiphome/generic/BIADFCOMPS_11_1_1_6_2_GENERIC_120328_1800_138929
                  34.zip
                  ps5rc4/biappsshiphome/generic/BIPUBLISHER_11_1_1_6_2_GENERIC_120403_1800_13884
                  765.zip

                  BI/Linux64     
                  ps5rc4/biappsshiphome/linux64/BIFNDN_11_1_1_6_2_LINUX_X64_120403_2100_13884769
                  .zip
                  ps5rc4/biappsshiphome/linux64/BIFNDNEPM_11_1_1_6_2_LINUX_X64_120330_0115_13884
                  779.zip

                  SOA     
                  ps5rc4/soa/generic/SOA_RUP3B7_13893692.zip

                  ATGPF/Generic     
                  ps5rc4/atgpf/generic/atgpf_RUP3MLR4.2_13885215.zip
                  ps5rc4/atgpf/generic/fscore_ps5rc4rup3b4_13894878.zip
                  ps5rc4/atgpf/generic/idmfat2p_rup3_op2_13875522.zip

                  ATGPF/Database     
                  ps5rc4/atgpf/database/incremental_upgrade/atgpf/atgpf_rup3mlr4.2_incremental_u
                  pgrade_13740689.zip

                  ODI     
                  ps5rc4/odi/generic/odi_blrrup3_13684592.zip

                  ECM_BUKET2     
                  ps5rc4/ecm_bucket2/generic/IPM_RUP3PS5RC4P3_13913127.zip
                  ps5rc4/ecm_bucket2/generic/atgpf_ucm_RUP3MLR4.2_13885217.zip

                  IDM     
                  ps5rc4/idm/generic/oam_rup3_op2_13901417.zip

                  (2) I have moved the entire report contents onto my folders under Bug
                  13966114 directory.
                  • 6. Re: Need Bug Information
                    prAshANT17
                    Hi Srini,

                    The link u gave is not available now... How can i see again.


                    Thanks,
                    Prashant