AIM
CV.060 CONVERSION PROGRAM
DESIGNS
<Company Long Name>
<Subject>
Author: <Author>
Creation Date: May 19, 1999
Last Updated: May 28, 1999
Document Ref: <Document Reference Number>
Version: DRAFT 1A
Approvals:
<Approver 1>
<Approver 2>
CV.060 Conversion Program Designs Doc Ref: <Document Reference Number>
May 28, 1999
Document Control
Change Record
5
Date Author Versio Change Reference
n
19-May- <Author> Draft No Previous Document
99 1a
Reviewers
Name Position
Distribution
Copy Name Location
No.
1 Library Master Project Library
2 Project Manager
3
4
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.
<Subject> Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. DRAFT 1A )
Company Confidential - For internal use only
CV.060 Conversion Program Designs Doc Ref: <Document Reference Number>
May 28, 1999
Contents
Document Control.......................................................................................ii
Introduction................................................................................................1
Century Date Compliance.....................................................................1
Conversion Assumptions.............................................................................3
Scope....................................................................................................3
Clean-Up Criteria...................................................................................3
Approach....................................................................................................4
Conversion Tables.................................................................................4
Ordering of Tables.................................................................................4
Dependencies.......................................................................................4
Processing Rules.........................................................................................5
Translation Rules........................................................................................7
Filter Rules..................................................................................................8
Foreign Key Rules.......................................................................................9
Derivation Rules.......................................................................................10
Default Values..........................................................................................11
Download Program Logic..........................................................................12
Interface Table Creation Program Logic....................................................13
Upload Program Logic...............................................................................14
Translation Program Logic........................................................................15
Interface/Validation Program Logic...........................................................16
Conversion Program Modules...................................................................17
Conversion Programs..........................................................................17
Automated Conversion Tool Files........................................................17
Open and Closed Issues for this Deliverable.............................................18
Open Issues.........................................................................................18
Closed Issues.......................................................................................18
<Subject> Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. DRAFT 1A )
Company Confidential - For internal use only
Doc Ref:
Introduction
This Conversion Program Design defines the key assumptions, rules, and
logic that are needed to create the conversion programs. The conversion
program code is not included in this document. The Develop Conversion
Programs (CV.080) task contains the actual code that is written and
debugged to perform the conversion. The conversion design document is
intended to provide the developer with the necessary information for
writing accurate conversion programs.
The Conversion Program Design is used to document and communicate
the conversion program design specifications for the conversion of an
individual business object to the Oracle Applications.
Distribute the Conversion Program Design to:
• developers who are responsible for writing the various pieces of
conversion code
• conversion project staff
• client staff member responsible for signing off on the
completeness of this program design
• overall project manager
• conversion project manager
Use the following criteria to ensure the quality of this deliverable:
Is the conversion data mapping complete? Are there any
application setup decisions that have not been finalized
which directly impact the data mapping and the accuracy of
the conversion code?
Are all of the rules which impact conversion documented so
that they can be written in the conversion code?
Is the program logic required to write the conversion code
documented?
Century Date Compliance
In the past, two character date coding was an acceptable convention due
to perceived costs associated with the additional disk and memory
storage requirements of full four character date encoding. As the year
2000 approached, it became evident that a full four character coding
scheme was more appropriate.
In the context of the Application Implementation Method (AIM), the
convention Century Date or C/Date support rather than Year2000 or Y2K
support is used. Coding for any future Century Date is now considered
the modern business and technical convention.
Every applications implementation team needs to consider the impact of
the century date on their implementation project. As part of the
implementation effort, all customizations, legacy data conversions, and
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
custom interfaces need to be reviewed for Century Date
compliance.
Programmatically converted legacy data must be translated to the
appropriate century date state before being uploaded to the production
tables. Manually converted legacy data must be keyed into the data
entry forms using 4 digits for the year, where supported.
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
Conversion Assumptions
The following are the <Business Object To Be Converted> conversion
criteria assumptions:
•
•
•
Scope
The following boundaries are specific to the conversion of the <Business
Object To Be Converted>:
Data Selection Criteria
Data Manipulation Criteria
Data Production Criteria
Data Exclusion Criteria
Clean-Up Criteria
Below is a list of clean-up criteria for the conversion of <Business Object
To Be Converted>:
Pre-Conversion Clean-Up Criteria
•
•
•
Post-Conversion Clean-Up Criteria
•
•
•
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
Approach
This section describes the:
• Oracle tables that will be populated during the conversion of
<Business Object To Be Converted>
• order in which the tables need to be populated
• dependencies between the tables that need to be populated and
any other tables in the Oracle system
Conversion Tables
The following tables are going to be populated in the Oracle application
for the conversion of <Business Object To Be Converted>:
•
•
•
Ordering of Tables
Below is the order in which the tables need to be populated for the
conversion of <Business Object To Be Converted>:
Dependencies
Following is a list of tables that need to be populated before <Business
Object To Be Converted> can be converted:
Foreign Key Dependencies
Parent/Child Dependencies
Quick Code Dependencies
Data Element Domains
Use of Sequence Generators
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
Processing Rules
This section lists the processing rules that are to be used in the
conversion of <Business Object To Be Converted>:
Rules:
<Business Object Abbreviation>PR1: <Describe Processing Rule 1>
<Business Object Abbreviation>PR2: <Describe Processing Rule 2>
<Business Object Abbreviation>PR3: <Describe Processing Rule 3>
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
Processing Legacy Data Source Legacy Data Element Data Target Table. Data
Rule Size/Type Column Size/Type
<Business
Object
Abbreviatio
n>PR1
<Business
Object
Abbreviatio
n>PR2
<Business
Object
Abbreviatio
n>PR3
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
Translation Rules
This section lists the translation rules which are to be used in the
conversion of <Business Object To Be Converted>:
Rules:
<Business Object Abbreviation>TR1: <Describe Translation Rule 1>
<Business Object Abbreviation>TR2: <Describe Translation Rule 2>
<Business Object Abbreviation>TR3: <Describe Translation Rule 3>
Processing Legacy Data Source Legacy Data Element Data Target Table. Column Data
Rule Size/Type Size/Type
<Business
Object
Abbreviatio
n>TR1
<Business
Object
Abbreviatio
n>TR2
<Business
Object
Abbreviatio
n>TR3
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
Filter Rules
This section lists the filter rules that are to be used in the conversion of
<Business Object To Be Converted>:
Rules:
<Business Object Abbreviation>FR1: <Describe Filter Rule 1>
<Business Object Abbreviation>FR2: <Describe Filter Rule 2>
<Business Object Abbreviation>FR3: <Describe Filter Rule 3>
Processing Legacy Data Source Legacy Data Element Data Size/Type Target Table. Column Data Size/Type
Rule
<Business
Object
Abbreviatio
n>FR1
<Business
Object
Abbreviatio
n>FR2
<Business
Object
Abbreviatio
n>FR3
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
Foreign Key Rules
This section lists the foreign key rules that are to be used in the
conversion of <Business Object To Be Converted>:
Rules:
<Business Object Abbreviation>FKR1: <Describe Foreign Key Rule
1>
<Business Object Abbreviation>FKR2: <Describe Foreign Key Rule
2>
<Business Object Abbreviation>FKR3: <Describe Foreign Key Rule
3>
Processing Legacy Data Source Legacy Data Data Size/Type Target Table. Column Data Size/Type
Rule Element
<Business
Object
Abbreviation
>FKR1
<Business
Object
Abbreviation
>FKR2
<Business
Object
Abbreviation
>FKR3
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
Derivation Rules
Below is a table listing the derivation rules that are to be used in the
conversion of <Business Object To Be Converted>:
Processing Legacy Data Source Legacy Data Element Data Size/Type Target Table. Column Data
Rule Size/Type
<Business
Object
Abbreviation
>DR1
<Business
Object
Abbreviation
>DR2
<Business
Object
Abbreviation
>DR3
Rules:
<Business Object Abbreviation>DR1: <Describe Derivation Rule 1>
<Business Object Abbreviation>DR2: <Describe Derivation Rule 2>
<Business Object Abbreviation>DR3: <Describe Derivation Rule 3>
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
Default Values
This section lists the default value rules that are to be used in the
conversion of <Business Object To Be Converted>. The default value
rules explain the logic behind why a certain default value has been
selected.
Rules:
<Business Object Abbreviation>DV1: <Describe Default Value Rule
1>
<Business Object Abbreviation>DV2: <Describe Default Value Rule
2>
<Business Object Abbreviation>DV3: <Describe Default Value Rule
3>
Processing Legacy Data Source Legacy Data Data Size/Type Target Table. Column Data Size/Type
Rule Element
<Business
Object
Abbreviation
>DV1
<Business
Object
Abbreviation
>DV2
<Business
Object
Abbreviation
>DV3
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
Download Program Logic
This section describes the logic for the conversion download programs
that will be built to support the conversion of <Business Object To Be
Converted>.
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
Interface Table Creation Program Logic
This section describes the logic for the conversion interface table creation
programs that will be built to support the conversion of <Business Object
To Be Converted>.
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
Upload Program Logic
This section describes the logic for the conversion upload programs that
will be built to support the conversion of <Business Object To Be
Converted>.
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
Translation Program Logic
This section describes the logic for the conversion translation programs
that will be built to support the conversion of <Business Object To Be
Converted>.
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
Interface/Validation Program Logic
This section describes the logic for the conversion interface/validation
programs that will be built to support the conversion of <Business Object
To Be Converted>.
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
Conversion Program Modules
Conversion Programs
The following table lists each program created for the conversion of <Business Object To Be Converted>:
Program Type Program Description/Purpose Program Location Developer Flat File: File Name and Location
Name (if any)
Automated Conversion Tool Files
Sequence <Conversion Tool> <Conversion Script Data File Location of Template Target Oracle Developer Comments
Tool> Name Name & Table
Template Name Map File Name Maps
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
Doc Ref:
Open and Closed Issues for this Deliverable
Open Issues
ID Issue Resolution Responsibility Target Date Impact
Date
Closed Issues
ID Issue Resolution Responsibili Target Impact Date
ty Date
Open and Closed Issues for this Deliverable
File Ref: 39674453.doc (v. )
Company Confidential - For internal use only
