OraFAQ Forum: Reports & Discoverer » REP-1401 'cf_Aformula' :Fatal PL/SQL erroroccurred

Home » Developer & Programmer » Reports & Discoverer » REP-1401 'cf_Aformula' :Fatal PL/SQL erroroccurred

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

REP-1401 'cf_Aformula' :Fatal PL/SQL erroroccurred [message #202697]

Sat, 11 November 2006 02:22

voralux
Messages: 72
Registered: January 2006

Member

I created Formula Column;
If run compile is no error but run repor, show error "REP-1401 'cf_Aformula' :Fatal PL/SQL erroroccurred ORA-00001: unique, constraint (.) violated

Report message to a moderator

Re: REP-1401 'cf_Aformula' :Fatal PL/SQL erroroccurred [message #202731 is a reply to message #202697]

Sat, 11 November 2006 08:16

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It seems that formula code tries to either INSERT or UPDATE records in a database table, and - doing so - it violates unique key constraint.

This error has nothing to do with compilation - it is about data manipulation which raises an error as the report gets executed.

Report message to a moderator

Re: REP-1401 'cf_Aformula' :Fatal PL/SQL erroroccurred [message #202752 is a reply to message #202731]

Sat, 11 November 2006 13:03

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

Hi Voralux,

You check you cf_aFormula again ... you can solve the problem.

Bye
Ashu

Report message to a moderator

Re: REP-1401 'cf_Aformula' :Fatal PL/SQL erroroccurred [message #203366 is a reply to message #202697]

Tue, 14 November 2006 22:40

tsilav
Messages: 22
Registered: September 2004

Junior Member

Your formula has an precise insert that make a duplicate record in your table, verify well it, or analysis well of choising a primary key of your table

Report message to a moderator

Previous Topic:	Difference between Reports6i and oracle 9i reports
Next Topic:	How to generate reports ?????? Very Urgent.... Format Specified...Plz Help me

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 17:30:44 CDT 2024