Re: EBS 12.2.0 NLS did not go through successfully

Posted by Max on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/EBS-12-2-0-NLS-did-not-go-through-successfully-tp216p285.html

Hi. Something strange happening. Since last error I've just replace whole installation. I mean delete old installation and untar new installation from 12.2.4 tar without NLS. So I've taken NLS patch V36823-01 from edelivery.oracle.com just for test. And now I have different error.

adop phase=apply patches=10124646_RU:u10124646.drv hotpatch=yes restart=no wait_on_failed_job=yes workers=5

log file is: /opt/vis13/fs_ne/EBSapps/log/adop/3/apply_20150410_164848/VIS13_db3h-dev/10124646_RU/log/u10124646.log

and error is:

Time is: Fri Apr 10 2015 17:01:16

   FAILED: file cua12alu.ldt on worker  4 for product cua username APPS.

Time is: Fri Apr 10 2015 17:01:16

 Deferred: file cua12alu.ldt on worker  4 for product cua username APPS.

Time is: Fri Apr 10 2015 17:01:16
               (Deferment number 2 for this job)
 Assigned: file fa12alu.ldt  on worker  4 for product fa  username APPS.

Time is: Fri Apr 10 2015 17:01:16

   FAILED: file zxcfctbc.ldt on worker  1 for product zx  username APPS.
...
....
......
....
......

ATTENTION: All workers either have failed or are waiting:

           FAILED: file arirulob.ldt on worker  1.
           FAILED: file cua12alu.ldt on worker  2.
           FAILED: file zxcfctbc.ldt on worker  3.
           FAILED: file fa12alu.ldt  on worker  4.
           FAILED: file falookupjp.ldt on worker  5.

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

Current time is: Fri Apr 10 2015 17:01:19


So lets see what happened in worker 4

less /opt/vis13/fs_ne/EBSapps/log/adop/3/apply_20150410_164848/VIS13_db3h-dev/10124646_RU/log/adwork004.log

Loading data using  FNDLOAD function.
**** Reseting package states in the current session ****

FNDLOAD APPS/***** 0 Y UPLOAD @OFA:patch/115/import/falku2.lct @CUA:patch/115/import/RU/cua12alu.ldt - UPLOAD_MODE=NLS WARNINGS=TRUE

Calling FNDLOAD function.

Returned from FNDLOAD function.

Log file: /opt/vis13/fs_ne/EBSapps/log/adop/3/apply_20150410_164848/VIS13_db3h-dev/10124646_RU/log/RU_cua12alu_ldt.log
Error calling FNDLOAD function.


Time when worker failed: Fri Apr 10 2015 17:01:16


Time when worker started job: Fri Apr 10 2015 17:01:16

Loading data using  FNDLOAD function.
**** Reseting package states in the current session ****

FNDLOAD APPS/***** 0 Y UPLOAD @OFA:patch/115/import/falku2.lct @OFA:patch/115/import/RU/fa12alu.ldt - UPLOAD_MODE=NLS WARNINGS=TRUE

Calling FNDLOAD function.

Returned from FNDLOAD function.

Log file: /opt/vis13/fs_ne/EBSapps/log/adop/3/apply_20150410_164848/VIS13_db3h-dev/10124646_RU/log/RU_fa12alu_ldt.log
Error calling FNDLOAD function.


But if I execute this FNDLOAD manually all is ok!

$ FNDLOAD APPS/APPS 0 Y UPLOAD @OFA:patch/115/import/falku2.lct @CUA:patch/115/import/RU/cua12alu.ldt - UPLOAD_MODE=NLS WARNINGS=TRUE
Log filename : L7457269.log


Report filename : O7457269.out


And no errors in the log file.

+---------------------------------------------------------------------------+
Application Object Library: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDLOAD: Generic Loader
+---------------------------------------------------------------------------+

Current system time is 10-APR-2015 17:10:10

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

Uploading from the data file /opt/vis13/fs1/EBSapps/appl/cua/12.0.0/patch/115/import/RU/cua12alu.ldt
Altering database NLS_LANGUAGE environment to RUSSIAN
Dump from LCT/LDT files (/opt/vis13/fs1/EBSapps/appl/fa/12.0.0/patch/115/import/falku2.lct(120.1), /opt/vis13/fs1/EBSapps/appl/cua/12.0.0/patch/115/import/RU/cua12alu.ldt) to stage tables
Dump LCT file /opt/vis13/fs1/EBSapps/appl/fa/12.0.0/patch/115/import/falku2.lct(120.1) into FND_SEED_STAGE_CONFIG
Dump LDT file /opt/vis13/fs1/EBSapps/appl/cua/12.0.0/patch/115/import/RU/cua12alu.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (FA_LOOKUP_TYPES IFA_HR_EVENT_CODE , FA_LOOKUPS RETIREMENT ) into FND_SEED_STAGE_ENTITY
Upload from stage tables

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 10-APR-2015 17:10:10

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