Unable to View EXCEL Output (XML Publisher) from Concurrent Program Request
Posted by: Edi Yanto on: December 17, 2008
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 of type 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
6 Responses to "Unable to View EXCEL Output (XML Publisher) from Concurrent Program Request"
July 8, 2011 at 2:40 PM
Halo Edi,
Pake Report Builder malah gak bisa di buka sama sekali.
Tq.
AdeS
July 8, 2011 at 2:55 PM
Halo pak Ade,
Download aja lgsg pll yang sudah gue upload di post itu, tinggal compile aja sesuai script di post juga..
Thanks,
Edi
Leave a Reply
RSS Syndication
Edi Yanto
Oracle Applications Technical Consultant
My Certifications
Recent Comments
- The XML Publisher Concurrent Request Fails Due to the Output Post Processing (OPP)
- BLOB Images in XML Publisher
- Moving Concurrent Programs, Data Definitions and Templates Between eBusiness Suite Instances
- Tuning Dynamic SQL with EXECUTE IMMEDIATE and Cursor Variables
- Receiving and Return Transaction with Receiving Open Interface (ROI)
- Transact Move Order and Ship Confirm Using API
- Spell Number (Function Terbilang)
- Making Custom Reports Oracle Apps Compliant
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
- Tuning PL/SQL Procedure Calls with the NOCOPY Compiler Hint
- Edi Yanto: Hi Mandi, Have you tried the steps on my blog? Please send me your RTF, XML and RDF files to my gmail (edi.y4nto@gmail.com), I'll take a look when I'
- Mandi: Hi Edi, I am trying to incorporate signature and logo for check printing template in R12. I have converted the blob to clob using getbase64 function
- Edi Yanto: Hi Siva, Images on excel output are not scale itself, so you must change the image size according to what you want. More info about excel limitation
Unknown Feed
- An error has occurred; the feed is probably down. Try again later.
Online Apps DBA
- Weekend Online Oracle R12 Apps DBA Training commencing from 03rd June 2012
- Weekend Online Oracle Weblogic Administrator 11g Training commencing from 02 June 2012
- Confused about Oracle IAM software version & release number ?
- ASM block corruption ORA-01115
- Oracle Adaptive Access Manager (OAAM) for beginners
Visitors
Users Online
July 8, 2011 at 2:27 PM
Halo Edi,
Saya coba edit pll pake Form Builder 10 dan compile pake f60gen. Ada Error pada saat compile:
‘PDE-PEP006: Encoded Program unit has an unknown format.’
Ada ide?
Salam,
AdeS