Failure of data merge utility during autoupgrade 10.7 to 11.0.5

From: <david.morgan_at_eu.sony.com>
Date: 12 Nov 2003 08:05:46 -0800
Message-ID: <d1e424f6.0311120805.3b912c97@posting.google.com>

Upgrade Oracle APPS 10.7 to 11.5.9 Problem with Datamerge utility Running HP_UX 11.11 RDBMS 8.1.7.4

Hi when running autoupgrade to upgrade the Oracle apps db from 10.7 db to 11.5.0

I keep on getting failure during run of datamerge utility addmimp

Error log is below.

Metalink points to variable $APPLTMP not being set or incorrect permissions. (metalink notes 1016296.102 and 1031161.6 )

I have tested this. Applmgr user can write to appltmp

touch $APPLTMP/test creates a file in the temp area.

That's all I have to go on I'm afraid.

Anyone out there come across this problem..

Davo
Sony Corp

DataMerge - dmmactfl: INFO: Failed to get temporary filename for action buffer.

DataMerge - dmmcep: ERROR: Error during first pass.

Start time for file is: Wed Nov 05 2003 09:50:35

HIDEPW: /star01/app/PCDPROD/appltop//ad/11.5.0/bin/addmimp target=APPS/***** control=afnlsa.ctl export=afnlsa.exp parameter=afnlsa.dat
log=/star01/app/PCDPROD/appltop/admin/PCDPROD/log/afnlsa.log summary=/star01/app/PCDPROD/appltop/admin/PCDPROD/log/afnlsa.sum /star01/app/PCDPROD/appltop//ad/11.5.0/bin/addmimp target=APPS/***** control=afnlsa.ctl export=afnlsa.exp parameter=afnlsa.dat log=/star01/app/PCDPROD
/appltop/admin/PCDPROD/log/afnlsa.log
summary=/star01/app/PCDPROD/appltop/admin/PCDPROD/log/afnlsa.sum Connecting to APPS/APPS...
Reading table FND_CURRENCIES ...
Reading table FND_LANGUAGES ...

Reading table FND_CURRENCIES ...
Reading table FND_LANGUAGES ...
Reading table FND_TERRITORIES ...
Reading table FND_TRANSLATION_EXCEPTIONS ...
Reading table FND_NEW_MESSAGES ...
Reading table FND_CURRENCIES_TL ...
Reading table FND_LANGUAGES_TL ...
Reading table FND_TERRITORIES_TL ...
Reading view FND_CURRENCIES_VL ...
Reading view FND_CURRENCIES_ACTIVE_MONET_V ...
Reading view FND_CURRENCIES_ACTIVE_V ...
Reading view FND_TERRITORIES_VL ...

Reading view FND_LANGUAGES_VL ...
Reading privilege set Default ...

 ###################################

Merging Building Block NLS.
Building the member network for building block NLS.

Processing Table FND_LANGUAGES.

(Wed Nov 05 2003 09:50:35)

First pass for table FND_LANGUAGES

DataMerge - dmmsrcms: INFO: The Source Fetch Buffer select SQL statement is:
SELECT ROWID,

        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        LANGUAGE_CODE,
        LANGUAGE_ID

FROM FND_LANGUAGES DataMerge - dmmtarms: INFO: The Target Fetch Buffer select SQL statement is:
SELECT T.ROWID,

        T.LAST_UPDATED_BY,
        T.CREATION_DATE,
        T.CREATED_BY,

        T.CREATION_DATE,
        T.CREATED_BY,
        T.LANGUAGE_CODE,
        T.LANGUAGE_ID

FROM APPS.FND_LANGUAGES T
ORDER BY T.LANGUAGE_CODE DataMerge - dmmsrcfch: INFO: Source Buffer: Read #1 for 5405 rows

DataMerge - dmmtarfch: INFO: Target Buffer: Fetch #1 for 4723 rows

Total Rows in Source Buffer: 37

Total Rows in Target Buffer: 37

  Insert new rows:               Yes;  Resolve mismatched rows:  Yes;
  Delete - obsolete rows:        Yes;  obsolete customized:      Yes;
  Delete - added rows:           Yes;
  Update - out-of-date rows:     Yes;  modified rows:            Yes;
  Update - added rows:           Yes;  unchanged customized:     No ;

  Update - out-of-date rows:     Yes;  modified rows:            Yes;
  Update - added rows:           Yes;  unchanged customized:     No ;

  Insert new rows:                 0;  Matching rows:             37;
  Resolve mismatched rows:         0;
  Delete - obsolete rows:          0;  obsolete customized:        0;
  Delete - added rows:             0;
  Update - out-of-date rows:       0;  modified rows:              0;
  Update - added rows:             0;  unchanged customized:       0;

                            Total actions: 0;

Second pass for table FND_LANGUAGES

(Wed Nov 05 2003 09:50:35)

Processing Table FND_TERRITORIES.

(Wed Nov 05 2003 09:50:35)

First pass for table FND_TERRITORIES
First pass for table FND_TERRITORIES

DataMerge - dmmsrcms: INFO: The Source Fetch Buffer select SQL statement is:
SELECT ROWID,

        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        TERRITORY_CODE

FROM FND_TERRITORIES DataMerge - dmmtarms: INFO: The Target Fetch Buffer select SQL statement is:
SELECT T.ROWID,

        T.LAST_UPDATED_BY,
        T.CREATION_DATE,
        T.CREATED_BY,
        T.TERRITORY_CODE
FROM APPS.FND_TERRITORIES T

ORDER BY T.TERRITORY_CODE DataMerge - dmmsrcfch: INFO: Source Buffer: Read #1 for 7598 rows

DataMerge - dmmsrcfch: INFO: Source Buffer: Read #1 for 7598 rows

DataMerge - dmmtarfch: INFO: Target Buffer: Fetch #1 for 6316 rows

Total Rows in Source Buffer: 242

Total Rows in Target Buffer: 242

  Insert new rows:               Yes;  Resolve mismatched rows:  Yes;
  Delete - obsolete rows:        No ;  obsolete customized:      No ;
  Delete - added rows:           No ;
  Update - out-of-date rows:     Yes;  modified rows:            Yes;
  Update - added rows:           Yes;  unchanged customized:     No ;

  Insert new rows:                 0;  Matching rows:            242;
  Resolve mismatched rows:         0;
  Delete - obsolete rows:          0;  obsolete customized:        0;
  Delete - added rows:             0;
  Update - out-of-date rows:       0;  modified rows:              0;
  Update - added rows:             0;  unchanged customized:       0;

  Update - out-of-date rows:       0;  modified rows:              0;
  Update - added rows:             0;  unchanged customized:       0;

                            Total actions: 0;

Second pass for table FND_TERRITORIES

(Wed Nov 05 2003 09:50:35)

Processing Table FND_TRANSLATION_EXCEPTIONS.

(Wed Nov 05 2003 09:50:35)

First pass for table FND_TRANSLATION_EXCEPTIONS

DataMerge - dmmsrcms: INFO: The Source Fetch Buffer select SQL statement is:
SELECT ROWID,

        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        APPLICATION_ID,

        CREATED_BY,
        APPLICATION_ID,
        TABLE_ID,
        COLUMN_ID,
        SEQUENCE,
        TYPE

FROM FND_TRANSLATION_EXCEPTIONS DataMerge - dmmtarms: INFO: The Target Fetch Buffer select SQL statement is:
SELECT T.ROWID,

        T.LAST_UPDATED_BY,
        T.CREATION_DATE,
        T.CREATED_BY,
        T.APPLICATION_ID,
        T.TABLE_ID,
        T.COLUMN_ID,
        T.SEQUENCE,
        T.TYPE
FROM APPS.FND_TRANSLATION_EXCEPTIONS T
ORDER BY T.APPLICATION_ID,
        T.TABLE_ID,
        T.COLUMN_ID,

        T.TABLE_ID,
        T.COLUMN_ID,
        T.SEQUENCE,
        T.TYPE

DataMerge - dmmsrcfch: INFO: Source Buffer: Read #1 for 3177 rows

DataMerge - dmmtarfch: INFO: Target Buffer: Fetch #1 for 2928 rows

Total Rows in Source Buffer: 16

Total Rows in Target Buffer: 16

  Insert new rows:               Yes;  Resolve mismatched rows:  Yes;
  Delete - obsolete rows:        Yes;  obsolete customized:      Yes;
  Delete - added rows:           Yes;
  Update - out-of-date rows:     Yes;  modified rows:            Yes;
  Update - added rows:           Yes;  unchanged customized:     Yes;

  Insert new rows:                 0;  Matching rows:             16;


  Insert new rows:                 0;  Matching rows:             16;
  Resolve mismatched rows:         0;
  Delete - obsolete rows:          0;  obsolete customized:        0;
  Delete - added rows:             0;
  Update - out-of-date rows:       0;  modified rows:              0;
  Update - added rows:             0;  unchanged customized:       0;

                            Total actions: 0;

Second pass for table FND_TRANSLATION_EXCEPTIONS

(Wed Nov 05 2003 09:50:35)

Processing Table FND_CURRENCIES.

(Wed Nov 05 2003 09:50:35)

First pass for table FND_CURRENCIES

DataMerge - dmmsrcms: INFO: The Source Fetch Buffer select SQL statement is:

DataMerge - dmmsrcms: INFO: The Source Fetch Buffer select SQL statement is:
SELECT ROWID,

        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        CURRENCY_CODE

FROM FND_CURRENCIES DataMerge - dmmtarms: INFO: The Target Fetch Buffer select SQL statement is:
SELECT T.ROWID,

        T.LAST_UPDATED_BY,
        T.CREATION_DATE,
        T.CREATED_BY,
        T.CURRENCY_CODE
FROM APPS.FND_CURRENCIES T

ORDER BY T.CURRENCY_CODE DataMerge - dmmsrcfch: INFO: Source Buffer: Read #1 for 6168 rows

DataMerge - dmmtarfch: INFO: Target Buffer: Fetch #1 for 5295 rows

Total Rows in Source Buffer: 219

Total Rows in Target Buffer: 219

  Insert new rows:               Yes;  Resolve mismatched rows:  Yes;
  Delete - obsolete rows:        No ;  obsolete customized:      No ;
  Delete - added rows:           No ;
  Update - out-of-date rows:     Yes;  modified rows:            No ;
  Update - added rows:           No ;  unchanged customized:     No ;

  Insert new rows:                 0;  Matching rows:            219;
  Resolve mismatched rows:         0;
  Delete - obsolete rows:          0;  obsolete customized:        0;
  Delete - added rows:             0;
  Update - out-of-date rows:       0;  modified rows:              0;
  Update - added rows:             0;  unchanged customized:       0;

                            Total actions: 0;


                            Total actions: 0;

Second pass for table FND_CURRENCIES

(Wed Nov 05 2003 09:50:35)

Processing Table FND_NEW_MESSAGES.

(Wed Nov 05 2003 09:50:35)

First pass for table FND_NEW_MESSAGES

DataMerge - dmmsrcms: INFO: The Source Fetch Buffer select SQL statement is:
SELECT ROWID,

        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        APPLICATION_ID,
        MESSAGE_NAME,
        LANGUAGE_CODE

        MESSAGE_NAME,
        LANGUAGE_CODE

FROM FND_NEW_MESSAGES DataMerge - dmmtarms: INFO: The Target Fetch Buffer select SQL statement is:
SELECT T.ROWID,

        T.LAST_UPDATED_BY,
        T.CREATION_DATE,
        T.CREATED_BY,
        T.APPLICATION_ID,
        T.MESSAGE_NAME,
        T.LANGUAGE_CODE
FROM APPS.FND_NEW_MESSAGES T

WHERE application_id in
(-2,-1,0,1,3,50,101,140,160,168,175,178,185,190,191,200,201,202,222,240,250,260,275,279,293,300,385,388,401,410,450,452,453,55

0,551,552,553,554,555,556,557,558,600,601,602,660,661,662,663,665,700,702,703,704,705,706,707,708,710,711,712,714,722,723,724,725,777,800,801,802,803,
804,805,808,810,7000,7002,7003,7004,8301) and language_code='US'
ORDER BY T.APPLICATION_ID,
        T.MESSAGE_NAME,
        T.LANGUAGE_CODE

DataMerge - dmmsrcfch: INFO: Source Buffer: Read #1 for 4002 rows

DataMerge - dmmtarfch: INFO: Target Buffer: Fetch #1 for 3615 rows

DataMerge - dmmsrcfch: INFO: Source Buffer: Read #2 for 4002 rows

DataMerge - dmmtarfch: INFO: Target Buffer: Fetch #2 for 3615 rows

DataMerge - dmmsrcfch: INFO: Source Buffer: Read #3 for 4002 rows

DataMerge - dmmsrcfch: INFO: Source Buffer: Read #4 for 4002 rows

DataMerge - dmmtarfch: INFO: Target Buffer: Fetch #3 for 3615 rows

DataMerge - dmmsrcfch: INFO: Source Buffer: Read #5 for 4002 rows

DataMerge - dmmsrcfch: INFO: Source Buffer: Read #6 for 4002 rows

DataMerge - dmmtarfch: INFO: Target Buffer: Fetch #4 for 3615 rows

DataMerge - dmmsrcfch: INFO: Source Buffer: Read #7 for 4002 rows

DataMerge - dmmsrcfch: INFO: Source Buffer: Read #8 for 4002 rows

DataMerge - dmmsrcfch: INFO: Source Buffer: Read #9 for 4002 rows

DataMerge - dmmtarfch: INFO: Target Buffer: Fetch #5 for 3615 rows

DataMerge - dmmsrcfch: INFO: Source Buffer: Read #10 for 4002 rows

DataMerge - dmmtarfch: INFO: Target Buffer: Fetch #6 for 3615 rows

DataMerge - dmmsrcfch: INFO: Source Buffer: Read #11 for 4002 rows

DataMerge - dmmactfl: INFO: Failed to get temporary filename for action buffer.

DataMerge - dmmcep: ERROR: Error during first pass.

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                               DataMerge Utility

                                 Version 11.5.0


                                 Version 11.5.0

NOTE: You may not use this utility for custom development
      unless you have written permission from Oracle Corporation.

Time when worker failed: Wed Nov 05 2003 09:50:37

Restarting job that failed and was fixed.

Time when worker restarted job: Wed Nov 05 2003 09:50:40

Start time for file is: Wed Nov 05 2003 09:50:40

HIDEPW: /star01/app/PCDPROD/appltop//ad/11.5.0/bin/addmimp target=APPS/APPS control=afnlsa.ctl export=afnlsa.exp parameter=afnlsa.dat log=/star01/app/
PCDPROD/appltop/admin/PCDPROD/log/afnlsa.log summary=/star01/app/PCDPROD/appltop/admin/PCDPROD/log/afnlsa.sum /star01/app/PCDPROD/appltop//ad/11.5.0/bin/addmimp target=APPS/***** control=afnlsa.ctl export=afnlsa.exp parameter=afnlsa.dat log=/star01/app/PCDPROD
/appltop/admin/PCDPROD/log/afnlsa.log
summary=/star01/app/PCDPROD/appltop/admin/PCDPROD/log/afnlsa.sum Connecting to APPS/APPS...

/star01/app/PCDPROD/appltop//ad/11.5.0/bin/addmimp target=APPS/***** control=afnlsa.ctl export=afnlsa.exp parameter=afnlsa.dat log=/star01/app/PCDPROD
/appltop/admin/PCDPROD/log/afnlsa.log
summary=/star01/app/PCDPROD/appltop/admin/PCDPROD/log/afnlsa.sum Connecting to APPS/APPS...

Reading table FND_CURRENCIES ...
Reading table FND_LANGUAGES ...
Reading table FND_TERRITORIES ...
Reading table FND_TRANSLATION_EXCEPTIONS ...
Reading table FND_NEW_MESSAGES ...
Reading table FND_CURRENCIES_TL ...
Reading table FND_LANGUAGES_TL ...
Reading table FND_TERRITORIES_TL ...
Reading view FND_CURRENCIES_VL ...
Reading view FND_CURRENCIES_ACTIVE_MONET_V ...
Reading view FND_CURRENCIES_ACTIVE_V ...
Reading view FND_TERRITORIES_VL ...

Reading view FND_LANGUAGES_VL ...
Reading privilege set Default ...

 ###################################

Merging Building Block NLS.
Building the member network for building block NLS.
Building the member network for building block NLS.

Processing Table FND_LANGUAGES.

(Wed Nov 05 2003 09:50:40)

First pass for table FND_LANGUAGES

DataMerge - dmmsrcms: INFO: The Source Fetch Buffer select SQL statement is:
SELECT ROWID,

        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        LANGUAGE_CODE,
        LANGUAGE_ID

FROM FND_LANGUAGES DataMerge - dmmtarms: INFO: The Target Fetch Buffer select SQL statement is:
SELECT T.ROWID, DataMerge - dmmtarms: INFO: The Target Fetch Buffer select SQL statement is:
SELECT T.ROWID,

        T.LAST_UPDATED_BY,
        T.CREATION_DATE,
        T.CREATED_BY,
        T.LANGUAGE_CODE,
        T.LANGUAGE_ID
FROM APPS.FND_LANGUAGES T

ORDER BY T.LANGUAGE_CODE DataMerge - dmmsrcfch: INFO: Source Buffer: Read #1 for 5405 rows

DataMerge - dmmtarfch: INFO: Target Buffer: Fetch #1 for 4723 rows

Total Rows in Source Buffer: 37

Total Rows in Target Buffer: 37

  Insert new rows:               Yes;  Resolve mismatched rows:  Yes;
  Delete - obsolete rows:        Yes;  obsolete customized:      Yes;

  Insert new rows:               Yes;  Resolve mismatched rows:  Yes;
  Delete - obsolete rows:        Yes;  obsolete customized:      Yes;
  Delete - added rows:           Yes;
  Update - out-of-date rows:     Yes;  modified rows:            Yes;
  Update - added rows:           Yes;  unchanged customized:     No ;

  Insert new rows:                 0;  Matching rows:             37;
  Resolve mismatched rows:         0;
  Delete - obsolete rows:          0;  obsolete customized:        0;
  Delete - added rows:             0;
  Update - out-of-date rows:       0;  modified rows:              0;
  Update - added rows:             0;  unchanged customized:       0;

                            Total actions: 0;

Second pass for table FND_LANGUAGES

(Wed Nov 05 2003 09:50:40)

Processing Table FND_TERRITORIES.
Processing Table FND_TERRITORIES.

(Wed Nov 05 2003 09:50:40)

First pass for table FND_TERRITORIES

DataMerge - dmmsrcms: INFO: The Source Fetch Buffer select SQL statement is:
SELECT ROWID,

        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        TERRITORY_CODE

FROM FND_TERRITORIES DataMerge - dmmtarms: INFO: The Target Fetch Buffer select SQL statement is:
SELECT T.ROWID,

        T.LAST_UPDATED_BY,
        T.CREATION_DATE,
        T.CREATED_BY,
        T.TERRITORY_CODE
FROM APPS.FND_TERRITORIES T

ORDER BY T.TERRITORY_CODE FROM APPS.FND_TERRITORIES T
ORDER BY T.TERRITORY_CODE DataMerge - dmmsrcfch: INFO: Source Buffer: Read #1 for 7598 rows

DataMerge - dmmtarfch: INFO: Target Buffer: Fetch #1 for 6316 rows

Total Rows in Source Buffer: 242

Total Rows in Target Buffer: 242

  Insert new rows:               Yes;  Resolve mismatched rows:  Yes;
  Delete - obsolete rows:        No ;  obsolete customized:      No ;
  Delete - added rows:           No ;
  Update - out-of-date rows:     Yes;  modified rows:            Yes;
  Update - added rows:           Yes;  unchanged customized:     No ;

  Insert new rows:                 0;  Matching rows:            242;
  Resolve mismatched rows:         0;
  Delete - obsolete rows:          0;  obsolete customized:        0;

  Resolve mismatched rows:         0;
  Delete - obsolete rows:          0;  obsolete customized:        0;
  Delete - added rows:             0;
  Update - out-of-date rows:       0;  modified rows:              0;
  Update - added rows:             0;  unchanged customized:       0;

                            Total actions: 0;

Second pass for table FND_TERRITORIES

(Wed Nov 05 2003 09:50:40)

Processing Table FND_TRANSLATION_EXCEPTIONS.

(Wed Nov 05 2003 09:50:40)

First pass for table FND_TRANSLATION_EXCEPTIONS

DataMerge - dmmsrcms: INFO: The Source Fetch Buffer select SQL statement is:
SELECT ROWID,
LAST_UPDATED_BY, SELECT ROWID,

        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        APPLICATION_ID,
        TABLE_ID,
        COLUMN_ID,
        SEQUENCE,
        TYPE

FROM FND_TRANSLATION_EXCEPTIONS DataMerge - dmmtarms: INFO: The Target Fetch Buffer select SQL statement is:
SELECT T.ROWID,

        T.LAST_UPDATED_BY,
        T.CREATION_DATE,
        T.CREATED_BY,
        T.APPLICATION_ID,
        T.TABLE_ID,
        T.COLUMN_ID,
        T.SEQUENCE,
        T.TYPE
FROM APPS.FND_TRANSLATION_EXCEPTIONS T

        T.TYPE

FROM APPS.FND_TRANSLATION_EXCEPTIONS T
ORDER BY T.APPLICATION_ID,

        T.TABLE_ID,
        T.COLUMN_ID,
        T.SEQUENCE,
        T.TYPE

DataMerge - dmmsrcfch: INFO: Source Buffer: Read #1 for 3177 rows

DataMerge - dmmtarfch: INFO: Target Buffer: Fetch #1 for 2928 rows

Total Rows in Source Buffer: 16

Total Rows in Target Buffer: 16

  Insert new rows:               Yes;  Resolve mismatched rows:  Yes;
  Delete - obsolete rows:        Yes;  obsolete customized:      Yes;
  Delete - added rows:           Yes;
  Update - out-of-date rows:     Yes;  modified rows:            Yes;

  Delete - added rows:           Yes;
  Update - out-of-date rows:     Yes;  modified rows:            Yes;
  Update - added rows:           Yes;  unchanged customized:     Yes;

  Insert new rows:                 0;  Matching rows:             16;
  Resolve mismatched rows:         0;
  Delete - obsolete rows:          0;  obsolete customized:        0;
  Delete - added rows:             0;
  Update - out-of-date rows:       0;  modified rows:              0;
  Update - added rows:             0;  unchanged customized:       0;

                            Total actions: 0;

Second pass for table FND_TRANSLATION_EXCEPTIONS

(Wed Nov 05 2003 09:50:40)

Processing Table FND_CURRENCIES.

(Wed Nov 05 2003 09:50:40)

First pass for table FND_CURRENCIES

DataMerge - dmmsrcms: INFO: The Source Fetch Buffer select SQL statement is:
SELECT ROWID,

        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        CURRENCY_CODE

FROM FND_CURRENCIES DataMerge - dmmtarms: INFO: The Target Fetch Buffer select SQL statement is:
SELECT T.ROWID,

        T.LAST_UPDATED_BY,
        T.CREATION_DATE,
        T.CREATED_BY,
        T.CURRENCY_CODE
FROM APPS.FND_CURRENCIES T

ORDER BY T.CURRENCY_CODE DataMerge - dmmsrcfch: INFO: Source Buffer: Read #1 for 6168 rows

DataMerge - dmmsrcfch: INFO: Source Buffer: Read #1 for 6168 rows

DataMerge - dmmtarfch: INFO: Target Buffer: Fetch #1 for 5295 rows

Total Rows in Source Buffer: 219

Total Rows in Target Buffer: 219

  Insert new rows:               Yes;  Resolve mismatched rows:  Yes;
  Delete - obsolete rows:        No ;  obsolete customized:      No ;
  Delete - added rows:           No ;
  Update - out-of-date rows:     Yes;  modified rows:            No ;
  Update - added rows:           No ;  unchanged customized:     No ;

  Insert new rows:                 0;  Matching rows:            219;
  Resolve mismatched rows:         0;
  Delete - obsolete rows:          0;  obsolete customized:        0;
  Delete - added rows:             0;
  Update - out-of-date rows:       0;  modified rows:              0;

  Delete - added rows:             0;
  Update - out-of-date rows:       0;  modified rows:              0;
  Update - added rows:             0;  unchanged customized:       0;

                            Total actions: 0;

Second pass for table FND_CURRENCIES

(Wed Nov 05 2003 09:50:40)

Processing Table FND_NEW_MESSAGES.

(Wed Nov 05 2003 09:50:40)

First pass for table FND_NEW_MESSAGES

DataMerge - dmmsrcms: INFO: The Source Fetch Buffer select SQL statement is:
SELECT ROWID,

        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,

        CREATION_DATE,
        CREATED_BY,
        APPLICATION_ID,
        MESSAGE_NAME,
        LANGUAGE_CODE

FROM FND_NEW_MESSAGES DataMerge - dmmtarms: INFO: The Target Fetch Buffer select SQL statement is:
SELECT T.ROWID,

        T.LAST_UPDATED_BY,
        T.CREATION_DATE,
        T.CREATED_BY,
        T.APPLICATION_ID,
        T.MESSAGE_NAME,
        T.LANGUAGE_CODE
FROM APPS.FND_NEW_MESSAGES T

WHERE application_id in
(-2,-1,0,1,3,50,101,140,160,168,175,178,185,190,191,200,201,202,222,240,250,260,275,279,293,300,385,388,401,410,450,452,453,55

0,551,552,553,554,555,556,557,558,600,601,602,660,661,662,663,665,700,702,703,704,705,706,707,708,710,711,712,714,722,723,724,725,777,800,801,802,803,
804,805,808,810,7000,7002,7003,7004,8301) and language_code='US'
ORDER BY T.APPLICATION_ID,
        T.MESSAGE_NAME,
        T.LANGUAGE_CODE

        T.MESSAGE_NAME,
        T.LANGUAGE_CODE