Unable to View EXCEL Output (XML Publisher) from Concurrent Program Request
Posted December 17, 2008on:
While running XML Publisher report for EXCEL output, the Concurrent Program has the error message :
“ORA-1403: no data found”
The cause of this problem has been identified in Bug 4396843 by Metalink.
The output of the report can be viewed from menu Request > Monitor through System Administration Responsibility or you can solve this problem by 2 way :
- Change the length of oftype variable from varchar2(4) to varchar2(5) in editor_pkg2.browser_show() of FNDCONC.PLL or download this fixed file here (remove the extension .odt) and upload it to $AU_TOP/resource. Because output type “EXCEL” can’t be stored in that variable as it exceeds the size of the variable. After that, compile PLL with this syntax: “f60gen module=FNDCONC.pll userid=apps/apps module_type=library batch=yes output_file=FNDCONC.plx compile_all=special“
- Apply patch 4396842 or later