Error inserting negative numbers from SAP to Oracle

[Former Member]

Hi everyone.

I have the following scenario.

R3 -> XI -> Oracle

I´m trying to insert fileds into the Oracle DB, but i can not, because some of these fileds contain negative numbers and the Number data type of Oracle is rejecting those negative numbers.

It seems like Sap send negative numbers with the minus sign at the right side and Oracle Number Type is expecting to receive this sign at the left side.

Examples:

Negative number in Oracle Negative number in SAP

-1213254 1213254-

Do someone know if there is a way in XI to pass the minus sign of SAP from right side to the left side like Oracle is expecting it ?

Or how can I solve this problem??

Thanks in advance.

[Former Member · Accepted solution]

Hi

If you have the field as string then just use trim (remove the - from left) and concate (- to right)on this

Else create a small UDF for this.

Thanks

Gaurav

[Former Member · Accepted solution]

Hi perez,

For this kind of issues follow the solution below.

SenderNode-> replace with(replace the '-' with the space)-> later use trim-> then you will get the normal integer. then go gor concatenating with '-' on the upper lobe.

Thats it ..........

Thanks

Ramana.

[Former Member · Accepted solution]

Hi Ramana

Thank you very much for your answer, it solved the problem.

[Former Member]

try using StandarfFunction.. FormatNum or create a java function that will handle with patterns.