MD070 Purchase Order - Supplier Report

MD.070 - TECHNICAL SPECIFICATION GE Supply, Shanghai GE SUPPLY – Purchase Order Report

Author: Creation Date:

07 JUN 2004

Last Updated:

07 JUN 2004

Document Name:

MD060 Order Acknowledgment Report

Version:

1.0

Copyright General Electric Corporation. All Rights Reserved

Functional Team Approval Project Leader Approval Technical Leader

GEPO Supplier Expedite Report Report

Oracle Custom

Document Control Change Record Date

Author

07/JUN/04

Version

Change Reference

1.0

No previous document

Reviewers Name

Position Functional Implementation Lead

Sign-off

Name

Location

Distribution Copy No.

Name

Location

1 2 3 4

Library Master

Project Library

Note To Holders:

If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes. If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.

/opt/scribd/conversion/tmp/scratch3110/46045681.doc Page 2 of 16 Last Updated by yugyu on 4/11/2006 09:45:00 PM

Company Confidential - For internal Use

GEPO Supplier Expedite Report Report

Oracle Custom

Contents

Document Control...................................................................2 Distribution..................................................................2 Functional Description.............................................................4 Process Flowchart.............................................................4 Process Steps & Guidelines.....................................................4 TECHNICAL APPROACH ................................................................5 Technical Environment.........................................................5 Module List...................................................................5 Technical Discussion ........................................................5 Prerequisites.................................................................5 Incompatibilities.............................................................5 Performance Considerations.....................................................6 Error Handling................................................................6 Report Layouts ...............................................................6 Database Tables Required.......................................................6 Database Views Required.......................................................6 Table and View Usage..........................................................6 Grants/Synonyms/Roles.........................................................7 Functions/Packages/Procedures/Triggers/Sequences...............................7 Forms and Reports.............................................................7 Installation and Setup .......................................................7 Testing ......................................................................8 Open Issues...................................................................8 Closed Issues ................................................................8 Notes.........................................................................8 APPENDIX .....................................................................8



GEPO Supplier Expedite Report

Oracle Custom Report

Functional Description The GE Supply China Shanghai needs a report for the Purchase Order The proposed solution includes creating a report to be available via the REPORTS option in the ORACLE Navigator screen. The purpose of this document is to layout the technical requirements for a project that addresses the functional request of incorporating the Purchase Order Report Concurrent Program. This Program Design defines the key assumptions, rules, and logic that are needed to create the Concurrent programs. This technical design document is intended to provide the developer with the necessary information for writing accurate concurrent program.

Process Flowchart The following dataflow diagram illustrates the high-level steps in the Process Validation from the host system to Oracle Apps.

User

Give Enter the parameters from SRS Window

The output of the report goes to the Output File

View Output button will open the output file.

Process Steps & Guidelines This GEPO Printed Purchase Order Report (GE Supply) the data from the Oracle Apps and outputs it in a specified format as required by User. The high level steps for the Purchase Order Report: 1. Concurrent Program is run in Oracle APPS. 2. Report output is appended with the addition of printer options (destination printer & number of copies), and additional Logos. The remaining document details focuses on technical aspects of the report.





TECHNICAL APPROACH Technical Environment This process will be constructed using the following software: 1. Oracle Reports 6i. 2. Concurrent Manager will be set up to run Concurrent Program. 3. SQL Query Development

Module List 1. Oracle APPS - The GEPO Printed Purchase Order Report (GE Supply) involves the following programs: The Concurrent Program code will be located in the respective $GEPO\11.5.0\ Reports\US\ directory.

PROCESS STEPS:

1. Concurrent Program is run having the below given parameters: 1. 2. 3. 4.

Vendor Number From Vendor Number To Report Title Sort By(PONumber,VendorNumber)

Technical Discussion A new report would be developed to meet the requirements as mentioned in the MD.020 document.

Prerequisites Application setups must be performed to support required functionality.

Incompatibilities Care should be taken not to send duplicate data. This program is incompatible with itself and the concurrent program should be set up to not to start another instance of itself. /opt/scribd/conversion/tmp/scratch3110/46045681.doc Page 5 of 16 Last Updated by yugyu on 4/11/2006 09:45:00 PM




Performance Considerations The performance aspects need to be considered from the design of the report.

Error Handling Care should be taken in scripts to handle all sorts of errors. This should be considered in all the scripts viz. the pl/sql scripts, shell scripts etc. DATABASE DESIGN Report Layouts Refer the Standard Oracle Order Acknowledgment Report.

Example Layout Sample Report for Kaye is given .Please use the Report for making the changes as given below. VendorNo: VendorName: VendorAddress1: Address1: City

PONo

PO Type Creationdate

Currency BilltoLocation Shiptolocation BuyerName

Report Notes N/A

Database Tables Required PO_VENDORS PO_VENDOR_SITES_ALL PO_HEADERS_ALL HR_LOCATIONS FND_CURRENCIES

Database Views Required N/A

Table and View Usage





Pseudo Code The report will be generated code based on the given pseudo code below:

Grants/Synonyms/Roles N/A

Functions/Packages/Procedures/Triggers/Sequences •

N/A

Forms and Reports PL/SQL and Developer 6i (Reports) will be used to develop the GEPO Printed Purchase Order Report (GE Supply) . IMPLEMENTATION NOTES Installation and Setup 1. Oracle Applications Installation The installation of these concurrent will be handled by a MD.120 document. will consist of migrating PL/SQL programs and reports.

Setup

a. Files having following extensions would be uploaded into APPS UNIX Box under the corresponding directories : Extension/ Directory Path File Type .rdf $GEPO_TOP/11.5.0\reports/US

Description Oracle Reports File

b. Following Concurrent Programs would be set-up in Oracle APPS Front - end: Concurrent Program : - GEPO Printed Purchase Order Report (GE Supply) Executable Name :- GEPOSUPP Request Group :- All GE Reports Responsibility :- GE Responsibility /opt/scribd/conversion/tmp/scratch3110/46045681.doc Page 7 of 16 Last Updated by yugyu on 4/11/2006 09:45:00 PM




Testing

The test plan will contain considerations for many variables that are factors on the reports output. A list of those variables has been consolidated below with specific items that will be tested for each variable.

Open and Closed Issues Open Issues

Closed Issues Supplier are not defined -Functional consultant should defind the Suppleirs ,sites, contacts details.

Notes APPENDIX



MD070 Purchase Order - Supplier Report

Recommend Documents