Get Started with Redwood for Oracle Cloud HCM Begin Now
PAY_PAYMT_SEARCH_RESULTS_VL Issue
Summary:
Issue with PAY_PAYMT_SEARCH_RESULTS_VL usage
Content (required):
Hi Team
Greetings!
This issue is about the usage of PAY_PAYMT_SEARCH_RESULTS_VL table ( it is a view actually) to get the status value for check (Void/ Paid/Canceled and cannot be reissued) used in the positive pay file.
When we just try to query on this view PAY_PAYMT_SEARCH_RESULTS_VL - it just times out and keep running for long time.
And when we run it in separate query along with the status check -that ends up in subquery returns more than one row.
0