Skip Headers
JD Edwards EnterpriseOne Applications One View Reporting User Guide
Release 9.1.x

E24997-11
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

A  B  C  D  E  F  H  I  J  L  M  N  O  P  Q  R  S  T  W 

A

adding all columns, 4.3.10
adding new One View reports, 5.1
ad-hoc reporting, 1.1

B

BI Publisher
integrations with JD Edwards EnterpriseOne, 1.1
Interactive Viewer, 2.4
Layout Editor, 5.1
release 11.1.1.7, 4.5, 4.6
report layouts, 2.3
blank numeric data, 4.7

C

capital asset management
applications
One View Equipment License/Permit Inquiry (P13500), 12.3
One View Equipment Location Inquiry (P13230), 12.6
One View Equipment Status Inquiry (P13400), 12.2
One View PM Analysis (P13570), 12.5
One View Work Order Analysis (P13560), 12.4
reports
Aging - Detailed, 12.4.3.1
Aging - Summary, 12.4.3.2
Completed PMs, 12.5.3.1
Completion Timeliness - Detailed, 12.4.3.3
Completion Timeliness - Summary, 12.4.3.4
Equipment by Location, 12.6.3.2
Equipment Location Analysis, 12.6.3.4
Equipment Status Analysis, 12.2.3.5
Equipment Status Analysis by Manufacturer, 12.2.3.2
Equipment Status Analysis by Parent Equipment, 12.2.3.3
Equipment Status Analysis by Product Model, 12.2.3.4
Equipment Status by Product Family, 12.2.3.1
Equipment Status History by Location, 12.6.3.3
Estimated vs. Actual Cost - Detailed, 12.4.3.5
Estimated vs. Actual Cost - Summary, 12.4.3.6
Estimated vs. Actual Hours - Detailed, 12.4.3.7
Estimated vs. Actual Hours - Summary, 12.4.3.8
Expiring/Expired Equipment Licenses and Permits Analysis, 12.3.3.1
Load - By Assigned To, 12.4.3.9
Load - By Failure, 12.4.3.10
Location by Equipment, 12.6.3.1
Overdue PMs, 12.5.3.3
Planned vs. Actual, 12.5.3.4
PM Key Metrics Analysis, 12.5.3.5
Statistics - Detailed, 12.4.3.11
Statistics - Summary, 12.4.3.12
Upcoming PMs, 12.5.3.2
Work Order Metrics Analysis, 12.4.3.13
column masks, 4.5.3, 4.5.3.1
updating to BI Publisher 11.1.1.7, 4.5.2
column title naming convention, 4.3.3, 4.3.3.1, 4.4.2
columns
adding all columns to a personal report, 4.3.10
adding selected columns, 4.3.9
removing all columns, 4.3.12
removing selected columns, 4.3.11
copying
personal report, 4.3.6
shared report, 4.4.2.1
copying report with sample data, 4.4.2.1

D

Data Browser
and One View Reporting, 1.2.2
data dictionary item naming convention, 4.3.3, 4.3.3.1
sync report to, 4.3.8
sync reports to, 4.4.2
data model, 2.3
removing columns, 4.7
save report with new data model, 4.3.4
decimal formatting
activating, 4.5
updating, 4.5.2
deleting personal reports, 4.3.3.1, 4.3.13
drill back, 4.6
drill back url
creating, 4.6.2
deleting, 4.6.4
drill back link composer, 4.6.1
modifying, 4.6.3

E

edit layout icon, 4.3.2.1
editing layouts, 4.3.2.1
embedded BI Publisher, 1.1

F

feature authorizations, 4.1
financial management
applications
One View Account Balance Inquiry (P09217), 6.2
One View Customer Ledger Inquiry (P03B2022), 6.3
One View Customer Receipt/Draft Inquiry (P03B720), 6.4
One View G/L Inquiry (P09219), 6.1
One View Supplier Ledger Inquiry (P042022), 6.5
One View Supplier Payment Inquiry (P04720), 6.6
reports
Account Balance Analysis, 6.2.3.7
Account Balance Trend, 6.2.3.5
A/R Write-Offs, 6.4.3.3
Budget vs. Actual by Business Unit, 6.2.3.3
Business Unit Detail, 6.1.3.3
Customer Account Balance Analysis, 6.3.3.4
Customer Balance, 6.3.3.1
G/L Account Balances, 6.2.3.1
G/L Transactions Analysis, 6.1.3.4
G/L Transactions by Account, 6.1.3.2
G/L Transactions by Customer and Business Unit, 6.1.3.1
Gross Profit, 6.2.3.6
Open Invoices, 6.3.3.2
Open Invoices with Aging, 6.3.3.3
Open Vouchers, 6.5.3.1
Payment Analysis, 6.6.3.4
Payment Discounts, 6.6.3.3
Payment Trends, 6.6.3.2
Payments, 6.6.3.1
Payments Due Within 30 Days, 6.5.3.2
Payments Overdue, 6.5.3.3
Q1 Sales by Store for Region, 6.2.3.2
Receipt Analysis, 6.4.3.4
Receipt History Trend, 6.4.3.2
Receipt Transactions, 6.4.3.1
Supplier Account Balance Analysis, 6.5.3.5
Transaction Volume by Pay Item, 6.5.3.4
Trial Balance, 6.2.3.4

H

health and safety incident management
applications
one view environmental incident inquiry (P54HS250), 17.5
one view incident equipment inquiry (P54HS240), 17.4
one view incident people inquiry (P54HS230), 17.3
one view incident summary inquiry (P54HS220), 17.2
one view safety statistics inquiry (P54HS260), 17.6
calculated columns, 17.3.2.1
calculated columns used by the incident impact rates report, 17.6.2.7
calculated columns used by the monthly incident safety statistics report, 17.6.2.4
calculated columns used by the safety statistics by incident type report, 17.6.2.6
calculated columns used by the safety statistics for reportable cases report, 17.6.2.5
calculated grid columns, 17.4.2.1, 17.5.2.1
reports
detailed injury/illness summary, 17.3.3.4
environmental incidents, 17.5.3.1
incident attributes, 17.2.2.1
incident costs, 17.2.2.2
incident impact rates, 17.6.3.4
incidents involving people, 17.3.3.1
monthly incident safety statistics, 17.6.3.1
motor vehicle summary report, 17.4.3.2
non-motor vehicle summary report, 17.4.3.3
operator/driver summary report, 17.4.3.4
property/equipment summary report, 17.4.3.1
reportable injury/illness summary, 17.3.3.3
safety statistics by incident type, 17.6.3.3
safety statistics for reportable cases, 17.6.3.2
summary of injured people, 17.3.3.2
special processing in the calculated grid columns, 17.2.1.2, 17.6.2.3
special processing in the header, 17.6.2.1
understanding incident frequency rates and incident impact rates, 17.6.2.2
human capital management
applications
One View Canadian Tax History Inquiry (P7713), 7.3
One View DBA History Detail Inquiry (P071902), 7.6
One View Employee Address Book Inquiry (P080110), 7.1
One View Employee Benefits Inquiry (P08234), 7.7
One View Employee Profile Inquiry (P080120), 7.8
One View Pay History Detail Inquiry (P071862), 7.5
One View PDBA History Inquiry (P07146), 7.4
One View Tax History Inquiry (P07136), 7.2
reports
401K Report, 7.6.3.1
Active Enrollment, 7.7.3.3
Balance Due, 7.4.3.3
Canadian Tax History by Quarter, 7.3.3.1
Canadian YTD Pay and Tax Register, 7.3.3.2
DBA History Analysis, 7.6.3.4
Earnings by Business Unit, 7.5.3.1
Earnings by Pay Type, 7.5.3.2
Emergency Contact Information by Supervisor, 7.1.3.2
Emergency Contacts, 7.1.3.1
Employee and Participant Active Enrollment, 7.7.3.4
Employee Benefits Analysis, 7.7.3.5
Employee Compensation Review, 7.8.3.4
Employee Enrollment Snapshot, 7.7.3.2
Employee Profile Analysis, 7.8.3.5
Employee Roster, 7.8.3.1
Employee Roster with Address, 7.8.3.2
Employee Seniority Report, 7.8.3.3
Employees by Country, 7.1.3.3
Enrollment Demographics, 7.7.3.1
Health and Welfare, 7.6.3.2
Leave Trend, 7.5.3.4
Overtime Pay, 7.5.3.3
Pay History Analysis, 7.5.3.5
Social Security and Medicare Tax by Quarter, 7.2.3.2
Tax History by Quarter, 7.2.3.3
Wage Attachments, 7.6.3.3
Year-to-Date 401K Report, 7.4.3.1
Year-to-Date PDBA Summary History, 7.4.3.2
YTD Pay and Tax Register, 7.2.3.1

I

icon
add all columns, 4.3.3.1
copy report, 4.3.3.1, 4.3.3.1, 4.4.2.1
delete report, 4.3.3.1, 4.3.3.1
edit layout, 4.3.2.1
promote report, 4.3.3.1, 4.3.3.1
remove all columns, 4.3.3.1
reserve report, 4.4.2.1
save as report, 4.3.3.1
sync report, 4.3.3.1, 4.3.3.1
icons
for personal report, layout tab, 4.3.2.1
for personal reports, report definition tab, 4.3.3.1
for shared reports, report definition tab, 4.4.2.1
Interactive Viewer, 2.4
viewing all records, 4.7
inventory
applications
One View Average Cost Analysis from Item Ledger Inquiry (P41270), 8.1
One View Inventory Cost Analysis by Item As Of Inquiry (P41272), 8.3
One View Inventory Valuation Analysis Inquiry (P41271), 8.2
One View Item Usage Trace Inquiry (P41273), 8.4
reports
Average As Of Cost Analysis, 8.3.3.4
Average As Of Cost by Item and Branch Plant, 8.3.3.1
Average As Of Cost by Item and Fiscal Year, 8.3.3.3
Average As Of Cost by Location and Lot, 8.3.3.2
Average Cost Analysis, 8.1.3.4
Average Cost Analysis by Branch Plant, 8.1.3.1
Average Cost Analysis by Lot Serial Number, 8.1.3.2
Average Cost Analysis by Month/GL Date, 8.1.3.3
Inventory Valuation Analysis, 8.2.3.4
Inventory Valuation by Branch Plant, 8.2.3.2
Inventory Valuation by Item, 8.2.3.1
Inventory Valuation by Location, 8.2.3.3
Item Usage Trace Analysis, 8.4.3.4
Item Usage Trace by Item and Date, 8.4.3.2
Item Usage Trace by Item Branch, 8.4.3.1
Item Usage Trace by Week, 8.4.3.3

J

JD Edwards EnterpriseOne report components, 5.1

L

Layout Editor, 5.1
viewing output types, 4.7
layout tab, 3.3.1
for personal report, 4.3.2
for shared report, 4.4.1
layouts
editing, 4.3.2.1

M

Manage Reports
on One View menu, 4.1
manufacturing
applications
One View Manufacturing Dispatch Inquiry (P48280), 13.2
One View Planning Analysis Inquiry (P48290), 13.3
One View Work Order Cost Analysis Inquiry (P48270), 13.1
reports
Calculated Actual Variance, 13.1.3.1
Calculated Engineering Variances, 13.1.3.2
Calculated Planned Variance, 13.1.3.3
Calculated Variance Analysis, 13.1.3.4
Messages by Buyer, 13.3.3.1
Messages by Planner, 13.3.3.2
Messages by Planning Family, 13.3.3.3
Open Work Orders by Item Number, 13.2.3.1
Open Work Orders by Operation Status, 13.2.3.2
Open Work Orders by Work Center, 13.2.3.3
Work Order Labor by Operation Status Analysis, 13.2.3.4
masks
row and column masks, 4.5.3
Mobile Applications, 12.1
Mobile Applications for Health and Safety, 12.1
modifying One View reports
introduction, 4.1
modifying reports
modifying personal reports, 4.3
modifying shared reports, 4.4
options, 4.1
shared and personal report differences, 4.1
tips, 4.7

N

naming convention
column title, 4.3.3
data dictionary item name, 4.3.3
for reports, 4.3
sync report to data dictionary item naming convention, 4.4.2.1, 4.4.2.1

O

One View menu
Manage Reports, 4.1
One View Reporting
and Data Browser, 1.2.2
benefits of, 1.2
key features, 2.1
overview, 1.2
security, 4.1
One View Reporting applications, 1.2.1, 3.4
One View reports
adding, 5.1
components of, 2.3
data model, 2.3
defining data for, 3.2
JD Edwards EnterpriseOne components, 5.1
layouts, 2.3
modifying, 4.1, 4.3
naming guidelines, 4.3
Oracle BI Publisher components, 5.1
output types, 2.4
personal, 2.2
report definition, 2.3
running, 3.1
shared, 2.2
Oracle BI Publisher
integrations with JD Edwards EnterpriseOne, 1.1
Interactive Viewer, 2.4
Layout Editor, 5.1
report layouts, 5.1
output types, 2.4
descriptions of, 3.3.1.1

P

P03B2022, 6.3
P03B720, 6.4
P042022, 6.5
P04720, 6.6
P07136, 7.2
P07146, 7.4
P071862, 7.5
P071902, 7.6
P080110, 7.1
P080120, 7.8
P08234, 7.7
P09217, 6.2
P09219, 6.1
P13230, 12.6
P13400, 12.2
P13500, 12.3
P13560, 12.4
P13570, 12.5
P15260, 14.1
P41270, 8.1
P41271, 8.2
P41272, 8.3
P41273, 8.4
P42270, 9.1
P42271, 9.2
P42272, 9.3
P42273, 9.4
P43260, 10.1
P43261, 10.2
P43263, 10.4
P43264, 10.5
P43265, 10.6
P43266, 10.7
P43267, 10.8
P46270, 18.1
P46271, 18.2
P46273, 18.4
P46L272, 18.3
P48270, 13.1
P48280, 13.2
P48290, 13.3
P49270, 16.1
P49271, 16.2
P51220, 11.1
P54HS220, 17.2
P54HS230, 17.3
P54Hs240, 17.4
P54HS250, 17.5
P54HS260, 17.6
P7713, 7.3
personal report
adding all columns, 4.3.10
adding selected columns, 4.3.9
copying, 4.3.6
creating from existing report, 4.3.1
deleting, 4.3.13
description, 4.3.3
modifying, 4.3
promoting to shared report, 4.3.3.1, 4.3.7
removing all columns, 4.3.12
removing selected columns, 4.3.11
report definition tab, 4.3.3
save report option, 4.3.4
personal reports, 2.2
pivot tables, 4.5
procurement
applications
One View Backordered Items Not Received Inquiry (P43264), 10.5
One View Purchase Order Inquiry (P43261), 10.2
One View Purchase Order Receipts Inquiry (P43260), 10.1
One View Purchase Order Vouchers Payment Inquiry (P43263), 10.4
One View Requisition Self Service Inquiry (P43267), 10.8
One View Simple Procurement Inquiry (P43265), 10.6
One View Subcontract Inquiry (P43262), 10.3
One View Supplier Cost Analysis Inquiry (P43266), 10.7
reports
Backordered Items Not Received Analysis, 10.5.3.4
Backordered Items Not Received by Fiscal Period, 10.5.3.1
Backordered Items Not Received by Item, 10.5.3.2
Backordered Items Not Received by Supplier, 10.5.3.3
Blanket Order Inquiry by Supplier, 10.6.3.3
Cost Analysis by Item, 10.7.3.1
Cost Analysis by Supplier, 10.7.3.2
Cost Variance by Purchase Order History, 10.2.3.1
Discount Analysis by Supplier, 10.7.3.3
Expected PO Receipts by Fiscal Period, 10.2.3.2
Expected PO Receipts by Item, 10.2.3.3
Expected PO Receipts by Supplier, 10.2.3.4
PO Voucher Payment Inquiry by Fiscal Period, 10.4.3.1
PO Voucher Payment Inquiry by Item, 10.4.3.2
PO Voucher Payment Inquiry by Supplier, 10.4.3.3
PO Voucher Payment Schedule Analysis, 10.4.3.4
Purchase Order Analysis, 10.2.3.8
Purchase Order History by Fiscal Period, 10.2.3.5
Purchase Order History by Item, 10.2.3.6
Purchase Order History by Supplier, 10.2.3.7
Purchase Order Receipts Analysis, 10.1.3.8
Quantity Analysis by Fiscal Period, 10.1.3.1
Quantity Analysis by Item, 10.1.3.2
Quantity Analysis by Supplier, 10.1.3.3
Received Not Vouchered by Company, 10.1.3.4
Received Not Vouchered by Fiscal Period, 10.1.3.5
Received Not Vouchered by Item, 10.1.3.6
Received Not Vouchered by Supplier, 10.1.3.7
Requisition Orders by Item and Requester, 10.8.3.1
Requisition Orders by Requester and Supplier, 10.8.3.2
Requisition Self Service Analysis, 10.8.3.3
Retained Amount Analysis, 10.3.3.3
Retained Amount Analysis by Fiscal Period, 10.3.3.1
Retained Amount Analysis by Subcontractor, 10.3.3.2
Retained Amount Analysis by Supplier, 10.6.3.2
Simple Procurement Analysis, 10.6.3.4
Simple Procurement Inquiry by Fiscal Period, 10.6.3.1
Supplier Cost Analysis, 10.7.3.4
project costing
application
One View Job Inquiry (P51220), 11.1
reports
Earned Value, 11.1.3.2
Job Status, 11.1.3.1
Labor Unit Analysis, 11.1.3.4
Work in Progress, 11.1.3.3
promoting personal reports, 4.3.3.1, 4.3.7

Q

queries, 3.2.1

R

real estate
application
One View Property Inquiry (P15260), 14.1
reports
Approaching Vacancy Review, 14.1.2.1
Occupancy Analysis, 14.1.2.2
Tenant Analysis, 14.1.2.4
Tenant Rent Roll - Rent Steps, 14.1.2.5
Tenant Rent Roll - Retail, 14.1.2.6
Vacancy Report, 14.1.2.3
removing all columns, 4.3.12
removing selected columns, 4.3.11
report definition, 2.3
report definition icons
for shared reports, 4.4.2.1
report definition tab
for personal report, 4.3.3
for shared report, 4.4.2
report layouts
editing, 4.3.2.1
in BI Publisher, 5.1
report naming guidelines, 4.3
report statuses, 4.3.3
report types
shared and personal, 4.3.3
reserving a shared report, 4.4.2.1, 4.4.4
row masks, 4.5.3, 4.5.3.2
updating to BI Publisher 11.1.1.7, 4.5.2
running One View reports
from Data Browser, 3.6
from EnterpriseOne standard or custom applications, 3.5
from One View Reporting applications, 3.4.1
runtime options, 3.3

S

sales
applications
One View Historical Sales Inquiry (P42271), 9.2
One View Open Sales Inquiry (P42270), 9.1
One View Sales Price Inquiry (P42273), 9.4
One View Sales to Date Inquiry (P42272), 9.3
reports
Average Historical Sales Report, 9.2.3.2
Commitment Report, 9.1.3.4
Customer Price List Report, 9.4.3.1
Customer Sales Report, 9.3.3.1, 9.3.3.5
Historical Sales Analysis, 9.2.3.4
Item Price List Report, 9.4.3.2
Item Sales Report, 9.3.3.2
Open Customer Report, 9.1.3.2
Open Items Report, 9.1.3.1
Open Sales Analysis, 9.1.3.5
Opportunity Trends Report, 9.3.3.6
Price Comparison by Region Report, 9.4.3.3
Sales Price Analysis, 9.4.3.4
Sales Profit Report, 9.3.3.3
Sales to Date Analysis, 9.3.3.4
Status Report, 9.1.3.3
Top Customers Report, 9.2.3.3
Total Historical Sales Report, 9.2.3.1
save report option, 4.3.4
security
feature authorizations, 4.1
shared report
copying, 4.4.2.1
description, 4.3.3
modifying, 4.4
report definition icons, 4.4.2.1
report definition tab, 4.4.2
reserving, 4.4.2.1, 4.4.4
syncing to data dictionary naming convention, 4.4.5
shared reports, 2.2
sync report to data dictionary item naming convention, 4.3.3.1, 4.3.8, 4.4.2.1, 4.4.2.1

T

transportation management
applications
One View Transportation Load Inquiry (P49271), 16.2
One View Transportation Shipment Inquiry (P49270), 16.1
reports
Load Bulk Volume by Shipment Depot and Date, 16.2.3.1
Load Distance by Shipment Depot and Carrier, 16.2.3.2
Load Freight by Planning Depot, 16.2.3.3
Load Payable Freight by Carrier and Planning Depot, 16.2.3.4
On Time Shipments by Shipment Depot, 16.1.3.1
Packaged Load Analysis, 16.2.3.6
Shipment Analysis, 16.1.3.5
Shipment Depot totals by Year and Month, 16.1.3.2
Shipment Freight Charges by Shipment Depot, 16.1.3.3
Shipment Value by Shipment Deport Report, 16.1.3.4
Vehicle Utilization by Planning Depot, 16.2.3.5

W

warehouse management
applications
One View License Plate Quantities Inquiry (P46L272), 18.3
One View Warehouse Location Inquiry (P46273), 18.4
One View Warehouse Request Inquiry (P46270), 18.1
One View Warehouse Suggestion Inquiry (P46271), 18.2
reports
License Plate Quantities Analysis, 18.3.3.1
Warehouse Location Usage, 18.4.3.1
Warehouse Location Velocity, 18.2.3.1
Warehouse Pick Request Analysis, 18.1.3.1
Warehouse Putaway Request Analysis, 18.1.3.2
Warehouse Replenishment Request Analysis, 18.1.3.3
Warehouse Request Summary, 18.1.3.4
Warehouse Suggestion Productivity, 18.2.3.2
Warehouse Utilization, 18.4.3.2