I ENCOUTERED A technical problem with BODS SAP.
The version is SAP BusinessObjects XI 3.2
Database Oracle 11g
I am using a function that return a output value from a input value.
if ($ID_TxRbs = 1)
if ($ID_TxRbs = 2)
if ($ID_TxRbs = 3)
if ($ID_TxRbs = 4)
if ($ID_TxRbs = 5)
if ($ID_TxRbs = 6)
Than I have a transform Validation that returns an error if the value equal with 300
Sometimes, it occurs that the function did not recognize the input value ( for ex input value = 5, and the function returns default value 300)
And the validation transformation take the line with the value =300 to the Pass way flow instead of taking it in the fail way flow.
This error happens randomly. For example, on 5 hundred lines, its occurs on only for two lines.
The type of the field is VARCHAR2(1024) . the received number of character is 1 in the field à ( length (TAUXREMBOURSEMENT)=1).
I don’t understand why this error occurs and why the validation transform doesn’t work properly all day.
Can you help me please?