What value can be set in Invoice Line data set “INV_LINES_DS_V2” without impacting performance
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.
Tagged:
0