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
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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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