
xvi
15.2.1 Locating Text in JSPs.................................................................................................... 15-3
15.2.2 Translating Message Text............................................................................................ 15-4
15.3 Site-Specific Messaging....................................................................................................... 15-4
15.3.1 Creating Custom Site Messages ................................................................................. 15-5
15.4 Oracle iStore Login Page Messages .................................................................................. 15-6
15.5 Self-Service Login Assistance Messages........................................................................... 15-6
15.6 Modifying Oracle Application Object Library Lookups................................................ 15-8
15.6.1 Sales Assistance Reasons Lookups ............................................................................ 15-9
15.6.2 Share Cart Roles Lookups ........................................................................................... 15-9
15.6.3 Media Objects and Content Components Classes Lookups ................................ 15-10
15.6.4 Site Group Names Lookup ....................................................................................... 15-10
15.6.5 Returns Reasons Lookup........................................................................................... 15-11
15.6.6 Order Tracker Search Lookup .................................................................................. 15-11
15.6.7 User Type Lookups.................................................................................................... 15-12
16 Implementing Reports
16.1 Overview of Oracle iStore Reports ................................................................................... 16-1
16.2 Implementing Oracle iStore Reports ................................................................................ 16-3
16.2.1 Set up Calendar in General Ledger ........................................................................... 16-4
16.2.2 Set up Oracle Discoverer 4i for Use in Oracle iStore............................................... 16-4
16.2.3 Set iStore Profile Options for Reports ....................................................................... 16-7
16.2.4 Set Conversion Rates ................................................................................................... 16-8
16.2.5 Prepare Data (Run Concurrent Programs)............................................................... 16-9
16.2.6 Verify Discoverer Implementation .......................................................................... 16-15
16.3 Using the Bins Dashboard................................................................................................ 16-15
16.4 Setting Bin Preferences ..................................................................................................... 16-16
16.5 Setting up E-mail Delivery for Reports .......................................................................... 16-19
16.6 Oracle iStore Business Reports Details........................................................................... 16-20
16.6.1 Top Product Sales Report.......................................................................................... 16-21
16.6.2 Customer Sales Report .............................................................................................. 16-24
16.6.3 Top N Orders Report ................................................................................................. 16-27
16.6.4 Site Order Summary Report ..................................................................................... 16-30
16.6.5 Sales by Agreement Report....................................................................................... 16-32
16.6.6 Shopping Cart Conversion Report .......................................................................... 16-33
16.6.7 Sales by End User Type Report................................................................................ 16-35