DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, July 1, 2013

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]

No comments: