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

PAY_PAYMT_SEARCH_RESULTS_VL Issue

Received Response
223
Views
3
Comments

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!