Function CF_MMM_formula
 RETURN NUMBER 
 IS 
  v_qty NUMBER; 
 v_qty := (:CF_MON + :CF_A1 + :CF_A2 + :CF_A3 + :CF_A4 + :CF_A5 + :CF_A6);
   return nvl(v_qty, 0);
end;

REP-1241: Circular column dependency originating with column 'CF_MMM'

FUNCTION Cf_formula RETURN NUMBER 
IS 
  v_qty NUMBER; 
Begin
IF :CF_MMM < 0 THEN AND Nvl(:cf_Fixed, 0) = 0 THEN
      IF Nvl(:cf_Min_Qty, 0) = 0 THEN
        v_qty := Abs(:CF_MMM); 
        RETURN Nvl(v_qty, 0); 
      END IF; 

      v_qty := Nvl(:cf_Min_Qty, 0); 

      IF v_qty >= Abs(:CF_MMM) THEN 

        RETURN Nvl(v_qty, 0); 
      END IF; 


      IF Nvl(:cf_Fixed, 0) > 0 THEN 

        LOOP 
            v_qty := v_qty + Nvl(:cf_Fixed, 0); 

            exit WHEN v_qty >= Abs(:CF_MMM); 
        END LOOP; 

        RETURN Nvl(v_qty, 0); 
      END IF; 

      v_qty := Abs(:CF_MMM); 

      RETURN Nvl(v_qty, 0); 
    END IF; 
RETURN Nvl(v_qty, 0); 
End;

function CF_A1Formula return Number 
is
.......
......
......

function CF_A2Formula return Number 
is
 if :CF_A1<0 then
 ...
 ...
 end if;
 
or 

 if :CF_A1Formula<0 then
 ...
 ...
 end if;

which one is correct in the above code?

if :CF_A1<0 then

CF_A1-->This is the Name of the Formula column name not a function name
CF_A1Formula--> is the Function name in the CF_A1

otherwise give an example.

function CF_C9Formula return Number is
  v_qty number(10);
begin
  v_qty := (:CF_1+:CF_2);  
    return nvl(v_qty, 0);
end;

And used CF_C9 calculate beloe column

function CF_C99_PlusFormula return Number is
begin
  return (:CF_C9 + :CF_A1 + :CF_A2);  
end;

function CF_a99Formula return Number is
  v_qty number(10);
  
begin

 v_qty := 0;
 
 If :CF_C99_Plus < 0 THEN
 .....
 .....
 .....
 END if;
end;

REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error: 
REP-271504897: 

[u]REP-271504897:[/u]
when all of the followings are true :

1. desformat=XML
2. The query is based on a table which has a "LONG" column
3. The length of the data in LONG column is 8192 bytes or larger. (When NLS_LANG and the database characterset does not match exactly -for example one is UTF8 and the other is WE8ISO8859P1- it fails even sooner, that is after 2730 characters)

When a character returning formula column returns NULL, memory leak
happens. This increases the memory usage exorbitantly, which results in
the REP error from Report Server.