Calculating Custom Fields - Apps 8

Hi
You can make the first two areas a permanent sandbox, write a function in the field you add. 3. and show the total value of the two areas.

create function 

function sum_deger  (source_ref1  IN number , source_ref2  IN number  )RETURN NUMBER
is
source_ref1_ number;
source_ref2_  number;
deger_ number;
BEGIN
source_ref1_  := source_ref1;
source_ref2_  := source_ref2;
deger_ := 0;

SELECT  source_ref1_ +  source_ref2_   deger_ FROM dual  t 
f deger_ is null then
return   0 ;
else   
return deger_ ;
end if;
end sum_deger;

Virtual areas are only worth to see.permanent fields are used for data usage.You can collect two permanent field values ​​with a function on PLSQL and show them in a virtual area.Note: If the value to be displayed in 2 fields is not entered manually and the other fields will continue, you need to make 3 virtual areas.

hi

Fields are of two types. Value entered Returning value If 3 fields return values, you can virtually open them. If two fields will enter values ​​and one field will return value, It is enough to make two permanent areas and 1 virtual area.

Hi Paul,

Thank you so much, this has worked perfectly!!  You have saved my sanity 

Hayley

Hi

I have created 3 new custom numeric fields, 2 will be manual entries and the 3rd I would like to add the numbers from the first 2 fields. Is this possible in Apps 8?

If so does this need to be done via a custom event? Would be much appreciated if it is possible for some to send a screen shot of how. Below is a screen shot of the fields I am referring to, and the one circled is the field I want the calculation to appear.

 

Wonderful @paul harland ….!!!

hi Hayley

SUM is what you need… but you wouldn’t normally put such a field in the row.  Are you putting it in the header?

ok - i’m not familiar with this module, and I can’t find it (!) anywhere so i can’t give you the table/field names.

However, you are looking for a read-only field, numeric, set to type “Select” and the SQL Statement will look something like

select sum(cf$_field3) 

from child_view c

where c.risk_id = :risk_id

and then put risk_id into the arguments field

hi Hayley,

thank you - based on that, try this:

select sum(cf$_initial_risk) 

from risk_hazard h

where h.risk_assessment_no = :risk_assessment

ah! my bad. 

replace the view name “risk_hazard h” with risk_hazard_cfv h”

ugh - that could be tricky.  do you have any other custom fields in the same LU?

you might need some direct support to clear that up

de nada.  There are some syntactical differences between custom fields framework in apps 8 and 10 which may explain this.