8 Replies Latest reply on Jan 16, 2017 2:51 PM by Srini Chavali-Oracle

    Problem viewing watermark in arabic in oracle EBS

    Mussa

      I am using oracle R12.1.3 , database 11.2.0.3 G

       

       

      On my server, there are two languages set to select when login in the system:

      1- English.

      2- Arabic.

       

      When selecting "English" while logging in , I have no issue viewing output  with watermark.

      However, when I select "Arabic" while logging in  , I see no watermark when viewing the output.

       

      Any idea how to investigate this so I can sort it out?

       

       

      Here is the output of my apps.xdo.lobs  table.

       

       

       

       

      select * from xdo_lobs where file_name like 'XXRIC_HXC_DETAILED_TRS_C%';
      

       

       

       

      DATA_TEMPLATEHXCXXRIC_HXC_DETAILED_TRS_C0000XXRIC_HXC_DETAILED_TRS_C.xmlXML-DATA-TEMPLATEEtext/xml(HUGEBLOB)298628/12/15 11:35:06 AM298628/12/15 11:35:06 AM4032981
      XML_SAMPLEHXCXXRIC_HXC_DETAILED_TRS_C0000XXRIC_HXC_DETAILED_TRS_C.xmlXMLEtext/xml(HUGEBLOB)298628/12/15 11:35:14 AM298628/12/15 11:35:14 AM4032981
      TEMPLATE_SOURCEHXCXXRIC_HXC_DETAILED_TRS_Car00XXRIC_HXC_DETAILED_TRS_C_AR.rtfRTFEapplication/rtf(HUGEBLOB)298628/12/15 11:42:42 AM298628/12/15 11:42:42 AM4032981
      TEMPLATEHXCXXRIC_HXC_DETAILED_TRS_Car00XXRIC_HXC_DETAILED_TRS_C_AR.xslXSL-FOEtext/xml(HUGEBLOB)RTF2XSLParser 5.6.3298628/12/15 11:42:44 AM298628/12/15 11:42:44 AM4032981
      TEMPLATE_SOURCEHXCXXRIC_HXC_DETAILED_TRS_Cen00XXRIC_HXC_DETAILED_TRS_C_US.rtfRTFEapplication/rtf(HUGEBLOB)298628/12/15 11:46:15 AM298628/12/15 11:46:15 AM4032981
      TEMPLATEHXCXXRIC_HXC_DETAILED_TRS_Cen00XXRIC_HXC_DETAILED_TRS_C_US.xslXSL-FOEtext/xml(HUGEBLOB)RTF2XSLParser 5.6.3298628/12/15 11:46:15 AM298628/12/15 11:46:15 AM4032981
        • 1. Re: Problem viewing watermark in arabic in oracle EBS
          Srini Chavali-Oracle

          I assume you are referring to a XML Publisher custom report ? If so, do both language RTF files have the watermark ?

          • 2. Re: Problem viewing watermark in arabic in oracle EBS
            Mussa

            Yes, both language have RTF files watermark

            • 3. Re: Problem viewing watermark in arabic in oracle EBS
              Srini Chavali-Oracle

              Pl post output of concurrent log files and relevant OPP log file section for the runs of engilsh and arabic versions of this report.

              • 4. Re: Problem viewing watermark in arabic in oracle EBS
                Mussa

                Srini Chavali-Oracle

                I have added rows to xdo_lobs tables.  Those rows I added have a similar existing data in xdo_lobs but updated language column to 'ar' ( which stands for arabic).  Now, I am able to get the water mark on both (when login in "English" and login in "Arabic") but another problem arises.  The data displayed are in Arabic which something I don't want.  The data displayed in the report should be in English.

                 

                Here is what the changes I did after backuping up xdo_lobs table:

                 

                 

                1) creating temporary table to insert the data in :

                 

                sql>create table xdo_lobs_tmp as select * from xdo_lobs X where X.creation_date >= to_date('01/01/2014','DD/MM/YYYY')

                and X.created_by not in (1,2) and X.lob_type in ('TEMPLATE_SOURCE','TEMPLATE')

                and  (select count(distinct language) from xdo_lobs where creation_date >= to_date('01/01/2014','DD/MM/YYYY')

                and created_by not in (1,2) and lob_type in ('TEMPLATE_SOURCE','TEMPLATE') and LOB_CODE = X.LOB_CODE) = 1

                 

                2) updating language column:

                sql>update xdo_lobs_tmp set language='ar';

                 

                3)populating xdo_lobs table from xdo_lobs_tmp

                sql> insert into xdo_lobs (select * from xdo_lobs_tmp);

                 

                 

                 

                 

                Here is the OPP log of the report that have been run in Arabic:

                 

                +---------------------------------------------------------------------------+

                محرك الوقت والعمالة: Version : 12.0.0

                 

                Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

                 

                XXRIC_HXC_DETAILED_TRS module: الرائدة : التقرير التفصيلي لحركات دخول و خروج الموظفين

                +---------------------------------------------------------------------------+

                 

                وقت النظام الحالي هو 10-01-2017 13:55:36

                 

                +---------------------------------------------------------------------------+

                 

                 

                +-----------------------------

                | بداية تنفيذ برنامج التزامن...

                +-----------------------------

                 

                المعاملات

                ------------

                P_DATE_FROM='2017/01/01 00:00:00'

                P_DATE_TO='2017/01/10 00:00:00'

                P_PERSON_ID='4411'

                ------------

                 

                Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing

                 

                Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

                ARABIC_AMERICA.AR8MSWIN1256

                 

                '.,'

                 

                أدخل كلمة السر:

                 

                Report Builder: Release 10.1.2.3.0 - Production on الثلاثاء 01 10 13:55:38 2017

                 

                Copyright (c) 1982, 2005, Oracle. All rights reserved.

                 

                 

                +---------------------------------------------------------------------------+

                بداية رسائل الأرشيف من FND_FILE

                +---------------------------------------------------------------------------+

                +---------------------------------------------------------------------------+

                نهاية رسائل الأرشيف من FND_FILE

                +---------------------------------------------------------------------------+

                 

                 

                +---------------------------------------------------------------------------+

                خيارات إتمام طلب التنفيذ...

                 

                Output file size:

                4332

                 

                +------------- 1) PUBLISH -------------+

                بدء ما بعد معالجة الطلب 5314208 بنقطة التوصيل ERPAPPSPROD عند 10-01-2017 13:55:39

                تمت عملية ما بعد معالجة الطلب 5314208 في 10-01-2017 13:55:40

                +--------------------------------------+

                 

                +------------- 2) PRINT -------------+

                 

                 

                ملف مخرجات الطباعة

                  معرف الطلب : 5314208

                  عدد النُسخ : 0

                  الطابعة : noprint

                 

                +--------------------------------------+

                 

                 

                خيارات إتمام طلب التنفيذ المنتهي.

                 

                +---------------------------------------------------------------------------+

                تم تنفيذ طلب التزامن بنجاح

                وقت النظام الحالي هو 10-01-2017 13:55:40

                 

                +---------------------------------------------------------------------------+

                 

                 

                 

                 

                 

                 

                 

                Here is the OPP log of the report that have been run when login in as "English":

                 

                +---------------------------------------------------------------------------+

                Time and Labor Engine: Version : 12.0.0

                 

                Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

                 

                XXRIC_HXC_DETAILED_TRS module: RIC: Detail Time Transactions Report

                +---------------------------------------------------------------------------+

                 

                Current system time is 10-JAN-2017 14:02:40

                 

                +---------------------------------------------------------------------------+

                 

                 

                +-----------------------------

                | Starting concurrent program execution...

                +-----------------------------

                 

                Arguments

                ------------

                P_DATE_FROM='2017/01/01 00:00:00'

                P_DATE_TO='2017/01/10 00:00:00'

                P_PERSON_ID='4411'

                ------------

                 

                Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing

                 

                Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

                AMERICAN_AMERICA.AR8MSWIN1256

                 

                '.,'

                 

                Enter Password:

                 

                Report Builder: Release 10.1.2.3.0 - Production on Tue Jan 10 14:02:42 2017

                 

                Copyright (c) 1982, 2005, Oracle. All rights reserved.

                 

                 

                +---------------------------------------------------------------------------+

                Start of log messages from FND_FILE

                +---------------------------------------------------------------------------+

                +---------------------------------------------------------------------------+

                End of log messages from FND_FILE

                +---------------------------------------------------------------------------+

                 

                 

                +---------------------------------------------------------------------------+

                Executing request completion options...

                 

                Output file size:

                4332

                 

                +------------- 1) PUBLISH -------------+

                Beginning post-processing of request 5314225 on node ERPAPPSPROD at 10-JAN-2017 14:02:43.

                Post-processing of request 5314225 completed at 10-JAN-2017 14:02:44.

                +--------------------------------------+

                 

                +------------- 2) PRINT -------------+

                 

                 

                Printing output file.

                  Request ID : 5314225

                  Number of copies : 0

                  Printer : noprint

                 

                +--------------------------------------+

                 

                 

                Finished executing request completion options.

                 

                +---------------------------------------------------------------------------+

                Concurrent request completed successfully

                Current system time is 10-JAN-2017 14:02:44

                 

                +---------------------------------------------------------------------------+

                • 5. Re: Problem viewing watermark in arabic in oracle EBS
                  Mussa

                  However, I have reverted the changes I did in step 3 above (removed the records I inserted).

                   

                   

                   

                  Here is the OPP log for Arabic regarding to the report:

                   

                  +---------------------------------------------------------------------------+

                  محرك الوقت والعمالة: Version : 12.0.0

                   

                  Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

                   

                  XXRIC_HXC_DETAILED_TRS module: الرائدة : التقرير التفصيلي لحركات دخول و خروج الموظفين

                  +---------------------------------------------------------------------------+

                   

                  وقت النظام الحالي هو 10-01-2017 14:44:27

                   

                  +---------------------------------------------------------------------------+

                   

                   

                  +-----------------------------

                  | بداية تنفيذ برنامج التزامن...

                  +-----------------------------

                   

                  المعاملات

                  ------------

                  P_DATE_FROM='2017/01/01 00:00:00'

                  P_DATE_TO='2017/01/10 00:00:00'

                  P_PERSON_ID='4411'

                  ------------

                   

                  Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing

                   

                  Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

                  ARABIC_AMERICA.AR8MSWIN1256

                   

                  '.,'

                   

                  أدخل كلمة السر:

                   

                  Report Builder: Release 10.1.2.3.0 - Production on الثلاثاء 01 10 14:44:28 2017

                   

                  Copyright (c) 1982, 2005, Oracle. All rights reserved.

                   

                   

                  +---------------------------------------------------------------------------+

                  بداية رسائل الأرشيف من FND_FILE

                  +---------------------------------------------------------------------------+

                  +---------------------------------------------------------------------------+

                  نهاية رسائل الأرشيف من FND_FILE

                  +---------------------------------------------------------------------------+

                   

                   

                  +---------------------------------------------------------------------------+

                  خيارات إتمام طلب التنفيذ...

                   

                  Output file size:

                  4332

                   

                  +------------- 1) PUBLISH -------------+

                  بدء ما بعد معالجة الطلب 5314360 بنقطة التوصيل ERPAPPSPROD عند 10-01-2017 14:44:29

                  تمت عملية ما بعد معالجة الطلب 5314360 في 10-01-2017 14:44:30

                  +--------------------------------------+

                   

                  +------------- 2) PRINT -------------+

                   

                   

                  ملف مخرجات الطباعة

                    معرف الطلب : 5314360

                    عدد النُسخ : 0

                    الطابعة : noprint

                   

                  +--------------------------------------+

                   

                   

                  خيارات إتمام طلب التنفيذ المنتهي.

                   

                  +---------------------------------------------------------------------------+

                  تم تنفيذ طلب التزامن بنجاح

                  وقت النظام الحالي هو 10-01-2017 14:44:30

                   

                  +---------------------------------------------------------------------------+

                   

                   

                   

                   

                   

                   

                  Here is the output when reporting while login in using "English":

                   

                  +---------------------------------------------------------------------------+

                  Time and Labor Engine: Version : 12.0.0

                   

                  Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

                   

                  XXRIC_HXC_DETAILED_TRS module: RIC: Detail Time Transactions Report

                  +---------------------------------------------------------------------------+

                   

                  Current system time is 10-JAN-2017 14:42:43

                   

                  +---------------------------------------------------------------------------+

                   

                   

                  +-----------------------------

                  | Starting concurrent program execution...

                  +-----------------------------

                   

                  Arguments

                  ------------

                  P_DATE_FROM='2017/01/01 00:00:00'

                  P_DATE_TO='2017/01/10 00:00:00'

                  P_PERSON_ID='4411'

                  ------------

                   

                  Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing

                   

                  Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

                  AMERICAN_AMERICA.AR8MSWIN1256

                   

                  '.,'

                   

                  Enter Password:

                   

                  Report Builder: Release 10.1.2.3.0 - Production on Tue Jan 10 14:42:44 2017

                   

                  Copyright (c) 1982, 2005, Oracle. All rights reserved.

                   

                   

                  +---------------------------------------------------------------------------+

                  Start of log messages from FND_FILE

                  +---------------------------------------------------------------------------+

                  +---------------------------------------------------------------------------+

                  End of log messages from FND_FILE

                  +---------------------------------------------------------------------------+

                   

                   

                  +---------------------------------------------------------------------------+

                  Executing request completion options...

                   

                  Output file size:

                  4332

                   

                  +------------- 1) PUBLISH -------------+

                  Beginning post-processing of request 5314348 on node ERPAPPSPROD at 10-JAN-2017 14:42:45.

                  Post-processing of request 5314348 completed at 10-JAN-2017 14:42:46.

                  +--------------------------------------+

                   

                  +------------- 2) PRINT -------------+

                   

                   

                  Printing output file.

                    Request ID : 5314348

                    Number of copies : 0

                    Printer : noprint

                   

                  +--------------------------------------+

                   

                   

                  Finished executing request completion options.

                   

                  +---------------------------------------------------------------------------+

                  Concurrent request completed successfully

                  Current system time is 10-JAN-2017 14:42:46

                   

                  +---------------------------------------------------------------------------+

                  • 6. Re: Problem viewing watermark in arabic in oracle EBS
                    Srini Chavali-Oracle

                    Were these base table updates done under the recommendation of Support ? If not, suggest you roll back those changes as direct base table updates are not supported.

                     

                    The data displayed are in Arabic which something I don't want.  The data displayed in the report should be in English.

                    Not sure what you mean by this - which data and what display ? Reports can only show data in the database as it was entered - neither EBS nor database has any translation technology built in.

                    • 7. Re: Problem viewing watermark in arabic in oracle EBS
                      Mussa

                      I did  rollbackup  to the changes.   Now, the watermark is not displayed when I select "arabic" language while login in to oracle.

                      • 8. Re: Problem viewing watermark in arabic in oracle EBS
                        Srini Chavali-Oracle

                        Suggest you open an SR and provide these details. Sounds like the Arabic version is not registered correctly in XDO. Can you detail out the steps taken to register these via XML Publisher ?