ERP Project
Functional Specifications
Void Checks Report
ORACLE
Author: Jay
Creation
Date: 2nd May 2005
Last
Updated: 2nd
May 2005
Last
Updated By: Jay
Version:
DRAFT
Approvals
|
Name
|
Title
|
Date
|
|
Team Leader
|
|
|
|
|
|
|
Contents
|
Approvals................................................................................................................................................ 1
Topical Essay........................................................................................................................................................ 3
Basic Business Needs............................................................................................................................................ 4
Major Features...................................................................................................................................................... 5
User Procedures.................................................................................................................................................... 6
Step 1........................................................................................................................................................ 6
Step 2........................................................................................................................................................ 6
Step 3........................................................................................................................................................ 6
Technical Overview............................................................................................................................................. 7
Considerations........................................................................................................................................ 7
Navigation Logic.................................................................................................................................................. 8
Report Definition.................................................................................................................................................. 9
Title........................................................................................................................................................... 9
Business Requirement........................................................................................................................... 9
Report Layout........................................................................................................................................ 9
Report Parameters................................................................................................................................. 9
Data Sources......................................................................................................................................... 10
Selection Criteria.................................................................................................................................. 10
Frequency/Run Time.......................................................................................................................... 10
Launch Parameters............................................................................................................................. 10
Output.................................................................................................................................................... 11
Open/Closed Issues............................................................................................................................................. 12
Open issues............................................................................................................................................ 12
Closed issues......................................................................................................................................... 12
|
Topical Essay
The purpose of this deliverable is to document the
functional requirements for the development of a report which lists out the
Cancelled Orders.
The report is built using Report Builder. Information is
taken from different base tables and the corresponding columns are used to form
the report.
Basic Business Needs
The basic business needs
are to get a list of Cancelled
Orders that have been cancelled
based on the Customer name
So an Oracle Report needs
to be built which will accept the Customer
Name as group field.
Major Features
The Query is written in the data model.
The layout of the report is planned using the layout
editor.
A concurrent program of type Oracle Reports is created to
access the report and the value sets are attached to the the parameters that
are being passed.
User Procedures
In order to view the Return to Vendor Report, you must
perform the following steps:
·
Step1 : Create the report in Oracle Reports Builder
·
Step2 : Create a concurrent Program
Steps are described in more detail below.
Step 1
The report is built in Oracle Reports Builder. The columns
from the various tables are queried and displayed with the required layout
grouped by the Bank Name which is passed
as parameters based on which the report
is created.
Step 2
A concurrent program of type Oracle Reports is created and
attached to the custo request group.
Technical Overview
Considerations
The following is the Table and column information used to
develop this report.
|
Table
Name
|
Table Column |
|
OE_ORDER_HEADERS_ALL
|
HEADER_ID
|
|
|
ORDER_NUMBER
|
|
|
SOLD_TO_ORG_ID
|
|
|
CREATION_DATE
|
|
|
CANCELLED_FLAG
|
|
RA_CUSTOMERS
|
CUSTOMER_NAME
|
|
|
|
|
OE_ORDER_LINES_ALL
|
LINE_NUM
|
|
|
ORDERED_ITEM
|
|
|
CANCELLED_QUANTITY
|
|
|
CANCELLED_FLAG
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Navigation Logic
The ‘Cancelled Orders Report’ is run from the
Standard Report Submission form.
Report Definition
Title
Cancelled Orders Report
Business Requirement
Report the list Cancelled Orders by Customers name for
today.
Report Layout
Report Parameters
|
Sequence
|
Parameter Name
|
Parameter Description
|
Required? (Yes/No)
|
Default Value
|
Value Set
|
|
1
|
Bank_Name
|
Name of the Bankwith voided
cheques
|
Yes
|
Null
|
Bank_Name
|
Data Sources
|
Report Column
|
Table Name
|
Column
|
|
Bank Name
|
RA_CUSTOMERS
|
CUSTOMER_NAME
|
|
Bank Branch Name
|
OE_ORDER_LINES_ALL
|
ORDER_NUMBER
|
|
Bank Account Number
|
OE_ORDER_LINES_ALL
|
LINE_NUMBER
|
|
Account Holder Name
|
OE_ORDER_LINES_ALL
|
ORDERED_ITEM
|
|
Cheque Number
|
OE_ORDER_LINES_ALL
|
CANCELLED_QUANTITY
|
|
Total Cancelled Orders per branch
|
|
TOTAL CANCELLED ORDERS
|
|
|
|
|
Selection Criteria
The Cancelled Flag should be set
to ‘Y’
Frequency/Run Time
This Report will be run in the Production instance
The user will run this report when he wants the list of
items that have been retured to the
vendor
Launch Parameters
The typical launch parameters for this report are:
|
Sequence
|
Parameter Name
|
Parameter Description
|
Required? (Yes/No)
|
Default Value
|
Value Set
|
|
1
|
Bank_Name
|
Name of the Bank with voided
cheques
|
Yes
|
Null
|
Bank_Name
|
Output
The
output would have the following columns
n Customer
Name
n Order Number
n Line
Number
n Cancelled Quantity
n Total Cancelled Orders
Open/Closed Issues
Open issues
|
Num
|
Issue description
|
Resolution
|
Owner
|
|
0001
|
|
|
|
|
|
|
|
|
Closed issues
|
Num
|
Issue description
|
Resolution
|
Owner
|
|
|
|
|
|
|
|
|
|
|
No comments:
Post a Comment