13563833:R12.CE.B fails ORA-06512: at "APPS.GL_CURRENCY_API"
Aparna says:The DBA encountered an error when applying Patch 13563833:R12.CE.B
This patch failed with the following error:
sqlplus -s APPS/***** @/prodfs/app/PROD/apps/apps_st/appl/ce/12.0.0/patch/115/sql/ceactupg.sql
Connected.
BEGIN
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.GL_CURRENCY_API", line 393
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.GL_CURRENCY_API", line 318
ORA-01403: no data found
ORA-06512: at line 2376
Customer tried the solution in PC thread:
https://communities.oracle.com/portal/server.pt/community/view_discussion_topic/216?threadid=450510&Portlet=Search Results&PrevPage=Communities-Search
**************
Solution is the following (please backup the related tables)