Performance Issue - AP_PAYMENT_SCHEDULES_ALL.PAYMENT_NUM

Hi Oracle Ocean,

Identified an issue with the index AP.AP_PAYMENT_SCHEDULES_N1 defined on table.column AP.AP_PAYMENT_SCHEDULES_ALL.PAYMENT_NUM,

1) When we run the below query with Parameter P1 (Pass invoice id) and Parameter P2 as BLANK/NULL, It takes 17 msecs to fetch the result.

2) When we run the below query with Parameter P1 (Pass invoice id) and Parameter P2 (Pass payment_num value ), It takes more than 2 MINUTES at average to fetch the result. Which is 100 times more than the first query execution time.

SELECT ai.invoice_num, aps.due_date, pv.vendor_name, pvs.vendor_site_code