[kumar]

Hi all,

I have created a report with parameters which is working fine in report builder and the same report i attached in OTM but When i run the report from OTM following error occured

"REP-771: 'afterpform': Fatal PL/SQL error occurred."

Kindly help me.

Thanks in advance!!!
Kumar

[manish_shriv]

This error seems to be your code related. When you run the report in report building use the same parameter that you are using in OTM. May be you will detect the problem. good luck

[oleemin]

I have encounter REP-771: 'afterpform': Fatal PL/SQL error occurred in reports as well. The report usually works fine but intermittently will have this error. Report is link to ID Automation barcode.

Workaround is to wait and it will auto recover or restart report server.
Anyone encounter same problem? Any solution?
Thanks.

[geetikadua]

Hello All,

I have faced this error many times and evrytime found the issue with the date handling done in set lexical parameters, Do you have date parameter in your report?

Regards
Geetika Dua

[oleemin]

No, the report does not have date parameter.
But when this problem happens it affect ALL the reports in OTM. Not just one.

[l_kator]

are you use full object name in PL/SQL code? Like 'user.object'