2 Replies Latest reply: Jun 1, 2011 8:58 PM by user5312418 RSS

    Reports in Spanish Language

    697761
      Hi All,

      I am trying to generate a report after logging in as a user whose languages is defaulted to Spanish,
      I am able to run all the reports expect the ones that are based on "Opportunity Product Revenue".I have a few reports both real time and historical which are based on "Opportunity Product Revenue", I get the below error when I run these reports .. has anybody come across this issue ?


      Error de visualización de vista
      Odbc ha devuelto un error (SQLExecDirectW).
      Impactos del error
      Códigos de error: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
      Estado: HY000. Código: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27005] Unresolved column: "Opportunity - Product"."DATE_25". (HY000)
      Instrucción SQL emitida: {call NQSGetQueryColumnInfo('SELECT "- Custom Number/Integer (Product)".INDEXED_NUM_0, "- Product Revenue"."Product Revenue", "- Quantity"."Total Quantity", "Opportunity - Product".DATE_25, "Opportunity - Product".INDEXED_PICK_1, Account."Account Name", CAST("Opportunity - Product"."Last Modified" AS DATE), CAST("Opportunity - Product".Created AS DATE), Employee."Business Unit Level 1", Employee."Business Unit Level 2", Opportunity."Close Date", Opportunity."Current Sales Stage", Opportunity."Opportunity Currency", Opportunity."Opportunity ID", Opportunity."Opportunity Name", Opportunity."Opportunity Revenue", Opportunity."Opportunity Status", Opportunity."Probability %", Opportunity."Source Campaign", Opportunity.DATE_29, Opportunity.INDEXED_PICK_0, Opportunity.INDEXED_PICK_1, Opportunity.INDEXED_SHORTTEXT_0, Opportunity.Owner, Opportunity.PICK_3, Product."Product Name", Product.TEXT_1, Product.TEXT_30, Product.TEXT_31 FROM "Opportunity-Product Analysis"')}

      Instrucción SQL emitida: SELECT "- Custom Number/Integer (Product)".INDEXED_NUM_0, "- Product Revenue"."Product Revenue", "- Quantity"."Total Quantity", "Opportunity - Product".DATE_25, "Opportunity - Product".INDEXED_PICK_1, Account."Account Name", CAST("Opportunity - Product"."Last Modified" AS DATE), CAST("Opportunity - Product".Created AS DATE), Employee."Business Unit Level 1", Employee."Business Unit Level 2", Opportunity."Close Date", Opportunity."Current Sales Stage", Opportunity."Opportunity Currency", Opportunity."Opportunity ID", Opportunity."Opportunity Name", Opportunity."Opportunity Revenue", Opportunity."Opportunity Status", Opportunity."Probability %", Opportunity."Source Campaign", Opportunity.DATE_29, Opportunity.INDEXED_PICK_0, Opportunity.INDEXED_PICK_1, Opportunity.INDEXED_SHORTTEXT_0, Opportunity.Owner, Opportunity.PICK_3, Product."Product Name", Product.TEXT_1, Product.TEXT_30, Product.TEXT_31 FROM "Opportunity-Product Analysis"

      Actualizar

      Pls contact me if you have come across this issue before or if you have resolved this error ?

      Satish Kumar
      satish_kumar03@infosys.com
      +1 812 341 1402
        • 1. Re: Reports in Spanish Language
          cblocklin
          Hi Satish,

          I was just wondering if you found a resolution to this? We just ran into the same error. It's just like your problem - the error is occuring on a custom field when the user's language is German.

          Thanks,
          Craig
          • 2. Re: Reports in Spanish Language
            user5312418
            Hello!

            I opened a TAR for this and Oracle's first suggestion was to verify that a translated value is assigned to the field name in the target language. That solved the issue for some of my reports, but I'm encountering a similar error for other reports and the same fix has not worked. I have a separate TAR open and will post the findings.

            Thanks!
            Meredith