Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem:
Upgrade to R12.1.1 failed with while running IGSAD4495730A.sql with error ORA-20100: Error due to ORA-06502: PL/SQL: numeric or value error: character to
number conversion error
Symptoms:
sqlplus -s APPS/***** @/ezwr12/apps/apps_st/appl/igs/12.0.0/patch/115/sql/IGSAD4495730A.sql
DECLARE
*
ERROR at line 1:
ORA-20100: Error due to ORA-06502: PL/SQL: numeric or value error: character to
number conversion error
ORA-06512: at line 149
From Note.1127593.1 Ext/Pub R12.1 Oracle Financials Pre-Upgrade Patch Supplemental List for EBS CUP:
R12.1: Oracle Financials Pre-Upgrade Patch Supplemental List for EBS CUP
The following Release 12.1 Oracle Financials pre-upgrade patches should be applied on top of the EBS Consolidated Upgrade Patch (see Doc ID 798258.1). These pre-upgrade patches apply to the Oracle Financials Release 11i to Release 12.1 upgrade.
Patch is therefore post upgrade requirement.
Bug: 8871012 definitely references: 12.0 8871012:R12.CE.B Standalone
as a solution to the problem when the upgrade script fails.
Intention must be to skip the script and apply 8871012:R12.CE.B later.
The bug update isn't clear.
Solution:
It appears that patch 8871012:R12.CE.B is a post upgrade solution. I apologise for any confusion.
1. Stop the patch 8871012:R12.CE.B
2. Reinstate the upgrade driver files as directed in note 175485.1
3. Once the upgrade driver is restarted use adctrl hidden option number 8 to skip the script cecestmt.sql
4. Once the upgrade driver is finished and the upgrade complete, then apply 8871012:R12.CE.B as a post upgrade solution.
. Use adctrl hidden option number 8 to skip the script cecestmt.sql
. Once the upgrade driver is finished and the upgrade complete, then apply 8871012:R12.CE.B as a post upgrade solution.
References:
Bug 8871012. documents the problem.
++ 1. Description
-> Upgrade process was failing because of the technical error
-> in cecestmt.sql.
-> The statement numbers when appended with org_id resulted in
-> more than 50 chars
-> The statement number column was having a length of
-> varchar2(50) when appened with the org_id, the length
-> exceeded the 50 characters.
Upgrade to R12.1.1 failed with while running IGSAD4495730A.sql with error ORA-20100: Error due to ORA-06502: PL/SQL: numeric or value error: character to
number conversion error
Symptoms:
sqlplus -s APPS/***** @/ezwr12/apps/apps_st/appl/igs/12.0.0/patch/115/sql/IGSAD4495730A.sql
DECLARE
*
ERROR at line 1:
ORA-20100: Error due to ORA-06502: PL/SQL: numeric or value error: character to
number conversion error
ORA-06512: at line 149
From Note.1127593.1 Ext/Pub R12.1 Oracle Financials Pre-Upgrade Patch Supplemental List for EBS CUP:
R12.1: Oracle Financials Pre-Upgrade Patch Supplemental List for EBS CUP
The following Release 12.1 Oracle Financials pre-upgrade patches should be applied on top of the EBS Consolidated Upgrade Patch (see Doc ID 798258.1). These pre-upgrade patches apply to the Oracle Financials Release 11i to Release 12.1 upgrade.
Patch is therefore post upgrade requirement.
Bug: 8871012 definitely references: 12.0 8871012:R12.CE.B Standalone
as a solution to the problem when the upgrade script fails.
Intention must be to skip the script and apply 8871012:R12.CE.B later.
The bug update isn't clear.
Solution:
It appears that patch 8871012:R12.CE.B is a post upgrade solution. I apologise for any confusion.
1. Stop the patch 8871012:R12.CE.B
2. Reinstate the upgrade driver files as directed in note 175485.1
3. Once the upgrade driver is restarted use adctrl hidden option number 8 to skip the script cecestmt.sql
4. Once the upgrade driver is finished and the upgrade complete, then apply 8871012:R12.CE.B as a post upgrade solution.
. Use adctrl hidden option number 8 to skip the script cecestmt.sql
. Once the upgrade driver is finished and the upgrade complete, then apply 8871012:R12.CE.B as a post upgrade solution.
References:
Bug 8871012. documents the problem.
++ 1. Description
-> Upgrade process was failing because of the technical error
-> in cecestmt.sql.
-> The statement numbers when appended with org_id resulted in
-> more than 50 chars
-> The statement number column was having a length of
-> varchar2(50) when appened with the org_id, the length
-> exceeded the 50 characters.
No comments:
Post a Comment