Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
4 BI Publisher Reports
This chapter describes the steps to view the Sales Audit Business Intelligence (BI) Publisher reports by accessing Reports from the task bar in Sales Audit.
1. Depending on the report, you can use prompts to select report parameters.
-
Some prompts allow you to filter the report contents and limit the information in the report. For example, you can filter on Store or Credit Cart Type in the Credit Card Summary report.
-
Some reports require a parameter.
-
Some reports require no parameters, and no prompts are displayed.
-
Select values as needed from the list for the prompts displayed.
2. Select the report output you may want to view.
-
HTML (default, Web page format)
-
PDF (Adobe Acrobat Portable Document Format)
-
RTF (Rich Text Format, used by Microsoft Word and other programs)
-
Excel (Microsoft Excel format)
-
PowerPoint (Microsoft PowerPoint format)
-
CSV (comma-separated values file)
-
Data (XML)
3. Click View . The report is displayed in Oracle BI Publisher.
(If you select another output format, you have the option to save the report. You can also open the report with another program, such as Microsoft Excel).
4. Close the browser window when you are finish viewing, printing, or saving the report.
Credit Card Summary Report
The Credit Card Summary report lists the credit card transactions for a specified type of credit card over a range of dates.
Note:
The masking character for data in the Card No. column depends on the setting of the Credit Card Masking Character system option.
Parameters :
-
Start date (this is a mandatory field)
-
End date
4-1
| ORACLE’ 8B!PublisherEnter | prise | |||||||
|---|---|---|---|---|---|---|---|---|
| sacc | ||||||||
| Store1521 | v | StartDate(DD- | MMM-YYYY) | 22-SEP-2018 tte | EndDate29-SEP-2018fe | |||
CreditCardType All sacc | v | Apply | ||||||
| ORACLERetail | Cre | ditCardSu | mmary | Report | ReportDate:4Apr2e | |||
| Report:(SACC) | ORACLE | RETAIL | Page:1OF1 | |||||
Currency : USD | ||||||||
| Visa 22-Sep-2018 | 1521 | 1 | 1000003257 | Return | 210210°*****2102 | 11111 | <139.97> | |
| 22-Sep-2018 | 1521 | 1 | 1000003272 | Return | 210210°*****2102 | 11111 | <129.97> | |
| 22-Sep-2018 | 1521 | 1 | 1000003315 | Return | <599.99> | |||
| 22-Sep-2018 | 1521 | 1 | 1000003224 | Return | 210210*** | ***2102 <84.90> | ||
| 22-Sep-2018 | 1521 | 2 | 1000003298 | Return | <163.98> | |||
| 22-Sep-2018 | 1521 | 2 | 1000003301 | Return | 210210°*****21021234 | 122333 | <64.99> | |
| 23-Sep-2018 | 1521 | 1 | 1000003372 | Return | 210210°*****2102 | 11111 | <129.97> | |
| 23-Sep-2018 | 1521 | 1 | 1000003357 | Return | 210210°*****2102 | 11111 | <139.97> | |
| 23-Sep-2018 | 1521 | 1 | 1000003434 | Return | 210210*** | ***2102 <84.90> | ||
| 23-Sep-2018 | 1521 | 1 | 1000003415 | Return | <599.99> | |||
| 23-Sep-2018 | 1521 | 2 | 1000003398 | Return | <163.98> | |||
| 23-Sep-2018 | 1521 | 2 | 1000003401 | Return | 210210°*****21021234 | 122333 | <64.99> | |
| 24-Sep-2018 | 1521 | 1 | 1000003515 | Return | <599.99> | |||
| 24-Sep-2018 | 1521 | 1 | 1000003472 | Retum | 210210°*****2102 | 11111 | <129.97> | |
| 24-Sep-2018 | 1521 | 1 | 1000003534 | Return | 210210° | ***2102 <84.90> | ||
| 24-Sep-2018 | 1521 | 1 | 1000003457 | Return | 210210°*****2102 | 11111 | <139.97> | |
| 24-Sep-2018 | 1521 | 2 | 1000003501 | Return | 210210°*"""21021234 | 122333 | <64.99> | |
| 24-Sep-2018 | 1521 | 2 | 1000003498 | Return | <163.98> | |||
| 25-Sep-2018 | 1521 | 1 | 1000003562 | Return | 210210”**+2102 | 41111 | <129.97> | |
| 25-Sep-2018 | 1621 | 1 | 1000003624 | Return | 210210*** | ***2102 <84.90> | ||
| 25-Sep-2018 | 1521 | 1 | 1000003605 | Return | <599.99> | |||
| 25-Sep-2018 | 1521 | 1 | 1000003657 | Return | 210210°*****2102 | 41111 | <139.97> | |
| 25-Sep-2018 | 1521 | 2 | 1000003588 | Return | <163.98> | |||
| 25-Sep-2018 | 1521 | 2 | 1000003591 | Return | 210210°*****21021234 | 122333 | <64.99> | |
| 26-Sep-2018 | 1521 | 1 | 1000003662 | Return | 210210°*****2102 | 41111 | <129.97> | |
| 26-Sep-2018 | 1521 | 1 | 1000003757 | Retum | 210210°*****2102 | 11111 | <139.97> | |
| 26-Sep-2018 | 1521 | 1 | 1000003705 | Return | <599.99> | |||
| 26-Sep-2018 | 1521 | 1 | 1000003724 | Return | 210210°** | *“*2102 <84.90> | ||
| 26-Sep-2018 | 1521 | 2 | 1000003691 | Return | 210210°*****21021234 | 122333 | <64.99> | |
| MR-Gan_Wi1iR | 41694 | 2 | ANANNNARRR | Raturmn | <1RIARS |
ORACLE:#1PubiisherEnterpr | ise | ||||||
|---|---|---|---|---|---|---|---|
| savouch | |||||||
| StartDate(DD-MMM-YYYY): 22-SEP-2018 | fe | EndDate(DD | -MMM-YYYY | ): | fe | RedeemedStore All | |
| Issue store All VoucherActivity Report | v | Voucher | No All | v | VoucherType GiftCard | ||
| ORACLERetail | Vouc | herActi | vity Re | port | ReportDatese | on20 | |
| Report: (SAVOUCH) | ORACLE | RETAIL | Page: | 1 OF 1 | |||
| GiftCard | Currenc | y: USD | |||||
| 600******0002 | 1111 | (‘) 27- Sep-2018 | 100.00 <100.00> | R | |||
| 600°*****4000 | 1111 | 0 27- Sep-2018 | 100.00 <100.00> | R | |||
| 600°*****4000 | 1111 | 0 26- Sep-2018 | 100.00 <100.00> | R | |||
| 6003800000001 1111 | 0 | 27-Sep-2018 | 25.00 | 25.00 | |||
| 6003800000002 1111 | 0 | 27-Sep-2018 | 100.00 | 100.00 | |||
| 6003800000003 1111 | 0 | 27-Sep-2018 | 50.00 | 50.00 | i | ||
| 6003800000004 1111 | 0 | 27-Sep-2018 | 100.00 | 100.00 | |||
| 6003800000005 1111 | 0 | 27-Sep-2018 | 100.00 | 100.00 | |||
| 6003879000123 1111 | 0 | 27-Sep-2018 | 25.00 | 25.00 | |||
| 6003879000123 1111 | 0 | 26-Sep-2018 | 25.00 | 25.00 | |||
| 6003879111000 1111 | 0 | 26-Sep-2018 | 100.00 | 100.00 | |||
| 6003879111000 1111 | 0 | 27-Sep-2018 | 100.00 | 100.00 | |||
| 6003879222000 1111 | 0 | 26-Sep-2018 | 50.00 | 50.00 | |||
| 6003879222000 1111 | 0 | 27-Sep-2018 | 50.00 | 50.00 | |||
| 6003879333000 1111 | 0 | 26-Sep-2018 | 100.00 | 100.00 | i | ||
| 6003879333000 1111 | 0 | 27-Sep-2018 | 100.00 | 100.00 | |||
| 6003879444000 1111 | 0 | 26-Sep-2018 | 100.00 | 100.00 | |||
| 6003879444000 1111 | 0 | 27-Sep-2018 | 100.00 | 100.00 | |||
| Sum Outstanding: 825.00 | |||||||
| Endof | Report |
In this guide
- Guide: Sales Audit Reports User Guide
- Previous: 3 Contextual Reports