You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Oracle ICS - (problem with grouping lines with arithmatic logic)

Received Response
48
Views
1
Comments
edited Jun 19, 2017 7:00AM in Integration 1 comment

Summary

Oracle ICS - (problem with grouping lines with arithmatic logic)

Content

I'm trying for the solution using ICS thereby i'm raising question.

Please find the use case as given below:

first we will apply the discount for each row as per the discountType.

if discount type is "amount" then we will do amount-discount or if discount type is "percentage" then we will do amount- (amount * %/100).

After this change, we need to merge the output lines as per the condition if (manufacturer and type) values are equal in the records.

ex: if (manufacturer = 'CISCO' and type='Network'), then we need to sum the amounts from the records.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!