Home » Developer & Programmer » Reports & Discoverer » REP-1401 'cf_Aformula' :Fatal PL/SQL erroroccurred
REP-1401 'cf_Aformula' :Fatal PL/SQL erroroccurred [message #202697] Sat, 11 November 2006 02:22 Go to next message
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
Re: REP-1401 'cf_Aformula' :Fatal PL/SQL erroroccurred [message #202731 is a reply to message #202697] Sat, 11 November 2006 08:16 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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.
Re: REP-1401 'cf_Aformula' :Fatal PL/SQL erroroccurred [message #202752 is a reply to message #202731] Sat, 11 November 2006 13:03 Go to previous messageGo to next message
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
Re: REP-1401 'cf_Aformula' :Fatal PL/SQL erroroccurred [message #203366 is a reply to message #202697] Tue, 14 November 2006 22:40 Go to previous message
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
Previous Topic: Difference between Reports6i and oracle 9i reports
Next Topic: How to generate reports ?????? Very Urgent.... Format Specified...Plz Help me
Goto Forum:
  


Current Time: Sat Dec 03 01:23:30 CST 2016

Total time taken to generate the page: 0.11330 seconds