Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

What value can be set in Invoice Line data set “INV_LINES_DS_V2” without impacting performance

edited Mar 20, 2024 1:49PM in Payables, Payments & Cash Management 4 comments

Approver Is Unable To View POET Information while approving the Invoice. Oracle suggested that the data set that has to be modified is “INV_LINES_DS_V2” and the modification can be done at the end of the query. Currently it is set as 30 and approver can't see the POET detail in the notification if invoice has more than 30 lines. Caution on the number of rows you set to fetch as greater number of rows will mean that the notification may have performance issues.

So my question is related to to number of rows to be set. What is recommended value we can set so that it would not impact the performance.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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