Percentage Delivered on Time Sales Orders Report

MD.070 Application Extension Technical Design

Intelligroup Asia Pvt Limited

      Percentage Delivered on Time

    Sales Orders Report

Contents

Document Control................................................................................................................................... ii

Technical Overview................................................................................................................................. 1

Approach........................................................................................................................................... 1

Module List....................................................................................................................................... 1

Table and View Usage.................................................................................................................... 1

Program Logic (pseudo code)........................................................................................................ 1

In this report based on the Part query will be running,.............................................................. 1

SQL Statements............................................................................................................................... 2

Concurrent Programs.............................................................................................................................. 3

Value Sets.......................................................................................................................................... 3

Database Design...................................................................................................................................... 4

Tables, Indexes, Sequences........................................................................................................... 4

Descriptive Flexfields...................................................................................................................... 4

Grants /Synonyms........................................................................................................................... 4

Installation Requirements...................................................................................................................... 5

Pre-Installation steps....................................................................................................................... 5

Installation........................................................................................................................................ 5

Test Plans.................................................................................................................................................. 6

Unit Test Plan................................................................................................................................... 6

Open and Closed Issues.......................................................................................................................... 7

Open Issues....................................................................................................................................... 7

Closed Issues.................................................................................................................................... 7

Note:To update the table of contents, put the cursor anywhere in the table and press [F9].  To change the number of levels displayed, select the menu option Insert‑>Index and Tables, make sure the Table of Contents tab is active, and change the Number of Levels to a new value.

Technical Overview

This document defines the technical components required to implement a report for ITGR: Percentage Delivered on Time Sales Orders. This report has been developed using Oracle Reports 6i, which is used to display the details required by the business. Based on the user parameters, details can be filtered.

Approach

Ø  The report should display details like Item, Qty Ordered, Qty. Shipped, Method of Shipment, Requested Ship Date,Actual Ship Date, Percentage On Time Delivery.

Ø  The report can be generated based on the given parameter values.

Note: 

Note: 

Note: 

Note: 

Note: 

Note: 

Note: 

Note:If the Functional Design included a Technical Overview section, duplicate that information here and add additional details.

Module List

Forms

 N/A

Reports

ITGROEXDONSO.rdf

Concurrent Programs

ITGR: Percentage Delivered on Time Sales Orders

This Report is developed to show the Percentage of a product delivered by a requested date.

Table and View Usage

Table Name	SELECT	INSERT	UPDATE	DELETE
OE_ORDER_HEADERS	X
OE_ORDER_LINES	X

Note: 

Note: 

Note: 

Note: 

Note: 

Note: 

Note: 

Note: 

Note:Add other components above as required

Program Logic (pseudo code)

In this report based on the Part query will be running,

SQL Statements

SELECT   oel.ordered_item           item,

         oel.ordered_quantity              qtyordered,

         oel.shipped_quantity              qtyshipped,

         oeh.shipping_method_code   methodofshipment,

         oel.schedule_ship_date           requestedshipdate,

         oel.actual_shipment_date    actualshipdate

    FROM oe_order_headers     oeh,

       oe_order_lines         oel

   WHERE oel.ship_from_org_id = :orgid

   AND oeh.header_id = oel.header_id

   AND oel.ordered_item = :item

   ORDER BY oel.ordered_item

Concurrent Programs

Concurrent Program Executable:

Executable	ITGR_OEXDONSO
Short Name	OEXDONSO
Application	Business Online
Description	ITGR: Percentage Delivered on Time Sales Orders
Execution Method	Oracle Reports
Execution File Name	ITGROEXDONSO
Subroutine Name

Program          : ITGR: Percentage Delivered on Time Sales Orders			Enabled [ X ]
Short Name    : OEXDONSO
Application     : Business Online e
Description    :  ITGR: Percentage Delivered on Time Sales Orders
Conflicts Domain Parameter
SEQ	PARAMETER	DESCRIPTION	ENABLED
1	Item	Item	Y

Value Sets

Value Set	Size	Type	Rqd	Validation/Values
ITEM_NO1	40	Character		Characters

COMMENTS/SPECIAL INSTRUCTIONS

Incompatibilities:

Application :

Name :

Scope :

Type :

Database Design

This section summarizes new and changed database objects and data required for Percentage Delivered on Time Sales Orders Report.

Tables, Indexes, Sequences   

Descriptive Flexfields

Grants /Synonyms

Sequences

Installation Requirements

Installation scripts must be prepared to perform the following actions in an automated way:

·         Define Value Sets.

·         Register Concurrent Programs.

·         Register Standard Report Submission parameters.

Pre-Installation steps

Installation Steps

Installation

All modules are installed as if part of a separate product.  A UNIX directory structure is created under $XBOL_TOP as shown in the following example:

                                                    $XBOL_TOP

                                                               |

                                                            1.0.0

                 ___________________________|___________________________________

                |       |       |               |       |       |        |      |               |

                reports

                |

                US

The directories contain the components of the enhancement as shown below (directories not listed are empty). 

Test Plans

Unit Test Plan

Seq	Action	Expected Results	Actual Results

Open and Closed Issues

Open Issues

Business ID	Issue	Resolution	Responsibility	Target Date	Impact Date
1

Closed Issues

Business ID	Issue	Resolution	Responsibility	Target Date	Impact Date
1.
2.
3.