6 Replies Latest reply on Feb 26, 2016 5:24 AM by Rajesh123

    reports finished with warning in oracle EBS R12 due to NLS_NUMERIC_CHARACTERS

    2679576

      Hi,

      i worked a report and i integrated it to EBS R12, when i used in preference of the EBS the format of NLS_NUMERIC_CHARACTERS='10,000.00', the reports finished correctly but when i change the format to '10.000,00', it finished with warning, i tried to correct the RTF by using this format <?xdofx:replace(CF_A1,',','.')?>  it works but i searched another way because the RTF has more then 100 functions, so i have to make many modifications in every function , so i search a solution in reports or more optimized, Please could  you help me

        • 1. Re: reports finished with warning in oracle EBS R12 due to NLS_NUMERIC_CHARACTERS
          pillair

          What is the exact message you are getting in the log file of your concurrent request, when it completes with warning? Please post that here

          • 2. Re: reports finished with warning in oracle EBS R12 due to NLS_NUMERIC_CHARACTERS
            2679576

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

            Spec: Version : UNKNOWN

             

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

             

            TUN_BILAN module: TUN Etat Bilan

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

             

            Date et heure système : 25-FEV-2016 08:28:42

             

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

             

             

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

            | Début de l'exécution du programme de traitements simultanés...

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

             

            Arguments :

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

            P_ledger_name='TUNISAIR'

            P_period_fin='12-14'

            P_AFFICHAGE='En Dinars'

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

             

            APPLLCSP Environment Variable set to :

             

            Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

            FRENCH_AMERICA.UTF8

             

            ',.'

             

            Entrer mot de passe :

             

            Report Builder: Release 10.1.2.3.0 - Production on Je Fev 25 08:28:43 2016

             

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

             

             

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

            Début des messages de journalisation à partir du fichier FND_FILE.

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

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

            Fin des messages de journalisation à partir du fichier FND_FILE.

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

             

             

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

            Exécution des options de fin de traitement en cours...

             

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

            Début du post-traitement de la demande 16872012 sur le noeud EBSAPP02 à 25-FEV-2016 08:28:56.

            Le post-traitement de la demande 16872012 a échoué à 25-FEV-2016 08:28:57 avec le message d'erreur :

            One or more post-processing actions failed. Consult the OPP service log for details.

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

             

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

            Pas d'impression de la sortie de cette demande car le post-traitement a échoué.

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

             

             

            Exécution des options de fin de traitement terminée.

             

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

            Traitement simultané terminé

            Date et heure système : 25-FEV-2016 08:28:57

             

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

            • 3. Re: reports finished with warning in oracle EBS R12 due to NLS_NUMERIC_CHARACTERS
              pillair

              Do you have the OPP log file too. You can get this by executing

               

              SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name

                FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp

              WHERE fcpp.processor_id = fcp.concurrent_process_id

                AND fcpp.action_type = 6

                AND fcpp.concurrent_request_id = <your request id>

              • 4. Re: reports finished with warning in oracle EBS R12 due to NLS_NUMERIC_CHARACTERS
                2679576

                Template code: TUN_BILAN

                Template app:  SPEC

                Language:      fr

                Territory:     TN

                Output type:   PDF

                [2/25/16 8:28:57 AM] [UNEXPECTED] [381004:RT16872012] java.lang.reflect.InvocationTargetException

                  at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source)

                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                  at java.lang.reflect.Method.invoke(Method.java:597)

                  at oracle.apps.xdo.common.xml.XSLT10gR1.invokeProcessXSL(XSLT10gR1.java:624)

                  at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:421)

                  at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:233)

                  at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)

                  at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)

                  at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)

                  at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)

                  at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1665)

                  at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)

                  at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5936)

                  at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)

                  at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)

                  at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:285)

                  at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:173)

                Caused by: oracle.xdo.parser.v2.XPathException: Cannot convert 4286502,549 to number.

                  at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1534)

                  at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:521)

                  at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:489)

                  at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:271)

                  at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:155)

                  at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:192)

                  ... 17 more

                 

                 

                [2/25/16 8:28:57 AM] [381004:RT16872012] Completed post-processing actions for request 16872012.

                [2/25/16 8:33:46 AM] [OPPServiceThread1] Post-processing request 16872098.

                [2/25/16 8:33:46 AM] [381004:RT16872098] Executing post-processing actions for request 16872098.

                [2/25/16 8:33:46 AM] [381004:RT16872098] Starting XML Publisher post-processing action.

                [2/25/16 8:33:46 AM] [381004:RT16872098]

                • 5. Re: reports finished with warning in oracle EBS R12 due to NLS_NUMERIC_CHARACTERS
                  pillair

                  Can you set the value of the Profile option ICX: Numeric characters to 10.000,00 and try? If you are unable to change the value of this profile, then also check what is the value of the profile option XDO: Numeric characters

                  • 6. Re: reports finished with warning in oracle EBS R12 due to NLS_NUMERIC_CHARACTERS
                    Rajesh123

                    Hi ,

                    Same issue i got and i have changed profile option like below .

                     

                     

                    Navigate to System Administrator Responsibility: Profile: System

                    Query for Profile = ICX: Numeric characters
                    Set value = 10,000.00
                    Save


                    And as per Pillar comments you can try.