The ORDER BY
keyword is used to sort the result-set by one or more columns.
You can sort the data in the SQL to save the time it takes for BI Publisher to generate the report.
You can sort the data by Invoice (inv_li_record_no
) and then by Invoice Line Item Number (inv_li.LI_NUM
): ORDER BY inv_li_record_no
, inv_li.LI_NUM
Note: Since Unifier nests the Line Items within the Invoices and in the processes making your table easier to read when troubleshooting, sorting by Invoice is not necessary.
Legal Notices
Copyright © 2016, 2018,
Oracle and/or its affiliates. All rights reserved.
Last Published Wednesday, March 28, 2018