13 Replies Latest reply: May 7, 2013 10:53 PM by Hussein Sawwan-Oracle RSS

    applying patch 8919491 on apps tier to upgrade from 12.1.1 to 12.1.3 failed

    User550057 - Oracle
      errors in adpatch.log:

      ........

      Program completed successfully

      Completed: file fwkportlink.ldt on worker 25 for product fnd username APPS.
      Completed: file jtfumprof.ldt on worker 31 for product jtf username APPS.
      Program completed successfully

      Program completed successfully

      FAILED: file ecxsvcc.ldt on worker 1 for product ecx username APPS.
      Completed: file fwklookaheadlov.ldt on worker 22 for product fnd username APPS.
      Program completed successfully

      FAILED: file wfsvcc.ldt on worker 2 for product fnd username APPS.
      Deferred: file wfsvcc.ldt on worker 2 for product fnd username APPS. (Deferment number 2 for this job)
      Assigned: file wfsvcc.ldt on worker 2 for product fnd username APPS.
      Program completed successfully

      Program completed successfully

      Completed: file b8607698p.ldt on worker 16 for product fnd username APPS.
      Completed: file b9652599p.ldt on worker 17 for product fnd username APPS.
      Program completed successfully

      FAILED: file wfsvcc.ldt on worker 2 for product fnd username APPS.

      ATTENTION: All workers either have failed or are waiting:

      FAILED: file ecxsvcc.ldt on worker 1.
      FAILED: file wfsvcc.ldt on worker 2.

      ATTENTION: Please fix the above failed worker(s) so the manager can continue.


      errors in adwork001.log:

      ........

      Loading data using FNDLOAD function.
      FNDLOAD APPS/***** 0 Y UPLOAD_PARTIAL @FND:patch/115/import/afsvcc.lct @ECX:patch/115/import/US/ecxsvcc.ldt FND_SVC_COMPONENTS

      Connecting to APPS......Connected successfully.

      Calling FNDLOAD function.

      Returned from FNDLOAD function.

      Log file: /apps/visappl/admin/VIS_BALANCE/log/US_ecxsvcc_ldt.log
      Error calling FNDLOAD function.


      Time when worker failed: Mon May 06 2013 23:20:40


      errors in adwork002.log:

      ........

      Loading data using FNDLOAD function.
      FNDLOAD APPS/***** 0 Y UPLOAD_PARTIAL @FND:patch/115/import/afsvcc.lct @FND:patch/115/import/US/wfsvcc.ldt FND_SVC_COMPONENTS

      Connecting to APPS......Connected successfully.

      Calling FNDLOAD function.

      Returned from FNDLOAD function.

      Log file: /apps/visappl/admin/VIS_BALANCE/log/US_wfsvcc_ldt.log
      Error calling FNDLOAD function.


      Time when worker failed: Mon May 06 2013 23:20:40


      errors in /apps/visappl/admin/VIS_BALANCE/log/US_ecxsvcc_ldt.log:

      ........

      Uploading from the data file /apps/visappl/ecx/12.0.0/patch/115/import/US/ecxsvcc.ldt
      Altering database NLS_LANGUAGE environment to AMERICAN
      Dumping from LCT/LDT files (/apps/visappl/fnd/12.0.0/patch/115/import/afsvcc.lct, /apps/visappl/ecx/12.0.0/patch/115/import/US/ecxsvcc.ldt) to staging tables
      Dumping LCT file /apps/visappl/fnd/12.0.0/patch/115/import/afsvcc.lct into FND_SEED_STAGE_CONFIG
      Dumping LDT file /apps/visappl/ecx/12.0.0/patch/115/import/US/ecxsvcc.ldt into FND_SEED_STAGE_ENTITY
      Dumped the batch (FND_SVC_COMPONENTS ECX Inbound Agent Listener , FND_SVC_COMP_PARAM_VALS SQL_TRACE_LEVEL ) into FND_SEED_STAGE_ENTITY
      Uploading from staging tables
      Error loading seed data for FND_SVC_COMPONENTS: COMPONENT_NAME = ECX Inbound Agent Listener, ORA-01403: no data found
      Error loading seed data for FND_SVC_COMPONENTS: COMPONENT_NAME = ECX Transaction Agent Listener, ORA-01403: no data found


      Concurrent request completed
      Current system time is Mon May 6 23:20:40 2013

      errors in /apps/visappl/admin/VIS_BALANCE/log/US_wfsvcc_ldt.log:

      ........

      Uploading from the data file /apps/visappl/fnd/12.0.0/patch/115/import/US/wfsvcc.ldt
      Altering database NLS_LANGUAGE environment to AMERICAN
      Dumping from LCT/LDT files (/apps/visappl/fnd/12.0.0/patch/115/import/afsvcc.lct, /apps/visappl/fnd/12.0.0/patch/115/import/US/wfsvcc.ldt) to staging tables
      Dumping LCT file /apps/visappl/fnd/12.0.0/patch/115/import/afsvcc.lct into FND_SEED_STAGE_CONFIG
      Dumping LDT file /apps/visappl/fnd/12.0.0/patch/115/import/US/wfsvcc.ldt into FND_SEED_STAGE_ENTITY
      Dumped the batch (FND_SVC_COMPONENTS Workflow Deferred Agent Listener , FND_SVC_COMP_PARAM_VALS WARNING ) into FND_SEED_STAGE_ENTITY
      Uploading from staging tables
      Error loading seed data for FND_SVC_COMPONENTS: COMPONENT_NAME = Workflow Deferred Agent Listener, ORA-01403: no data found
      Error loading seed data for FND_SVC_COMPONENTS: COMPONENT_NAME = Workflow Deferred Notification Agent Listener, ORA-01403: no data found
      Error loading seed data for FND_SVC_COMPONENTS: COMPONENT_NAME = Workflow Error Agent Listener, ORA-01403: no data found
      Error loading seed data for FND_SVC_COMPONENTS: COMPONENT_NAME = Workflow Inbound JMS Agent Listener, ORA-01403: no data found
      Error loading seed data for FND_SVC_COMPONENTS: COMPONENT_NAME = Workflow Inbound Notifications Agent Listener, ORA-01403: no data found
      Error loading seed data for FND_SVC_COMPONENTS: COMPONENT_NAME = Workflow Java Deferred Agent Listener, ORA-01403: no data found
      Error loading seed data for FND_SVC_COMPONENTS: COMPONENT_NAME = Workflow Java Error Agent Listener, ORA-01403: no data found


      Concurrent request completed
      Current system time is Mon May 6 23:20:40 2013

      Edited by: 1004455 on 2013-5-7 上午12:58
        • 1. Re: applying patch 8919491 on apps tier to upgrade from 12.1.1 to 12.1.3 failed
          User550057 - Oracle
          OS platform:
          bash-3.2$ cat /etc/issue
          Oracle Linux Server release 5.8
          Kernel \r on an \m

          database is on another server:

          $ cat /etc/issue
          Oracle Linux Server release 6.2
          Kernel \r on an \m

          database version:11.2.0.3
          • 2. Re: applying patch 8919491 on apps tier to upgrade from 12.1.1 to 12.1.3 failed
            Srini Chavali-Oracle
            Pl open an SR for this issue - it looks like seed data in base tables is missing or has been deleted

            HTH
            Srini
            • 3. Re: applying patch 8919491 on apps tier to upgrade from 12.1.1 to 12.1.3 failed
              Hussein Sawwan-Oracle
              Did you complete all the steps in (Oracle E-Business Suite Applications Technology Readme for Release 12.1.3 (R12.ATG_PF.B.delta.3, Patch 8919491) [ID 1066312.1])?

              What is the output of the following query?
              SQL> select COMPONENT_NAME
              from FND_SVC_COMPONENTS;
              Thanks,
              Hussein
              • 4. Re: applying patch 8919491 on apps tier to upgrade from 12.1.1 to 12.1.3 failed
                User550057 - Oracle
                SQL> select COMPONENT_NAME from FND_SVC_COMPONENTS;

                COMPONENT_NAME
                --------------------------------------------------------------------------------
                ECX Inbound Agent Listener
                ECX Transaction Agent Listener
                WF_JMS_IN Listener(M4U)
                Web Services IN Agent
                Web Services OUT Agent
                Workflow Deferred Agent Listener
                Workflow Deferred Notification Agent Listener
                Workflow Error Agent Listener
                Workflow Inbound JMS Agent Listener
                Workflow Inbound Notifications Agent Listener
                Workflow Java Deferred Agent Listener
                Workflow Java Error Agent Listener
                Workflow Notification Mailer

                13 rows selected.
                • 5. Re: applying patch 8919491 on apps tier to upgrade from 12.1.1 to 12.1.3 failed
                  Hussein Sawwan-Oracle
                  What is the output of the following query?
                  SQL> select owner, object_type, object_name 
                  from dba_objects
                  where object_name like 'FND_SVC_COMPONENTS%';
                  Do you have any invalid objects in the database?

                  Thanks,
                  Hussein
                  • 6. Re: applying patch 8919491 on apps tier to upgrade from 12.1.1 to 12.1.3 failed
                    Hussein Sawwan-Oracle
                    Please also confirm that you get an output when you run:
                    SQL> SELECT cpb.parameter_name
                            , cpv.parameter_value
                            , cpv.customization_level
                            , -1 object_version_number
                            , DECODE (cpv.last_updated_by, 1, 'ORACLE', 'CUSTOM') owner
                            , to_char(cpv.last_update_date, 'YYYY/MM/DD HH24:MI:SS') last_update_date
                       FROM   fnd_svc_comp_param_vals cpv
                            , fnd_svc_comp_params_b cpb
                            , fnd_svc_components c
                       WHERE c.component_name = 'ECX Inbound Agent Listener'
                         AND cpv.parameter_id = cpb.parameter_id
                         AND cpv.component_id = c.component_id
                       ORDER BY cpb.parameter_name;
                    Thanks,
                    Hussein
                    • 7. Re: applying patch 8919491 on apps tier to upgrade from 12.1.1 to 12.1.3 failed
                      User550057 - Oracle
                      SQL> select owner, object_type, object_name
                      from dba_objects
                      where object_name like 'FND_SVC_COMPONENTS%'; 2 3

                      OWNER OBJECT_TYPE OBJECT_NAME
                      ------------------------------ ------------------- ------------------------------
                      APPLSYS SEQUENCE FND_SVC_COMPONENTS_S
                      APPLSYS TABLE FND_SVC_COMPONENTS
                      APPLSYS INDEX FND_SVC_COMPONENTS_U1
                      APPLSYS INDEX FND_SVC_COMPONENTS_U2
                      APPS SYNONYM FND_SVC_COMPONENTS_S
                      APPS SYNONYM FND_SVC_COMPONENTS
                      APPS PACKAGE FND_SVC_COMPONENTS_PKG
                      APPS VIEW FND_SVC_COMPONENTS_V
                      APPS PACKAGE BODY FND_SVC_COMPONENTS_PKG
                      OWF_MGR TABLE FND_SVC_COMPONENTS
                      OWF_MGR SEQUENCE FND_SVC_COMPONENTS_S
                      OWF_MGR INDEX FND_SVC_COMPONENTS_PK1
                      OWF_MGR INDEX FND_SVC_COMPONENTS_U2
                      OWF_MGR PACKAGE FND_SVC_COMPONENTS_PKG
                      OWF_MGR VIEW FND_SVC_COMPONENTS_V
                      OWF_MGR PACKAGE BODY FND_SVC_COMPONENTS_PKG

                      16 rows selected.


                      SQL> SELECT cpb.parameter_name
                      2 , cpv.parameter_value
                      , cpv.customization_level
                      3 4 , -1 object_version_number
                      5 , DECODE (cpv.last_updated_by, 1, 'ORACLE', 'CUSTOM') owner
                      , to_char(cpv.last_update_date, 'YYYY/MM/DD HH24:MI:SS') last_update_date
                      6 7 FROM fnd_svc_comp_param_vals cpv
                      8 , fnd_svc_comp_params_b cpb
                      9 , fnd_svc_components c
                      10 WHERE c.component_name = 'ECX Inbound Agent Listener'
                      AND cpv.parameter_id = cpb.parameter_id
                      11 12 AND cpv.component_id = c.component_id
                      13 ORDER BY cpb.parameter_name;

                      PARAMETER_NAME
                      ------------------------------
                      PARAMETER_VALUE
                      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                      CUSTOMIZATION_LEVEL OBJECT_VERSION_NUMBER OWNER LAST_UPDATE_DATE
                      ------------------------------ --------------------- ------ -------------------
                      COMPONENT_LOG_LEVEL
                      4
                      L -1 ORACLE 2007/01/03 18:22:47

                      LISTENER_PROCESS_EVT_COUNT
                      500
                      L -1 ORACLE 2007/01/03 18:22:47

                      PROCESSOR_ERROR_LOOP_SLEEP
                      60
                      L -1 ORACLE 2007/01/03 18:22:47

                      PROCESSOR_IN_THREAD_COUNT
                      1
                      L -1 ORACLE 2007/01/03 18:22:47

                      PROCESSOR_LOOP_SLEEP
                      120
                      L -1 ORACLE 2007/01/03 18:22:47

                      PROCESSOR_MAX_ERROR_COUNT
                      10
                      L -1 ORACLE 2007/01/03 18:22:47

                      PROCESSOR_MAX_LOOP_SLEEP
                      0
                      C -1 ORACLE 2007/01/03 18:22:47

                      PROCESSOR_OUT_THREAD_COUNT
                      0
                      C -1 ORACLE 2007/01/03 18:22:47

                      PROCESSOR_READ_TIMEOUT
                      0
                      L -1 ORACLE 2007/01/03 18:22:47

                      PROCESSOR_READ_TIMEOUT_CLOSE
                      Y
                      L -1 ORACLE 2007/01/03 18:22:47


                      10 rows selected.
                      • 8. Re: applying patch 8919491 on apps tier to upgrade from 12.1.1 to 12.1.3 failed
                        User550057 - Oracle
                        SQL> select owner,count(*) from dba_objects where status='INVALID' group by owner;

                        OWNER COUNT(*)
                        ------------------------------ ----------
                        FLOWS_020000 1
                        D4OSYS 1
                        OLAPSYS 28
                        PUBLIC 43
                        APEX_030200 1
                        APPS 2017
                        SQLTXPLAIN 1
                        XDB 6
                        SYS 29
                        FLOWS_010500 3

                        10 rows selected.
                        • 9. Re: applying patch 8919491 on apps tier to upgrade from 12.1.1 to 12.1.3 failed
                          User550057 - Oracle
                          OWNER OBJECT_TYPE OBJECT_NAME STATUS
                          ------------------------------ ------------------- ------------------------------ -------
                          APPLSYS SEQUENCE FND_SVC_COMPONENTS_S VALID
                          APPS SYNONYM FND_SVC_COMPONENTS_S VALID
                          APPLSYS TABLE FND_SVC_COMPONENTS VALID
                          APPLSYS INDEX FND_SVC_COMPONENTS_U1 VALID
                          APPLSYS INDEX FND_SVC_COMPONENTS_U2 VALID
                          APPS SYNONYM FND_SVC_COMPONENTS VALID
                          APPS PACKAGE FND_SVC_COMPONENTS_PKG VALID
                          APPS VIEW FND_SVC_COMPONENTS_V VALID
                          APPS PACKAGE BODY FND_SVC_COMPONENTS_PKG VALID
                          OWF_MGR TABLE FND_SVC_COMPONENTS VALID
                          OWF_MGR SEQUENCE FND_SVC_COMPONENTS_S VALID
                          OWF_MGR INDEX FND_SVC_COMPONENTS_PK1 VALID
                          OWF_MGR INDEX FND_SVC_COMPONENTS_U2 VALID
                          OWF_MGR PACKAGE FND_SVC_COMPONENTS_PKG VALID
                          OWF_MGR VIEW FND_SVC_COMPONENTS_V VALID
                          OWF_MGR PACKAGE BODY FND_SVC_COMPONENTS_PKG VALID

                          16 rows selected.
                          • 10. Re: applying patch 8919491 on apps tier to upgrade from 12.1.1 to 12.1.3 failed
                            Hussein Sawwan-Oracle
                            All the above look OK to me and it indicates you have no missing data.
                            Uploading from the data file /apps/visappl/fnd/12.0.0/patch/115/import/US/wfsvcc.ldt
                            Can you find any data in this ldt file?

                            Thanks,
                            Hussein
                            • 11. Re: applying patch 8919491 on apps tier to upgrade from 12.1.1 to 12.1.3 failed
                              User550057 - Oracle
                              Following is the content of the file:

                              # $Header: wfsvcc.ldt 120.6.12010000.4 2010/04/08 10:43:22 skandepu ship $

                              # dbdrv: exec fnd bin FNDLOAD bin &phase=daa+70 checkfile(115.37=120.4):~PROD:~PATH:~FILE:FND_SVC_COMPONENTS &ui_apps 0 Y UPLOAD_PARTIAL @FND:patch/115/import/afsvcc.lct @~PROD:~PATH/~FILE FND_SVC_COMPONENTS
                              LANGUAGE = "US"
                              LDRCONFIG = "afsvcc.lct"

                              #Source Database seed121

                              #RELEASE_NAME 12.1.0

                              # -- Begin Entity Definitions --

                              DEFINE FND_SVC_COMPONENTS
                              KEY COMPONENT_NAME VARCHAR2(80)
                              BASE COMPONENT_STATUS VARCHAR2(30)
                              BASE COMPONENT_TYPE VARCHAR2(30)
                              BASE STARTUP_MODE VARCHAR2(30)
                              BASE CONTAINER_TYPE VARCHAR2(30)
                              BASE CUSTOMIZATION_LEVEL VARCHAR2(30)
                              BASE APPLICATION_SHORT_NAME VARCHAR2(50)
                              BASE CONCURRENT_QUEUE_NAME VARCHAR2(30)
                              BASE STANDALONE_CONTAINER_NAME VARCHAR2(30)
                              BASE INBOUND_AGENT_NAME VARCHAR2(30)
                              BASE OUTBOUND_AGENT_NAME VARCHAR2(30)
                              BASE CORRELATION_ID VARCHAR2(240)
                              BASE MAX_IDLE_TIME NUMBER(22)
                              BASE COMPONENT_STATUS_INFO VARCHAR2(1996)
                              BASE OBJECT_VERSION_NUMBER NUMBER(22)
                              CTX OWNER VARCHAR2(7)
                              CTX LAST_UPDATE_DATE VARCHAR2(75)

                              *......*

                              BEGIN FND_SVC_COMP_PARAM_VALS "COMPONENT_LOG_LEVEL"
                              PARAMETER_VALUE = "5"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "DEBUG_MAIL_SESSION"
                              PARAMETER_VALUE = "N"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "DIRECT_RESPONSE"
                              PARAMETER_VALUE = "N"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "DISCARD"
                              PARAMETER_VALUE = "DISCARD"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:06:42"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "EMAIL_PARSER"
                              PARAMETER_VALUE = "oracle.apps.fnd.wf.mailer.TemplatedEmailParser"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:06:42"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "ENABLE_STYLESHEET"
                              PARAMETER_VALUE = "N"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "EXPUNGE_ON_CLOSE"
                              PARAMETER_VALUE = "Y"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:06:42"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "FRAMEWORK_APP"
                              PARAMETER_VALUE = "1"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "FRAMEWORK_RESP"
                              PARAMETER_VALUE = "20420"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "FRAMEWORK_URL_TIMEOUT"
                              PARAMETER_VALUE = "30"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "FRAMEWORK_USER"
                              PARAMETER_VALUE = "0"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "FROM"
                              PARAMETER_VALUE = "Workflow Mailer"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "HTMLAGENT"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "HTTP_USER_AGENT"
                              PARAMETER_VALUE = "Mozilla/4.76"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "INBOUND_CONNECTION_TIMEOUT"
                              PARAMETER_VALUE = "120"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "INBOUND_FETCH_SIZE"
                              PARAMETER_VALUE = "100"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "INBOUND_MAX_IGNORE_SIZE"
                              PARAMETER_VALUE = "1000"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "INBOUND_MAX_LOOKUP_CACHE_SIZE"
                              PARAMETER_VALUE = "100"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "INBOUND_MAX_RET_EMAIL_SIZE"
                              PARAMETER_VALUE = "100"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "INBOUND_PASSWORD"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:06:42"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "INBOUND_PROTOCOL"
                              PARAMETER_VALUE = "imap"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:06:42"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "INBOUND_SERVER"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:06:42"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "INBOUND_SSL_ENABLED"
                              PARAMETER_VALUE = "N"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/08/15 07:11:22"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "INBOUND_UNSOLICITED_THRESHOLD"
                              PARAMETER_VALUE = "2"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS


                              BEGIN FND_SVC_COMP_PARAM_VALS "INBOX"
                              PARAMETER_VALUE = "INBOX"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:06:42"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "INLINE_ATTACHMENT"
                              PARAMETER_VALUE = "N"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "MAILER_SSL_TRUSTSTORE"
                              PARAMETER_VALUE = "NONE"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/08/15 07:11:22"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "MAX_INVALID_ADDR_LIST_SIZE"
                              PARAMETER_VALUE = "100"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "MESSAGE_FORMATTER"
                              PARAMETER_VALUE = "oracle.apps.fnd.wf.mailer.NotificationFormatter"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "MORE_INFO_ANSWERED"
                              PARAMETER_VALUE = "WFMAIL:MORE_INFO_ANSWERED"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2008/04/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "NODENAME"
                              PARAMETER_VALUE = "WFMAIL"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "OPEN_INVALID"
                              PARAMETER_VALUE = "WFMAIL:OPEN_INVALID"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "OPEN_INVALID_MORE_INFO"
                              PARAMETER_VALUE = "WFMAIL:OPEN_INVALID_MORE_INFO"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "OPEN_MAIL"
                              PARAMETER_VALUE = "WFMAIL:OPEN_MAIL"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "OPEN_MAIL_DIRECT"
                              PARAMETER_VALUE = "WFMAIL:OPEN_MAIL_DIRECT"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "OPEN_MAIL_FYI"
                              PARAMETER_VALUE = "WFMAIL:OPEN_MAIL_FYI"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "OPEN_MORE_INFO"
                              PARAMETER_VALUE = "WFMAIL:OPEN_MORE_INFO"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "OUTBOUND_CONNECTION_TIMEOUT"
                              PARAMETER_VALUE = "120"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "OUTBOUND_PROTOCOL"
                              PARAMETER_VALUE = "smtp"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:06:42"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "HTML_DELIMITER"
                              PARAMETER_VALUE = "DEFAULT"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:06:42"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "OUTBOUND_SERVER"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:06:42"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "OUTBOUND_USER"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2010/01/29 14:06:42"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "OUTBOUND_PASSWORD"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2010/01/29 14:06:42"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "OUTBOUND_SSL_ENABLED"
                              PARAMETER_VALUE = "N"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/08/15 07:11:22"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "PROCESS"
                              PARAMETER_VALUE = "PROCESS"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:06:42"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "PROCESSOR_DEFER_EVTDATA_READ"
                              PARAMETER_VALUE = "Y"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "PROCESSOR_ERROR_LOOP_SLEEP"
                              PARAMETER_VALUE = "60"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "PROCESSOR_IN_THREAD_COUNT"
                              PARAMETER_VALUE = "1"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "PROCESSOR_LOOP_SLEEP"
                              PARAMETER_VALUE = "5"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "PROCESSOR_MAX_ERROR_COUNT"
                              PARAMETER_VALUE = "10"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "PROCESSOR_MAX_LOOP_SLEEP"
                              PARAMETER_VALUE = "60"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "PROCESSOR_OUT_THREAD_COUNT"
                              PARAMETER_VALUE = "1"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "PROCESSOR_READ_TIMEOUT"
                              PARAMETER_VALUE = "10"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "PROCESSOR_READ_TIMEOUT_CLOSE"
                              PARAMETER_VALUE = "Y"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "REPLYTO"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "RESET_NLS"
                              PARAMETER_VALUE = "N"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "SEND_ACCESS_KEY"
                              PARAMETER_VALUE = "Y"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "SEND_CANCELED_EMAIL"
                              PARAMETER_VALUE = "Y"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/08/23 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "SEND_UNSOLICITED_WARNING"
                              PARAMETER_VALUE = "Y"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/08/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS


                              BEGIN FND_SVC_COMP_PARAM_VALS "SUMHTML"
                              PARAMETER_VALUE = "WFMAIL:SUMHTML"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/03 05:14:18"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "SUMMARY"
                              PARAMETER_VALUE = "WFMAIL:SUMMARY"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "TEST_ADDRESS"
                              PARAMETER_VALUE = "NONE"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:06:42"
                              END FND_SVC_COMP_PARAM_VALS

                              BEGIN FND_SVC_COMP_PARAM_VALS "WARNING"
                              PARAMETER_VALUE = "WFMAIL:WARNING"
                              CUSTOMIZATION_LEVEL = "L"
                              OBJECT_VERSION_NUMBER = "-1"
                              OWNER = "ORACLE"
                              LAST_UPDATE_DATE = "2005/03/29 14:07:23"
                              END FND_SVC_COMP_PARAM_VALS


                              END FND_SVC_COMPONENTS

                              Edited by: 1004455 on 2013-5-7 下午8:47
                              • 12. Re: applying patch 8919491 on apps tier to upgrade from 12.1.1 to 12.1.3 failed
                                User550057 - Oracle
                                if all is ok,can I ignore the errors? If I can,how?

                                thanks a lot
                                • 13. Re: applying patch 8919491 on apps tier to upgrade from 12.1.1 to 12.1.3 failed
                                  Hussein Sawwan-Oracle
                                  Please don't skip the error unless you are instructed to do so by Oracle support -- If this is a test instance, I would personally skip the error and upload the ldt file manaully later.

                                  You can skip the failed worker using adctrl (option 8 which is a hidden option).

                                  Please log a SR for the permanent fix.

                                  Thanks,
                                  Hussein