Hi Nathan CCC , In the query I am putting another condition PAY_INPUT_VALUES_TL.name = 'Amount' to fetch the amount from the column RESULT_VALUE from PAY_RUN_RESULT_VALUES table , I am expecting RESULT_VALUE is holding number in string data type and we could convert that string into number but it's not working.

Hi Rajasekhar Bandaru-Oracle , Thanks for the response! I tried this but when I am trying to see the data , getting below error as ORA-01722: invalid number.

This report has been requested for audit purpose , please suggest the better solution. It will be really helpful if working session can be arranged

Hi User_PFO2E Run Result Value holds alphanumeric value. There is another column 'Amount' , amount is having value if Run Result Value is returning number else Amount is blank. So to fetch the number only from the Run Result Value, we have added one more condition 'Amount is not null' , over this condition we have added…

Hi Hassan El Bouihi-Oracle , I tried the logic on filter which you have suggested but it's not working , result is returning all values. Please suggest. Thanks, Anjali Kumari