[Resolved by work around] Default values in processing constraints global records
Hi,
I'm using a processing constraint to disable the ability to create an order line with an amount greater than 1000000 CNY.
The amount is calculated as : NVL(oe_line_security.g_record.ordered_quantity * oe_line_security.g_record.unit_selling_price + NVL(oe_line_security.g_record.tax_value,0),0).
It seems that in case tax_value is not provided in the interface record (or before is as been calculated), it is defaulted to 9.990000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000E+125.
According to my debug logs, it is the same for oe_line_security.g_record.line_ID.
Does anyone have information about that ?
Should I modified my code using something like the following ?
I'm using a processing constraint to disable the ability to create an order line with an amount greater than 1000000 CNY.
The amount is calculated as : NVL(oe_line_security.g_record.ordered_quantity * oe_line_security.g_record.unit_selling_price + NVL(oe_line_security.g_record.tax_value,0),0).
It seems that in case tax_value is not provided in the interface record (or before is as been calculated), it is defaulted to 9.990000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000E+125.
According to my debug logs, it is the same for oe_line_security.g_record.line_ID.
Does anyone have information about that ?
Should I modified my code using something like the following ?
0