Edi Yanto (何 萬 新)

Unable to View EXCEL Output (XML Publisher) from Concurrent Program Request

Posted 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 :

  1. 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
  2. Apply patch 4396842 or later

6 Responses to "Unable to View EXCEL Output (XML Publisher) from Concurrent Program Request"

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

Like

Dear Ade.

Edit pll pake Report Builder….

Thanks,
Edi

Like

Halo Edi,

Pake Report Builder malah gak bisa di buka sama sekali.
Tq.

AdeS

Like

Halo pak Ade,

Download aja lgsg pll yang sudah gue upload di post itu, tinggal compile aja sesuai script di post juga..

Thanks,
Edi

Like

OK. Berhasil. Terima kasih Edi.
Salam

AdeS

Like

Sama2 pak Ade, keep contact always ya…

Thanks,
Edi

Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,368 other followers


Edi Yanto
Oracle Applications Technical Consultant
View Edi Yanto's profile on LinkedIn

My Certifications






Follow me on Twitter

Archives

December 2008
M T W T F S S
« Nov   Jan »
1234567
891011121314
15161718192021
22232425262728
293031  

Visitors

Categories

Blog Stats

  • 140,585 hits

Users Online

web counter

Pages

%d bloggers like this: