1 2 3 Previous Next 38 Replies Latest reply on Aug 11, 2015 6:19 AM by Bashar.

    Create Accounting Process  taking sooo long?

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.1.3

       

      Users submitted job request "CREATE ACCOUNTING" but it runs 1 day and not yet finished.

      I check the system and the CPU resources are idle.

       

      How can I check what is locking this process?

       

      Capture.JPG

       

      Thanks a lot,

      jc

        • 1. Re: Create Accounting Process  taking sooo long?
          Bashar.

          Hi,

           

          Please post the contents of the log file.

           

          Regards,

          Bashar

          • 2. Re: Create Accounting Process  taking sooo long?
            Beauty_and_dBest

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

            Bills of Material: Version : 12.0.0

             

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

             

            CSTCRACC module: Create Accounting - Cost Management

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

             

            Current system time is 08-AUG-2015 15:26:51

             

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

             

            XDO Data Engine Version No: 5.6.3

            Resp: 64166

            Org ID : 204

            Request ID: 5978389

            All Parameters: P_APPLICATION_ID=707:P_SOURCE_APPLICATION_ID=707:P_DUMMY=Y:P_LEDGER_ID=1:P_PROCESS_CATEGORY_CODE=:P_END_DATE="2015/08/08 00:00:00":P_CREATE_ACCOUNTING_FLAG=Y:P_DUMMY_PARAM_1=Y:P_ACCOUNTING_MODE=F:P_DUMMY_PARAM_2=Y:P_ERRORS_ONLY_FLAG=N:P_REPORT_STYLE=D:P_TRANSFER_TO_GL_FLAG=N:P_DUMMY_PARAM_3=:P_POST_IN_GL_FLAG=:P_GL_BATCH_NAME=:P_MIN_PRECISION=2:P_INCLUDE_ZERO_AMOUNT_LINES=N:P_REQUEST_ID=:P_ENTITY_ID=:P_SOURCE_APPLICATION_NAME=Cost Management:P_APPLICATION_NAME=Cost Management:P_LEDGER_NAME=Vision Operations (USA):P_PROCESS_CATEGORY_NAME=:P_CREATE_ACCOUNTING=Yes:P_ACCOUNTING_MODE_NAME=Final:P_ERRORS_ONLY=No:P_ACCOUNTING_REPORT_LEVEL=Detail:P_TRANSFER_TO_GL=No:P_POST_IN_GL=:P_INCLUDE_ZERO_AMT_LINES=No:P_VALUATION_METHOD_CODE=:P_SECURITY_INT_1=7920:P_SECURITY_INT_2=:P_SECURITY_INT_1=:P_SECURITY_CHAR_1=:P_SECURITY_CHAR_2=:P_SECURITY_CHAR_3=:P_CONC_REQUEST_ID=:P_INCLUDE_USER_TRX_ID_FLAG=N:P_INCLUDE_USER_TRX_IDENTIFIERS=No:DebugFlag=

            Data Template Code: CSTCRACC

            Data Template Application Short Name: BOM

            Debug Flag:

            {P_ACCOUNTING_REPORT_LEVEL=Detail, P_DUMMY=Y, P_ACCOUNTING_MODE_NAME=Final, P_ERRORS_ONLY_FLAG=N, P_REPORT_STYLE=D, P_GL_BATCH_NAME=, P_END_DATE=2015/08/08 00:00:00, P_SECURITY_INT_2=, P_SECURITY_INT_1=, P_VALUATION_METHOD_CODE=, P_POST_IN_GL=, P_TRANSFER_TO_GL=No, P_TRANSFER_TO_GL_FLAG=N, P_INCLUDE_USER_TRX_IDENTIFIERS=No, P_PROCESS_CATEGORY_NAME=, P_ERRORS_ONLY=No, P_DUMMY_PARAM_3=, P_SECURITY_CHAR_3=, P_DUMMY_PARAM_2=Y, P_SECURITY_CHAR_2=, P_DUMMY_PARAM_1=Y, P_SECURITY_CHAR_1=, P_ENTITY_ID=, P_PROCESS_CATEGORY_CODE=, P_INCLUDE_ZERO_AMT_LINES=No, P_LEDGER_ID=1, P_POST_IN_GL_FLAG=, P_APPLICATION_ID=707, P_INCLUDE_USER_TRX_ID_FLAG=N, P_APPLICATION_NAME=Cost Management, P_REQUEST_ID=, P_CONC_REQUEST_ID=, P_LEDGER_NAME=Vision Operations (USA), P_SOURCE_APPLICATION_ID=707, P_CREATE_ACCOUNTING=Yes, P_CREATE_ACCOUNTING_FLAG=Y, P_MIN_PRECISION=2, P_SOURCE_APPLICATION_NAME=Cost Management, P_INCLUDE_ZERO_AMOUNT_LINES=N, P_ACCOUNTING_MODE=F}

            Calling XDO Data Engine...

            • 3. Re: Create Accounting Process  taking sooo long?
              Bashar.

              Check the status of the output post processor through the "processes" window.

               

              Post the output of this query:

               

              select application_id, event_status_code, count(0)

              from xla_events

              where event_status_code != 'P'

              group by application_id, event_status_code

              order by 1,2;

               

              Regards,

              Bashar

              1 person found this helpful
              • 4. Re: Create Accounting Process  taking sooo long?
                Beauty_and_dBest

                SQL> select application_id, event_status_code, count(0)

                from xla_events

                where event_status_code != 'P'

                group by application_id, event_status_code

                order by 1,2;

                 

                 

                 

                APPLICATION_ID E   COUNT(0)

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

                           140 N          3

                           140 U      20015

                           140 Z         97

                           200 I        330

                           200 N        163

                           200 U       1394

                           200 Z        878

                           201 U         70

                           201 Z          9

                           206 U          4

                           206 Z          1

                           222 I        116

                           222 U        789

                           222 Z         67

                           260 N         24

                           275 U          1

                           275 Z        892

                           540 U          4

                           707 U       1546

                           707 Z          3

                          8901 Z          1

                         20065 U        315

                         20066 U        177

                 

                23 rows selected.

                • 5. Re: Create Accounting Process  taking sooo long?
                  Beauty_and_dBest

                  By the way, how do I let my gather schema job get passed the other pending jobs?

                  Can I change its priority to 1?

                   

                  Thanks.

                  • 6. Re: Create Accounting Process  taking sooo long?
                    Bashar.

                    You can change the priority in the concurrent program setup form. It will take effect next time you run the request.

                     

                    I recommend to cancel all running create accounting requests, let gather statistics request finish and then run them one at a time.

                     

                    Regards,

                    Bashar

                    1 person found this helpful
                    • 7. Re: Create Accounting Process  taking sooo long?
                      Beauty_and_dBest

                      Thanks

                      So there is no clue why they are pending hanging?

                      I do not know how to rerun those jobs. Can I just rerun a cancelled job? or copy it So I will not repeat entering the parameters?

                      • 8. Re: Create Accounting Process  taking sooo long?
                        Bashar.

                        Just let the user, who submitted a cancelled job, submit the same request again.

                         

                        Regards,

                        Bashar

                        1 person found this helpful
                        • 9. Re: Create Accounting Process  taking sooo long?
                          Beauty_and_dBest

                          Thanks Bashar,

                           

                          How do I purge or delete old cm logs?

                          • 10. Re: Create Accounting Process  taking sooo long?
                            Beauty_and_dBest

                            Hi Bashar,

                             

                            I also found this logs. Maybe it can give clue why the job is running hang?

                             

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

                            Application Object Library: Concurrent Processing version 11.5

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

                            STANDARD Concurrent Manager started : 08-AUG-2015 04:33:06

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

                             

                            08-AUG-2015 04:33:08

                            Starting concurrent program FNDWFBG for concurrent request 5976510 (MODULE=FNDWFBG)

                             

                            08-AUG-2015 04:38:27

                            Starting concurrent program CMCTCM for concurrent request 5737890 (MODULE=/u01/applmgr/VIS/apps/apps_st/appl/bom/12.0.0/bin/CMCTCM)

                             

                            08-AUG-2015 04:38:57

                            Starting concurrent program FNDWFBG for concurrent request 5976521 (MODULE=FNDWFBG)

                             

                            08-AUG-2015 04:43:59

                            Starting concurrent program FNDOAMCOL for concurrent request 5976519 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

                             

                            08-AUG-2015 04:49:03

                            Starting concurrent program FNDWFBG for concurrent request 5976535 (MODULE=FNDWFBG)

                             

                            08-AUG-2015 04:53:34

                             

                            ========================================================================

                            Starting VIS_0808@VIS Internal Concurrent Manager -- shell process ID 2756

                             

                            Found dead process: spid=(3043), cpid=(2073446), ORA pid=(31), manager=(0/4)

                            Found dead process: spid=(3060), cpid=(2073447), ORA pid=(25), manager=(0/0)

                            Found dead process: spid=(3061), cpid=(2073448), ORA pid=(33), manager=(0/0)

                            Found dead process: spid=(3062), cpid=(2073449), ORA pid=(23), manager=(0/0)

                            Found dead process: spid=(3063), cpid=(2073450), ORA pid=(32), manager=(0/1071)

                            Found dead process: spid=(3068), cpid=(2073451), ORA pid=(37), manager=(275/40)

                            Found dead process: spid=(3069), cpid=(2073452), ORA pid=(36), manager=(401/10)

                            Found dead process: spid=(3070), cpid=(2073453), ORA pid=(38), manager=(704/39)

                            Found dead process: spid=(2989), cpid=(2073435), ORA pid=(21), manager=(802/2216)

                            Found dead process: spid=(2990), cpid=(2073436), ORA pid=(27), manager=(201/222)

                            Found dead process: spid=(2992), cpid=(2073438), ORA pid=(30), manager=(201/15)

                            Found dead process: spid=(2993), cpid=(2073439), ORA pid=(29), manager=(705/12)

                            Found dead process: spid=(2760), cpid=(2073433), ORA pid=(16), manager=(0/1)

                             

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

                            Application Object Library: Concurrent Processing version 11.5

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

                            Internal Concurrent Manager started : 08-AUG-2014 10:06:08

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

                             

                              Process monitor session started : 08-AUG-2014 10:06:09

                            CONC-SM TNS FAIL

                            Call to PingProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to StopProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to PingProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to StopProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to PingProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to StopProcess failed for FNDCPGSC

                            Found dead process: spid=(3009), cpid=(2073442), Service Instance=(2158)

                            CONC-SM TNS FAIL

                            Call to PingProcess failed for FNDOPP

                            CONC-SM TNS FAIL

                            Call to StopProcess failed for FNDOPP

                            Found dead process: spid=(3007), cpid=(2073441), Service Instance=(31528)

                            CONC-SM TNS FAIL

                            Call to PingProcess failed for IEMDPDEV

                            CONC-SM TNS FAIL

                            Call to StopProcess failed for IEMDPDEV

                             

                             

                            Starting FFTM Concurrent Manager : 08-AUG-2014 10:06:19

                            Starting RCVOLTM Concurrent Manager : 08-AUG-2014 10:06:19

                            Starting RCVOLTM14 Concurrent Manager : 08-AUG-2014 10:06:19

                            Starting PODAMGR Concurrent Manager : 08-AUG-2014 10:06:20

                            Starting CRPINQMGR Concurrent Manager : 08-AUG-2014 10:06:20

                            Starting INVTMRPM Concurrent Manager : 08-AUG-2014 10:06:20

                            Starting DownloadProcessorNormalMode Concurrent Manager : 08-AUG-2014 10:06:20

                            Starting FNDCPOPP Concurrent Manager : 08-AUG-2014 10:06:21

                            Starting WFWSSVC Concurrent Manager : 08-AUG-2014 10:06:21

                            Starting WFMLRSVC Concurrent Manager : 08-AUG-2014 10:06:21

                            Starting WFALSNRSVC Concurrent Manager : 08-AUG-2014 10:06:21

                            Starting FNDCRM Concurrent Manager : 08-AUG-2014 10:06:21

                            Starting STANDARD Concurrent Manager : 08-AUG-2014 10:06:21

                            Starting STANDARD Concurrent Manager : 08-AUG-2014 10:06:21

                            Starting STANDARD Concurrent Manager : 08-AUG-2014 10:06:21

                             

                             

                            Starting OAMCOLMGR Concurrent Manager : 08-AUG-2014 10:06:21

                            Starting PASMGR Concurrent Manager : 08-AUG-2014 10:06:21

                            Starting INVMGR Concurrent Manager : 08-AUG-2014 10:06:21

                            Starting MRPMGR Concurrent Manager : 08-AUG-2014 10:06:22

                              Process monitor session ended : 08-AUG-2014 10:06:22

                              Process monitor session started : 08-AUG-2014 10:08:22

                            CONC-SM TNS FAIL

                            Call to PingProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to StopProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to PingProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to StopProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to PingProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to StopProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to PingProcess failed for FNDOPP

                            CONC-SM TNS FAIL

                            Call to StopProcess failed for FNDOPP

                            CONC-SM TNS FAIL

                            Call to PingProcess failed for IEMDPDEV

                            CONC-SM TNS FAIL

                            Call to StopProcess failed for IEMDPDEV

                              Process monitor session ended : 08-AUG-2014 10:08:22

                              Process monitor session started : 08-AUG-2014 10:10:22

                            CONC-SM TNS FAIL

                            Call to PingProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to StopProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to PingProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to StopProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to PingProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to StopProcess failed for FNDCPGSC

                            CONC-SM TNS FAIL

                            Call to PingProcess failed for FNDOPP

                            CONC-SM TNS FAIL

                            Call to StopProcess failed for FNDOPP

                            CONC-SM TNS FAIL

                            Call to PingProcess failed for IEMDPDEV

                            CONC-SM TNS FAIL

                            Call to StopProcess failed for IEMDPDEV

                              logfile=/u01/applmgr/VIS/inst/apps/VIS_fitc/logs/appl/conc/log/VIS_0808.mgr  PRINTER=noprint  mailto=applmgr  restart=N  diag=N  sleep=30  pmon=4  quesiz=1  Reviver is ENABLED
                            • 11. Re: Create Accounting Process  taking sooo long?
                              Bashar.

                              Jenna_C wrote:

                               

                              Thanks Bashar,

                               

                              How do I purge or delete old cm logs?

                               

                              Check this discussion:

                               

                              In r12 What is use of Purge log and Closed system alerts

                              1 person found this helpful
                              • 12. Re: Create Accounting Process  taking sooo long?
                                Bashar.

                                Please review this document:

                                 

                                Concurrent Processing - ICM log file shows 'CONC-SM TNS FAIL', 'Call to PingProcess failed', and/or 'Call to StopProcess failed' for FNDCPGSC/FNDOPP (Doc ID 1312632.1)

                                 

                                Regards,

                                Bashar

                                1 person found this helpful
                                • 13. Re: Create Accounting Process  taking sooo long?
                                  Beauty_and_dBest

                                  Its weird, I see dates like 2014? >Internal Concurrent Manager started : 08-AUG-2014 10:06:08

                                  But the other one is good > STANDARD Concurrent Manager started : 08-AUG-2015 04:33:06

                                  • 14. Re: Create Accounting Process  taking sooo long?
                                    Bashar.

                                    Maybe someone changed the date of the server?!

                                    1 person found this helpful
                                    1 2 3 Previous Next