Extension function error: Method not found 'xdo_format_currency'

Scenario :

========

After the upgrade from 12.0.4 to 12.1.3 the custom reports are completed with warning and the request log file show there was an error in OPP and OPP log file shows the following error

OPP Log file error :

=================

Output file was found but is zero sized - Deleted

Request log file :

==============

DOYNODC module: DOYN-Print PO Stand

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

Current system time is 13-JUN-2013 15:39:25

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

| Starting concurrent program execution...

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

Arguments

------------

p_po_num='1239'

p_po_num_to='1239'

------------

Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing

 APPLLCSP Environment Variable set to :

 Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

American_America.UTF8

'.,'

Enter Password: 

Report Builder: Release 10.1.2.3.0 - Production on Thu Jun 13 15:39:32 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

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

Start of log messages from FND_FILE

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

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

End of log messages from FND_FILE

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

Executing request completion options...

Output file size: 

111825

+------------- 1) PUBLISH -------------+

Beginning post-processing of request 12668087 on node DEVSERVER at 13-JUN-2013 15:39:34.

Post-processing of request 12668087 failed at 13-JUN-2013 15:39:36 with the error message:

One or more post-processing actions failed. Consult the OPP service log for details.

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

+------------- 2) PRINT   -------------+

Not printing the output of this request because post-processing failed.

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

Finished executing request completion options.

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

Concurrent request completed

Current system time is 13-JUN-2013 15:39:36

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

OPP log shows the following error :

==================================

[6/13/13 3:09:21 PM] [1651373:RT12668079] Completed post-processing actions for request 12668079.

[6/13/13 3:38:53 PM] [OPPServiceThread1] Post-processing request 12668083.

[6/13/13 3:39:34 PM] [OPPServiceThread0] Post-processing request 12668087.

[6/13/13 3:39:35 PM] [1651373:RT12668087] Executing post-processing actions for request 12668087.

[6/13/13 3:39:35 PM] [1651373:RT12668087] Starting XML Publisher post-processing action.

[6/13/13 3:39:35 PM] [1651373:RT12668087] 

Template code: XXDNPODC

Template app:  XXDN

Language:      en

Territory:     00

Output type:   RTF

[6/13/13 3:39:36 PM] [1651373:RT12668087] Output file was found but is zero sized - Deleted

[6/13/13 3:39:36 PM] [UNEXPECTED] [1651373:RT12668087] java.lang.reflect.InvocationTargetException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

at java.lang.reflect.Method.invoke(Method.java:599)

at oracle.apps.xdo.common.xml.XSLT10gR1.invokeProcessXSL(XSLT10gR1.java:677)

at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:425)

at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:244)

at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:182)

at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)

at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)

at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)

at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1665)

at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)

at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5936)

at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)

at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)

at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:302)

at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)

Caused by: oracle.xdo.parser.v2.XPathException: Extension function error: Method not found 'xdo_format_currency'

at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1534)

at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:521)

at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:489)

at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:271)

at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:155)

at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:192)

... 18 more

Cause :

=======

Templates were not regenerated properly.

Solution :

========

Regenerate templates and try again.

Steps to regenerate templates :

=============================

Responsibility: XML Publisher Administrator

Navigation: Request > Run

Submit Concurrent Process = XML Publisher Template Re-Generator 

Select 'ALL'

Once templates are regenerated test the report again to see if issue is resolved.

Reference :

==========

AR to GL Reconciliation Report Error: Method not found 'xdo_format_currency' [ID 787974.1]