APP132 -- DETAILED TEST PLAN:

Conversion Test 2 - FY2004 YE/FY2005 Nov STARS Conversion

*Department of Energy I-MANAGE Program - STARS Project*

+------------------+---------------------------------------------------+
| Deliverable ID:  | APP132 -- DETAILED TEST PLAN: Conversion Test 2 - |
|                  | FY2004 YE/FY2005 Nov STARS Conversion             |
+------------------+---------------------------------------------------+
| Version number:  | 1.03                                              |
+------------------+---------------------------------------------------+
| Draft as of:     | *1 December 2004*                                 |
+------------------+---------------------------------------------------+
| Printed on:      | 12 November 2023                                  |
+------------------+---------------------------------------------------+
| Author:          | Mark Tulip                                        |
|                  |                                                   |
|                  | Mark.tulip@hq.doe.gov                             |
|                  |                                                   |
|                  | 301-903-3812                                      |
+------------------+---------------------------------------------------+
| Owner:           | Laura Kramer, STARS Project Manager               |
+------------------+---------------------------------------------------+

Status of Document

> Draft
>
> Delivered
>
> Accepted

Document information

Document source

This document is maintained as an online document. Contact the author
for the latest version.

Revision history

  --------- --------- ------------------------------------- -----------------
  Version   Date      Summary of changes                    Revised By
  number                                                    

  1.01      25 Nov 04 Initial version of test plan          Mark Tulip

  1.02      29 Nov 04 Revised by Federal DEV Team Lead      Bryan Long

  1.03      01 Dec 04 Reviewed / Revised by Team IBM        Don A. Cox
                      Project Executive                     
  --------- --------- ------------------------------------- -----------------

Approvals

The following people have approved this document. (Sign below name)

  -------------------------------------- --------------------------------
  Name                                   Function

  Laura Kramer                           DOE I-MANAGE Stars Project
                                         Manager

  **Signature**                          **Date:**

                                         

  Don Cox                                Team IBM I-MANAGE Project
                                         Executive

  **Signature:**                         **Date:**
  -------------------------------------- --------------------------------

Distribution

This document has been distributed to:

  -------------------------------------- --------------------------------
  Name                                   Function

                                         

                                         
  -------------------------------------- --------------------------------

1.  **Test Objectives**

    The test objectives listed within this document are in accordance
    with the principles outlined in the ENG354 Mid-Year Conversion
    Strategy. As such, this conversion test is to validate the following
    data conversions:

-   General Ledger (GL) data from DISCAS and MARS into STARS for the
    October and November Fiscal Year 2005 period

-   Vendors, employees, and customers

-   Sub-ledger data for Purchasing (PO) and Accounts Payable (AP), both
    Fiscal Year 2004 ending balances for cumulative reporting, and
    Fiscal Year 2005 November cumulative balances.

-   Accounts Receivable (AR) and Fixed Assets (FA) Fiscal Year 2005
    November balances

    The execution of the conversion is comprised of the following steps:

-   Extracting the legacy data from DISCAS and MARS (All)

-   Importing the data into staging tables (All)

-   Cross walking the data into the STARS format, (All)

-   Importing the journals into Oracle (GL)

-   Posting the journal entries (GL)

-   Creating Bank Accounts (Vendor)

-   Creating Vendors in Oracle (Vendor)

-   Creating Vendor Sites in Oracle (Vendor)

-   Creating Vendors for each Employee in Oracle (Employee)

-   Creating Vendor Sites for each Employee in Oracle (Employee)

-   Creating HR records for each Employee in Oracle (Employee)

-   Executing the DOEinfo -- Employee interface to update employee
    information (Employee)

-   Populate the required fields necessary to get the Revenue and
    Receivable CCID values (Customers)

-   Loading AR Customer interface tables and running Standard "Customer
    Interface" to create Customers in Oracle tables (Customers)

-   Grouping and pre-validating the DISCAS data (PO/AP/AR/FA)

-   Creating PO and Receipt Transaction Codes (PO)

-   Loading PO interface tables and running standard PO import utility
    to create POs in Oracle tables (PO)

-   Approving the newly created POs through 'PO Approval Workflow'
    process (PO)

-   Loading Receiving interface tables and running Standard "Receiving
    Transaction Processor" to create Receipts in Oracle tables (PO)

-   Loading invoices into AP Invoice interface tables and breaking them
    into appropriate batch sizes before handling over to DCT for invoice
    creations in Oracle from interface tables (AP)

-   Loading the Receivables Invoices and Credit Memos to AR Interface
    tables (AR)

-   Through Autoinvoice, create AR Transactions from Interface table
    (AR)

-   Process GL Advances through Receipt APIs and AR Interface table (AR)

-   Loading Assets into Oracle (FA)

-   Running of Depreciation (FA)

-   Extraction and posting of Fiscal Year 2004 ending cumulative
    balances in PO and AP to GL period 13 for cumulative reporting.
    (PO/AP)

-   Logging any entries that fail anywhere throughout the process.

    The conversion test described within this document ensures each of
    these steps as well as the overall conversion is executed properly.

    1.  **Functions/Features to be Tested**

        The functions and features to be tested during this process
        correspond directly to the test objectives listed in section
        1.1. These are as follows:

```{=html}
<!-- -->
```
-   The data load of legacy data files into custom tables

-   The cross walk of data from the legacy system values to the new
    STARS values.

-   The data load into the standard GL interface import tables via
    Oracle's standard gl_interface.

-   Running Oracle's standard Journal Import process to create Journal
    entries, and then posting the data into the correct conversion
    period via Oracle's standard posting process.

-   Inserting Bank Accounts (Vendors)

-   Inserting a vendor and vendor site record for each vendor (Vendors)

-   Inserting a vendor and vendor site record for each employee
    (Employee)

-   Execution of the create_employee, create_person_address, and
    create_phone APIs for each employee (Employee)

-   Execution of the Doeinfo -- Employee interface to update employee
    information unavailable from DISCAS (Employee)

-   Valid Revenue and Receivable CCIDs are created and assigned to
    debtor records (Customers)

-   Customers are created in Oracle from interface tables (Customers)

-   Valid Transaction Codes are assigned to DISCAS POs (PO)

-   POs are created and approved (PO)

-   Journal Entries are created by ensuring successful run of concurrent
    program called 'Program- Create Journals' (PO)

-   Valid Transaction Codes are assigned to STARS Receipts (PO)

-   Receipts are created in Oracle from the interface tables (PO)

-   Invoices are created in Oracle from the interface tables (AP)

-   The data load into the AR Interface table and to Oracle Standard
    Receivables tables via Oracle's Autoinvoice and APIs (AR)

-   Inserting of assets (FA)

-   Running Depreciation in Oracle (FA)

-   Posting of sub-ledger transactions into GL (PO/AP/AR/FA)

    1.  **Work Items**

        The detailed test plans for each conversion are attached at the
        end of this document.

    2.  **Entry and Exit Criteria for Level**

        Entry Criteria

```{=html}
<!-- -->
```
-   Oracle Applications GL, PO, AP, AR, FA setups

-   Legacy data files extracted

-   Conversion program and SQL\*Loader ctl files created

-   STARS baseline instance available

-   Data mapping and Crosswalk tables complete

    Exit Criteria

-   GL journals entered and posted in Oracle

-   Vendors are created in Oracle

-   Employees are created in Oracle

-   Employee information updated from DOEinfo

-   Customers are created in Oracle

-   POs are created and approved in Oracle

-   PO Receipts are created in Oracle

-   AP Invoices are created in Oracle

-   AR Invoices, Credit Memos and Receipts are created in Oracle

-   Assets are created in Oracle

-   Depreciation executed

-   Error logs reviewed

-   All entries not loaded due to errors identified and handled

-   Reconciliation routines run and output confirmed

-   Comparison of the MARS Trial Balance with the STARS Trial Balance
    for each Fund, Allottee, and SGL combination identified by the Data
    Reconciliation Team

    1.  **Testing Tools and Techniques**

        Tools that will be used during the Conversion process are:

-   Oracle SQL\*Loader -- for loading of the data files into the staging
    tables

-   TOAD (Tools for Oracle Application Developers) -- for running
    queries during the staging process.

-   Oracle SQL\*Plus -- for executing the procedures from the
    gl_conv_pkg, c_po_vendor_pkg, c_emp_pkg, c_ar_customer,
    c_po_convert_rollup, c_ap_convert packages, c_ar_convert, and
    c_fa_conv.pkg conversion packages, and running various conversion
    and test sql scripts.

```{=html}
<!-- -->
```
-   Windows CMD Line -- used for splitting the GL source files into 8
    sub-files, and for executing the sql\*loader program from sql\*plus
    to load data into the staging tables.

    1.  **Test Schedule**

        The following presents a summary level list of tasks with each
        task's corresponding duration, start date, and finish date. This
        is followed by details surrounding the actual execution of the
        conversion program.

  -------------------------------------- -------------- ------------ ------------
  **Task**                               **Duration**   **Start      **Finish
                                                        Date**       Date**

  Conversion Test 2 - FY04 / Nov ME      26 days        11/22/2004   12/30/2004
  FY2005 STARS Conversion                                            

  Publish Conversion Test 2 Plan /       5 days         11/22/2004   11/30/2004
  Success Criteria                                                   

  Pre-Conversion Instance Configuration  5 days         12/01/2004   12/07/2004

  Receive DISCAS / MARS Nov 04 Extract   0 days         12/07/2004   12/07/2004

  Execute GL to GL Conversion            2 days         12/07/2004   12/08/2004

  Execute Vendor Conversion              2 days         12/08/2004   12/09/2004

  Execute Employee Conversion            2 days         12/08/2004   12/09/2004

  Execute Employee Interface             2 days         12/10/2004   12/13/2004

  Execute AR Customer Conversion         2 days         12/08/2004   12/09/2004

  Execute PO / AP / AR / FA Conversion   5 days         12/14/2004   12/20/2004

  Execute Post Conversion Activities     2 days         12/21/2004   12/22/2004

  Conversion Test 2 Reconciliation       5 days         12/23/2004   12/30/2004
  Support / Issue Resolution                                         
  -------------------------------------- -------------- ------------ ------------

Tuesday, November 30, 2004

-   STARS instance turned over for conversion of the instance

-   STARS apps and custom passwords given

-   Access to GL, PO, AP, AR, FA, Sysadmin, and Applications Admin given
    thru the applications

    Wednesday, December 1, 2004 -- Tuesday December 7, 2004

```{=html}
<!-- -->
```
-   Confirm setup and technical installation follows baseline
    configuration

-   Confirm values setup is accurate and complete

    Tuesday, December 7, 2004

```{=html}
<!-- -->
```
-   Setup static DISCAS and MARS databases and extract data

    Wednesday, December 8, 2004

```{=html}
<!-- -->
```
-   Create the database objects in the instance (tables, views, grants,
    sequences, packages, the common routines program)

-   Receive the data extract files from DISCAS and MARS

-   Load the GL, vendor, employee, and customer extract files into the
    staging tables

-   Send out query of gl_code_combinations that did not crosswalk

-   Load the entries thru the conversion program into the gl_interface
    table

-   Create Vendors

-   Create Vendor Sites

-   Execute Create_employee, create_person_address and create_phone APIs

-   Customer Category, Customer Class, Communication Type and Customer
    Profile setups are verified

-   Duplicate Debtors and Orders are checked

-   Extract data is loaded into AR Customer Interface tables

-   'Customer Interface is run to create customers in Oracle from
    Interface tables

    Thursday, December 9, 2004

-   Execute the GL Journal Import program

-   Change the GL Period, and post the Journals in the applications

-   Review Journals and obtain sign off from the DCT team

-   Review Vendor records and obtain sign off from the DCT team

-   Review Customer records and obtain sign off from the DCT team

    Friday, December 10, 2004 -- Monday, December 13, 2004

-   Execute the DOEinfo -- Employee interface program.

-   Review Employee records and obtain sign off from the DCT team

    Tuesday, December 14, 2004

```{=html}
<!-- -->
```
-   Extracted PO, AP, FA data is loaded into custom staging tables

```{=html}
<!-- -->
```
-   Create Assets (FA)

```{=html}
<!-- -->
```
-   Run Depreciation (FA)

    Wednesday, December 15, 2004 -- Friday, December 17, 2004

-   Review Assets records and obtain sign off from the DCT team (FA)

-   Required Default spreadsheet and PCS datasheet are provided by DCT
    (PO)

-   Accounting segments and Transactions codes are cross walked and
    verified by DCT. Null ID Number is verified and default provided by
    DCT. If required, missing AFF segment values are created by DCT

-   CCIDS are created and assigned to rolled up PO data

-   PO Interface tables are loaded and batch IDs assigned

-   POs are created in Oracle usgin 'Import Standard Purchase Order'
    program

-   Newly created POs are approved using 'Workflow Background Process"

-   Any POs stuck in 'IN PROCESS' status are investigated to make sure
    that all POs are approved

-   Concurrent program "Program -- Create Journals" is run under DOE GL
    Superuser responsibility (PO)

Saturday, December 18, 2004

-   Main AP package "c_ap_convert" is created and compiled in new
    instance

-   All AP setup including GL and Purchasing periods are verified to be
    existing, valid and open

-   Receipts are loaded from custom.c_po_convert_rollup table to
    Receipts Interface tables (PO)

-   Default Location called "CONVERSION' is created through 'DOE
    Application Admin" responsibility

-   Under the same responsibility, Location/Inventory Orgs are
    associated

-   Standard program "Receiving Transaction Processor' is run to create
    Receipts in Oracle from Receiving Interface tables (PO)

-   Invoices sitting in c_po_convert_rollup tables are verified by
    executing verifyinvoices procedure in c_ap_convert package (AP)

-   Invoices are loaded into AP Interface tables (AP)

-   Invoices are grouped based on the number of invoices and
    distributions (AP)

-   DCT is informed of the group IDs created in interface tables. DCT
    informs DEV team when they have created invoices for the group IDs
    sent to them. (AP)

Sunday, December 19, 2004 -- Monday, December 20, 2004

-   AR Extract data loaded into custom staging tables

-   Legacy segments are cross walked and any missing segments created by
    DCT (AR)

-   SGL accounts are cross walked based on BSC codes as provided by DCT
    (AR)

-   Code Combinations are created and assigned to staged receivables
    data (AR)

-   Transaction flexfields are created and verified (AR)

-   Conversion source is created and verified (AR)

-   Transaction Types are verified to be setup by DCT (AR)

-   GL date updated in the package and confirmed with DCT (AR)

-   GL period is verified to be valid and open (AR)

-   Invoices and Credit Memos are loaded into AR interface tables (AR)

-   Invoices and Credit Memos are created in Oracle from Interface
    tables using "Autoinvoice" utility (AR)

-   Credit Memos are created to close debit items created for Finance
    Charges (AR)

-   GL Advances data are cross walked, SGL segments assigned based on
    BSC codes and GL CCIDS created and assigned to grouped GL Advances
    transactions. (AR)

-   On-Account and Unidentified Receipts are created using AR APIs (AR)

-   Invoices are created for 39xx debit balances using Autoinvoice (AR)

-   Review PO, AP, AR records and obtain sign off from the DCT team
    (PO/AP/AR)

Tuesday, December 21, 2004 -- Wednesday, December 22, 2004

-   DCT executes Post-Conversion activities

Thursday, December 23, 2004 -- Thursday, December 30, 2004

-   Reconcile STARS converted data to DISCAS and MARS

-   Identify and address conversion/reconciliation issues

    1.  **Test Environment Requirements**

        The following are requirements of the testing environment.

```{=html}
<!-- -->
```
-   In order to execute conversion testing, the baseline instance must
    be established along with the application login and passwords to the
    apps and custom schemas.

-   To execute the conversion and conduct appropriate unit testing, the
    user will need DOE GL Superuser, DOE Payables SuperUser, DOE
    Purchasing Superuser, DOE AR Superuser, DOE PR and PO entries with
    Processes, DOE PO Application Administrator, DOE AR Superuser, DOE
    FA SuperUser, and Sysadmin responsibilities.

-   If errors are discovered prior to running Oracle's standard Journal
    Import, Import Standard Purchase Orders, Receiving Transaction
    Processor, or Autoinvoice processes, the data in the staging tables
    will be deleted, the errors corrected, and the data load
    re-executed. If errors are discovered after running the Journal
    Import process, the instance will need to be refreshed by the IT
    Team back to the baseline. At that point, the errors will be
    corrected and the data load re-executed.

    1.  **Risks and Contingencies**

        1.  Legacy System Data

```{=html}
<!-- -->
```
-   Risk - Extract data files not available

-   Contingency -- None. This data is necessary for implementation.
    However, the DEV Team will work with the legacy system owners where
    possible to resolve any issues with extracting the data. This task
    can be delayed if necessary since it is only needs to be
    accomplished just prior to go-live. Therefore, the impact of the
    data files being unavailable at the scheduled start date of this
    task is minimal.

    1.  STRS Instance

-   Risk - STRS instance not available

-   Contingency -- This task can be accomplished by using another
    instance. The impact of this is a schedule delay of this task while
    the IT Team readies another instance of suitable proportions. The
    impact of the realization of this risk would be minimal, assuming
    another instance could be made available.

    1.  Mapping

-   Risk - Crosswalk data not correctly mapped

-   Contingency -- There is ample time to correct the mapping since the
    converted data is truly not needed until just prior to
    implementation. Therefore, the mapping can be corrected and the
    conversion re-run, if necessary. Another option is to correct the
    entries after they have been created in STARS.

Appendix A: Detailed Test Plans

A.1 General Ledger Conversion Test Plan

+----+-------------------+------------------+----------------+-------+
| ** | **Conversion      | **Testing Step** | **Expected     | **A   |
| Un | Step**            |                  | Results**      | ctual |
| it |                   |                  |                | Resu  |
| T  |                   |                  |                | lts** |
| es |                   |                  |                |       |
| ti |                   |                  |                |       |
| ng |                   |                  |                |       |
| St |                   |                  |                |       |
| ep |                   |                  |                |       |
| ** |                   |                  |                |       |
+====+===================+==================+================+=======+
| 1  | Verify that view  | Execute the      | Description of |       |
| .1 | c_aff_crosswalk_v | following        | the view is    |       |
| .3 | exists in the     | command as       | displayed to   |       |
|    | CUSTOM schema     | custom:          | verify that    |       |
|    |                   |                  | the view was   |       |
|    |                   | SQL\> desc       | created.       |       |
|    |                   | custom.          |                |       |
|    |                   | c                |                |       |
|    |                   | _aff_crosswalk_v |                |       |
+----+-------------------+------------------+----------------+-------+
| 1  | Ensure that the   | Execute the      | Should return  |       |
| .1 | package           | following query  | a value of     |       |
| .4 | apps.c_co         | as apps:         | 'VALID'        |       |
|    | mmon_routines_pkg |                  |                |       |
|    | is valid          | SQL\> select     |                |       |
|    |                   | distinct(status) |                |       |
|    |                   |                  |                |       |
|    |                   | from dba_objects |                |       |
|    |                   |                  |                |       |
|    |                   | where            |                |       |
|    |                   | object_name like |                |       |
|    |                   | \'C_COMMO        |                |       |
|    |                   | N_ROUTINES_PKG\' |                |       |
|    |                   |                  |                |       |
|    |                   | and owner =      |                |       |
|    |                   | \'APPS\'         |                |       |
+----+-------------------+------------------+----------------+-------+
| 1  | Ensure that the   | Log into the     | Responsibility |       |
| .1 | 'DOE GL           | applications,    | is setup       |       |
| .5 | Superuser' exists | and verify that  |                |       |
|    |                   | the              |                |       |
|    |                   | responsibility   |                |       |
|    |                   | exists.          |                |       |
+----+-------------------+------------------+----------------+-------+
| 1  | Ensure that the   | Log into 'DOE GL | Period         |       |
| .1 | period is open in | Superuser',      | 'SEPADJ1-04'   |       |
| .6 | the applications  | navigate to      | is 'Open';     |       |
|    | that the          | Setup:           |                |       |
|    | conversion is     | Open/Close,      | 'SEP-04' is    |       |
|    | going to occur.   |                  | 'Open'         |       |
|    | Ex. SEP-04.       | verify that the  |                |       |
|    |                   | conversion       |                |       |
|    |                   | period'SEP-04'   |                |       |
|    |                   | and 'SEPADJ1-04' |                |       |
|    |                   | are Open         |                |       |
+----+-------------------+------------------+----------------+-------+
| 1. | Verify DFFs are   | Log into 'DOE GL | All the DFF's  |       |
| 17 | set up in the     | Superuser',      | are setup and  |       |
|    | instance for CID, | navigate to      | they are set   |       |
|    | Asset_type,       | Setup:           | to optional    |       |
|    | Asset_status,     | Financials:      |                |       |
|    | OPI, Environment  | Flexfields:      |                |       |
|    | Liability Type,   | Descriptive:     |                |       |
|    | and Trading       | Segments,        |                |       |
|    | Partner. All DFFs |                  |                |       |
|    | should be set up  | Query up the     |                |       |
|    | to be optional.   | 'Enter Journals: |                |       |
|    |                   | Lines' DFF,      |                |       |
|    |                   | click on the     |                |       |
|    |                   | segments button  |                |       |
|    |                   | under global     |                |       |
|    |                   | data elements,   |                |       |
|    |                   | and verify that  |                |       |
|    |                   | they are setup.  |                |       |
+----+-------------------+------------------+----------------+-------+
| 1. | Verify AutoPost   | Log into 'DOE GL | There are      |       |
| 18 | criteria exists   | Superuser',      | records setup, |       |
|    | and is set up to  | navigate to      | and they are   |       |
|    | automatically     | Setup: Journal:  | set to         |       |
|    | post all batches  | Autopost,        | automatically  |       |
|    | created by        |                  | post all       |       |
|    | Journal Import    | Query all        | batches        |       |
|    |                   | records          |                |       |
+----+-------------------+------------------+----------------+-------+
| 1  | Remove all        | Log into 'DOE GL | Query should   |       |
| .2 | Summary Templates | Superuser',      | return with no |       |
|    |                   | navigate to      | records        |       |
|    | Log into 'DOE GL  | Setup: Accounts: |                |       |
|    | Superuser',       | Summary          |                |       |
|    | navigate to       |                  |                |       |
|    | Setup: Accounts:  | Query all        |                |       |
|    | Summary           | templates        |                |       |
|    |                   |                  |                |       |
|    | Query all         |                  |                |       |
|    | templates         |                  |                |       |
|    |                   |                  |                |       |
|    | Delete all        |                  |                |       |
|    | templates using   |                  |                |       |
|    | the red X         |                  |                |       |
|    |                   |                  |                |       |
|    | Save records      |                  |                |       |
+----+-------------------+------------------+----------------+-------+
| 1  | Download from     | On your          | All the files  | 1.3   |
| .3 | PVCS all of the   | computer, open   | from the PVCS  |       |
|    | files in the      | windows          | directory are  |       |
|    | CustomSQL         | explorer.        | in the         |       |
|    | \\Conversions\\GL | Navigate to      | directory      |       |
|    | directory. Put    | c:\\temp, verify | c:\\temp:      |       |
|    | them into a       | files are in the |                |       |
|    | working           | directory        | c_cre          |       |
|    | directory, for    |                  | _alo_stage.sql |       |
|    | example c:\\temp  |                  |                |       |
|    |                   |                  | c_cre          |       |
|    |                   |                  | _cap_stage.sql |       |
|    |                   |                  |                |       |
|    |                   |                  | c_cre          |       |
|    |                   |                  | _oro_stage.sql |       |
|    |                   |                  |                |       |
|    |                   |                  | c_de           |       |
|    |                   |                  | l_gl_stage.sql |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.alo1 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.alo2 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.alo3 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.alo4 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.alo5 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.alo6 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.alo7 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.alo8 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.cap1 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.cap2 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.cap3 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.cap4 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.cap5 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.cap6 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.cap7 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.cap8 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.grt  |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.idx  |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.oro1 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.oro2 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.oro3 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.oro4 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.oro5 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.oro6 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.oro7 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.oro8 |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.pkg  |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.seq  |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.tab  |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_conv.vw   |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl           |       |
|    |                   |                  | _conv_mars.ctl |       |
|    |                   |                  |                |       |
|    |                   |                  | c_upd_alo_c    |       |
|    |                   |                  | onv_status.sql |       |
|    |                   |                  |                |       |
|    |                   |                  | c_upd_cap_c    |       |
|    |                   |                  | onv_status.sql |       |
|    |                   |                  |                |       |
|    |                   |                  | c_upd_mars_c   |       |
|    |                   |                  | onv_status.sql |       |
|    |                   |                  |                |       |
|    |                   |                  | c_upd_oro_c    |       |
|    |                   |                  | onv_status.sql |       |
|    |                   |                  |                |       |
|    |                   |                  | determi        |       |
|    |                   |                  | ne_org_ids.sql |       |
|    |                   |                  |                |       |
|    |                   |                  | load           |       |
|    |                   |                  | _gl_discas.bat |       |
|    |                   |                  |                |       |
|    |                   |                  | lo             |       |
|    |                   |                  | ad_gl_mars.bat |       |
|    |                   |                  |                |       |
|    |                   |                  | split_d        |       |
|    |                   |                  | iscas_data.bat |       |
|    |                   |                  |                |       |
|    |                   |                  | split.exe      |       |
|    |                   |                  |                |       |
|    |                   |                  | SPLIT60I.DOC   |       |
|    |                   |                  |                |       |
|    |                   |                  | c_gl_segment   |       |
|    |                   |                  | _balancing.sql |       |
+----+-------------------+------------------+----------------+-------+

A.2 Vendor Conversion Test Plan

+---+--------------------+-------------------+--------------+---------+
| * | **Conversion       | **Testing Step**  | **Expected   | *       |
| * | Step**             |                   | Results**    | *Actual |
| U |                    |                   |              | Re      |
| n |                    |                   |              | sults** |
| i |                    |                   |              |         |
| t |                    |                   |              |         |
| T |                    |                   |              |         |
| e |                    |                   |              |         |
| s |                    |                   |              |         |
| t |                    |                   |              |         |
| i |                    |                   |              |         |
| n |                    |                   |              |         |
| g |                    |                   |              |         |
| S |                    |                   |              |         |
| t |                    |                   |              |         |
| e |                    |                   |              |         |
| p |                    |                   |              |         |
| * |                    |                   |              |         |
| * |                    |                   |              |         |
+---+--------------------+-------------------+--------------+---------+
| 1 | Supplier           | Log into 'DOE     | Supplier     |         |
|   | auto-numbering     | Purchasing        | au           |         |
|   | should be turned   | Superuser',       | to-numbering |         |
|   | on, with a 'type'  | navigate to       | is set to    |         |
|   | of 'NUMERIC'.      | Setup:            | 'Numbeic'    |         |
|   |                    | Organizations:    |              |         |
|   |                    | Financial         |              |         |
|   |                    | Options: Supplier |              |         |
|   |                    | Entry Tab         |              |         |
+---+--------------------+-------------------+--------------+---------+
| 2 | Before loading     | Verify with the   | In the code: |         |
|   | ensure that the    | AP Team the       |              |         |
|   | values of          | values, and then  | con          |         |
|   | ACCTS_PAY_CO       | put the values in | st_accts_pay |         |
|   | DE_COMBINATION_ID, | the c_emp_pkg     | _ccid_nonfed |         |
|   | PREPAY_CO          | constants.        |              |         |
|   | DE_COMBINATION_ID, |                   | constant     |         |
|   | FUTURE_            |                   | number :=    |         |
|   | DATED_PAYMENT_CCID |                   | 1062;        |         |
|   | are correctly set. |                   |              |         |
|   | These values       |                   | const_prepay |         |
|   | should be provided |                   | _ccid_nonfed |         |
|   | to the Dev team by |                   |              |         |
|   | the AP team prior  |                   | constant     |         |
|   | to starting the    |                   | number :=    |         |
|   | Vendor conversion. |                   | 1062;        |         |
|   |                    |                   | c            |         |
|   |                    |                   | onst_future_ |         |
|   |                    |                   | dt_pymt_ccid |         |
|   |                    |                   |              |         |
|   |                    |                   | constant     |         |
|   |                    |                   | number :=    |         |
|   |                    |                   | NULL;        |         |
+---+--------------------+-------------------+--------------+---------+
| 3 | Ensure that the    | Run the following | Returns '43' |         |
|   | table              | query to verify:  |              |         |
|   | c_common_ic_cids   |                   |              |         |
|   | exists and is      | select count(\*)  |              |         |
|   | populated with     | from              |              |         |
|   | data               | custom            |              |         |
|   |                    | .c_common_ic_cids |              |         |
+---+--------------------+-------------------+--------------+---------+
| 4 | Although the       | Run Steps 1.1     | Employee     |         |
|   | Vendor conversion  | thru 13 in the    | conversion   |         |
|   | is technically run | Employee          | programs     |         |
|   | before the         | conversion        | will be      |         |
|   | Employee           | document          | created, and |         |
|   | conversion, a      |                   | employee     |         |
|   | requirement was    |                   | data staged. |         |
|   | added to check     |                   |              |         |
|   | Vendor **and**     |                   |              |         |
|   | Employee data for  |                   |              |         |
|   | existence of ABA   |                   |              |         |
|   | numbers when       |                   |              |         |
|   | loading the Bank   |                   |              |         |
|   | Branches. For this |                   |              |         |
|   | reason, the        |                   |              |         |
|   | Employee data      |                   |              |         |
|   | actually needs to  |                   |              |         |
|   | be staged before   |                   |              |         |
|   | the Vendor package |                   |              |         |
|   | (c_po_vendor) can  |                   |              |         |
|   | be compiled        |                   |              |         |
+---+--------------------+-------------------+--------------+---------+
| 5 | Download from PVCS | On your computer, | All the      |         |
|   | all of the files   | open windows      | files from   |         |
|   | in the             | explorer.         | the PVCS     |         |
|   | CustomSQL\\C       | Navigate to       | directory    |         |
|   | onversions\\Vendor | c:\\temp, verify  | are in the   |         |
|   | directory. Put     | files are in the  | directory    |         |
|   | them into a        | directory         | c:\\temp:    |         |
|   | working directory, |                   |              |         |
|   | for example        |                   | c_p          |         |
|   | c:\\temp           |                   | o_vendor.alz |         |
|   |                    |                   |              |         |
|   |                    |                   | c_p          |         |
|   |                    |                   | o_vendor.grt |         |
|   |                    |                   |              |         |
|   |                    |                   | c_p          |         |
|   |                    |                   | o_vendor.idx |         |
|   |                    |                   |              |         |
|   |                    |                   | c_p          |         |
|   |                    |                   | o_vendor.pkg |         |
|   |                    |                   |              |         |
|   |                    |                   | c_p          |         |
|   |                    |                   | o_vendor.seq |         |
|   |                    |                   |              |         |
|   |                    |                   | c_p          |         |
|   |                    |                   | o_vendor.tab |         |
|   |                    |                   |              |         |
|   |                    |                   | c_trad_par   |         |
|   |                    |                   | t_lookup.ctl |         |
|   |                    |                   |              |         |
|   |                    |                   | c_trad_par   |         |
|   |                    |                   | t_lookup.tab |         |
|   |                    |                   |              |         |
|   |                    |                   | f            |         |
|   |                    |                   | od_banks.ctl |         |
|   |                    |                   |              |         |
|   |                    |                   | load_f       |         |
|   |                    |                   | od_banks.bat |         |
|   |                    |                   |              |         |
|   |                    |                   | load_t       |         |
|   |                    |                   | rad_part.bat |         |
|   |                    |                   |              |         |
|   |                    |                   | load         |         |
|   |                    |                   | _vendors.bat |         |
|   |                    |                   |              |         |
|   |                    |                   | TIN_differ   |         |
|   |                    |                   | ent_Name.sql |         |
|   |                    |                   |              |         |
|   |                    |                   | uat_vendo    |         |
|   |                    |                   | r_errors.sql |         |
|   |                    |                   |              |         |
|   |                    |                   | vendor_te    |         |
|   |                    |                   | rms_used.sql |         |
|   |                    |                   |              |         |
|   |                    |                   | Ven          |         |
|   |                    |                   | dor Conversi |         |
|   |                    |                   | on Setup.doc |         |
|   |                    |                   |              |         |
|   |                    |                   | vendors.ctl  |         |
+---+--------------------+-------------------+--------------+---------+
| 5 | Run the following  | Execute the       | All 4 tables |         |
|   | script to create   | following to      | were         |         |
|   | the staging tables | verify all 4      | described    |         |
|   |                    | tables were       | verifying    |         |
|   | As custom, execute | created:          | that they    |         |
|   | the following      |                   | were         |         |
|   | script:            | SQL\> desc        | created.     |         |
|   |                    | c_vendors         |              |         |
|   | SQL\>@c:\\tem      |                   |              |         |
|   | p\\c_po_vendor.tab | SQL\> desc        |              |         |
|   |                    | c_vendors_temp    |              |         |
|   |                    |                   |              |         |
|   |                    | SQL\> desc        |              |         |
|   |                    | c_fod_banks       |              |         |
|   |                    |                   |              |         |
|   |                    | SQL\> desc        |              |         |
|   |                    | c_vendor_errors   |              |         |
+---+--------------------+-------------------+--------------+---------+
| 6 | Check to see if    | Execute the       | Table was    |         |
|   | the Trading        | following to      | described to |         |
|   | Partner lookup     | verify all 4      | verify that  |         |
|   | table is created   | tables were       | it was       |         |
|   |                    | created:          | created. If  |         |
|   |                    |                   | not, follow  |         |
|   |                    | SQL\> desc        | the          |         |
|   |                    | c                 | instructions |         |
|   |                    | _trad_part_lookup | in Appendix  |         |
|   |                    |                   | A, in the    |         |
|   |                    |                   | Vendor       |         |
|   |                    |                   | Conversion   |         |
|   |                    |                   | Setup.doc    |         |
+---+--------------------+-------------------+--------------+---------+
| 7 | Run the following  | Execute the       | Values were  |         |
|   | script to create   | following to      | returned for |         |
|   | sequences.         | verify 2          | all 4 calls  |         |
|   |                    | sequences were    |              |         |
|   | As custom, execute | created:          | First time   |         |
|   | the following      |                   | run, both of |         |
|   | script:            | SQL\> select      | these should |         |
|   |                    | c_                | return =     |         |
|   | SQL\>@c:\\temp\\   | vendors_s.nextval | '1'.         |         |
|   | c_po_vendor.seq    | from dual         |              |         |
|   |                    |                   |              |         |
|   |                    | SQL\> select      |              |         |
|   |                    | c_vendors_d       |              |         |
|   |                    | up_city_s.nextval |              |         |
|   |                    | from dual         |              |         |
|   |                    |                   |              |         |
|   |                    | SQL\> select      |              |         |
|   |                    | c_fo              |              |         |
|   |                    | d_banks_s.nextval |              |         |
|   |                    | from dual         |              |         |
|   |                    |                   |              |         |
|   |                    | SQL\> select      |              |         |
|   |                    | c_vendor          |              |         |
|   |                    | _errors_s.nextval |              |         |
|   |                    | from dual         |              |         |
+---+--------------------+-------------------+--------------+---------+
| 8 | Run the following  | Execute the       | '4' and      |         |
|   | script to create   | following to      | 'Valid'      |         |
|   | indexes for the    | verify 4 indexes  | should be    |         |
|   | staging tables     | were created:     | returned     |         |
|   |                    |                   |              |         |
|   | As custom, execute | SQL\> select      |              |         |
|   | the following      | count(\*), status |              |         |
|   | script:            |                   |              |         |
|   |                    | from all_indexes  |              |         |
|   | SQL\>@c:\\tem      |                   |              |         |
|   | p\\c_po_vendor.idx | where             |              |         |
|   |                    | upper(owner) =    |              |         |
|   |                    | \'CUSTOM\'        |              |         |
|   |                    |                   |              |         |
|   |                    | and               |              |         |
|   |                    | lower(index_name) |              |         |
|   |                    | in                |              |         |
|   |                    |                   |              |         |
|   |                    | (\'c_v            |              |         |
|   |                    | endors_name_idx', |              |         |
|   |                    |                   |              |         |
|   |                    | 'c_vend           |              |         |
|   |                    | ors_fmt_tin_idx', |              |         |
|   |                    |                   |              |         |
|   |                    | 'c_vendor         |              |         |
|   |                    | s_vendor_id_idx', |              |         |
|   |                    |                   |              |         |
|   |                    | 'c_vendors_t      |              |         |
|   |                    | emp_fmt_tin_idx') |              |         |
|   |                    |                   |              |         |
|   |                    | group by status   |              |         |
+---+--------------------+-------------------+--------------+---------+
| 9 | Run the following  | Execute the       | '16' should  |         |
|   | script to grant    | following query   | be returned  |         |
|   | permissions to     | as apps:SQL\>     |              |         |
|   | apps for the       | select count(\*)  |              |         |
|   | custom tables      | from              |              |         |
|   |                    | a                 |              |         |
|   | As apps, execute   | ll_tab_privswhere |              |         |
|   | the following      | table_name in     |              |         |
|   | script:            | ('c_              |              |         |
|   |                    | vendors_s','c_ven |              |         |
|   | SQL\>@c:\\tem      | dors_dup_city_s', |              |         |
|   | p\\c_po_vendor.grt |                   |              |         |
|   |                    | 'c                |              |         |
|   |                    | _fod_banks_s','c_ |              |         |
|   |                    | vendor_errors_s', |              |         |
|   |                    |                   |              |         |
|   |                    | 'c_               |              |         |
|   |                    | vendors','c_vendo |              |         |
|   |                    | rs_temp','c_fod\_ |              |         |
|   |                    |                   |              |         |
|   |                    | banks','          |              |         |
|   |                    | c_vendor_errors') |              |         |
+---+--------------------+-------------------+--------------+---------+
| 1 | Run the following  | Execute the       | Should       |         |
| 0 | script to compile  | following query   | return a     |         |
|   | the package        | as apps:          | value of     |         |
|   |                    |                   | 'VALID'      |         |
|   | As apps, execute   | SQL\> select      |              |         |
|   | the following      | distinct(status)  |              |         |
|   | script:            |                   |              |         |
|   |                    | from dba_objects  |              |         |
|   | SQL\>@c:\\tem      |                   |              |         |
|   | p\\c_po_vendor.pkg | where object_name |              |         |
|   |                    | =                 |              |         |
|   |                    | \'C_PO_VENDOR'\'  |              |         |
|   |                    |                   |              |         |
|   |                    | and owner =       |              |         |
|   |                    | \'APPS\'          |              |         |
+---+--------------------+-------------------+--------------+---------+
| 1 | Make sure that the | On your computer, | There should |         |
| 1 | names of the       | open windows      | be 4 files:  |         |
|   | DISCAS extract     | explorer.         |              |         |
|   | data files are     | Navigate to       | flp          |         |
|   | flpo0              | c:\\              | o011_alo.dat |         |
|   | 11\_\<org_id\>.dat | temp\\sourcedata. |              |         |
|   | where \<org_id\>   | Verify the files. | flp          |         |
|   | represents the     |                   | o011_cap.dat |         |
|   | service center     |                   |              |         |
|   | (domain values are |                   | flp          |         |
|   | 'cap', 'alo', or   |                   | o011_oro.dat |         |
|   | 'oro') and         |                   |              |         |
|   | DOEinfo-Banks.dat  |                   | DOEin        |         |
|   |                    |                   | fo-Banks.dat |         |
+---+--------------------+-------------------+--------------+---------+
| 1 | Ensure that there  | On your computer, | Directory    |         |
| 2 | exists a 'logs'    | open windows      | exists       |         |
|   | folder under the   | explorer.         |              |         |
|   | working directory  | Navigate to       |              |         |
|   | (c:\\temp\\logs)   | c:\\temp\\logs,   |              |         |
|   |                    | verify directory  |              |         |
+---+--------------------+-------------------+--------------+---------+
| 1 | Stage the          | Script generates  | Verify that  |         |
| 3 | fod_banks data     | a log file called | no errors    |         |
|   | files.             | c:\\temp\\lo      | occurred     |         |
|   |                    | gs\\fod_banks.log | while        |         |
|   | Run the following  |                   | loading the  |         |
|   | command line:      |                   | data into    |         |
|   |                    |                   | the staging  |         |
|   | C:\\temp\>         |                   | tables from  |         |
|   | load_fod_banks.bat |                   | the log file |         |
|   | custom             |                   |              |         |
|   | \<password\>       |                   | Near the     |         |
|   | \<instance\>       |                   | bottom of    |         |
|   | c:\\temp           |                   | the log file |         |
|   |                    |                   | verify that  |         |
|   |                    |                   | it says '0   |         |
|   |                    |                   | rows not     |         |
|   |                    |                   | loaded due   |         |
|   |                    |                   | to data      |         |
|   |                    |                   | errors'      |         |
+---+--------------------+-------------------+--------------+---------+
| 1 | Stage the DISCAS   | Script generates  | Verify that  |         |
| 4 | vendor data files. | a log file called | no errors    |         |
|   |                    | c:\\temp\\l       | occurred     |         |
|   | Run the following  | ogs\\vendor\_\<or | while        |         |
|   | command line 3     | g_id_suffix\>.log | loading the  |         |
|   | times:             |                   | data into    |         |
|   |                    |                   | the staging  |         |
|   | C:\\temp\>         |                   | tables from  |         |
|   | load_vendor.bat    |                   | the log file |         |
|   | custom             |                   |              |         |
|   | \<password\>       |                   | Near the     |         |
|   | \<instance\>       |                   | bottom of    |         |
|   | c:\\temp           |                   | the log file |         |
|   | \<org_id_suffix\>  |                   | verify that  |         |
|   |                    |                   | it says '0   |         |
|   | The org_id_suffix  |                   | rows not     |         |
|   | is cap, oro, and   |                   | loaded due   |         |
|   | alo.               |                   | to data      |         |
|   |                    |                   | errors'      |         |
|   |                    |                   |              |         |
|   |                    |                   | NOTE that at |         |
|   |                    |                   | this time    |         |
|   |                    |                   | some of the  |         |
|   |                    |                   | extract data |         |
|   |                    |                   | gets         |         |
|   |                    |                   | filtered     |         |
|   |                    |                   | out, and not |         |
|   |                    |                   | included in  |         |
|   |                    |                   | the staging  |         |
|   |                    |                   | area for     |         |
|   |                    |                   | conversion.  |         |
|   |                    |                   | Those        |         |
|   |                    |                   | records with |         |
|   |                    |                   | a            |         |
|   |                    |                   | RECORD_STATE |         |
|   |                    |                   | of 'RETIRED' |         |
|   |                    |                   | are not      |         |
|   |                    |                   | staged to    |         |
|   |                    |                   | c_vendors    |         |
|   |                    |                   | and are      |         |
|   |                    |                   | reflected in |         |
|   |                    |                   | the log as   |         |
|   |                    |                   | 'failing all |         |
|   |                    |                   | WHEN         |         |
|   |                    |                   | clauses'.    |         |
+---+--------------------+-------------------+--------------+---------+
| 1 | Execute the        | Run the procedure | Procedure    |         |
| 5 | following script   |                   | completes    |         |
|   | to load AP Bank    |                   | successfully |         |
|   | Branches           |                   |              |         |
|   |                    |                   | The loading  |         |
|   | SQL\> exec         |                   | of           |         |
|   | c_po_vendor.       |                   | AP_B         |         |
|   | load_bank_branches |                   | ANK_BRANCHES |         |
|   |                    |                   | involves     |         |
|   |                    |                   | error        |         |
|   |                    |                   | checking,    |         |
|   |                    |                   | and then two |         |
|   |                    |                   | insert       |         |
|   |                    |                   | statements   |         |
|   |                    |                   | with one     |         |
|   |                    |                   | COMMIT at    |         |
|   |                    |                   | the end. The |         |
|   |                    |                   | error        |         |
|   |                    |                   | checking     |         |
|   |                    |                   | produces     |         |
|   |                    |                   | c_v          |         |
|   |                    |                   | endor_errors |         |
|   |                    |                   | records and  |         |
|   |                    |                   | sets the     |         |
|   |                    |                   | c_fod_banks  |         |
|   |                    |                   | status field |         |
|   |                    |                   | to 'E' if    |         |
|   |                    |                   | there are    |         |
|   |                    |                   | duplicate    |         |
|   |                    |                   | bank ABA     |         |
|   |                    |                   | numbers OR   |         |
|   |                    |                   | if the ABA   |         |
|   |                    |                   | number does  |         |
|   |                    |                   | not exist in |         |
|   |                    |                   | the          |         |
|   |                    |                   | Ven          |         |
|   |                    |                   | dor/Employee |         |
|   |                    |                   | extract      |         |
|   |                    |                   | data. See    |         |
|   |                    |                   | below for    |         |
|   |                    |                   | c_v          |         |
|   |                    |                   | endor_errors |         |
|   |                    |                   | table        |         |
|   |                    |                   | description. |         |
+---+--------------------+-------------------+--------------+---------+
| 1 | Execute the        | Run the procedure | Procedure    |         |
| 6 | following to       |                   | completes    |         |
|   | ensure that any    |                   | successfully |         |
|   | null extract       |                   |              |         |
|   | org_id's are       |                   |              |         |
|   | populated in the   |                   |              |         |
|   | staging table      |                   |              |         |
|   |                    |                   |              |         |
|   | SQL\> exec         |                   |              |         |
|   | c_po_vend          |                   |              |         |
|   | or.upd_null_org_id |                   |              |         |
+---+--------------------+-------------------+--------------+---------+
| 1 | Validate the       | Run the procedure | Procedure    |         |
| 7 | DISCAS Vendor data |                   | completes    |         |
|   |                    |                   | successfully |         |
|   | SQL\>exec          |                   |              |         |
|   | c_hr               |                   | Staging      |         |
|   | _emp.validate_data |                   | table        |         |
|   |                    |                   | c_vendors    |         |
|   |                    |                   | contains     |         |
|   |                    |                   | three status |         |
|   |                    |                   | fields       |         |
|   |                    |                   | called       |         |
|   |                    |                   | ve           |         |
|   |                    |                   | ndor_status, |         |
|   |                    |                   | site_status, |         |
|   |                    |                   | and          |         |
|   |                    |                   | acct_status. |         |
|   |                    |                   | Possible     |         |
|   |                    |                   | values for   |         |
|   |                    |                   | these fields |         |
|   |                    |                   | are          |         |
|   |                    |                   | (U           |         |
|   |                    |                   | )nprocessed, |         |
|   |                    |                   | (P)rocessed, |         |
|   |                    |                   | and (E)rror. |         |
|   |                    |                   | In addition, |         |
|   |                    |                   | the          |         |
|   |                    |                   | acct_status  |         |
|   |                    |                   | field can    |         |
|   |                    |                   | temporarily  |         |
|   |                    |                   | hold a value |         |
|   |                    |                   | of (N)ew to  |         |
|   |                    |                   | indicate     |         |
|   |                    |                   | that the ABA |         |
|   |                    |                   | number in    |         |
|   |                    |                   | DUNS-MM data |         |
|   |                    |                   | did not      |         |
|   |                    |                   | exist in     |         |
|   |                    |                   | Treasury FOD |         |
|   |                    |                   | data, and    |         |
|   |                    |                   | will require |         |
|   |                    |                   | the insert   |         |
|   |                    |                   | of new Bank  |         |
|   |                    |                   | Branch and   |         |
|   |                    |                   | Bank Account |         |
|   |                    |                   | data. The    |         |
|   |                    |                   | v            |         |
|   |                    |                   | endor_status |         |
|   |                    |                   | field can    |         |
|   |                    |                   | temporarily  |         |
|   |                    |                   | hold an 'A'  |         |
|   |                    |                   | value to     |         |
|   |                    |                   | indicate     |         |
|   |                    |                   | additional   |         |
|   |                    |                   | records that |         |
|   |                    |                   | the PO       |         |
|   |                    |                   | Conversion   |         |
|   |                    |                   | adds to the  |         |
|   |                    |                   | c_vendors    |         |
|   |                    |                   | staging      |         |
|   |                    |                   | table (as a  |         |
|   |                    |                   | separate     |         |
|   |                    |                   | process).    |         |
|   |                    |                   | The 'E'      |         |
|   |                    |                   | status in    |         |
|   |                    |                   | c_vendors    |         |
|   |                    |                   | can be       |         |
|   |                    |                   | cros         |         |
|   |                    |                   | s-referenced |         |
|   |                    |                   | to the       |         |
|   |                    |                   | number of    |         |
|   |                    |                   | records in   |         |
|   |                    |                   | the          |         |
|   |                    |                   | c_v          |         |
|   |                    |                   | endor_errors |         |
|   |                    |                   | table. The   |         |
|   |                    |                   | default      |         |
|   |                    |                   | values of    |         |
|   |                    |                   | these fields |         |
|   |                    |                   | are 'U', and |         |
|   |                    |                   | from there   |         |
|   |                    |                   | they can go  |         |
|   |                    |                   | to 'P', 'E', |         |
|   |                    |                   | or 'N'.      |         |
+---+--------------------+-------------------+--------------+---------+
| 1 | Execute the        | Run the procedure | Procedure    |         |
| 8 | following script   |                   | completes    |         |
|   | to ensure that a   |                   | successfully |         |
|   | unique Vendor Name |                   |              |         |
|   | is set for each    |                   |              |         |
|   | Vendor to be       |                   |              |         |
|   | loaded             |                   |              |         |
|   |                    |                   |              |         |
|   | SQL\> exec         |                   |              |         |
|   | c_po_vend          |                   |              |         |
|   | or.upd_unique_name |                   |              |         |
+---+--------------------+-------------------+--------------+---------+
| 1 | Execute the        | Run the procedure | Procedure    |         |
| 9 | following to       |                   | completes    |         |
|   | remove dashes in   |                   | successfully |         |
|   | the account number |                   |              |         |
|   | field, in order to |                   |              |         |
|   | facilitate the     |                   |              |         |
|   | matching of        |                   |              |         |
|   | tfcs_acct when     |                   |              |         |
|   | setting the        |                   |              |         |
|   | mult               |                   |              |         |
|   | i_assignments_flag |                   |              |         |
|   | in                 |                   |              |         |
|   | ap                 |                   |              |         |
|   | _bank_accounts_all |                   |              |         |
|   |                    |                   |              |         |
|   | SQL\>exec          |                   |              |         |
|   | c_po_vendo         |                   |              |         |
|   | r.remove_acct_dash |                   |              |         |
+---+--------------------+-------------------+--------------+---------+
| 2 | Load the           | Run the procedure | Procedure    |         |
| 0 | PO_VENDORS table   | to create the     | completes    |         |
|   |                    | vendors.          | successfully |         |
|   | SQL\>exec          |                   |              |         |
|   | c_po_vendo         | Run the following | The 2^nd^    |         |
|   | r.create_po_vendor | 2 queries when it | count should |         |
|   |                    | completes.        | be equal to  |         |
|   |                    |                   | the first    |         |
|   |                    | Select count(1)   | count plus   |         |
|   |                    |                   | any vendors  |         |
|   |                    | From c_vendors    | in the       |         |
|   |                    |                   | tables       |         |
|   |                    | Where             | before the   |         |
|   |                    | vendor_status =   | conversion   |         |
|   |                    | 'P'               | is executed. |         |
|   |                    |                   |              |         |
|   |                    | And               |              |         |
|   |                    |                   |              |         |
|   |                    | Select count(1)   |              |         |
|   |                    |                   |              |         |
|   |                    | From po_vendors   |              |         |
+---+--------------------+-------------------+--------------+---------+
| 2 | Load the tables    | Run the procedure | Procedure    |         |
| 1 | PO                 | to create the     | completes    |         |
|   | _VENDOR_SITES_ALL, | vendors.          | successfully |         |
|   | AP_BANK_BRANCHES,  |                   |              |         |
|   | AP_                | Run the following | The 2^nd^    |         |
|   | BANK_ACCOUNTS_ALL, | 2 queries when it | count should |         |
|   | and                | completes.        | be equal to  |         |
|   | AP_BAN             |                   | the first    |         |
|   | K_ACCOUNT_USES_ALL | Select count(1)   | count plus   |         |
|   |                    |                   | any vendor   |         |
|   | SQL\>exec          | From c_vendors    | sites in the |         |
|   | c_po_vendor        |                   | tables       |         |
|   | .create_acct_sites | Where site_status | before the   |         |
|   |                    | = 'P'             | conversion   |         |
|   | Note that the AP   |                   | is executed. |         |
|   | Bank Account       | And               |              |         |
|   | tables are only    |                   |              |         |
|   | loaded if an ABA   | Select count(1)   |              |         |
|   | number is present  |                   |              |         |
|   | in the DUNS-MM     | From              |              |         |
|   | data AND if the    | po                |              |         |
|   | site being created | _vendor_sites_all |              |         |
|   | is not a           |                   |              |         |
|   | 'Purchasing-only'  |                   |              |         |
|   | site               |                   |              |         |
+---+--------------------+-------------------+--------------+---------+
| 2 | Load the Bank      | Run this          | Procedure    |         |
| 2 | Branches that were | procedure to      | completes    |         |
|   | not in Treasury    | create the bank   | successfully |         |
|   | FOD data, as well  | branches          |              |         |
|   | as corresponding   |                   | The loading  |         |
|   | Bank Account data  | This procedure    | of           |         |
|   |                    | loads Bank        | AP_B         |         |
|   | SQL\>exec          | information using | ANK_BRANCHES |         |
|   | c                  | only the DUNS-MM  | involves     |         |
|   | _po_vendor.load_br | vendor data       | error        |         |
|   | anches_from_vendor |                   | checking,    |         |
|   |                    |                   | and then two |         |
|   |                    |                   | insert       |         |
|   |                    |                   | statements   |         |
|   |                    |                   | with one     |         |
|   |                    |                   | COMMIT at    |         |
|   |                    |                   | the end. The |         |
|   |                    |                   | error        |         |
|   |                    |                   | checking     |         |
|   |                    |                   | produces     |         |
|   |                    |                   | c_v          |         |
|   |                    |                   | endor_errors |         |
|   |                    |                   | records and  |         |
|   |                    |                   | sets the     |         |
|   |                    |                   | c_fod_banks  |         |
|   |                    |                   | status field |         |
|   |                    |                   | to 'E' if    |         |
|   |                    |                   | there are    |         |
|   |                    |                   | duplicate    |         |
|   |                    |                   | bank ABA     |         |
|   |                    |                   | numbers OR   |         |
|   |                    |                   | if the ABA   |         |
|   |                    |                   | number does  |         |
|   |                    |                   | not exist in |         |
|   |                    |                   | the          |         |
|   |                    |                   | Ven          |         |
|   |                    |                   | dor/Employee |         |
|   |                    |                   | extract      |         |
|   |                    |                   | data. See    |         |
|   |                    |                   | below for    |         |
|   |                    |                   | c_v          |         |
|   |                    |                   | endor_errors |         |
|   |                    |                   | table        |         |
|   |                    |                   | description. |         |
+---+--------------------+-------------------+--------------+---------+
| 2 | Log into 'DOE AP   | Review Vendors to | Vendors      |         |
| 3 | Inquiry', navigate | see if they have  | should be    |         |
|   | to Suppliers       | been imported     | loaded into  |         |
|   | Inquiry.           | correctly.        | the system   |         |
|   |                    |                   |              |         |
|   | Query vendors.     |                   |              |         |
+---+--------------------+-------------------+--------------+---------+

A.3 Employee Conversion Test Plan

+---+-------------+---------+-------------+-----+---+-------------+---+
| * | *           |         | **Testing   |     |   | **Expected  | * |
| * | *Conversion |         | Step**      |     |   | Results**   | * |
| U | Step**      |         |             |     |   |             | A |
| n |             |         |             |     |   |             | c |
| i |             |         |             |     |   |             | t |
| t |             |         |             |     |   |             | u |
| T |             |         |             |     |   |             | a |
| e |             |         |             |     |   |             | l |
| s |             |         |             |     |   |             | R |
| t |             |         |             |     |   |             | e |
| i |             |         |             |     |   |             | s |
| n |             |         |             |     |   |             | u |
| g |             |         |             |     |   |             | l |
| S |             |         |             |     |   |             | t |
| t |             |         |             |     |   |             | s |
| e |             |         |             |     |   |             | * |
| p |             |         |             |     |   |             | * |
| * |             |         |             |     |   |             |   |
| * |             |         |             |     |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 1 | Supplier    |         | Log into    |     |   | Supplier    |   |
|   | aut         |         | 'DOE        |     |   | aut         |   |
|   | o-numbering |         | Purchasing  |     |   | o-numbering |   |
|   | should be   |         | Superuser', |     |   | is set to   |   |
|   | turned on,  |         | navigate to |     |   | 'Numbeic'   |   |
|   | with a      |         | Setup:      |     |   |             |   |
|   | 'type' of   |         | Org         |     |   |             |   |
|   | 'NUMERIC'.  |         | anizations: |     |   |             |   |
|   |             |         | Financial   |     |   |             |   |
|   |             |         | Options:    |     |   |             |   |
|   |             |         | Supplier    |     |   |             |   |
|   |             |         | Entry Tab   |     |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 2 | Before      |         | Verify with |     |   | In the      |   |
|   | loading     |         | the AP Team |     |   | code:       |   |
|   | ensure that |         | the values, |     |   |             |   |
|   | the values  |         | and then    |     |   | const       |   |
|   | of          |         | put the     |     |   | _accts_pay_ |   |
|   | ACCTS_PA    |         | values in   |     |   | ccid_nonfed |   |
|   | Y_CODE_COMB |         | the         |     |   |             |   |
|   | INATION_ID, |         | c_emp_pkg   |     |   | constant    |   |
|   | PREPA       |         | constants.  |     |   | number :=   |   |
|   | Y_CODE_COMB |         |             |     |   | 1062;       |   |
|   | INATION_ID, |         |             |     |   |             |   |
|   | FUT         |         |             |     |   | co          |   |
|   | URE_DATED_P |         |             |     |   | nst_prepay_ |   |
|   | AYMENT_CCID |         |             |     |   | ccid_nonfed |   |
|   | are         |         |             |     |   |             |   |
|   | correctly   |         |             |     |   | constant    |   |
|   | set. These  |         |             |     |   | number :=   |   |
|   | values      |         |             |     |   | 1062;       |   |
|   | should be   |         |             |     |   | con         |   |
|   | provided to |         |             |     |   | st_future_d |   |
|   | the Dev     |         |             |     |   | t_pymt_ccid |   |
|   | team by the |         |             |     |   |             |   |
|   | AP team     |         |             |     |   | constant    |   |
|   | prior to    |         |             |     |   | number :=   |   |
|   | starting    |         |             |     |   | NULL;       |   |
|   | the Vendor  |         |             |     |   |             |   |
|   | conversion. |         |             |     |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 3 | The profile |         | Log into    |     |   | Value set   |   |
|   | setting     |         | 'Sysadmin', |     |   | to 'N'      |   |
|   | **PA:       |         | navigate to |     |   |             |   |
|   | Licensed to |         | Profile:    |     |   |             |   |
|   | Use Project |         | System.     |     |   |             |   |
|   | Resource    |         | Query up '  |     |   |             |   |
|   | M           |         | **PA:       |     |   |             |   |
|   | anagement** |         | Licensed to |     |   |             |   |
|   | is set to   |         | Use Project |     |   |             |   |
|   | 'NO'        |         | Resource    |     |   |             |   |
|   |             |         | Ma          |     |   |             |   |
|   |             |         | nagement'** |     |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 4 | Download    |         | On your     |     | A |             |   |
|   | from PVCS   |         | computer,   |     | l |             |   |
|   | all of the  |         | open        |     | l |             |   |
|   | files in    |         | windows     |     | t |             |   |
|   | the         |         | explorer.   |     | h |             |   |
|   | CustomSQL\  |         | Navigate to |     | e |             |   |
|   | \Conversion |         | c:\\temp,   |     | f |             |   |
|   | s\\Employee |         | verify      |     | i |             |   |
|   | directory.  |         | files are   |     | l |             |   |
|   | Put them    |         | in the      |     | e |             |   |
|   | into a      |         | directory   |     | s |             |   |
|   | working     |         |             |     | f |             |   |
|   | directory,  |         |             |     | r |             |   |
|   | for example |         |             |     | o |             |   |
|   | c:\\temp    |         |             |     | m |             |   |
|   |             |         |             |     | t |             |   |
|   |             |         |             |     | h |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | P |             |   |
|   |             |         |             |     | V |             |   |
|   |             |         |             |     | C |             |   |
|   |             |         |             |     | S |             |   |
|   |             |         |             |     | d |             |   |
|   |             |         |             |     | i |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | c |             |   |
|   |             |         |             |     | t |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | y |             |   |
|   |             |         |             |     | a |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | i |             |   |
|   |             |         |             |     | n |             |   |
|   |             |         |             |     | t |             |   |
|   |             |         |             |     | h |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | d |             |   |
|   |             |         |             |     | i |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | c |             |   |
|   |             |         |             |     | t |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | y |             |   |
|   |             |         |             |     | c |             |   |
|   |             |         |             |     | : |             |   |
|   |             |         |             |     | \ |             |   |
|   |             |         |             |     | \ |             |   |
|   |             |         |             |     | t |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | m |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | : |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     | c |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | h |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | m |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | . |             |   |
|   |             |         |             |     | a |             |   |
|   |             |         |             |     | l |             |   |
|   |             |         |             |     | z |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     | c |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | h |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | m |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | . |             |   |
|   |             |         |             |     | g |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | t |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     | c |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | h |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | m |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | . |             |   |
|   |             |         |             |     | i |             |   |
|   |             |         |             |     | d |             |   |
|   |             |         |             |     | x |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     | c |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | h |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | m |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | . |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | k |             |   |
|   |             |         |             |     | g |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     | c |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | h |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | m |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | . |             |   |
|   |             |         |             |     | s |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | q |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     | c |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | h |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | m |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | . |             |   |
|   |             |         |             |     | t |             |   |
|   |             |         |             |     | a |             |   |
|   |             |         |             |     | b |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | m |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | l |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | y |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | g |             |   |
|   |             |         |             |     | s |             |   |
|   |             |         |             |     | . |             |   |
|   |             |         |             |     | c |             |   |
|   |             |         |             |     | t |             |   |
|   |             |         |             |     | l |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | m |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | l |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | y |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | . |             |   |
|   |             |         |             |     | a |             |   |
|   |             |         |             |     | l |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | m |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | l |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | y |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | . |             |   |
|   |             |         |             |     | c |             |   |
|   |             |         |             |     | a |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | m |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | l |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | y |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | . |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     | E |             |   |
|   |             |         |             |     | m |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | l |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | y |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     | C |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | n |             |   |
|   |             |         |             |     | v |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | s |             |   |
|   |             |         |             |     | i |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | n |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     | S |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | t |             |   |
|   |             |         |             |     | u |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | . |             |   |
|   |             |         |             |     | d |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | c |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     | l |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | a |             |   |
|   |             |         |             |     | d |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | m |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | g |             |   |
|   |             |         |             |     | s |             |   |
|   |             |         |             |     | . |             |   |
|   |             |         |             |     | b |             |   |
|   |             |         |             |     | a |             |   |
|   |             |         |             |     | t |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     | l |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | a |             |   |
|   |             |         |             |     | d |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | m |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | l |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | y |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | . |             |   |
|   |             |         |             |     | b |             |   |
|   |             |         |             |     | a |             |   |
|   |             |         |             |     | t |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     | u |             |   |
|   |             |         |             |     | a |             |   |
|   |             |         |             |     | t |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | m |             |   |
|   |             |         |             |     | p |             |   |
|   |             |         |             |     | _ |             |   |
|   |             |         |             |     | e |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | o |             |   |
|   |             |         |             |     | r |             |   |
|   |             |         |             |     | s |             |   |
|   |             |         |             |     | . |             |   |
|   |             |         |             |     | s |             |   |
|   |             |         |             |     | q |             |   |
|   |             |         |             |     | l |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 5 | Run the     | Execute |             | All |   |             |   |
|   | following   | the     |             | 3   |   |             |   |
|   | script to   | fo      |             | tab |   |             |   |
|   | create the  | llowing |             | les |   |             |   |
|   | staging     | to      |             | w   |   |             |   |
|   | tables      | verify  |             | ere |   |             |   |
|   |             | all 3   |             | des |   |             |   |
|   | As custom,  | tables  |             | cri |   |             |   |
|   | execute the | were    |             | bed |   |             |   |
|   | following   | c       |             | ver |   |             |   |
|   | script:     | reated: |             | ify |   |             |   |
|   |             |         |             | ing |   |             |   |
|   | SQL\>@      | SQL\>   |             | t   |   |             |   |
|   | c:\\temp\\c | desc    |             | hat |   |             |   |
|   | _hr_emp.tab | c_e     |             | t   |   |             |   |
|   |             | mployee |             | hey |   |             |   |
|   |             |         |             | w   |   |             |   |
|   |             | SQL\>   |             | ere |   |             |   |
|   |             | desc    |             | cr  |   |             |   |
|   |             | c_e     |             | eat |   |             |   |
|   |             | mp_orgs |             | ed. |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             | SQL\>   |             |     |   |             |   |
|   |             | desc    |             |     |   |             |   |
|   |             | c_e     |             |     |   |             |   |
|   |             | mployee |             |     |   |             |   |
|   |             | _errors |             |     |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 6 | Run the     | Execute |             | Val |   |             |   |
|   | following   | the     |             | ues |   |             |   |
|   | script to   | fo      |             | w   |   |             |   |
|   | create      | llowing |             | ere |   |             |   |
|   | sequences.  | to      |             | re  |   |             |   |
|   |             | verify  |             | tur |   |             |   |
|   | As custom,  | 2       |             | ned |   |             |   |
|   | execute the | se      |             | for |   |             |   |
|   | following   | quences |             | b   |   |             |   |
|   | script:     | were    |             | oth |   |             |   |
|   |             | c       |             | ca  |   |             |   |
|   | SQL\>       | reated: |             | lls |   |             |   |
|   | @c:\\temp\\ |         |             |     |   |             |   |
|   | c           | SQL\>   |             | Fi  |   |             |   |
|   | _hr_emp.seq | select  |             | rst |   |             |   |
|   |             | c_empl  |             | t   |   |             |   |
|   |             | oyee_s. |             | ime |   |             |   |
|   |             | nextval |             | r   |   |             |   |
|   |             | from    |             | un, |   |             |   |
|   |             | dual    |             | b   |   |             |   |
|   |             |         |             | oth |   |             |   |
|   |             | SQL\>   |             | of  |   |             |   |
|   |             | select  |             | th  |   |             |   |
|   |             | c_emp   |             | ese |   |             |   |
|   |             | loyee_e |             | sho |   |             |   |
|   |             | rror_s. |             | uld |   |             |   |
|   |             | nextval |             | ret |   |             |   |
|   |             | from    |             | urn |   |             |   |
|   |             | dual    |             | =   |   |             |   |
|   |             |         |             | '   |   |             |   |
|   |             |         |             | 1'. |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 7 | Make sure   | On your |             | Th  |   |             |   |
|   | that the    | co      |             | ere |   |             |   |
|   | names of    | mputer, |             | sho |   |             |   |
|   | the DISCAS  | open    |             | uld |   |             |   |
|   | extract     | windows |             | be  |   |             |   |
|   | data files  | ex      |             | 3   |   |             |   |
|   | are         | plorer. |             | fil |   |             |   |
|   | f           | N       |             | es: |   |             |   |
|   | lhr010\_\<o | avigate |             |     |   |             |   |
|   | rg_id\>.dat | to      |             | flh |   |             |   |
|   | where       | c:\\tem |             | r01 |   |             |   |
|   | \<org_id\>  | p\\sour |             | 0_a |   |             |   |
|   | represents  | cedata. |             | lo. |   |             |   |
|   | the service | Verify  |             | dat |   |             |   |
|   | center      | the     |             |     |   |             |   |
|   | (domain     | files.  |             | flh |   |             |   |
|   | values are  |         |             | r01 |   |             |   |
|   | 'cap',      |         |             | 0_c |   |             |   |
|   | 'alo', or   |         |             | ap. |   |             |   |
|   | 'oro')      |         |             | dat |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | flh |   |             |   |
|   |             |         |             | r01 |   |             |   |
|   |             |         |             | 0_o |   |             |   |
|   |             |         |             | ro. |   |             |   |
|   |             |         |             | dat |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 8 | Locate the  | On your |             | Th  |   |             |   |
|   | spreadsheet | co      |             | ere |   |             |   |
|   | of Org_code | mputer, |             | sho |   |             |   |
|   | crosswalk   | open    |             | uld |   |             |   |
|   | values and  | windows |             | be  |   |             |   |
|   | save it to  | ex      |             | 1   |   |             |   |
|   | the working | plorer. |             | fi  |   |             |   |
|   | directory   | N       |             | le: |   |             |   |
|   | in the      | avigate |             |     |   |             |   |
|   | '           | to      |             | emp |   |             |   |
|   | sourcedata' | c:\\tem |             | _or |   |             |   |
|   | folder      | p\\sour |             | gs. |   |             |   |
|   |             | cedata. |             | csv |   |             |   |
|   |             | Verify  |             |     |   |             |   |
|   |             | the     |             |     |   |             |   |
|   |             | file.   |             |     |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 9 | Ensure that | On your |             | Dir |   |             |   |
|   | there       | co      |             | ect |   |             |   |
|   | exists a    | mputer, |             | ory |   |             |   |
|   | 'logs'      | open    |             | exi |   |             |   |
|   | folder      | windows |             | sts |   |             |   |
|   | under the   | ex      |             |     |   |             |   |
|   | working     | plorer. |             |     |   |             |   |
|   | directory   | N       |             |     |   |             |   |
|   | (c:\\       | avigate |             |     |   |             |   |
|   | temp\\logs) | to      |             |     |   |             |   |
|   |             | c       |             |     |   |             |   |
|   |             | :\\temp |             |     |   |             |   |
|   |             | \\logs, |             |     |   |             |   |
|   |             | verify  |             |     |   |             |   |
|   |             | di      |             |     |   |             |   |
|   |             | rectory |             |     |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 1 | Stage the   | Script  |             | Ver |   |             |   |
| 0 | org_code    | ge      |             | ify |   |             |   |
|   | crosswalk   | nerates |             | t   |   |             |   |
|   | data files. | a log   |             | hat |   |             |   |
|   |             | file    |             | no  |   |             |   |
|   | Run the     | called  |             | err |   |             |   |
|   | following   | c:\\tem |             | ors |   |             |   |
|   | command     | p\\logs |             | oc  |   |             |   |
|   | line:       | \\emp_o |             | cur |   |             |   |
|   |             | rgs.log |             | red |   |             |   |
|   | C:\\temp\>  |         |             | wh  |   |             |   |
|   | load_e      |         |             | ile |   |             |   |
|   | mp_ords.bat |         |             | l   |   |             |   |
|   | custom      |         |             | oad |   |             |   |
|   | \           |         |             | ing |   |             |   |
|   | <password\> |         |             | the |   |             |   |
|   | \           |         |             | d   |   |             |   |
|   | <instance\> |         |             | ata |   |             |   |
|   | c:\\temp    |         |             | i   |   |             |   |
|   |             |         |             | nto |   |             |   |
|   |             |         |             | the |   |             |   |
|   |             |         |             | s   |   |             |   |
|   |             |         |             | tag |   |             |   |
|   |             |         |             | ing |   |             |   |
|   |             |         |             | tab |   |             |   |
|   |             |         |             | les |   |             |   |
|   |             |         |             | f   |   |             |   |
|   |             |         |             | rom |   |             |   |
|   |             |         |             | the |   |             |   |
|   |             |         |             | log |   |             |   |
|   |             |         |             | f   |   |             |   |
|   |             |         |             | ile |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | N   |   |             |   |
|   |             |         |             | ear |   |             |   |
|   |             |         |             | the |   |             |   |
|   |             |         |             | bot |   |             |   |
|   |             |         |             | tom |   |             |   |
|   |             |         |             | of  |   |             |   |
|   |             |         |             | the |   |             |   |
|   |             |         |             | log |   |             |   |
|   |             |         |             | f   |   |             |   |
|   |             |         |             | ile |   |             |   |
|   |             |         |             | ver |   |             |   |
|   |             |         |             | ify |   |             |   |
|   |             |         |             | t   |   |             |   |
|   |             |         |             | hat |   |             |   |
|   |             |         |             | it  |   |             |   |
|   |             |         |             | s   |   |             |   |
|   |             |         |             | ays |   |             |   |
|   |             |         |             | '0  |   |             |   |
|   |             |         |             | r   |   |             |   |
|   |             |         |             | ows |   |             |   |
|   |             |         |             | not |   |             |   |
|   |             |         |             | loa |   |             |   |
|   |             |         |             | ded |   |             |   |
|   |             |         |             | due |   |             |   |
|   |             |         |             | to  |   |             |   |
|   |             |         |             | d   |   |             |   |
|   |             |         |             | ata |   |             |   |
|   |             |         |             | e   |   |             |   |
|   |             |         |             | rro |   |             |   |
|   |             |         |             | rs' |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 1 | Stage the   | Script  |             | Ver |   |             |   |
| 1 | DISCAS      | ge      |             | ify |   |             |   |
|   | employee    | nerates |             | t   |   |             |   |
|   | data files. | a log   |             | hat |   |             |   |
|   |             | file    |             | no  |   |             |   |
|   | Run the     | called  |             | err |   |             |   |
|   | following   | c:\\t   |             | ors |   |             |   |
|   | command     | emp\\lo |             | oc  |   |             |   |
|   | line 3      | gs\\emp |             | cur |   |             |   |
|   | times:      | loyee\_ |             | red |   |             |   |
|   |             | \<org_i |             | wh  |   |             |   |
|   | C:\\temp\>  | d_suffi |             | ile |   |             |   |
|   | load_e      | x\>.log |             | l   |   |             |   |
|   | mployee.bat |         |             | oad |   |             |   |
|   | custom      |         |             | ing |   |             |   |
|   | \           |         |             | the |   |             |   |
|   | <password\> |         |             | d   |   |             |   |
|   | \           |         |             | ata |   |             |   |
|   | <instance\> |         |             | i   |   |             |   |
|   | c:\\temp    |         |             | nto |   |             |   |
|   | \<org_      |         |             | the |   |             |   |
|   | id_suffix\> |         |             | s   |   |             |   |
|   |             |         |             | tag |   |             |   |
|   | The         |         |             | ing |   |             |   |
|   | or          |         |             | tab |   |             |   |
|   | g_id_suffix |         |             | les |   |             |   |
|   | is cap,     |         |             | f   |   |             |   |
|   | oro, and    |         |             | rom |   |             |   |
|   | alo.        |         |             | the |   |             |   |
|   |             |         |             | log |   |             |   |
|   |             |         |             | f   |   |             |   |
|   |             |         |             | ile |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | N   |   |             |   |
|   |             |         |             | ear |   |             |   |
|   |             |         |             | the |   |             |   |
|   |             |         |             | bot |   |             |   |
|   |             |         |             | tom |   |             |   |
|   |             |         |             | of  |   |             |   |
|   |             |         |             | the |   |             |   |
|   |             |         |             | log |   |             |   |
|   |             |         |             | f   |   |             |   |
|   |             |         |             | ile |   |             |   |
|   |             |         |             | ver |   |             |   |
|   |             |         |             | ify |   |             |   |
|   |             |         |             | t   |   |             |   |
|   |             |         |             | hat |   |             |   |
|   |             |         |             | it  |   |             |   |
|   |             |         |             | s   |   |             |   |
|   |             |         |             | ays |   |             |   |
|   |             |         |             | '0  |   |             |   |
|   |             |         |             | r   |   |             |   |
|   |             |         |             | ows |   |             |   |
|   |             |         |             | not |   |             |   |
|   |             |         |             | loa |   |             |   |
|   |             |         |             | ded |   |             |   |
|   |             |         |             | due |   |             |   |
|   |             |         |             | to  |   |             |   |
|   |             |         |             | d   |   |             |   |
|   |             |         |             | ata |   |             |   |
|   |             |         |             | e   |   |             |   |
|   |             |         |             | rro |   |             |   |
|   |             |         |             | rs' |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 1 | Run the     | Execute |             | '1' |   |             |   |
| 2 | following   | the     |             | and |   |             |   |
|   | script to   | fo      |             | '   |   |             |   |
|   | create      | llowing |             | Val |   |             |   |
|   | indexes for | to      |             | id' |   |             |   |
|   | the staging | verify  |             | sho |   |             |   |
|   | tables      | 1       |             | uld |   |             |   |
|   |             | indexes |             | be  |   |             |   |
|   | As custom,  | were    |             | re  |   |             |   |
|   | execute the | c       |             | tur |   |             |   |
|   | following   | reated: |             | ned |   |             |   |
|   | script:     |         |             |     |   |             |   |
|   |             | SQL\>   |             |     |   |             |   |
|   | SQL\>@      | select  |             |     |   |             |   |
|   | c:\\temp\\c | cou     |             |     |   |             |   |
|   | _hr_emp.idx | nt(\*), |             |     |   |             |   |
|   |             | status  |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             | from    |             |     |   |             |   |
|   |             | all_    |             |     |   |             |   |
|   |             | indexes |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             | where   |             |     |   |             |   |
|   |             | upper   |             |     |   |             |   |
|   |             | (owner) |             |     |   |             |   |
|   |             | =       |             |     |   |             |   |
|   |             | \'C     |             |     |   |             |   |
|   |             | USTOM\' |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             | and     |             |     |   |             |   |
|   |             | low     |             |     |   |             |   |
|   |             | er(inde |             |     |   |             |   |
|   |             | x_name) |             |     |   |             |   |
|   |             | in      |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             | (\      |             |     |   |             |   |
|   |             | 'c_empl |             |     |   |             |   |
|   |             | oyee_ss |             |     |   |             |   |
|   |             | n_idx') |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             | group   |             |     |   |             |   |
|   |             | by      |             |     |   |             |   |
|   |             | status  |             |     |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 1 | Run the     | Execute |             | '   |   |             |   |
| 3 | following   | the     |             | 10' |   |             |   |
|   | script to   | fo      |             | sho |   |             |   |
|   | grant       | llowing |             | uld |   |             |   |
|   | permissions | query   |             | be  |   |             |   |
|   | to apps for | as      |             | re  |   |             |   |
|   | the custom  | apps:   |             | tur |   |             |   |
|   | tables      |         |             | ned |   |             |   |
|   |             | SQL\>   |             |     |   |             |   |
|   | As apps,    | select  |             |     |   |             |   |
|   | execute the | co      |             |     |   |             |   |
|   | following   | unt(\*) |             |     |   |             |   |
|   | script:     |         |             |     |   |             |   |
|   |             | from    |             |     |   |             |   |
|   | SQL\>@      | all_ta  |             |     |   |             |   |
|   | c:\\temp\\c | b_privs |             |     |   |             |   |
|   | _hr_emp.grt |         |             |     |   |             |   |
|   |             | where   |             |     |   |             |   |
|   |             | tab     |             |     |   |             |   |
|   |             | le_name |             |     |   |             |   |
|   |             | in      |             |     |   |             |   |
|   |             | (       |             |     |   |             |   |
|   |             | 'c_empl |             |     |   |             |   |
|   |             | oyee_s' |             |     |   |             |   |
|   |             | ,'c_emp |             |     |   |             |   |
|   |             | loyee_e |             |     |   |             |   |
|   |             | rror_s' |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             | ,'c_e   |             |     |   |             |   |
|   |             | mployee |             |     |   |             |   |
|   |             | ','c_em |             |     |   |             |   |
|   |             | ployee_ |             |     |   |             |   |
|   |             | errors' |             |     |   |             |   |
|   |             | ,'c_emp |             |     |   |             |   |
|   |             | _orgs') |             |     |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 1 | Run the     | Execute |             | Sho |   |             |   |
| 4 | following   | the     |             | uld |   |             |   |
|   | script to   | fo      |             | ret |   |             |   |
|   | compile the | llowing |             | urn |   |             |   |
|   | package     | query   |             | a   |   |             |   |
|   |             | as      |             | va  |   |             |   |
|   | As apps,    | apps:   |             | lue |   |             |   |
|   | execute the |         |             | of  |   |             |   |
|   | following   | SQL\>   |             | '   |   |             |   |
|   | script:     | select  |             | VAL |   |             |   |
|   |             | di      |             | ID' |   |             |   |
|   | SQL\>@      | stinct( |             |     |   |             |   |
|   | c:\\temp\\c | status) |             |     |   |             |   |
|   | _hr_emp.pkg |         |             |     |   |             |   |
|   |             | from    |             |     |   |             |   |
|   |             | dba_    |             |     |   |             |   |
|   |             | objects |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             | where   |             |     |   |             |   |
|   |             | obje    |             |     |   |             |   |
|   |             | ct_name |             |     |   |             |   |
|   |             | =       |             |     |   |             |   |
|   |             | \'C_H   |             |     |   |             |   |
|   |             | R_EMP\' |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             | and     |             |     |   |             |   |
|   |             | owner = |             |     |   |             |   |
|   |             | \       |             |     |   |             |   |
|   |             | 'APPS\' |             |     |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 1 | Execute the | Run the |             | Pro |   |             |   |
| 5 | following   | pr      |             | ced |   |             |   |
|   | script to   | ocedure |             | ure |   |             |   |
|   | ensure that |         |             | com |   |             |   |
|   | a unique    |         |             | ple |   |             |   |
|   | Vendor Name |         |             | tes |   |             |   |
|   | is set for  |         |             | suc |   |             |   |
|   | each        |         |             | ces |   |             |   |
|   | Employee to |         |             | sfu |   |             |   |
|   | be loaded   |         |             | lly |   |             |   |
|   |             |         |             |     |   |             |   |
|   | SQL\> exec  |         |             |     |   |             |   |
|   | c_hr_e      |         |             |     |   |             |   |
|   | mp.upd_name |         |             |     |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 1 | Execute the | Run the |             | Pro |   |             |   |
| 6 | following   | pr      |             | ced |   |             |   |
|   | script to   | ocedure |             | ure |   |             |   |
|   | populate    |         |             | com |   |             |   |
|   | the         |         |             | ple |   |             |   |
|   | formatted   |         |             | tes |   |             |   |
|   | f           |         |             | suc |   |             |   |
|   | ield_office |         |             | ces |   |             |   |
|   | value using |         |             | sfu |   |             |   |
|   | the         |         |             | lly |   |             |   |
|   | Org_code    |         |             |     |   |             |   |
|   | lookup      |         |             |     |   |             |   |
|   | table       |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   | SQL\> exec  |         |             |     |   |             |   |
|   | c_h         |         |             |     |   |             |   |
|   | r_emp.upd_f |         |             |     |   |             |   |
|   | ield_office |         |             |     |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 1 | Validate    | Run the |             | -   |   |             |   |
| 7 | the DISCAS  | pr      |             |   S |   |             |   |
|   | Employee    | ocedure |             | tag |   |             |   |
|   | data        |         |             | ing |   |             |   |
|   |             |         |             |     |   |             |   |
|   | SQL\>exec   |         |             |  ta |   |             |   |
|   | c_hr_emp.va |         |             | ble |   |             |   |
|   | lidate_data |         |             |     |   |             |   |
|   |             |         |             |   c |   |             |   |
|   |             |         |             | _em |   |             |   |
|   |             |         |             | plo |   |             |   |
|   |             |         |             | yee |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  co |   |             |   |
|   |             |         |             | nta |   |             |   |
|   |             |         |             | ins |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   f |   |             |   |
|   |             |         |             | our |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | sta |   |             |   |
|   |             |         |             | tus |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | fie |   |             |   |
|   |             |         |             | lds |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | cal |   |             |   |
|   |             |         |             | led |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  ve |   |             |   |
|   |             |         |             | ndo |   |             |   |
|   |             |         |             | r_s |   |             |   |
|   |             |         |             | tat |   |             |   |
|   |             |         |             | us, |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | sit |   |             |   |
|   |             |         |             | e_s |   |             |   |
|   |             |         |             | tat |   |             |   |
|   |             |         |             | us, |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | acc |   |             |   |
|   |             |         |             | t_s |   |             |   |
|   |             |         |             | tat |   |             |   |
|   |             |         |             | us, |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | and |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  ap |   |             |   |
|   |             |         |             | i_s |   |             |   |
|   |             |         |             | tat |   |             |   |
|   |             |         |             | us. |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  Po |   |             |   |
|   |             |         |             | ssi |   |             |   |
|   |             |         |             | ble |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | val |   |             |   |
|   |             |         |             | ues |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | for |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  th |   |             |   |
|   |             |         |             | ese |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | fie |   |             |   |
|   |             |         |             | lds |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | are |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  (U |   |             |   |
|   |             |         |             | )np |   |             |   |
|   |             |         |             | roc |   |             |   |
|   |             |         |             | ess |   |             |   |
|   |             |         |             | ed, |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | (P) |   |             |   |
|   |             |         |             | roc |   |             |   |
|   |             |         |             | ess |   |             |   |
|   |             |         |             | ed, |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  (E |   |             |   |
|   |             |         |             | )rr |   |             |   |
|   |             |         |             | or, |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | and |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  (D |   |             |   |
|   |             |         |             | )up |   |             |   |
|   |             |         |             | lic |   |             |   |
|   |             |         |             | ate |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | for |   |             |   |
|   |             |         |             | mat |   |             |   |
|   |             |         |             | ted |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   T |   |             |   |
|   |             |         |             | IN. |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | The |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   d |   |             |   |
|   |             |         |             | efa |   |             |   |
|   |             |         |             | ult |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | val |   |             |   |
|   |             |         |             | ues |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  of |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  th |   |             |   |
|   |             |         |             | ese |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | fie |   |             |   |
|   |             |         |             | lds |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | are |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   ' |   |             |   |
|   |             |         |             | U', |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | and |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   f |   |             |   |
|   |             |         |             | rom |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  th |   |             |   |
|   |             |         |             | ere |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   t |   |             |   |
|   |             |         |             | hey |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | can |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  go |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  to |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | 'P' |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  or |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   ' |   |             |   |
|   |             |         |             | E'. |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | The |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | 'E' |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | sta |   |             |   |
|   |             |         |             | tus |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  in |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   c |   |             |   |
|   |             |         |             | _em |   |             |   |
|   |             |         |             | plo |   |             |   |
|   |             |         |             | yee |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | can |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  be |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   c |   |             |   |
|   |             |         |             | ros |   |             |   |
|   |             |         |             | s-r |   |             |   |
|   |             |         |             | efe |   |             |   |
|   |             |         |             | ren |   |             |   |
|   |             |         |             | ced |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  to |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | the |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | num |   |             |   |
|   |             |         |             | ber |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  of |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   r |   |             |   |
|   |             |         |             | eco |   |             |   |
|   |             |         |             | rds |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  in |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | the |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  c_ |   |             |   |
|   |             |         |             | emp |   |             |   |
|   |             |         |             | loy |   |             |   |
|   |             |         |             | ee_ |   |             |   |
|   |             |         |             | err |   |             |   |
|   |             |         |             | ors |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | tab |   |             |   |
|   |             |         |             | le. |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  If |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  an |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | SSN |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  is |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  fo |   |             |   |
|   |             |         |             | und |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   t |   |             |   |
|   |             |         |             | hat |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   a |   |             |   |
|   |             |         |             | lre |   |             |   |
|   |             |         |             | ady |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | exi |   |             |   |
|   |             |         |             | sts |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  in |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   p |   |             |   |
|   |             |         |             | o_v |   |             |   |
|   |             |         |             | end |   |             |   |
|   |             |         |             | ors |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  ta |   |             |   |
|   |             |         |             | ble |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  as |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   a |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | for |   |             |   |
|   |             |         |             | mat |   |             |   |
|   |             |         |             | ted |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | TIN |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   n |   |             |   |
|   |             |         |             | umb |   |             |   |
|   |             |         |             | er, |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   t |   |             |   |
|   |             |         |             | hen |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   t |   |             |   |
|   |             |         |             | his |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | rec |   |             |   |
|   |             |         |             | ord |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  is |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | mar |   |             |   |
|   |             |         |             | ked |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  as |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   a |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | (D) |   |             |   |
|   |             |         |             | upl |   |             |   |
|   |             |         |             | ica |   |             |   |
|   |             |         |             | te, |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | but |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  no |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  er |   |             |   |
|   |             |         |             | ror |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  is |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | rec |   |             |   |
|   |             |         |             | ord |   |             |   |
|   |             |         |             | ed. |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  In |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   t |   |             |   |
|   |             |         |             | his |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  ca |   |             |   |
|   |             |         |             | se, |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  no |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  po |   |             |   |
|   |             |         |             | _ve |   |             |   |
|   |             |         |             | ndo |   |             |   |
|   |             |         |             | rs, |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | sit |   |             |   |
|   |             |         |             | es, |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  or |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   b |   |             |   |
|   |             |         |             | ank |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   r |   |             |   |
|   |             |         |             | eco |   |             |   |
|   |             |         |             | rds |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | are |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  cr |   |             |   |
|   |             |         |             | eat |   |             |   |
|   |             |         |             | ed, |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | but |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | the |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  Em |   |             |   |
|   |             |         |             | plo |   |             |   |
|   |             |         |             | yee |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | API |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  is |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   c |   |             |   |
|   |             |         |             | all |   |             |   |
|   |             |         |             | ed. |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  In |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | add |   |             |   |
|   |             |         |             | iti |   |             |   |
|   |             |         |             | on, |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | the |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   p |   |             |   |
|   |             |         |             | o_v |   |             |   |
|   |             |         |             | end |   |             |   |
|   |             |         |             | ors |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | and |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   p |   |             |   |
|   |             |         |             | o_v |   |             |   |
|   |             |         |             | end |   |             |   |
|   |             |         |             | or_ |   |             |   |
|   |             |         |             | sit |   |             |   |
|   |             |         |             | es_ |   |             |   |
|   |             |         |             | all |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   r |   |             |   |
|   |             |         |             | eco |   |             |   |
|   |             |         |             | rds |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   t |   |             |   |
|   |             |         |             | hat |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   h |   |             |   |
|   |             |         |             | ave |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | the |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | for |   |             |   |
|   |             |         |             | mat |   |             |   |
|   |             |         |             | ted |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | TIN |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  ma |   |             |   |
|   |             |         |             | tch |   |             |   |
|   |             |         |             | ing |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | the |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | SSN |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  in |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   E |   |             |   |
|   |             |         |             | mpl |   |             |   |
|   |             |         |             | oye |   |             |   |
|   |             |         |             | es, |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | are |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   u |   |             |   |
|   |             |         |             | pda |   |             |   |
|   |             |         |             | ted |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  to |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   m |   |             |   |
|   |             |         |             | ake |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   t |   |             |   |
|   |             |         |             | hem |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | 'lo |   |             |   |
|   |             |         |             | ok' |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   l |   |             |   |
|   |             |         |             | ike |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   t |   |             |   |
|   |             |         |             | hey |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   w |   |             |   |
|   |             |         |             | ere |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   o |   |             |   |
|   |             |         |             | rig |   |             |   |
|   |             |         |             | ina |   |             |   |
|   |             |         |             | lly |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |   e |   |             |   |
|   |             |         |             | nte |   |             |   |
|   |             |         |             | red |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  by |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             | the |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  Em |   |             |   |
|   |             |         |             | plo |   |             |   |
|   |             |         |             | yee |   |             |   |
|   |             |         |             |     |   |             |   |
|   |             |         |             |  co |   |             |   |
|   |             |         |             | nve |   |             |   |
|   |             |         |             | rsi |   |             |   |
|   |             |         |             | on. |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 1 | Execute the | Run the |             | Pro |   |             |   |
| 8 | following   | pr      |             | ced |   |             |   |
|   | to remove   | ocedure |             | ure |   |             |   |
|   | dashes in   |         |             | com |   |             |   |
|   | the account |         |             | ple |   |             |   |
|   | number      |         |             | tes |   |             |   |
|   | field, in   |         |             | suc |   |             |   |
|   | order to    |         |             | ces |   |             |   |
|   | facilitate  |         |             | sfu |   |             |   |
|   | the         |         |             | lly |   |             |   |
|   | matching of |         |             |     |   |             |   |
|   | tfcs_acct   |         |             |     |   |             |   |
|   | when        |         |             |     |   |             |   |
|   | setting the |         |             |     |   |             |   |
|   | multi_assig |         |             |     |   |             |   |
|   | nments_flag |         |             |     |   |             |   |
|   | in          |         |             |     |   |             |   |
|   | ap_bank_a   |         |             |     |   |             |   |
|   | ccounts_all |         |             |     |   |             |   |
|   |             |         |             |     |   |             |   |
|   | SQL\>exec   |         |             |     |   |             |   |
|   | c_h         |         |             |     |   |             |   |
|   | r_emp.remov |         |             |     |   |             |   |
|   | e_acct_dash |         |             |     |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 1 | Load the    | Run the |             | Pro |   |             |   |
| 9 | PO_VENDORS  | pr      |             | ced |   |             |   |
|   | table       | ocedure |             | ure |   |             |   |
|   |             | to      |             | com |   |             |   |
|   | SQL\>exec   | create  |             | ple |   |             |   |
|   | c_hr_em     | the     |             | tes |   |             |   |
|   | p.create_em | v       |             | suc |   |             |   |
|   | p_po_vendor | endors. |             | ces |   |             |   |
|   |             |         |             | sfu |   |             |   |
|   |             | Run the |             | lly |   |             |   |
|   |             | fo      |             |     |   |             |   |
|   |             | llowing |             | The |   |             |   |
|   |             | 2       |             | 2^  |   |             |   |
|   |             | queries |             | nd^ |   |             |   |
|   |             | when it |             | co  |   |             |   |
|   |             | com     |             | unt |   |             |   |
|   |             | pletes. |             | sho |   |             |   |
|   |             |         |             | uld |   |             |   |
|   |             | Select  |             | be  |   |             |   |
|   |             | c       |             | eq  |   |             |   |
|   |             | ount(1) |             | ual |   |             |   |
|   |             |         |             | to  |   |             |   |
|   |             | From    |             | the |   |             |   |
|   |             | c_e     |             | fi  |   |             |   |
|   |             | mployee |             | rst |   |             |   |
|   |             |         |             | co  |   |             |   |
|   |             | Where   |             | unt |   |             |   |
|   |             | vendor  |             | p   |   |             |   |
|   |             | _status |             | lus |   |             |   |
|   |             | = 'P'   |             | any |   |             |   |
|   |             |         |             | v   |   |             |   |
|   |             | And     |             | end |   |             |   |
|   |             |         |             | ors |   |             |   |
|   |             | Select  |             | in  |   |             |   |
|   |             | c       |             | the |   |             |   |
|   |             | ount(1) |             | tab |   |             |   |
|   |             |         |             | les |   |             |   |
|   |             | From    |             | bef |   |             |   |
|   |             | po_     |             | ore |   |             |   |
|   |             | vendors |             | the |   |             |   |
|   |             |         |             | c   |   |             |   |
|   |             |         |             | onv |   |             |   |
|   |             |         |             | ers |   |             |   |
|   |             |         |             | ion |   |             |   |
|   |             |         |             | is  |   |             |   |
|   |             |         |             | exe |   |             |   |
|   |             |         |             | cut |   |             |   |
|   |             |         |             | ed. |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 2 | Load the    | Run the |             | Pro |   |             |   |
| 0 | tables      | pr      |             | ced |   |             |   |
|   | PO_VENDOR   | ocedure |             | ure |   |             |   |
|   | _SITES_ALL, | to      |             | com |   |             |   |
|   | AP_BAN      | create  |             | ple |   |             |   |
|   | K_BRANCHES, | the     |             | tes |   |             |   |
|   | AP_BANK_AC  | v       |             | suc |   |             |   |
|   | COUNTS_ALL, | endors. |             | ces |   |             |   |
|   | and         |         |             | sfu |   |             |   |
|   | AP          | Run the |             | lly |   |             |   |
|   | _BANK_ACCOU | fo      |             |     |   |             |   |
|   | NT_USES_ALL | llowing |             | The |   |             |   |
|   |             | 2       |             | 2^  |   |             |   |
|   | SQL\>exec   | queries |             | nd^ |   |             |   |
|   | c_hr_emp    | when it |             | co  |   |             |   |
|   | .create_emp | com     |             | unt |   |             |   |
|   | _acct_sites | pletes. |             | sho |   |             |   |
|   |             |         |             | uld |   |             |   |
|   | Note that   | Select  |             | be  |   |             |   |
|   | the AP Bank | c       |             | eq  |   |             |   |
|   | Account     | ount(1) |             | ual |   |             |   |
|   | tables are  |         |             | to  |   |             |   |
|   | only loaded | From    |             | the |   |             |   |
|   | if an ABA   | c_e     |             | fi  |   |             |   |
|   | number is   | mployee |             | rst |   |             |   |
|   | present in  |         |             | co  |   |             |   |
|   | the DISCAS  | Where   |             | unt |   |             |   |
|   | Employee    | site    |             | p   |   |             |   |
|   | data        | _status |             | lus |   |             |   |
|   |             | = 'P'   |             | any |   |             |   |
|   | Note that   |         |             | ven |   |             |   |
|   | the         | And     |             | dor |   |             |   |
|   | AP_BA       |         |             | si  |   |             |   |
|   | NK_BRANCHES | Select  |             | tes |   |             |   |
|   | table is    | c       |             | in  |   |             |   |
|   | only loaded | ount(1) |             | the |   |             |   |
|   | if the ABA  |         |             | tab |   |             |   |
|   | number is   | From    |             | les |   |             |   |
|   | present in  | po_ve   |             | bef |   |             |   |
|   | the DISCAS  | ndor_si |             | ore |   |             |   |
|   | Employee    | tes_all |             | the |   |             |   |
|   | data, but   |         |             | c   |   |             |   |
|   | does not    |         |             | onv |   |             |   |
|   | already     |         |             | ers |   |             |   |
|   | exist in    |         |             | ion |   |             |   |
|   | the         |         |             | is  |   |             |   |
|   | AP_BA       |         |             | exe |   |             |   |
|   | NK_BRANCHES |         |             | cut |   |             |   |
|   | table       |         |             | ed. |   |             |   |
|   | (hence the  |         |             |     |   |             |   |
|   | Vendor      |         |             |     |   |             |   |
|   | Conversion  |         |             |     |   |             |   |
|   | p           |         |             |     |   |             |   |
|   | rerequisite |         |             |     |   |             |   |
|   | since       |         |             |     |   |             |   |
|   | Vendor      |         |             |     |   |             |   |
|   | conversion  |         |             |     |   |             |   |
|   | initially   |         |             |     |   |             |   |
|   | populates   |         |             |     |   |             |   |
|   | AP_BAN      |         |             |     |   |             |   |
|   | K_BRANCHES) |         |             |     |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 2 | Call the    | Run the |             | Pro |   |             |   |
| 1 | Oracle APIs | pr      |             | ced |   |             |   |
|   | for loading | ocedure |             | ure |   |             |   |
|   | the         | to      |             | com |   |             |   |
|   | Employee    | create  |             | ple |   |             |   |
|   | into the HR | the     |             | tes |   |             |   |
|   | module.     | v       |             | suc |   |             |   |
|   | This API    | endors. |             | ces |   |             |   |
|   | call loads  |         |             | sfu |   |             |   |
|   | the tables  | Run the |             | lly |   |             |   |
|   | PER_AL      | fo      |             |     |   |             |   |
|   | L_PEOPLE_F, | llowing |             | The |   |             |   |
|   | PER_ALL_ASS | 2       |             | 2^  |   |             |   |
|   | IGNMENTS_F, | queries |             | nd^ |   |             |   |
|   | and         | when it |             | co  |   |             |   |
|   | PER         | com     |             | unt |   |             |   |
|   | _ADDRESSES. | pletes. |             | sho |   |             |   |
|   | The custom  |         |             | uld |   |             |   |
|   | procedure   | Select  |             | be  |   |             |   |
|   | will link   | c       |             | eq  |   |             |   |
|   | the newly   | ount(1) |             | ual |   |             |   |
|   | created     |         |             | to  |   |             |   |
|   | employee to | From    |             | the |   |             |   |
|   | the         | c_e     |             | fi  |   |             |   |
|   | PO_VENDOR   | mployee |             | rst |   |             |   |
|   | record.     |         |             | co  |   |             |   |
|   |             | Where   |             | unt |   |             |   |
|   | > SQL\>exec | aoi     |             | p   |   |             |   |
|   | > c_        | _status |             | lus |   |             |   |
|   | hr_emp.crea | = 'P'   |             | emp |   |             |   |
|   | te_employee |         |             | loy |   |             |   |
|   |             | And     |             | ees |   |             |   |
|   |             |         |             | in  |   |             |   |
|   |             | Select  |             | the |   |             |   |
|   |             | c       |             | tab |   |             |   |
|   |             | ount(1) |             | les |   |             |   |
|   |             |         |             | bef |   |             |   |
|   |             | From    |             | ore |   |             |   |
|   |             | pe      |             | the |   |             |   |
|   |             | r_all_p |             | c   |   |             |   |
|   |             | eople_f |             | onv |   |             |   |
|   |             |         |             | ers |   |             |   |
|   |             |         |             | ion |   |             |   |
|   |             |         |             | is  |   |             |   |
|   |             |         |             | exe |   |             |   |
|   |             |         |             | cut |   |             |   |
|   |             |         |             | ed. |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+
| 2 | Log into    | Review  |             | Emp |   |             |   |
| 2 | 'DOE AP and | Em      |             | loy |   |             |   |
|   | FV          | ployees |             | ees |   |             |   |
|   | Admi        | to see  |             | sho |   |             |   |
|   | nistrator', | if they |             | uld |   |             |   |
|   | navigate to | have    |             | be  |   |             |   |
|   | Employees:  | been    |             | loa |   |             |   |
|   | View        | i       |             | ded |   |             |   |
|   | Employees.  | mported |             | i   |   |             |   |
|   |             | cor     |             | nto |   |             |   |
|   | Query       | rectly. |             | the |   |             |   |
|   | employees.  |         |             | sys |   |             |   |
|   |             |         |             | tem |   |             |   |
+---+-------------+---------+-------------+-----+---+-------------+---+

A.4 Customer Conversion Test Plan

+---+-------------+----------------------+-----------------+----------+
| * | *           | **Testing Step**     | **Expected      | **Actual |
| * | *Conversion |                      | Results**       | R        |
| U | Step**      |                      |                 | esults** |
| n |             |                      |                 |          |
| i |             |                      |                 |          |
| t |             |                      |                 |          |
| T |             |                      |                 |          |
| e |             |                      |                 |          |
| s |             |                      |                 |          |
| t |             |                      |                 |          |
| i |             |                      |                 |          |
| n |             |                      |                 |          |
| g |             |                      |                 |          |
| S |             |                      |                 |          |
| t |             |                      |                 |          |
| e |             |                      |                 |          |
| p |             |                      |                 |          |
| * |             |                      |                 |          |
| * |             |                      |                 |          |
+---+-------------+----------------------+-----------------+----------+
| 1 | Download    | Open local directory | All files are   |          |
|   | from PVCS   | and verify the files | successfully    |          |
|   | all of the  | in next column are   | downloaded      |          |
|   | files in    | successfully         |                 |          |
|   | the         | downloaded           |                 |          |
|   | Cust        |                      |                 |          |
|   | omSQL\\Conv |                      |                 |          |
|   | ersions\\AR |                      |                 |          |
|   | Customer    |                      |                 |          |
|   | directory.  |                      |                 |          |
|   | Put them    |                      |                 |          |
|   | into a      |                      |                 |          |
|   | working     |                      |                 |          |
|   | directory,  |                      |                 |          |
|   | for example |                      |                 |          |
|   | c:\\temp    |                      |                 |          |
+---+-------------+----------------------+-----------------+----------+
| 2 | Validate    | Execute the          | Tables created  |          |
|   | Custom      | following query as   |                 |          |
|   | Table       | apps:                |                 |          |
|   | creations   |                      |                 |          |
|   |             | SQLc_ar_customer.tab |                 |          |
+---+-------------+----------------------+-----------------+----------+
| 3 | Validate    | Execute the          | Sequences       |          |
|   | Custom      | following query as   | created         |          |
|   | Sequences   | apps:                |                 |          |
|   | creation    |                      |                 |          |
|   |             | SQLc_ar_customer.seq |                 |          |
+---+-------------+----------------------+-----------------+----------+
| 4 | Compile the | Execute the          | Package created |          |
|   | PL/SQL      | following script as  |                 |          |
|   | package     | custom               |                 |          |
|   |             |                      |                 |          |
|   |             | SQL\>@c:\\tem        |                 |          |
|   |             | p\\c_ar_customer.pkg |                 |          |
+---+-------------+----------------------+-----------------+----------+
| 5 | Locate the  | From the command     | The log file    |          |
|   | DISCAS      | line, execute the    | will contain    |          |
|   | conversion  | following script     | the following:  |          |
|   | extract     |                      |                 |          |
|   | file for    | C:\\temp\>           | Table           |          |
|   | the service | load_ar_customer.bat | "C_DEBTOR" x    |          |
|   | center      |                      | rows            |          |
|   | being       | View the resulting   | successfully    |          |
|   | loaded, and | log file             | laoded. Where x |          |
|   | view it     |                      | is the count of |          |
|   | using       |                      | records         |          |
|   | Textpad.    |                      |                 |          |
|   | Determine   |                      |                 |          |
|   | how many    |                      |                 |          |
|   | records are |                      |                 |          |
|   | in the      |                      |                 |          |
|   | dataset by  |                      |                 |          |
|   | looking at  |                      |                 |          |
|   | the row     |                      |                 |          |
|   | count       |                      |                 |          |
|   | displayed   |                      |                 |          |
|   | in Textpad. |                      |                 |          |
+---+-------------+----------------------+-----------------+----------+
| 6 | Locate the  | Execute the          | View the log    |          |
|   | Sql Loader  | following script     | file to verify  |          |
|   | control     | from the command     | that no errors  |          |
|   | file in     | line (assumes        | occurred while  |          |
|   | c:\\t       | Windows OS) and pass | loading the     |          |
|   | emp\\debtor | appropriate          | data into the   |          |
|   | _orders.ctl | parameters as listed | staging table   |          |
|   |             | below:               | c_debtor_orders |          |
|   |             |                      |                 |          |
|   |             | c:\\temp\\load_ar    |                 |          |
|   |             | _customer_orders.bat |                 |          |
|   |             |                      |                 |          |
|   |             | Parameter 1:         |                 |          |
|   |             | Database User Name   |                 |          |
|   |             |                      |                 |          |
|   |             | Parameter 2:         |                 |          |
|   |             | Database Password    |                 |          |
|   |             |                      |                 |          |
|   |             | Parameter 3:         |                 |          |
|   |             | Database Instance    |                 |          |
|   |             |                      |                 |          |
|   |             | Parameter 4: PVCS    |                 |          |
|   |             | working directory    |                 |          |
|   |             | referenced above     |                 |          |
|   |             | where files were     |                 |          |
|   |             | downloaded           |                 |          |
|   |             |                      |                 |          |
|   |             | Parameter 5:         |                 |          |
|   |             | Organization Id      |                 |          |
|   |             | corresponding to     |                 |          |
|   |             | Service Center       |                 |          |
|   |             | ('cap', 'alo',       |                 |          |
|   |             | 'oro')               |                 |          |
|   |             |                      |                 |          |
|   |             | A sample command     |                 |          |
|   |             | line might look like |                 |          |
|   |             | the following:       |                 |          |
|   |             | C:\\\>load_ar        |                 |          |
|   |             | _customer_orders.bat |                 |          |
|   |             | custom \<password\>  |                 |          |
|   |             | dev1 c:\\temp cap    |                 |          |
+---+-------------+----------------------+-----------------+----------+
| 7 | create      | Execute the          | Index created   |          |
|   | indexes on  | following script     |                 |          |
|   | the         |                      |                 |          |
|   | appropriate | SQL\>@c:\\tem        |                 |          |
|   | staging     | p\\c_ar_customer.idx |                 |          |
|   | tables      |                      |                 |          |
+---+-------------+----------------------+-----------------+----------+
| 8 | remove      | In SQLPlus, execute  | Procedure       |          |
|   | duplicate   | the following SQL    | completed       |          |
|   | debtor_code | packages as CUSTOM:  | successfully    |          |
|   | records     |                      |                 |          |
|   | from the    | exec                 |                 |          |
|   | debtors     | c_ar_custo           |                 |          |
|   | extract     | mer.check_dup_debtor |                 |          |
|   | data        |                      |                 |          |
+---+-------------+----------------------+-----------------+----------+
| 9 | remove      | In SQLPlus, execute  | Procedure       |          |
|   | duplicates  | the following SQL    | completed       |          |
|   | from the    | packages as CUSTOM:  | successfully    |          |
|   | order_num   |                      |                 |          |
|   | extract     | exec                 |                 |          |
|   | data.       | c_ar_cu              |                 |          |
|   |             | stomer.rem_dup_order |                 |          |
+---+-------------+----------------------+-----------------+----------+
| 1 | Populate    | Connect to the       | CCIDs are       |          |
| 0 | the         | database as the APPS | created in      |          |
|   | required    | schema owner         | GL_C            |          |
|   | fields      |                      | ODE_COMBINATION |          |
|   | necessary   | SQL\>@c:\            | table.          |          |
|   | to get the  | \temp\\cre_ccids.sql |                 |          |
|   | Revenue and |                      |                 |          |
|   | Receivable  |                      |                 |          |
|   | CCID values |                      |                 |          |
+---+-------------+----------------------+-----------------+----------+
| 1 | Ensure that | Apps.ra_cus          | Tables are      |          |
| 1 | the 3       | tomers_interface_all | empty. Verified |          |
|   | relevant    |                      |                 |          |
|   | Customer    | Apps.ra_custo        |                 |          |
|   | Interface   | mer_profiles_int_all |                 |          |
|   | tables have |                      |                 |          |
|   | no records  | Apps.ra_co           |                 |          |
|   |             | ntact_phones_int_all |                 |          |
+---+-------------+----------------------+-----------------+----------+
| 1 | Execute the | In SQLPlus, execute  | After package   |          |
| 2 | package's   | the following script | is finished,    |          |
|   | main        | as CUSTOM:           | check the       |          |
|   | procedure   |                      | 'Status' field  |          |
|   | to load the | exec                 | in c_debtors    |          |
|   | Customer    | c_ar_                | table. Possible |          |
|   | Interface   | customer.main('CAP') | statuses are    |          |
|   | tables, and |                      | (U)nprocessed,  |          |
|   | pass the    |                      | (P)rocessed,    |          |
|   | value 'CAP' |                      | and (E)rror.    |          |
|   | as a        |                      | Cross-reference |          |
|   | parameter.  |                      | the c_debtors   |          |
|   | Since all   |                      | records status  |          |
|   | c_debtors   |                      | of 'E' with the |          |
|   | records     |                      | number of       |          |
|   | will have   |                      | records in the  |          |
|   | the same    |                      | c_ar_           |          |
|   | org_id      |                      | customer_errors |          |
|   | value then  |                      | table (see      |          |
|   | all will be |                      | below for       |          |
|   | processed   |                      | c_ar_           |          |
|   | when using  |                      | customer_errors |          |
|   | 'CAP' as    |                      | table           |          |
|   | the input   |                      | description).   |          |
|   | parameter.  |                      | For each        |          |
|   |             |                      | service center  |          |
|   |             |                      | package run,    |          |
|   |             |                      | the number of   |          |
|   |             |                      | c_ar_           |          |
|   |             |                      | customer_errors |          |
|   |             |                      | records should  |          |
|   |             |                      | equal the       |          |
|   |             |                      | number of       |          |
|   |             |                      | c_debtors 'E'   |          |
|   |             |                      | records. At     |          |
|   |             |                      | this point, the |          |
|   |             |                      | number of 'P'   |          |
|   |             |                      | records in      |          |
|   |             |                      | c_debtors       |          |
|   |             |                      | indicate how    |          |
|   |             |                      | many records    |          |
|   |             |                      | will be run     |          |
|   |             |                      | through the     |          |
|   |             |                      | Customer        |          |
|   |             |                      | Interface.      |          |
+---+-------------+----------------------+-----------------+----------+
| 1 | Load        | Log in to STARS as   | After the       |          |
| 3 | customers   | the DOE Receivables  | Request has     |          |
|   | from        | Superuser.           | completed,      |          |
|   | Interface   |                      | check for       |          |
|   | tables to   | Submit a Concurrent  | errors. A       |          |
|   | Oracle      | Request to run the   | successful      |          |
|   | Customer    | 'Customer Interface' | single Customer |          |
|   | tables      |                      | conversion is   |          |
|   |             | Set the Reciprocal   | indicated by    |          |
|   |             | Customer parameter   | the removal of  |          |
|   |             | to 'N', which is the | all records     |          |
|   |             | default value        | (see NOTE       |          |
|   |             |                      | below) in the 3 |          |
|   |             |                      | relevant        |          |
|   |             |                      | Customer        |          |
|   |             |                      | Interface       |          |
|   |             |                      | tables for the  |          |
|   |             |                      | particular      |          |
|   |             |                      | debtor code.    |          |
+---+-------------+----------------------+-----------------+----------+

A.5 Purchasing (PO) Conversion Test Plan

+---+------------+---------------------+----------------+------------+
| * | **         | **Testing Step**    | **Expected     | **Actual   |
| * | Conversion |                     | Results**      | Results**  |
| U | Step**     |                     |                |            |
| n |            |                     |                |            |
| i |            |                     |                |            |
| t |            |                     |                |            |
| T |            |                     |                |            |
| e |            |                     |                |            |
| s |            |                     |                |            |
| t |            |                     |                |            |
| i |            |                     |                |            |
| n |            |                     |                |            |
| g |            |                     |                |            |
| S |            |                     |                |            |
| t |            |                     |                |            |
| e |            |                     |                |            |
| p |            |                     |                |            |
| * |            |                     |                |            |
| * |            |                     |                |            |
+---+------------+---------------------+----------------+------------+
| 1 | Download   | Open local          | All files are  |            |
| . | from PVCS  | directory and       | successfully   |            |
| 0 | all of the | verify the files in | downloaded     |            |
|   | files in   | next column are     |                |            |
|   | the        | successfully        |                |            |
|   | Custom     | downloaded          |                |            |
|   | SQL\\Conve |                     |                |            |
|   | rsions\\GL |                     |                |            |
|   | directory. |                     |                |            |
|   | Put them   |                     |                |            |
|   | into a     |                     |                |            |
|   | working    |                     |                |            |
|   | directory, |                     |                |            |
|   | for        |                     |                |            |
|   | example    |                     |                |            |
|   | c:\\temp   |                     |                |            |
+---+------------+---------------------+----------------+------------+
| 1 | Grant      | Execute the         | Messages       |            |
| . | Custom     | following query as  | returned in    |            |
| 1 | access to  | apps:               | SQLplus        |            |
|   | Apps or    |                     | confirmed that |            |
|   | Module     | SQLc_po.grt         | grants         |            |
|   | owner      |                     | succeeded      |            |
|   | tab        |                     |                |            |
|   | les/views. |                     |                |            |
+---+------------+---------------------+----------------+------------+
| 1 | Validate   | Execute the         | Tables created |            |
| . | Custom     | following query as  |                |            |
| 2 | Table      | apps:               |                |            |
|   | creations  |                     |                |            |
|   |            | SQLc_po.tab         |                |            |
+---+------------+---------------------+----------------+------------+
| 1 | Validate   | Execute the         | Sequences      |            |
| . | Custom     | following query as  | created        |            |
| 3 | Sequences  | apps:               |                |            |
|   | creation   |                     |                |            |
|   |            | SQLc_po.seq         |                |            |
+---+------------+---------------------+----------------+------------+
| 1 | Validate   | Execute the         | Index created  |            |
| . | temporary  | following query as  |                |            |
| 4 | index      | apps:               |                |            |
|   | creation   |                     |                |            |
|   |            | SQLc                |                |            |
|   |            | _po_tempindexes.sql |                |            |
+---+------------+---------------------+----------------+------------+
| 1 | Validate   | Execute the         | Views created  |            |
| . | Custom     | following query as  |                |            |
| 5 | Views      | apps:               |                |            |
|   | creations  |                     |                |            |
|   |            | SQLc_po.vw          |                |            |
+---+------------+---------------------+----------------+------------+
| 1 | Load       | From DOS prompt run | log and bad    |            |
| . | default    | the following       | files          |            |
| 6 | site       |                     | confirmed that |            |
|   | source     | Sqlldr userid=      | data loaded    |            |
|   | i          | CUST                | successfully   |            |
|   | nformation | OM/{password}@{sid} |                |            |
|   | from ASCII | control =           |                |            |
|   | file into  | c_po_source.ctl log |                |            |
|   | Oracle     | = c_po_source.log   |                |            |
|   | staging    | bad=c_po_source.bad |                |            |
|   | tables     |                     |                |            |
|   |            | Check log and bad   |                |            |
|   |            | files and make sure |                |            |
|   |            | all records         |                |            |
+---+------------+---------------------+----------------+------------+
| 1 | Load PO    | From DOS prompt run | All log and    |            |
| . | data from  | the following       | bad files      |            |
| 7 | ASCII file |                     | confirmed that |            |
|   | into       | Sqlldr userid=      | data loaded    |            |
|   | Oracle     | CUST                | successfully   |            |
|   | staging    | OM/{password}@{sid} |                |            |
|   | tables for | control =           |                |            |
|   | all        | c_po_rollup.cap log |                |            |
|   | service    | =                   |                |            |
|   | centers    | c_po_rollup_cap.log |                |            |
|   |            | bad=                |                |            |
|   |            | c_po_rollup_cap.bad |                |            |
|   |            |                     |                |            |
|   |            | Sqlldr userid=      |                |            |
|   |            | CUST                |                |            |
|   |            | OM/{password}@{sid} |                |            |
|   |            | control =           |                |            |
|   |            | c_po_rollup.alo log |                |            |
|   |            | =                   |                |            |
|   |            | c_po_rollup_alo.log |                |            |
|   |            | bad=                |                |            |
|   |            | c_po_rollup_alo.bad |                |            |
|   |            |                     |                |            |
|   |            | Sqlldr userid=      |                |            |
|   |            | CUST                |                |            |
|   |            | OM/{password}@{sid} |                |            |
|   |            | control =           |                |            |
|   |            | c_po_rollup.oro log |                |            |
|   |            | =                   |                |            |
|   |            | c_po_rollup_oro.log |                |            |
|   |            | bad=                |                |            |
|   |            | c_po_rollup_oro.bad |                |            |
|   |            |                     |                |            |
|   |            | Check log and bad   |                |            |
|   |            | files and make sure |                |            |
|   |            | all records         |                |            |
+---+------------+---------------------+----------------+------------+
| 1 | Load PO    | Open                | Log and Bad    |            |
| . | PCS data   | c_po_pcs_rollup.cap | files          |            |
| 8 | from ASCII | in textpad and      | confirmed      |            |
|   | file into  | verify the org_id   | successful     |            |
|   | Oracle     | CONSTANT is set to  | load           |            |
|   | staging    | correct integer for |                |            |
|   | table      | the service center. |                |            |
|   |            | The number should   |                |            |
|   |            | correspond to the   |                |            |
|   |            | organization_id     |                |            |
|   |            | found in the view   |                |            |
|   |            | hr_organiza         |                |            |
|   |            | tion_information_v. |                |            |
|   |            |                     |                |            |
|   |            | From DOS prompt run |                |            |
|   |            | the following       |                |            |
|   |            |                     |                |            |
|   |            | Sqlldr              |                |            |
|   |            | userid=CUST         |                |            |
|   |            | OM/{password}@{sid} |                |            |
|   |            | control =           |                |            |
|   |            | c_po_pcs_rollup.cap |                |            |
|   |            | log=c_po            |                |            |
|   |            | _pcs_rollup_cap.log |                |            |
|   |            | bad=c_po            |                |            |
|   |            | _pcs_rollup_cap.bad |                |            |
|   |            |                     |                |            |
|   |            | Check log and bad   |                |            |
|   |            | files and make sure |                |            |
|   |            | all records         |                |            |
+---+------------+---------------------+----------------+------------+
| 1 | Validate   | From SQLplus as     | Package        |            |
| . | Package    | CUSTOM run the      | created        |            |
| 9 | creation   | following           |                |            |
|   |            |                     |                |            |
|   |            | C_po                |                |            |
|   |            | _convert_rollup.pkg |                |            |
+---+------------+---------------------+----------------+------------+
| 1 | Validate   | From SQLplus as     | To verify the  |            |
| . | Date       | CUSTOM run the      | validate       |            |
| 1 | format     | following           | script         |            |
| 0 |            |                     | succeeded, in  |            |
|   |            | C_po                | SQLPLUS        |            |
|   |            | _validate_dates.sql | connect as     |            |
|   |            |                     | CUSTOM and     |            |
|   |            |                     | verify the     |            |
|   |            |                     | following SQL  |            |
|   |            |                     | statement runs |            |
|   |            |                     | successfully   |            |
|   |            |                     | (unsuccessful  |            |
|   |            |                     | query will     |            |
|   |            |                     | return message |            |
|   |            |                     | "invalid       |            |
|   |            |                     | month"):       |            |
|   |            |                     |                |            |
|   |            |                     | SELECT TO_CHAR |            |
|   |            |                     | (TO_DATE       |            |
|   |            |                     | (RTRIM         |            |
|   |            |                     | (start_date),  |            |
|   |            |                     | \'rrmmdd\'),   |            |
|   |            |                     | \'yyyy/mm/dd   |            |
|   |            |                     | hh:mi:ss\'),   |            |
|   |            |                     | TO_CHAR        |            |
|   |            |                     | (TO_DATE       |            |
|   |            |                     | (RTRIM         |            |
|   |            |                     | (end_date),    |            |
|   |            |                     | \'rrmmdd\'),   |            |
|   |            |                     | \'yyyy/mm/dd   |            |
|   |            |                     | hh:mi:ss\')    |            |
|   |            |                     | FROM           |            |
|   |            |                     | c_po_rollup    |            |
|   |            |                     | WHERE ROWNUM   |            |
|   |            |                     | \< 10;         |            |
+---+------------+---------------------+----------------+------------+
| 1 | Verify     | In SQLPlus, execute | To verify the  |            |
| . | Data       | the following       | data script    |            |
| 1 | converted  | script as CUSTOM:   | succeeded, in  |            |
| 1 | for        | c_po_xferdata.sql.  | SQLPLUS        |            |
|   | Transfers  |                     | connect as     |            |
|   |            |                     | CUSTOM and run |            |
|   |            |                     | the following  |            |
|   |            |                     | SQL            |            |
|   |            |                     | statements.    |            |
|   |            |                     | Each should    |            |
|   |            |                     | return 0 rows. |            |
|   |            |                     |                |            |
|   |            |                     | SELECT \* FROM |            |
|   |            |                     | c_po_rollup    |            |
|   |            |                     | WHERE          |            |
|   |            |                     | fund_type !=   |            |
|   |            |                     | \'YZ89X0240\'  |            |
|   |            |                     | AND SUBSTR     |            |
|   |            |                     | (              |            |
|   |            |                     | bnr_any_level, |            |
|   |            |                     | 1, 6) IN       |            |
|   |            |                     | (\'YN1902\',   |            |
|   |            |                     | \'820202\',    |            |
|   |            |                     | \'820102\',    |            |
|   |            |                     | \'YN1901\',    |            |
|   |            |                     | \'820201\',    |            |
|   |            |                     | \'820101\');   |            |
|   |            |                     |                |            |
|   |            |                     | SELECT \* FROM |            |
|   |            |                     | c_po_rollup    |            |
|   |            |                     | WHERE SUBSTR   |            |
|   |            |                     | (              |            |
|   |            |                     | bnr_any_level, |            |
|   |            |                     | 1, 6) IN       |            |
|   |            |                     | (\'820201\',   |            |
|   |            |                     | \'820101\',    |            |
|   |            |                     | \'820202\',    |            |
|   |            |                     | \'820102\');   |            |
+---+------------+---------------------+----------------+------------+
| 1 | Verify All | In SQLPlus, execute | To verify the  |            |
| . | original   | the following PLSQL | all segments   |            |
| 1 | PO AFF     | package procedure   | exist, in      |            |
| 2 | segments   | as CUSTOM:          | SQLPLUS        |            |
|   | exist in   | c_po_convert_ro     | connect as     |            |
|   | Oracle     | llup.verifysegments | CUSTOM and     |            |
|   | apps FND   |                     | verify the     |            |
|   | tables.    |                     | data, by       |            |
|   |            |                     | running the    |            |
|   |            |                     | following SQL  |            |
|   |            |                     | statement:     |            |
|   |            |                     |                |            |
|   |            |                     | select         |            |
|   |            |                     | count(\*) from |            |
|   |            |                     | c_po_errors    |            |
|   |            |                     | where          |            |
|   |            |                     | err_source='   |            |
|   |            |                     | SEGMENT        |            |
|   |            |                     | VERIFY';       |            |
|   |            |                     |                |            |
|   |            |                     | The count(\*)  |            |
|   |            |                     | returned       |            |
|   |            |                     | should be zero |            |
+---+------------+---------------------+----------------+------------+
| 1 | Verify     | In SQLPlus, execute | To verify the  |            |
| . | Org_ID is  | the following       | data script    |            |
| 1 | not null   | procedure as        | succeeded, in  |            |
| 3 |            | CUSTOM:             | SQLPLUS        |            |
|   |            | c_po_convert_ro     | connect as     |            |
|   |            | llup.validateorgid; | CUSTOM and run |            |
|   |            |                     | the following  |            |
|   |            |                     | SQL statement. |            |
|   |            |                     | Zero rows      |            |
|   |            |                     | should be      |            |
|   |            |                     | returned.      |            |
|   |            |                     |                |            |
|   |            |                     | SELECT \* FROM |            |
|   |            |                     | c_po_rollup a  |            |
|   |            |                     | WHERE status   |            |
|   |            |                     | != \'ERROR\'   |            |
|   |            |                     | AND org_id IS  |            |
|   |            |                     | NULL;          |            |
+---+------------+---------------------+----------------+------------+
| 1 | Verify All | In SQLPlus, execute | execute        |            |
| . | PO Vendors | the following PLSQL | c_po_vend      |            |
| 1 | exist      | CUSTOM to find and  | or.format_duns |            |
| 4 | after      | create missing      |                |            |
|   | missing    | vendors:            | execute        |            |
|   | Vendors    |                     | c_po_vendor    |            |
|   | Created    |                     | .validate_data |            |
|   |            |                     |                |            |
|   |            |                     | upd_u          |            |
|   |            |                     | nique_name.sql |            |
|   |            |                     |                |            |
|   |            |                     | execute        |            |
|   |            |                     | c_po_vendor.cr |            |
|   |            |                     | eate_po_vendor |            |
|   |            |                     |                |            |
|   |            |                     | execute        |            |
|   |            |                     | c              |            |
|   |            |                     | _po_vendor.cre |            |
|   |            |                     | ate_acct_sites |            |
|   |            |                     |                |            |
|   |            |                     | In SQLPlus,    |            |
|   |            |                     | execute the    |            |
|   |            |                     | following      |            |
|   |            |                     | PLSQL CUSTOM   |            |
|   |            |                     | to find        |            |
|   |            |                     | missing        |            |
|   |            |                     | vendors:       |            |
|   |            |                     |                |            |
|   |            |                     | Create table   |            |
|   |            |                     | c_d            |            |
|   |            |                     | uns_oblig_bak2 |            |
|   |            |                     | as select \*   |            |
|   |            |                     | from           |            |
|   |            |                     | c_duns_oblig;  |            |
|   |            |                     |                |            |
|   |            |                     | Truncate table |            |
|   |            |                     | c_duns_oblig;  |            |
|   |            |                     |                |            |
|   |            |                     | execute        |            |
|   |            |                     | c_po_c         |            |
|   |            |                     | onvert_rollup. |            |
|   |            |                     | verifyvendors; |            |
|   |            |                     |                |            |
|   |            |                     | To verify no   |            |
|   |            |                     | missing        |            |
|   |            |                     | vendors, the   |            |
|   |            |                     | following SQL  |            |
|   |            |                     | statement      |            |
|   |            |                     | should return  |            |
|   |            |                     | 0 (Zero) rows. |            |
|   |            |                     |                |            |
|   |            |                     | SELECT \* FROM |            |
|   |            |                     | c_duns_oblig;  |            |
+---+------------+---------------------+----------------+------------+
| 1 | Verify PO  | In SQLPlus, execute | To verify the  |            |
| . | AFF Data   | the following SQL   | procedure      |            |
| 1 | C          | script as CUSTOM:   | executed       |            |
| 5 | rosswalked | c_po_crosswalk.sql  | succeesfully,  |            |
|   | su         |                     | in SQLPLUS     |            |
|   | ccessfully |                     | connect as     |            |
|   |            |                     | CUSTOM and     |            |
|   |            |                     | verify the     |            |
|   |            |                     | data, by       |            |
|   |            |                     | running the    |            |
|   |            |                     | following SQL  |            |
|   |            |                     | statement:     |            |
|   |            |                     |                |            |
|   |            |                     | select \* from |            |
|   |            |                     | c_po_rollup    |            |
|   |            |                     | where          |            |
|   |            |                     | (segment1 is   |            |
|   |            |                     | null or        |            |
|   |            |                     | segment2 is    |            |
|   |            |                     | null or        |            |
|   |            |                     | segment3 is    |            |
|   |            |                     | null or        |            |
|   |            |                     | segment4 is    |            |
|   |            |                     | null or        |            |
|   |            |                     | segment5 is    |            |
|   |            |                     | null or        |            |
|   |            |                     | segment6 is    |            |
|   |            |                     | null or        |            |
|   |            |                     | segment7 is    |            |
|   |            |                     | null or        |            |
|   |            |                     | segment8 is    |            |
|   |            |                     | null or        |            |
|   |            |                     | segment9 is    |            |
|   |            |                     | null or        |            |
|   |            |                     | segment10 is   |            |
|   |            |                     | null) and      |            |
|   |            |                     | datasource =   |            |
|   |            |                     | \'YE DATA\'    |            |
|   |            |                     |                |            |
|   |            |                     | Record count   |            |
|   |            |                     | should be      |            |
|   |            |                     | zero.          |            |
+---+------------+---------------------+----------------+------------+
| 1 | Verify GL  | In SQLPlus, execute | To verify all  |            |
| . | Code       | the following SQL   | code           |            |
| 1 | Co         | as CUSTOM:          | combinations   |            |
| 6 | mbinations | c_po_convert_       | exist, in      |            |
|   | Created    | rollup.createglccid | SQLPLUS        |            |
|   |            |                     | connect as     |            |
|   |            | As DOE GL Superuser | CUSTOM and run |            |
|   |            | run                 | the following  |            |
|   |            | jou                 | SQL statement. |            |
|   |            | rnal=\>import=\>run | A count of 0   |            |
|   |            | for source CONVERT  | (Zero) Should  |            |
|   |            | and all group ids.  | be returned:   |            |
|   |            |                     |                |            |
|   |            | In SQLPlus, execute | select         |            |
|   |            | the following SQL   | count(\*) from |            |
|   |            | as CUSTOM:          | c_po_rollup    |            |
|   |            | c_po_load_ccid.sql  | where cc_id is |            |
|   |            |                     | null;          |            |
+---+------------+---------------------+----------------+------------+
| 1 | Verify the | In SQLPlus, connect | All scripts    |            |
| . | PO Open    | as CUSTOM.          | completed      |            |
| 1 | Interface  |                     | successfully   |            |
| 7 | Staging    | Execute the         |                |            |
|   | tables are | following SQL       |                |            |
|   | empty      | Statements to clear |                |            |
|   |            | the PO Interface    |                |            |
|   |            | tables.             |                |            |
|   |            |                     |                |            |
|   |            | Delete from         |                |            |
|   |            | po.po               |                |            |
|   |            | _headers_interface; |                |            |
|   |            |                     |                |            |
|   |            | Delete from         |                |            |
|   |            | po.                 |                |            |
|   |            | po_lines_interface; |                |            |
|   |            |                     |                |            |
|   |            | Delete from         |                |            |
|   |            | po.po_distr         |                |            |
|   |            | ibutions_interface; |                |            |
|   |            |                     |                |            |
|   |            | Delete from         |                |            |
|   |            | po.p                |                |            |
|   |            | o_interface_errors; |                |            |
|   |            |                     |                |            |
|   |            | Delete from         |                |            |
|   |            | custom.c_po_errors; |                |            |
|   |            |                     |                |            |
|   |            | Execute the         |                |            |
|   |            | following SQL       |                |            |
|   |            | Statements to       |                |            |
|   |            | verify the counts   |                |            |
|   |            | within the staging  |                |            |
|   |            | tables (all counts  |                |            |
|   |            | should be zero).    |                |            |
|   |            |                     |                |            |
|   |            | Select Count(\*)    |                |            |
|   |            | from                |                |            |
|   |            | po.po               |                |            |
|   |            | _headers_interface; |                |            |
|   |            |                     |                |            |
|   |            | Select Count(\*)    |                |            |
|   |            | from                |                |            |
|   |            | po.                 |                |            |
|   |            | po_lines_interface; |                |            |
|   |            |                     |                |            |
|   |            | Select Count(\*)    |                |            |
|   |            | from                |                |            |
|   |            | po.po_distr         |                |            |
|   |            | ibutions_interface; |                |            |
|   |            |                     |                |            |
|   |            | Select Count(\*)    |                |            |
|   |            | from                |                |            |
|   |            | po.p                |                |            |
|   |            | o_interface_errors; |                |            |
|   |            |                     |                |            |
|   |            | Select Count(\*)    |                |            |
|   |            | from                |                |            |
|   |            | custom.c_po_errors; |                |            |
+---+------------+---------------------+----------------+------------+
| 1 | Verify PCS | In SQLPlus, execute | To verify the  |            |
| . | data is    | the following SQL   | procedure      |            |
| 1 | flagged in | script as CUSTOM:   | executed       |            |
| 8 | PO Data    | c_po_pcs.sql        | succeesfully,  |            |
|   |            |                     | in SQLPLUS     |            |
|   |            |                     | connect as     |            |
|   |            |                     | CUSTOM and     |            |
|   |            |                     | verify the     |            |
|   |            |                     | data, by       |            |
|   |            |                     | running the    |            |
|   |            |                     | following SQL  |            |
|   |            |                     | statement:     |            |
|   |            |                     |                |            |
|   |            |                     | select         |            |
|   |            |                     | count(\*) from |            |
|   |            |                     | c_po_rollup    |            |
|   |            |                     | where status = |            |
|   |            |                     | \'PCS NEW\';   |            |
|   |            |                     |                |            |
|   |            |                     | select         |            |
|   |            |                     | count(\*) from |            |
|   |            |                     | c_po_rollup    |            |
|   |            |                     | where          |            |
|   |            |                     | SUBSTR(cid, 1, |            |
|   |            |                     | 4) like        |            |
|   |            |                     | \'TV_8\';      |            |
+---+------------+---------------------+----------------+------------+
| 1 | Verify PCS | In SQLPlus, execute | To verify the  |            |
| . | PO Data    | the following SQL   | procedure      |            |
| 1 | Segment6   | script as CUSTOM:   | executed       |            |
| 9 | C          | c_p                 | succeesfully,  |            |
|   | rosswalked | o_pcs_crosswalk.sql | in SQLPLUS     |            |
|   | su         |                     | connect as     |            |
|   | ccessfully |                     | CUSTOM and     |            |
|   |            |                     | verify the     |            |
|   |            |                     | data, by       |            |
|   |            |                     | running the    |            |
|   |            |                     | following SQL  |            |
|   |            |                     | statement:     |            |
|   |            |                     |                |            |
|   |            |                     | select         |            |
|   |            |                     | count(\*) from |            |
|   |            |                     | c              |            |
|   |            |                     | _po_pcs_rollup |            |
|   |            |                     | where segment6 |            |
|   |            |                     | is null;       |            |
|   |            |                     |                |            |
|   |            |                     | Record count   |            |
|   |            |                     | should be      |            |
|   |            |                     | zero.          |            |
+---+------------+---------------------+----------------+------------+
| 1 | Verify PCS | In SQLPlus, execute | Verify No      |            |
| . | Data Load  | the following SQL   | errors exist   |            |
| 2 | to Staging | packages as CUSTOM: | in data by, in |            |
| 0 | Table      |                     | SQLPLUS        |            |
|   |            | execute             | connect as     |            |
|   |            | c_po_convert_r      | CUSTOM and     |            |
|   |            | ollup.pcserrorcheck | verify the     |            |
|   |            |                     | data, by       |            |
|   |            |                     | running the    |            |
|   |            |                     | following SQL  |            |
|   |            |                     | statement:     |            |
|   |            |                     |                |            |
|   |            |                     | select         |            |
|   |            |                     | count(\*) from |            |
|   |            |                     | c_po_errors    |            |
|   |            |                     |                |            |
|   |            |                     | The count(\*)  |            |
|   |            |                     | returned       |            |
|   |            |                     | should be zero |            |
|   |            |                     |                |            |
|   |            |                     | In SQLPlus,    |            |
|   |            |                     | execute the    |            |
|   |            |                     | following SQL  |            |
|   |            |                     | package as     |            |
|   |            |                     | CUSTOM:        |            |
|   |            |                     |                |            |
|   |            |                     | execute        |            |
|   |            |                     | c_po_convert_  |            |
|   |            |                     | rollup.loadpcs |            |
|   |            |                     |                |            |
|   |            |                     | Verify No      |            |
|   |            |                     | errors exist   |            |
|   |            |                     | in data by, in |            |
|   |            |                     | SQLPLUS        |            |
|   |            |                     | connect as     |            |
|   |            |                     | CUSTOM and     |            |
|   |            |                     | verify the     |            |
|   |            |                     | data, by       |            |
|   |            |                     | running the    |            |
|   |            |                     | following SQL  |            |
|   |            |                     | statement:     |            |
|   |            |                     |                |            |
|   |            |                     | select         |            |
|   |            |                     | count(\*) from |            |
|   |            |                     | c_po_errors    |            |
|   |            |                     |                |            |
|   |            |                     | The count(\*)  |            |
|   |            |                     | returned       |            |
|   |            |                     | should be zero |            |
+---+------------+---------------------+----------------+------------+
| 1 | Validate   | In SQLPlus, execute | Verify No      |            |
| . | O          | the following SQL   | errors exist   |            |
| 2 | bligations | packages as CUSTOM: | in data by, in |            |
| 1 | Staging    |                     | SQLPLUS        |            |
|   | Table      | execute             | connect as     |            |
|   |            | c_po_convert        | CUSTOM and     |            |
|   |            | _rollup.validateobs | verify the     |            |
|   |            |                     | data, by       |            |
|   |            |                     | running the    |            |
|   |            |                     | following SQL  |            |
|   |            |                     | statement:     |            |
|   |            |                     |                |            |
|   |            |                     | select         |            |
|   |            |                     | count(\*) from |            |
|   |            |                     | c_po_errors    |            |
|   |            |                     |                |            |
|   |            |                     | The count(\*)  |            |
|   |            |                     | returned       |            |
|   |            |                     | should be zero |            |
+---+------------+---------------------+----------------+------------+
| 1 | Verify     | In SQLPlus, execute | Verify No      |            |
| . | Data       | the following SQL   | errors exist   |            |
| 2 | loaded     | packages as CUSTOM: | in data by, in |            |
| 2 | su         |                     | SQLPLUS        |            |
|   | ccessfully | execute             | connect as     |            |
|   | into PO    | po_c                | CUSTOM and     |            |
|   | Open       | onvert_rollup.main; | verify the     |            |
|   | Interface  |                     | data, by       |            |
|   | tables     |                     | running the    |            |
|   |            |                     | following SQL  |            |
|   |            |                     | statement:     |            |
|   |            |                     |                |            |
|   |            |                     | select         |            |
|   |            |                     | count(\*) from |            |
|   |            |                     | c_po_errors    |            |
|   |            |                     |                |            |
|   |            |                     | The count(\*)  |            |
|   |            |                     | returned       |            |
|   |            |                     | should be zero |            |
+---+------------+---------------------+----------------+------------+
| 1 | Verify     | Under 'DOE PR and   | Check Log and  |            |
| . | Concurrent | PO Entry with       | Output of      |            |
| 2 | Process    | Processes'          | Request for    |            |
| 3 | Import     | responsibility Run  | errors         |            |
|   | PO's       | "Import Standard    |                |            |
|   | finishes   | PO's "              | Verify No      |            |
|   | su         |                     | errors exist   |            |
|   | ccessfully |                     | in data by, in |            |
|   |            |                     | SQLPLUS        |            |
|   |            |                     | connect as     |            |
|   |            |                     | CUSTOM and     |            |
|   |            |                     | verify the     |            |
|   |            |                     | data, by       |            |
|   |            |                     | running the    |            |
|   |            |                     | following SQL  |            |
|   |            |                     | statement:     |            |
|   |            |                     |                |            |
|   |            |                     | select         |            |
|   |            |                     | count(\*)      |            |
|   |            |                     | po_in          |            |
|   |            |                     | terface_errors |            |
|   |            |                     |                |            |
|   |            |                     | The count(\*)  |            |
|   |            |                     | returned       |            |
|   |            |                     | should be zero |            |
+---+------------+---------------------+----------------+------------+
| 1 | Drop       | In SQLPlus, execute | In SQLPLUS as  |            |
| . | Temporary  | the following       | Custom, run    |            |
| 2 | Index      | script as CUSTOM:   | Select         |            |
| 4 | Creation   | c_po_d              | index_name     |            |
|   |            | rop_tempindexes.sql | from           |            |
|   |            |                     | user_indexes.  |            |
|   |            |                     | The following  |            |
|   |            |                     | index names    |            |
|   |            |                     | should not be  |            |
|   |            |                     | displayed:     |            |
|   |            |                     |                |            |
|   |            |                     | gl_code_comb   |            |
|   |            |                     | inations_temp2 |            |
|   |            |                     |                |            |
|   |            |                     | gl_code_comb   |            |
|   |            |                     | inations_temp1 |            |
|   |            |                     |                |            |
|   |            |                     | gl_code_comb   |            |
|   |            |                     | inations_temp3 |            |
|   |            |                     |                |            |
|   |            |                     | po_headers_int |            |
|   |            |                     | erface_tempidx |            |
|   |            |                     |                |            |
|   |            |                     | po_distrib_    |            |
|   |            |                     | inter_tmp_idx1 |            |
|   |            |                     |                |            |
|   |            |                     | po_ve          |            |
|   |            |                     | ndors_idx_temp |            |
|   |            |                     |                |            |
|   |            |                     | po             |            |
|   |            |                     | _headers_inter |            |
|   |            |                     | face_idx_temp1 |            |
|   |            |                     |                |            |
|   |            |                     | fn             |            |
|   |            |                     | d_descr_flex_c |            |
|   |            |                     | olumn_use_tmp1 |            |
|   |            |                     |                |            |
|   |            |                     | fn             |            |
|   |            |                     | d_descr_flex_c |            |
|   |            |                     | olumn_use_tmp2 |            |
|   |            |                     |                |            |
|   |            |                     | po_requistion_ |            |
|   |            |                     | interface_tmp1 |            |
|   |            |                     |                |            |
|   |            |                     | po_req_dist_   |            |
|   |            |                     | interface_tmp1 |            |
+---+------------+---------------------+----------------+------------+

A.6 Accounts Payable (AP) Conversion Test Plan

+----+--------------+---------------------+---------------+----------+
| ** | **Conversion | **Testing Step**    | **Expected    | **Actual |
| Un | Step**       |                     | Results**     | R        |
| it |              |                     |               | esults** |
| T  |              |                     |               |          |
| es |              |                     |               |          |
| ti |              |                     |               |          |
| ng |              |                     |               |          |
| St |              |                     |               |          |
| ep |              |                     |               |          |
| ** |              |                     |               |          |
+----+--------------+---------------------+---------------+----------+
| 1  | Download     | Open local          | All files are |          |
| .0 | from PVCS    | directory and       | successfully  |          |
|    | all of the   | verify the files in | downloaded    |          |
|    | files in the | next column are     |               |          |
|    | Cu           | successfully        |               |          |
|    | stomSQL\\Con | downloaded          |               |          |
|    | versions\\AP |                     |               |          |
|    | directory.   |                     |               |          |
|    | Put them     |                     |               |          |
|    | into a       |                     |               |          |
|    | working      |                     |               |          |
|    | directory,   |                     |               |          |
|    | for example  |                     |               |          |
|    | c:\\temp     |                     |               |          |
+----+--------------+---------------------+---------------+----------+
| 1  | Grant Custom | Execute the         | Messages      |          |
| .1 | access to    | following query as  | returned in   |          |
|    | Apps or      | apps:               | SQLplus       |          |
|    | Module owner |                     | confirmed     |          |
|    | t            | SQLc_ap.grt         | that grants   |          |
|    | ables/views. |                     | succeeded     |          |
+----+--------------+---------------------+---------------+----------+
| 1  | Validate     | Execute the         | Tables        |          |
| .2 | Custom Table | following query as  | created       |          |
|    | creations    | apps:               |               |          |
|    |              |                     |               |          |
|    |              | SQLc_ap.tab         |               |          |
+----+--------------+---------------------+---------------+----------+
| 1  | Validate     | Execute the         | Sequences     |          |
| .3 | Custom       | following query as  | created       |          |
|    | Sequences    | apps:               |               |          |
|    | creation     |                     |               |          |
|    |              | SQLc_ap.seq         |               |          |
+----+--------------+---------------------+---------------+----------+
| 1  | Validate     | Execute the         | Index created |          |
| .4 | temporary    | following query as  |               |          |
|    | index        | apps:               |               |          |
|    | creation     |                     |               |          |
|    |              | SQLc_ap_cre         |               |          |
|    |              | ate_tempindexes.sql |               |          |
+----+--------------+---------------------+---------------+----------+
| 1  | Validate     | From SQLplus as     | Package       |          |
| .5 | Package      | CUSTOM run the      | created       |          |
|    | creation     | following           |               |          |
|    |              |                     |               |          |
|    |              | C_ap_convert.pkg    |               |          |
+----+--------------+---------------------+---------------+----------+
| 1  | Verify       | In SQLPlus, execute | Verify No     |          |
| .6 | Receipt Data | the following SQL   | errors exist  |          |
|    | Integrity    | packages as CUSTOM: | in data by,   |          |
|    |              |                     | in SQLPLUS    |          |
|    |              | execute             | connect as    |          |
|    |              | ap_convert_rol      | CUSTOM and    |          |
|    |              | lup.verifyreceipts; | verify the    |          |
|    |              |                     | data, by      |          |
|    |              |                     | running the   |          |
|    |              |                     | following SQL |          |
|    |              |                     | statement:    |          |
|    |              |                     |               |          |
|    |              |                     | select        |          |
|    |              |                     | count(\*)     |          |
|    |              |                     | from          |          |
|    |              |                     | c_ap_errors   |          |
|    |              |                     |               |          |
|    |              |                     | The count(\*) |          |
|    |              |                     | returned      |          |
|    |              |                     | should be     |          |
|    |              |                     | zero          |          |
+----+--------------+---------------------+---------------+----------+
| 1  | Verify       | In SQLPlus, execute | Verify No     |          |
| .7 | Receipt Data | the following SQL   | errors exist  |          |
|    | loaded       | packages as CUSTOM: | in data by,   |          |
|    | successfully |                     | in SQLPLUS    |          |
|    | into AP Open | e                   | connect as    |          |
|    | Interface    | xec_ap_convert.Crea | CUSTOM and    |          |
|    |              | tereceipts(85,null) | verify the    |          |
|    |              |                     | data, by      |          |
|    |              |                     | running the   |          |
|    |              |                     | following SQL |          |
|    |              |                     | statement:    |          |
|    |              |                     |               |          |
|    |              |                     | select        |          |
|    |              |                     | count(\*)     |          |
|    |              |                     | from          |          |
|    |              |                     | c_ap_errors;  |          |
|    |              |                     |               |          |
|    |              |                     | The count(\*) |          |
|    |              |                     | returned      |          |
|    |              |                     | should be     |          |
|    |              |                     | zero          |          |
+----+--------------+---------------------+---------------+----------+
| 1  | Verify       | Under Purchasing    | Verify No     |          |
| .8 | Concurrent   | Conversion Role,    | errors exist  |          |
|    | Process      | Run "Receiving      | in data by,   |          |
|    | Receiving    | transaction         | in SQLPLUS    |          |
|    | transaction  | processor "         | connect as    |          |
|    | Processor    |                     | CUSTOM and    |          |
|    | finishes     | Check Log and       | verify the    |          |
|    | s            | Output of Request   | data, by      |          |
|    | uccessfully. | for errors          | running the   |          |
|    |              |                     | following SQL |          |
|    |              |                     | statement:    |          |
|    |              |                     |               |          |
|    |              |                     | select        |          |
|    |              |                     | count(\*)     |          |
|    |              |                     | po_int        |          |
|    |              |                     | erface_errors |          |
|    |              |                     |               |          |
|    |              |                     | The count(\*) |          |
|    |              |                     | returned      |          |
|    |              |                     | should be     |          |
|    |              |                     | zero          |          |
+----+--------------+---------------------+---------------+----------+
| 1  | Verify       | In SQLPlus, execute | Verify No     |          |
| .9 | Invoice Data | the following SQL   | errors exist  |          |
|    | Integrity    | packages as CUSTOM: | in data by,   |          |
|    |              |                     | in SQLPLUS    |          |
|    |              | execute             | connect as    |          |
|    |              | ap_convert_rol      | CUSTOM and    |          |
|    |              | lup.verifyinvoices; | verify the    |          |
|    |              |                     | data, by      |          |
|    |              |                     | running the   |          |
|    |              |                     | following SQL |          |
|    |              |                     | statement:    |          |
|    |              |                     |               |          |
|    |              |                     | select        |          |
|    |              |                     | count(\*)     |          |
|    |              |                     | from          |          |
|    |              |                     | c_ap_errors   |          |
|    |              |                     |               |          |
|    |              |                     | The count(\*) |          |
|    |              |                     | returned      |          |
|    |              |                     | should be     |          |
|    |              |                     | zero;         |          |
+----+--------------+---------------------+---------------+----------+
| 1. | Verify       | In SQLPlus, execute | Verify No     |          |
| 10 | Invoice Data | the following SQL   | errors exist  |          |
|    | loaded       | packages as CUSTOM: | in data by,   |          |
|    | successfully |                     | in SQLPLUS    |          |
|    | into AP Open | execute             | connect as    |          |
|    | Interface    | ap_c                | CUSTOM and    |          |
|    | tables.      | onvert_rollup.creat | verify the    |          |
|    |              | einvoices(83,null); | data, by      |          |
|    |              |                     | running the   |          |
|    |              |                     | following SQL |          |
|    |              |                     | statement:    |          |
|    |              |                     |               |          |
|    |              |                     | select        |          |
|    |              |                     | count(\*)     |          |
|    |              |                     | from          |          |
|    |              |                     | c_ap_errors   |          |
|    |              |                     |               |          |
|    |              |                     | The count(\*) |          |
|    |              |                     | returned      |          |
|    |              |                     | should be     |          |
|    |              |                     | zero          |          |
+----+--------------+---------------------+---------------+----------+
| 1. | Drop         | In SQLPlus, execute | In SQLPLUS as |          |
| 11 | Temporary    | the following       | Custom, run   |          |
|    | Index        | script as CUSTOM:   | Select        |          |
|    | Creation     | c_ap_d              | index_name    |          |
|    |              | rop_tempindexes.sql | from          |          |
|    |              |                     | user_indexes. |          |
|    |              |                     | The following |          |
|    |              |                     | index names   |          |
|    |              |                     | should not be |          |
|    |              |                     | displayed:    |          |
|    |              |                     |               |          |
|    |              |                     | rcv_          |          |
|    |              |                     | transactions_ |          |
|    |              |                     | interface_id2 |          |
+----+--------------+---------------------+---------------+----------+
| 1. | Assign group | In SQLPlus, execute | Procedure     |          |
| 12 | IDs to       | the following SQL   | completed     |          |
|    | import data. | as CUSTOM:          | successfully  |          |
|    | Adjust group | c_ap                |               |          |
|    | size         | _set_invgroupid.sql |               |          |
|    | depending on |                     |               |          |
|    | the number   |                     |               |          |
|    | of records.  |                     |               |          |
+----+--------------+---------------------+---------------+----------+
| 1. | Email DCT/AP | DCT/AP team would   | Should get    |          |
| 13 | team list of | confirm the AP      | the           |          |
|    | group IDs    | Import run to       | confirmation  |          |
|    | created in   | create invoices     | from DCT/AP   |          |
|    | previous     |                     | of invoice    |          |
|    | step         |                     | creation      |          |
+----+--------------+---------------------+---------------+----------+

A.7 Accounts Receivable (AR) Conversion Test Plan

+---+-------------+---------------------+-----------------+-----------+
| * | *           | **Testing Step**    | **Expected      | **Actual  |
| * | *Conversion |                     | Results**       | Results** |
| U | Step**      |                     |                 |           |
| n |             |                     |                 |           |
| i |             |                     |                 |           |
| t |             |                     |                 |           |
| T |             |                     |                 |           |
| e |             |                     |                 |           |
| s |             |                     |                 |           |
| t |             |                     |                 |           |
| i |             |                     |                 |           |
| n |             |                     |                 |           |
| g |             |                     |                 |           |
| S |             |                     |                 |           |
| t |             |                     |                 |           |
| e |             |                     |                 |           |
| p |             |                     |                 |           |
| * |             |                     |                 |           |
| * |             |                     |                 |           |
+---+-------------+---------------------+-----------------+-----------+
| 1 | Download    | Open local          | c               |           |
|   | all AR      | directory and       | _ar_convert.TAB |           |
|   | files from  | verify the files in |                 |           |
|   | PVCS        | next column are     | c               |           |
|   | Cust        | successfully        | _ar_convert.SEQ |           |
|   | omSQL\\Conv | downloaded          |                 |           |
|   | ersions\\AR |                     | c               |           |
|   | directory   |                     | _ar_convert.GRT |           |
|   | to a local  |                     |                 |           |
|   | working     |                     | c_a             |           |
|   | directory   |                     | r_crosswalk.SQL |           |
|   |             |                     |                 |           |
|   |             |                     | c_arg           |           |
|   |             |                     | l_crosswalk.SQL |           |
|   |             |                     |                 |           |
|   |             |                     | c_arg           |           |
|   |             |                     | l_crosswalk.SQL |           |
|   |             |                     |                 |           |
|   |             |                     | c_argl_sg       |           |
|   |             |                     | l_crosswalk.SQL |           |
|   |             |                     |                 |           |
|   |             |                     | c               |           |
|   |             |                     | _ar_convert.CAC |           |
|   |             |                     |                 |           |
|   |             |                     | c               |           |
|   |             |                     | _ar_convert.ALO |           |
|   |             |                     |                 |           |
|   |             |                     | c               |           |
|   |             |                     | _ar_convert.ORO |           |
|   |             |                     |                 |           |
|   |             |                     | c               |           |
|   |             |                     | _gl_extract.ALO |           |
|   |             |                     |                 |           |
|   |             |                     | c               |           |
|   |             |                     | _gl_extract.ORO |           |
|   |             |                     |                 |           |
|   |             |                     | c               |           |
|   |             |                     | _gl_extract.CAC |           |
|   |             |                     |                 |           |
|   |             |                     | c               |           |
|   |             |                     | _ar_convert.PKG |           |
|   |             |                     |                 |           |
|   |             |                     | f               |           |
|   |             |                     | lar070a_cac.DAT |           |
|   |             |                     |                 |           |
|   |             |                     | f               |           |
|   |             |                     | lar070a_alo.DAT |           |
|   |             |                     |                 |           |
|   |             |                     | f               |           |
|   |             |                     | lar070a_oro.DAT |           |
|   |             |                     |                 |           |
|   |             |                     | f               |           |
|   |             |                     | lar070b_cac.DAT |           |
|   |             |                     |                 |           |
|   |             |                     | f               |           |
|   |             |                     | lar070b_alo.DAT |           |
|   |             |                     |                 |           |
|   |             |                     | f               |           |
|   |             |                     | lar070b_oro.DAT |           |
|   |             |                     |                 |           |
|   |             |                     | ARaut           |           |
|   |             |                     | oinvoice115.SQL |           |
|   |             |                     |                 |           |
|   |             |                     | ARautoinvo      |           |
|   |             |                     | ice_readme.HTML |           |
|   |             |                     |                 |           |
|   |             |                     | AR              |           |
|   |             |                     | autoinvoice_sam |           |
|   |             |                     | ple_Output.HTML |           |
+---+-------------+---------------------+-----------------+-----------+
| 2 | Create      | Execute the         | Messages        |           |
|   | necessary   | following command   | returned in     |           |
|   | Tables,     | as custom:          | SQLplus         |           |
|   | Sequences   |                     | confirmed that  |           |
|   | and Grants  | SQL\>               | objects are     |           |
|   |             | c_ar_convert.tab    | created         |           |
|   |             |                     |                 |           |
|   |             | SQL\>               |                 |           |
|   |             | c_ar_convert.seq    |                 |           |
|   |             |                     |                 |           |
|   |             | SQL\>               |                 |           |
|   |             | c_ar_convert.grt    |                 |           |
+---+-------------+---------------------+-----------------+-----------+
| 3 | Create main | Execute the         | Package epec    |           |
|   | AR Package, | following as APPS   | and body        |           |
|   | c           |                     | created         |           |
|   | _ar_convert | SQL\>               |                 |           |
|   |             | c_ar_convert.pkg    |                 |           |
+---+-------------+---------------------+-----------------+-----------+
| 4 | Load        | From DOS prompt run | All log and bad |           |
|   | Receivables | the following       | files confirmed |           |
|   | data from   |                     | that data       |           |
|   | extract     | Sqlldr              | loaded          |           |
|   | files to    | userid=custom/\     | successfully    |           |
|   | staging     | <password\>@\<SID\> |                 |           |
|   | tables      | contr               |                 |           |
|   |             | ol=c_ar_convert.cac |                 |           |
|   |             | log=c               |                 |           |
|   |             | _ar_convert_cac.log |                 |           |
|   |             | bad=c               |                 |           |
|   |             | _ar_convert_cac.bad |                 |           |
|   |             |                     |                 |           |
|   |             | Sqlldr              |                 |           |
|   |             | userid=custom/\     |                 |           |
|   |             | <password\>@\<SID\> |                 |           |
|   |             | contr               |                 |           |
|   |             | ol=c_ar_convert.alo |                 |           |
|   |             | log=c               |                 |           |
|   |             | _ar_convert_alo.log |                 |           |
|   |             | bad=c               |                 |           |
|   |             | _ar_convert_alo.bad |                 |           |
|   |             |                     |                 |           |
|   |             | Sqlldr              |                 |           |
|   |             | userid=custom/\     |                 |           |
|   |             | <password\>@\<SID\> |                 |           |
|   |             | contr               |                 |           |
|   |             | ol=c_ar_convert.oro |                 |           |
|   |             | log=c               |                 |           |
|   |             | _ar_convert_oro.log |                 |           |
|   |             | bad=c               |                 |           |
|   |             | _ar_convert_oro.bad |                 |           |
|   |             |                     |                 |           |
|   |             | Check all log and   |                 |           |
|   |             | bad files and make  |                 |           |
|   |             | sure all records    |                 |           |
|   |             | are loaded          |                 |           |
+---+-------------+---------------------+-----------------+-----------+
| 5 | Load GL     | From DOS prompt run | All log and bad |           |
|   | Advances    | the following       | files confirmed |           |
|   | data from   |                     | that data       |           |
|   | extract     | Sqlldr              | loaded          |           |
|   | files to    | userid=custom/\     | successfully    |           |
|   | staging     | <password\>@\<SID\> |                 |           |
|   | tables      | contr               |                 |           |
|   |             | ol=c_gl_extract.cac |                 |           |
|   |             | log=c               |                 |           |
|   |             | _gl_extract_cac.log |                 |           |
|   |             | bad=c_              |                 |           |
|   |             | gl_extaract_cac.bad |                 |           |
|   |             |                     |                 |           |
|   |             | Sqlldr              |                 |           |
|   |             | userid=custom/\     |                 |           |
|   |             | <password\>@\<SID\> |                 |           |
|   |             | contr               |                 |           |
|   |             | ol=c_gl_extract.alo |                 |           |
|   |             | log=c               |                 |           |
|   |             | _gl_extract_alo.log |                 |           |
|   |             | bad=c               |                 |           |
|   |             | _gl_extract_alo.bad |                 |           |
|   |             |                     |                 |           |
|   |             | Sqlldr              |                 |           |
|   |             | userid=custom/\     |                 |           |
|   |             | <password\>@\<SID\> |                 |           |
|   |             | contr               |                 |           |
|   |             | ol=c_gl_extract.oro |                 |           |
|   |             | log=c               |                 |           |
|   |             | _gl_extract_oro.log |                 |           |
|   |             | bad=c               |                 |           |
|   |             | _gl_extract_oro.bad |                 |           |
|   |             |                     |                 |           |
|   |             | Check all log and   |                 |           |
|   |             | bad files and make  |                 |           |
|   |             | sure all records    |                 |           |
|   |             | are loaded          |                 |           |
+---+-------------+---------------------+-----------------+-----------+
| 6 | Verify all  | From SQL promt      | Create an excel |           |
|   | Oracle      | execute the         | sheet of the    |           |
|   | segment     | following           | values in       |           |
|   | exists for  |                     | c_ar            |           |
|   | all         | SQL\> exec          | _invoice_errors |           |
|   | Receivables | c_ar_con            | table and       |           |
|   | an Advances | vert.verifysegments | forward to DCT  |           |
|   | to be       |                     | to create       |           |
|   | converted   | SQL\> exec          | missing segment |           |
|   |             | c_ar_conver         | values          |           |
|   |             | t.verifyAdvsegments |                 |           |
+---+-------------+---------------------+-----------------+-----------+
| 7 | After DCT   | Truncate table      | Table           |           |
|   | has created | c_ar_invoice_errors | c_ar            |           |
|   | the missing | and repeat the      | _invoice_errors |           |
|   | segments    | steps in above      | should be empty |           |
|   | repeat the  | column              | this time       |           |
|   | step above  |                     |                 |           |
|   | to make     |                     |                 |           |
|   | sure that   |                     |                 |           |
|   | x-walked    |                     |                 |           |
|   | values are  |                     |                 |           |
|   | created     |                     |                 |           |
+---+-------------+---------------------+-----------------+-----------+
| 8 | Crosswalk   | From SQL prompt     | Semgments 1     |           |
|   | legacy      | execute the         | through 10 in   |           |
|   | segment     | following as custom | c_ar_invoices   |           |
|   | values to   |                     | table should    |           |
|   | Oracle      | SQL\                | have non-zzzzz  |           |
|   | values      | >c_ar_crosswalk.sql | values          |           |
+---+-------------+---------------------+-----------------+-----------+
| 9 | Crosswalk   | From SQL prompt     | Rec_sgl and     |           |
|   | SGL segment | execute the         | rec_sgl columns |           |
|   | values      | following as custom | in              |           |
|   | based on    |                     | c_ar_invoices   |           |
|   | BSC account | SQL\>c_a            | table should    |           |
|   | codes.      | r_agl_crosswalk.sql | have non-zzzzz  |           |
|   |             |                     | values          |           |
+---+-------------+---------------------+-----------------+-----------+
| 1 | Create      | From SQL prompt     | While the       |           |
| 0 | CCIDs for   | execute the         | process is      |           |
|   | the segment | following as custom | running the     |           |
|   | c           |                     | count in        |           |
|   | ombinations | SQL\>@c_a           | GL_C            |           |
|   |             | r_create_glccid.sql | ODE_COMBINATION |           |
|   |             |                     | table should    |           |
|   |             |                     | increase        |           |
|   |             |                     | indicating that |           |
|   |             |                     | code            |           |
|   |             |                     | combinations    |           |
|   |             |                     | are being       |           |
|   |             |                     | created         |           |
+---+-------------+---------------------+-----------------+-----------+
| 1 | Load        | From SQL prompt     | RA_INTE         |           |
| 1 | Invoices    | execute the         | RFACE_LINES_ALL |           |
|   | and Credit  | following as APPS   | table should be |           |
|   | Memos to AR |                     | loaded with     |           |
|   | Interface   | SQL\>c_             | Invoices and    |           |
|   | tables      | ar_convert.load_ar_ | Credit Memos    |           |
|   |             | invoices(\<org_id\> |                 |           |
+---+-------------+---------------------+-----------------+-----------+
| 1 | Verify that | Please see step 2.0 | Directions in   |           |
| 2 | the         | in APP153 of AR     | APP153 were     |           |
|   | Transaction | Conversion          | followed to     |           |
|   | flexfields  | document. The       | create          |           |
|   | are         | document can be     | Transaction     |           |
|   | properly    | downloaded from     | flexfields      |           |
|   | setup       | PVCS                |                 |           |
|   |             | CustomS             |                 |           |
|   |             | QL\\Conversions\\AR |                 |           |
|   |             | directory           |                 |           |
+---+-------------+---------------------+-----------------+-----------+
| 1 | Verify that | Please see step 3.0 | Directions in   |           |
| 3 | the         | in APP153 of AR     | APP153 were     |           |
|   | Autoinvoie  | Conversion          | followed to     |           |
|   | Source      | document. The       | create          |           |
|   | 'DISCAS     | document can be     | Autoinovice     |           |
|   | CONVERSION' | downloaded from     | Source called   |           |
|   | is properly | PVCS                | 'DISCAS         |           |
|   | setup       | CustomS             | CONVERSION'     |           |
|   |             | QL\\Conversions\\AR |                 |           |
|   |             | directory           |                 |           |
+---+-------------+---------------------+-----------------+-----------+
| 1 | Verify that | Please see step 4.0 | Directions in   |           |
| 4 | the         | in APP153 of AR     | APP153 were     |           |
|   | Autoinvoie  | Conversion          | followed to     |           |
|   | Source      | document. The       | create          |           |
|   | 'ADVANCES   | document can be     | Autoinovice     |           |
|   | CONVERSION' | downloaded from     | Source called   |           |
|   | is properly | PVCS                | 'ADVANCES       |           |
|   | setup       | CustomS             | CONVERSION'     |           |
|   |             | QL\\Conversions\\AR |                 |           |
|   |             | directory           |                 |           |
+---+-------------+---------------------+-----------------+-----------+
| 1 | Run         | Please see step 5.0 | Log and Output  |           |
| 5 | Autoinvoice | in APP153 of AR     | files were      |           |
|   | to load     | Conversion          | reviewed after  |           |
|   | Receivables | document. The       | the concurrent  |           |
|   | data from   | document can be     | program         |           |
|   | interface   | downloaded from     | completed.      |           |
|   | tables to   | PVCS                | Receivable      |           |
|   | Oracle      | CustomS             | transactions    |           |
|   | Receivables | QL\\Conversions\\AR | are created in  |           |
|   |             | directory           | Oracle AR from  |           |
|   |             |                     | interface       |           |
|   |             |                     | tables          |           |
+---+-------------+---------------------+-----------------+-----------+
| 1 | Close       | Please see step 6.0 | Log and Output  |           |
| 6 | converted   | in APP153 of AR     | files were      |           |
|   | Finance     | Conversion          | reviewed after  |           |
|   | Charges by  | document. The       | the concurrent  |           |
|   | creating    | document can be     | program         |           |
|   | Credit      | downloaded from     | completed.      |           |
|   | Memos       | PVCS                | Credit Memos    |           |
|   |             | CustomS             | are             |           |
|   |             | QL\\Conversions\\AR | successfully    |           |
|   |             | directory           | created to      |           |
|   |             |                     | close Finance   |           |
|   |             |                     | Charges         |           |
+---+-------------+---------------------+-----------------+-----------+
| 1 | Now process | From SQL prompt     | Segment values  |           |
| 7 | GL Advances | execute the         | are x-walked    |           |
|   | data from   | following           | since the       |           |
|   | staging     |                     | missing         |           |
|   | tables.     | SQL\>@c             | segments were   |           |
|   | Crosswalk   | _argl_crosswalk.sql | created in      |           |
|   | legacy      |                     | previous step   |           |
|   | segment     |                     |                 |           |
|   | values to   |                     |                 |           |
|   | Oracle      |                     |                 |           |
|   | values      |                     |                 |           |
+---+-------------+---------------------+-----------------+-----------+
| 1 | Crosswalk   | From SQL prompt     | SGL segments    |           |
| 8 | SGL segment | execute the         | are created.    |           |
|   | values      | following           |                 |           |
|   | based on    |                     |                 |           |
|   | BSC codes   | SQL\>@c_arg         |                 |           |
|   |             | l_sgl_crosswalk.sql |                 |           |
+---+-------------+---------------------+-----------------+-----------+
| 1 | Create      | From SQL prompt     | Code            |           |
| 9 | CCIDs for   | execute the         | Combinations    |           |
|   | segment     | following           | are created.    |           |
|   | c           |                     |                 |           |
|   | ombinations | SQL\>@c_a           |                 |           |
|   |             | r_create_glccid.sql |                 |           |
+---+-------------+---------------------+-----------------+-----------+
| 2 | Set the     | As APPS run the     | Profile Option  |           |
| 0 | profile     | following           | is setup        |           |
|   | options     |                     |                 |           |
|   |             | SQL\>exec           |                 |           |
|   |             | dbms_applic         |                 |           |
|   |             | ation_info.set_clie |                 |           |
|   |             | nt_info(\<org_id\>) |                 |           |
+---+-------------+---------------------+-----------------+-----------+
| 2 | Create      | From SQL prompt     | At completion,  |           |
| 1 | On-Account  | execute the         | the number of   |           |
|   | and         | following           | Receipts and    |           |
|   | U           |                     | to-be created   |           |
|   | nidentified | SQL\>exec           | invoices are    |           |
|   | Cash        | c_a                 | returned        |           |
|   | Receipts    | r_convert.load_gl_r |                 |           |
|   | from        | eceipts(\<org_id\>) |                 |           |
|   | C_GL_ROLLUP |                     |                 |           |
|   | table. This |                     |                 |           |
|   | step also   |                     |                 |           |
|   | loads       |                     |                 |           |
|   | invoices    |                     |                 |           |
|   | for 39xx    |                     |                 |           |
|   | debit       |                     |                 |           |
|   | balances to |                     |                 |           |
|   | AR          |                     |                 |           |
|   | Interface   |                     |                 |           |
|   | table       |                     |                 |           |
+---+-------------+---------------------+-----------------+-----------+
| 2 | Load        | Please see step 7.9 | Log and Output  |           |
| 2 | invoices    | in APP153 of AR     | files were      |           |
|   | for 39xx    | Conversion          | reviewed after  |           |
|   | debit       | document. The       | the concurrent  |           |
|   | balances    | document can be     | program         |           |
|   | from        | downloaded from     | completed.      |           |
|   | interface   | PVCS                | Receivable      |           |
|   | table to    | CustomS             | transactions    |           |
|   | Oracle AR   | QL\\Conversions\\AR | are created in  |           |
|   |             | directory           | Oracle AR from  |           |
|   |             |                     | interface       |           |
|   |             |                     | tables          |           |
+---+-------------+---------------------+-----------------+-----------+

A.8 Fixed Assets (FA) Conversion Test Plan

+---+-------------+---------------------+---+----------------+-----------+
| * | *           | **Testing Step**    |   | **Expected     | **Actual  |
| * | *Conversion |                     |   | Results**      | Results** |
| U | Step**      |                     |   |                |           |
| n |             |                     |   |                |           |
| i |             |                     |   |                |           |
| t |             |                     |   |                |           |
| T |             |                     |   |                |           |
| e |             |                     |   |                |           |
| s |             |                     |   |                |           |
| t |             |                     |   |                |           |
| i |             |                     |   |                |           |
| n |             |                     |   |                |           |
| g |             |                     |   |                |           |
| S |             |                     |   |                |           |
| t |             |                     |   |                |           |
| e |             |                     |   |                |           |
| p |             |                     |   |                |           |
| * |             |                     |   |                |           |
| * |             |                     |   |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 1 | Verify the  | Verify with the     |   | Values are the |           |
|   | values of   | functional team     |   | same, if not   |           |
|   | four        | that the following  |   | change the     |           |
|   | 'default'   | values are valid:   |   | constants in   |           |
|   | cost        |                     |   | the c_fa_conv  |           |
|   | centers,    | const_TC_costcenter |   | package.       |           |
|   | stored in   | := \'TC3I\';        |   |                |           |
|   | constants   |                     |   |                |           |
|   | at the top  | const_OH_costcenter |   |                |           |
|   | of the      | := \'OH00\';        |   |                |           |
|   | c_fa_conv   | const_OR_costcenter |   |                |           |
|   | package.    | := \'Q1AA\';        |   |                |           |
|   |             |                     |   |                |           |
|   | The values  | const_FT_costcenter |   |                |           |
|   | store a     | := \'FTDA\';        |   |                |           |
|   | default     |                     |   |                |           |
|   | cost center |                     |   |                |           |
|   | for field   |                     |   |                |           |
|   | offices TC, |                     |   |                |           |
|   | OH, OR, and |                     |   |                |           |
|   | FT, and are |                     |   |                |           |
|   | used to     |                     |   |                |           |
|   | determine   |                     |   |                |           |
|   | Reporting   |                     |   |                |           |
|   | Entity      |                     |   |                |           |
|   | value.      |                     |   |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 2 | Run         | Log into 'DOE FA    |   | Verify request |           |
|   | D           | Superuser',         |   | logs that the  |           |
|   | epreciation | navigate to Run     |   | depreciation   |           |
|   | up until    | Depreciation.       |   | completed each |           |
|   | the period  |                     |   | period         |           |
|   | before the  | Run Depreciation    |   | successfully.  |           |
|   | period we   | until the period    |   |                |           |
|   | are going   | that includes the   |   |                |           |
|   | to          | const_Sep1_dt. For  |   |                |           |
|   | implement   | example, for UAT 1, |   |                |           |
|   | in.         | const_Sep1_dt was   |   |                |           |
|   |             | 4/1/2005, so 'Run   |   |                |           |
|   |             | Depreciation'       |   |                |           |
|   |             | needed to be run    |   |                |           |
|   |             | through the March   |   |                |           |
|   |             | 2005 period. Make   |   |                |           |
|   |             | sure to 'Close      |   |                |           |
|   |             | Period' for each    |   |                |           |
|   |             | run of              |   |                |           |
|   |             | depreciation.       |   |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 3 | Ensure that | Run the following   |   | Returns        |           |
|   | the view    | query to verify:    |   | '[43']{.mark}  |           |
|   | custom.     |                     |   |                |           |
|   | c_po_source | select count(\*)    |   |                |           |
|   | _defaults_v | from                |   |                |           |
|   | exists and  | custom.c_p          |   |                |           |
|   | is          | o_source_defaults_v |   |                |           |
|   | populated   |                     |   |                |           |
|   | with data   |                     |   |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 4 | Ensure that | Run the following   |   | Returns        |           |
|   | the table   | query to verify:    |   | '[43']{.mark}  |           |
|   | custom.c_   |                     |   |                |           |
|   | load_values | select count(\*)    |   |                |           |
|   | exists and  | from                |   |                |           |
|   | is          | c                   |   |                |           |
|   | populated   | ustom.c_load_values |   |                |           |
|   | with data   |                     |   |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 5 | Download    | On your computer,   |   | All the files  |           |
|   | from PVCS   | open windows        |   | from the PVCS  |           |
|   | all of the  | explorer. Navigate  |   | directory are  |           |
|   | files in    | to c:\\temp, verify |   | in the         |           |
|   | the         | files are in the    |   | directory      |           |
|   | Cust        | directory           |   | c:\\temp:      |           |
|   | omSQL\\Conv |                     |   |                |           |
|   | ersions\\FA |                     |   | assets.alo     |           |
|   | directory.  |                     |   |                |           |
|   | Put them    |                     |   | assets.cap     |           |
|   | into a      |                     |   |                |           |
|   | working     |                     |   | assets.oro     |           |
|   | directory,  |                     |   |                |           |
|   | for example |                     |   | c_fa_conv.grt  |           |
|   | c:\\temp    |                     |   |                |           |
|   |             |                     |   | c_fa_conv.pkg  |           |
|   |             |                     |   |                |           |
|   |             |                     |   | c_fa_conv.seq  |           |
|   |             |                     |   |                |           |
|   |             |                     |   | c_fa_conv.tab  |           |
|   |             |                     |   |                |           |
|   |             |                     |   | c_fa_mi        |           |
|   |             |                     |   | ssing_segs.sql |           |
|   |             |                     |   |                |           |
|   |             |                     |   | fa_locs.ctl    |           |
|   |             |                     |   |                |           |
|   |             |                     |   | l              |           |
|   |             |                     |   | oad_assets.bat |           |
|   |             |                     |   |                |           |
|   |             |                     |   | lo             |           |
|   |             |                     |   | ad_fa_locs.bat |           |
|   |             |                     |   |                |           |
|   |             |                     |   | uat            |           |
|   |             |                     |   | _fa_errors.sql |           |
|   |             |                     |   |                |           |
|   |             |                     |   | upd_f          |           |
|   |             |                     |   | a_alloterr.sql |           |
|   |             |                     |   |                |           |
|   |             |                     |   | upd_fa_dumm    |           |
|   |             |                     |   | y_orcl_val.sql |           |
|   |             |                     |   |                |           |
|   |             |                     |   | upd_status_m   |           |
|   |             |                     |   | assadd_err.sql |           |
+---+-------------+---------------------+---+----------------+-----------+
| 6 | Run the     | Execute the         |   | All 3 tables   |           |
|   | following   | following to verify |   | were described |           |
|   | script to   | all 4 tables were   |   | verifying that |           |
|   | create the  | created:            |   | they were      |           |
|   | staging     |                     |   | created.       |           |
|   | tables      | SQL\> desc          |   |                |           |
|   |             | c_fa_stage          |   |                |           |
|   | As custom,  |                     |   |                |           |
|   | execute the | SQL\> desc          |   |                |           |
|   | following   | c_fa_locs           |   |                |           |
|   | script:     |                     |   |                |           |
|   |             | SQL\> desc          |   |                |           |
|   | SQL\>@c     | c_fa_errors         |   |                |           |
|   | :\\temp\\c_ |                     |   |                |           |
|   | fa_conv.tab |                     |   |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 7 | Run the     | Execute the         |   | Values were    |           |
|   | following   | following to verify |   | returned for   |           |
|   | script to   | 2 sequences were    |   | both calls     |           |
|   | create      | created:            |   |                |           |
|   | sequences.  |                     |   | First time     |           |
|   |             | SQL\> select        |   | run, both of   |           |
|   | As custom,  | c                   |   | these should   |           |
|   | execute the | _fa_stage_s.nextval |   | return = '1'.  |           |
|   | following   | from dual           |   |                |           |
|   | script:     |                     |   |                |           |
|   |             | SQL\> select        |   |                |           |
|   | SQL\>       | c_                  |   |                |           |
|   | @c:\\temp\\ | fa_errors_s.nextval |   |                |           |
|   | c_          | from dual           |   |                |           |
|   | fa_conv.seq |                     |   |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 8 | Run the     | Execute the         |   | '12' should be | 1.        |
|   | following   | following query as  |   | returned       |           |
|   | script to   | apps:               |   |                |           |
|   | grant       |                     |   |                |           |
|   | permissions | SQL\> select        |   |                |           |
|   | to apps for | count(\*)           |   |                |           |
|   | the custom  |                     |   |                |           |
|   | tables      | from all_tab_privs  |   |                |           |
|   |             |                     |   |                |           |
|   | As apps,    | where table_name in |   |                |           |
|   | execute the | (                   |   |                |           |
|   | following   | 'c_fa_stage','c_fa_ |   |                |           |
|   | script:     | locs','c_fa_errors' |   |                |           |
|   |             | ,'c_fa_stage_s','c_ |   |                |           |
|   | SQL\>@c     | fa_errors_s','c_po_ |   |                |           |
|   | :\\temp\\c_ | source_defaults_v') |   |                |           |
|   | fa_conv.grt |                     |   |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 9 | Run the     | Execute the         | S |                |           |
|   | following   | following query as  | h |                |           |
|   | script to   | apps:               | o |                |           |
|   | compile the |                     | u |                |           |
|   | package     | SQL\> select        | l |                |           |
|   |             | distinct(status)    | d |                |           |
|   | As apps,    |                     | r |                |           |
|   | execute the | from dba_objects    | e |                |           |
|   | following   |                     | t |                |           |
|   | script:     | where object_name = | u |                |           |
|   |             | \'C_FA_CONV'        | r |                |           |
|   | SQL\>@c     |                     | n |                |           |
|   | :\\temp\\c_ | and owner =         | a |                |           |
|   | fa_conv.pkg | \'APPS\'            | v |                |           |
|   |             |                     | a |                |           |
|   |             |                     | l |                |           |
|   |             |                     | u |                |           |
|   |             |                     | e |                |           |
|   |             |                     | o |                |           |
|   |             |                     | f |                |           |
|   |             |                     | ' |                |           |
|   |             |                     | V |                |           |
|   |             |                     | A |                |           |
|   |             |                     | L |                |           |
|   |             |                     | I |                |           |
|   |             |                     | D |                |           |
|   |             |                     | ' |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 1 | Make sure   | On your computer,   | T |                |           |
| 0 | that the    | open windows        | h |                |           |
|   | names of    | explorer. Navigate  | e |                |           |
|   | the PNE     | to                  | r |                |           |
|   | asset       | c:                  | e |                |           |
|   | extract     | \\temp\\sourcedata. | s |                |           |
|   | data files  | Verify the files.   | h |                |           |
|   | are         |                     | o |                |           |
|   | f           |                     | u |                |           |
|   | lfa292\_\<o |                     | l |                |           |
|   | rg_id\>.dat |                     | d |                |           |
|   | where       |                     | b |                |           |
|   | \<org_id\>  |                     | e |                |           |
|   | represents  |                     | 4 |                |           |
|   | the service |                     | f |                |           |
|   | center      |                     | i |                |           |
|   | (domain     |                     | l |                |           |
|   | values are  |                     | e |                |           |
|   | 'cap',      |                     | s |                |           |
|   | 'alo', or   |                     | : |                |           |
|   | 'oro') and  |                     |   |                |           |
|   | fa_locs.csv |                     | f |                |           |
|   |             |                     | l |                |           |
|   |             |                     | f |                |           |
|   |             |                     | a |                |           |
|   |             |                     | 2 |                |           |
|   |             |                     | 9 |                |           |
|   |             |                     | 2 |                |           |
|   |             |                     | _ |                |           |
|   |             |                     | a |                |           |
|   |             |                     | l |                |           |
|   |             |                     | o |                |           |
|   |             |                     | . |                |           |
|   |             |                     | d |                |           |
|   |             |                     | a |                |           |
|   |             |                     | t |                |           |
|   |             |                     |   |                |           |
|   |             |                     | f |                |           |
|   |             |                     | l |                |           |
|   |             |                     | f |                |           |
|   |             |                     | a |                |           |
|   |             |                     | 2 |                |           |
|   |             |                     | 9 |                |           |
|   |             |                     | 2 |                |           |
|   |             |                     | _ |                |           |
|   |             |                     | c |                |           |
|   |             |                     | a |                |           |
|   |             |                     | p |                |           |
|   |             |                     | . |                |           |
|   |             |                     | d |                |           |
|   |             |                     | a |                |           |
|   |             |                     | t |                |           |
|   |             |                     |   |                |           |
|   |             |                     | f |                |           |
|   |             |                     | l |                |           |
|   |             |                     | f |                |           |
|   |             |                     | a |                |           |
|   |             |                     | 2 |                |           |
|   |             |                     | 9 |                |           |
|   |             |                     | 2 |                |           |
|   |             |                     | _ |                |           |
|   |             |                     | o |                |           |
|   |             |                     | r |                |           |
|   |             |                     | o |                |           |
|   |             |                     | . |                |           |
|   |             |                     | d |                |           |
|   |             |                     | a |                |           |
|   |             |                     | t |                |           |
|   |             |                     |   |                |           |
|   |             |                     | f |                |           |
|   |             |                     | a |                |           |
|   |             |                     | _ |                |           |
|   |             |                     | l |                |           |
|   |             |                     | o |                |           |
|   |             |                     | c |                |           |
|   |             |                     | s |                |           |
|   |             |                     | . |                |           |
|   |             |                     | c |                |           |
|   |             |                     | s |                |           |
|   |             |                     | v |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 1 | Ensure that | On your computer,   | D |                |           |
| 1 | there       | open windows        | i |                |           |
|   | exists a    | explorer. Navigate  | r |                |           |
|   | 'logs'      | to c:\\temp\\logs,  | e |                |           |
|   | folder      | verify directory    | c |                |           |
|   | under the   |                     | t |                |           |
|   | working     |                     | o |                |           |
|   | directory   |                     | r |                |           |
|   | (c:\\       |                     | y |                |           |
|   | temp\\logs) |                     | e |                |           |
|   |             |                     | x |                |           |
|   |             |                     | i |                |           |
|   |             |                     | s |                |           |
|   |             |                     | t |                |           |
|   |             |                     | s |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 1 | Stage the   | Script generates a  | V |                |           |
| 2 | FA          | log file called     | e |                |           |
|   | locations   | c:\\temp            | r |                |           |
|   | data files. | \\logs\\fa_locs.log | i |                |           |
|   |             |                     | f |                |           |
|   | Run the     |                     | y |                |           |
|   | following   |                     | t |                |           |
|   | command     |                     | h |                |           |
|   | line:       |                     | a |                |           |
|   |             |                     | t |                |           |
|   | C:\\temp\>  |                     | n |                |           |
|   | load_       |                     | o |                |           |
|   | fa_locs.bat |                     | e |                |           |
|   | custom      |                     | r |                |           |
|   | \           |                     | r |                |           |
|   | <password\> |                     | o |                |           |
|   | \           |                     | r |                |           |
|   | <instance\> |                     | s |                |           |
|   | c:\\temp    |                     | o |                |           |
|   |             |                     | c |                |           |
|   |             |                     | c |                |           |
|   |             |                     | u |                |           |
|   |             |                     | r |                |           |
|   |             |                     | r |                |           |
|   |             |                     | e |                |           |
|   |             |                     | d |                |           |
|   |             |                     | w |                |           |
|   |             |                     | h |                |           |
|   |             |                     | i |                |           |
|   |             |                     | l |                |           |
|   |             |                     | e |                |           |
|   |             |                     | l |                |           |
|   |             |                     | o |                |           |
|   |             |                     | a |                |           |
|   |             |                     | d |                |           |
|   |             |                     | i |                |           |
|   |             |                     | n |                |           |
|   |             |                     | g |                |           |
|   |             |                     | t |                |           |
|   |             |                     | h |                |           |
|   |             |                     | e |                |           |
|   |             |                     | d |                |           |
|   |             |                     | a |                |           |
|   |             |                     | t |                |           |
|   |             |                     | a |                |           |
|   |             |                     | i |                |           |
|   |             |                     | n |                |           |
|   |             |                     | t |                |           |
|   |             |                     | o |                |           |
|   |             |                     | t |                |           |
|   |             |                     | h |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | t |                |           |
|   |             |                     | a |                |           |
|   |             |                     | g |                |           |
|   |             |                     | i |                |           |
|   |             |                     | n |                |           |
|   |             |                     | g |                |           |
|   |             |                     | t |                |           |
|   |             |                     | a |                |           |
|   |             |                     | b |                |           |
|   |             |                     | l |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | f |                |           |
|   |             |                     | r |                |           |
|   |             |                     | o |                |           |
|   |             |                     | m |                |           |
|   |             |                     | t |                |           |
|   |             |                     | h |                |           |
|   |             |                     | e |                |           |
|   |             |                     | l |                |           |
|   |             |                     | o |                |           |
|   |             |                     | g |                |           |
|   |             |                     | f |                |           |
|   |             |                     | i |                |           |
|   |             |                     | l |                |           |
|   |             |                     | e |                |           |
|   |             |                     |   |                |           |
|   |             |                     | N |                |           |
|   |             |                     | e |                |           |
|   |             |                     | a |                |           |
|   |             |                     | r |                |           |
|   |             |                     | t |                |           |
|   |             |                     | h |                |           |
|   |             |                     | e |                |           |
|   |             |                     | b |                |           |
|   |             |                     | o |                |           |
|   |             |                     | t |                |           |
|   |             |                     | t |                |           |
|   |             |                     | o |                |           |
|   |             |                     | m |                |           |
|   |             |                     | o |                |           |
|   |             |                     | f |                |           |
|   |             |                     | t |                |           |
|   |             |                     | h |                |           |
|   |             |                     | e |                |           |
|   |             |                     | l |                |           |
|   |             |                     | o |                |           |
|   |             |                     | g |                |           |
|   |             |                     | f |                |           |
|   |             |                     | i |                |           |
|   |             |                     | l |                |           |
|   |             |                     | e |                |           |
|   |             |                     | v |                |           |
|   |             |                     | e |                |           |
|   |             |                     | r |                |           |
|   |             |                     | i |                |           |
|   |             |                     | f |                |           |
|   |             |                     | y |                |           |
|   |             |                     | t |                |           |
|   |             |                     | h |                |           |
|   |             |                     | a |                |           |
|   |             |                     | t |                |           |
|   |             |                     | i |                |           |
|   |             |                     | t |                |           |
|   |             |                     | s |                |           |
|   |             |                     | a |                |           |
|   |             |                     | y |                |           |
|   |             |                     | s |                |           |
|   |             |                     | ' |                |           |
|   |             |                     | 0 |                |           |
|   |             |                     | r |                |           |
|   |             |                     | o |                |           |
|   |             |                     | w |                |           |
|   |             |                     | s |                |           |
|   |             |                     | n |                |           |
|   |             |                     | o |                |           |
|   |             |                     | t |                |           |
|   |             |                     | l |                |           |
|   |             |                     | o |                |           |
|   |             |                     | a |                |           |
|   |             |                     | d |                |           |
|   |             |                     | e |                |           |
|   |             |                     | d |                |           |
|   |             |                     | d |                |           |
|   |             |                     | u |                |           |
|   |             |                     | e |                |           |
|   |             |                     | t |                |           |
|   |             |                     | o |                |           |
|   |             |                     | d |                |           |
|   |             |                     | a |                |           |
|   |             |                     | t |                |           |
|   |             |                     | a |                |           |
|   |             |                     | e |                |           |
|   |             |                     | r |                |           |
|   |             |                     | r |                |           |
|   |             |                     | o |                |           |
|   |             |                     | r |                |           |
|   |             |                     | s |                |           |
|   |             |                     | ' |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 1 | Stage the   | Script generates a  | V |                |           |
| 3 | PNE asset   | log file called     | e |                |           |
|   | data files. | c:\\tem             | r |                |           |
|   |             | p\\logs\\assets\_\< | i |                |           |
|   | Run the     | org_id_suffix\>.log | f |                |           |
|   | following   |                     | y |                |           |
|   | command     |                     | t |                |           |
|   | line 3      |                     | h |                |           |
|   | times:      |                     | a |                |           |
|   |             |                     | t |                |           |
|   | C:\\temp\>  |                     | n |                |           |
|   | load_       |                     | o |                |           |
|   | assetsr.bat |                     | e |                |           |
|   | custom      |                     | r |                |           |
|   | \           |                     | r |                |           |
|   | <password\> |                     | o |                |           |
|   | \           |                     | r |                |           |
|   | <instance\> |                     | s |                |           |
|   | c:\\temp    |                     | o |                |           |
|   | \<org_      |                     | c |                |           |
|   | id_suffix\> |                     | c |                |           |
|   |             |                     | u |                |           |
|   | The         |                     | r |                |           |
|   | or          |                     | r |                |           |
|   | g_id_suffix |                     | e |                |           |
|   | is cap,     |                     | d |                |           |
|   | oro, and    |                     | w |                |           |
|   | alo.        |                     | h |                |           |
|   |             |                     | i |                |           |
|   |             |                     | l |                |           |
|   |             |                     | e |                |           |
|   |             |                     | l |                |           |
|   |             |                     | o |                |           |
|   |             |                     | a |                |           |
|   |             |                     | d |                |           |
|   |             |                     | i |                |           |
|   |             |                     | n |                |           |
|   |             |                     | g |                |           |
|   |             |                     | t |                |           |
|   |             |                     | h |                |           |
|   |             |                     | e |                |           |
|   |             |                     | d |                |           |
|   |             |                     | a |                |           |
|   |             |                     | t |                |           |
|   |             |                     | a |                |           |
|   |             |                     | i |                |           |
|   |             |                     | n |                |           |
|   |             |                     | t |                |           |
|   |             |                     | o |                |           |
|   |             |                     | t |                |           |
|   |             |                     | h |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | t |                |           |
|   |             |                     | a |                |           |
|   |             |                     | g |                |           |
|   |             |                     | i |                |           |
|   |             |                     | n |                |           |
|   |             |                     | g |                |           |
|   |             |                     | t |                |           |
|   |             |                     | a |                |           |
|   |             |                     | b |                |           |
|   |             |                     | l |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | f |                |           |
|   |             |                     | r |                |           |
|   |             |                     | o |                |           |
|   |             |                     | m |                |           |
|   |             |                     | t |                |           |
|   |             |                     | h |                |           |
|   |             |                     | e |                |           |
|   |             |                     | l |                |           |
|   |             |                     | o |                |           |
|   |             |                     | g |                |           |
|   |             |                     | f |                |           |
|   |             |                     | i |                |           |
|   |             |                     | l |                |           |
|   |             |                     | e |                |           |
|   |             |                     |   |                |           |
|   |             |                     | N |                |           |
|   |             |                     | e |                |           |
|   |             |                     | a |                |           |
|   |             |                     | r |                |           |
|   |             |                     | t |                |           |
|   |             |                     | h |                |           |
|   |             |                     | e |                |           |
|   |             |                     | b |                |           |
|   |             |                     | o |                |           |
|   |             |                     | t |                |           |
|   |             |                     | t |                |           |
|   |             |                     | o |                |           |
|   |             |                     | m |                |           |
|   |             |                     | o |                |           |
|   |             |                     | f |                |           |
|   |             |                     | t |                |           |
|   |             |                     | h |                |           |
|   |             |                     | e |                |           |
|   |             |                     | l |                |           |
|   |             |                     | o |                |           |
|   |             |                     | g |                |           |
|   |             |                     | f |                |           |
|   |             |                     | i |                |           |
|   |             |                     | l |                |           |
|   |             |                     | e |                |           |
|   |             |                     | v |                |           |
|   |             |                     | e |                |           |
|   |             |                     | r |                |           |
|   |             |                     | i |                |           |
|   |             |                     | f |                |           |
|   |             |                     | y |                |           |
|   |             |                     | t |                |           |
|   |             |                     | h |                |           |
|   |             |                     | a |                |           |
|   |             |                     | t |                |           |
|   |             |                     | i |                |           |
|   |             |                     | t |                |           |
|   |             |                     | s |                |           |
|   |             |                     | a |                |           |
|   |             |                     | y |                |           |
|   |             |                     | s |                |           |
|   |             |                     | ' |                |           |
|   |             |                     | 0 |                |           |
|   |             |                     | r |                |           |
|   |             |                     | o |                |           |
|   |             |                     | w |                |           |
|   |             |                     | s |                |           |
|   |             |                     | n |                |           |
|   |             |                     | o |                |           |
|   |             |                     | t |                |           |
|   |             |                     | l |                |           |
|   |             |                     | o |                |           |
|   |             |                     | a |                |           |
|   |             |                     | d |                |           |
|   |             |                     | e |                |           |
|   |             |                     | d |                |           |
|   |             |                     | d |                |           |
|   |             |                     | u |                |           |
|   |             |                     | e |                |           |
|   |             |                     | t |                |           |
|   |             |                     | o |                |           |
|   |             |                     | d |                |           |
|   |             |                     | a |                |           |
|   |             |                     | t |                |           |
|   |             |                     | a |                |           |
|   |             |                     | e |                |           |
|   |             |                     | r |                |           |
|   |             |                     | r |                |           |
|   |             |                     | o |                |           |
|   |             |                     | r |                |           |
|   |             |                     | s |                |           |
|   |             |                     | ' |                |           |
|   |             |                     |   |                |           |
|   |             |                     | W |                |           |
|   |             |                     | H |                |           |
|   |             |                     | E |                |           |
|   |             |                     | N |                |           |
|   |             |                     | c |                |           |
|   |             |                     | l |                |           |
|   |             |                     | a |                |           |
|   |             |                     | u |                |           |
|   |             |                     | s |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | ' |                |           |
|   |             |                     | . |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 1 | If it is    | If it is necessary  | P |                |           |
| 4 | necessary   | run the steps to    | r |                |           |
|   | to generate | the left. This will | o |                |           |
|   | dummy AFF   | create values in    | c |                |           |
|   | segment     | the crosswalk       | e |                |           |
|   | values then | table. To verify    | d |                |           |
|   | execute the | this, check the     | u |                |           |
|   | following   | c_fa_stage table to | r |                |           |
|   | sc          | see if any segment  | e |                |           |
|   | ripts/steps | information is null | c |                |           |
|   | as CUSTOM   |                     | o |                |           |
|   |             |                     | m |                |           |
|   | SQ          |                     | p |                |           |
|   | L\>@c:\\tem |                     | l |                |           |
|   | p\\upd_fa_a |                     | e |                |           |
|   | lloterr.sql |                     | t |                |           |
|   |             |                     | e |                |           |
|   | SQL\        |                     | s |                |           |
|   | >@c:\\temp\ |                     | s |                |           |
|   | \c_fa_missi |                     | u |                |           |
|   | ng_segs.sql |                     | c |                |           |
|   |             |                     | c |                |           |
|   | Logged in   |                     | e |                |           |
|   | to the      |                     | s |                |           |
|   | application |                     | s |                |           |
|   | as DOE GL   |                     | f |                |           |
|   | Superuser,  |                     | u |                |           |
|   | run the     |                     | l |                |           |
|   | request     |                     | l |                |           |
|   | Load AFF    |                     | y |                |           |
|   | Values      |                     | . |                |           |
|   | (Custom)    |                     |   |                |           |
|   | ten times,  |                     | I |                |           |
|   | once for    |                     | f |                |           |
|   | each AFF    |                     | t |                |           |
|   | segment     |                     | h |                |           |
|   | value (1    |                     | e |                |           |
|   | thru 10)    |                     | r |                |           |
|   |             |                     | e |                |           |
|   | Logged in   |                     | a |                |           |
|   | to the      |                     | r |                |           |
|   | application |                     | e |                |           |
|   | as DOE GL   |                     | v |                |           |
|   | Superuser,  |                     | a |                |           |
|   | run the     |                     | l |                |           |
|   | request     |                     | u |                |           |
|   | Load AFF    |                     | e |                |           |
|   | Mapping     |                     | s |                |           |
|   | (Custom)    |                     | m |                |           |
|   | ten times,  |                     | i |                |           |
|   | once for    |                     | s |                |           |
|   | each AFF    |                     | s |                |           |
|   | segment     |                     | i |                |           |
|   | value (1    |                     | n |                |           |
|   | thru 10)    |                     | g |                |           |
|   |             |                     | , |                |           |
|   | S           |                     | t |                |           |
|   | QL\>execute |                     | h |                |           |
|   | dbms        |                     | e |                |           |
|   | _mview.refr |                     | n |                |           |
|   | esh(\'c_aff |                     | r |                |           |
|   | _crosswalk_ |                     | u |                |           |
|   | mv\',\'C\') |                     | n |                |           |
|   |             |                     | t |                |           |
|   | SQL\>@c:    |                     | h |                |           |
|   | \\temp\\upd |                     | e |                |           |
|   | _fa_dummy_o |                     | s |                |           |
|   | rcl_val.sql |                     | t |                |           |
|   |             |                     | e |                |           |
|   |             |                     | p |                |           |
|   |             |                     | s |                |           |
|   |             |                     | t |                |           |
|   |             |                     | o |                |           |
|   |             |                     | t |                |           |
|   |             |                     | h |                |           |
|   |             |                     | e |                |           |
|   |             |                     | l |                |           |
|   |             |                     | e |                |           |
|   |             |                     | f |                |           |
|   |             |                     | t |                |           |
|   |             |                     | . |                |           |
|   |             |                     | T |                |           |
|   |             |                     | h |                |           |
|   |             |                     | e |                |           |
|   |             |                     | p |                |           |
|   |             |                     | r |                |           |
|   |             |                     | o |                |           |
|   |             |                     | c |                |           |
|   |             |                     | e |                |           |
|   |             |                     | d |                |           |
|   |             |                     | u |                |           |
|   |             |                     | r |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | s |                |           |
|   |             |                     | h |                |           |
|   |             |                     | o |                |           |
|   |             |                     | u |                |           |
|   |             |                     | l |                |           |
|   |             |                     | d |                |           |
|   |             |                     | c |                |           |
|   |             |                     | o |                |           |
|   |             |                     | m |                |           |
|   |             |                     | p |                |           |
|   |             |                     | l |                |           |
|   |             |                     | e |                |           |
|   |             |                     | t |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | u |                |           |
|   |             |                     | c |                |           |
|   |             |                     | c |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | s |                |           |
|   |             |                     | f |                |           |
|   |             |                     | u |                |           |
|   |             |                     | l |                |           |
|   |             |                     | l |                |           |
|   |             |                     | y |                |           |
|   |             |                     | . |                |           |
|   |             |                     | I |                |           |
|   |             |                     | f |                |           |
|   |             |                     | t |                |           |
|   |             |                     | h |                |           |
|   |             |                     | e |                |           |
|   |             |                     | r |                |           |
|   |             |                     | e |                |           |
|   |             |                     | i |                |           |
|   |             |                     | s |                |           |
|   |             |                     | n |                |           |
|   |             |                     | o |                |           |
|   |             |                     | n |                |           |
|   |             |                     | e |                |           |
|   |             |                     | m |                |           |
|   |             |                     | i |                |           |
|   |             |                     | s |                |           |
|   |             |                     | s |                |           |
|   |             |                     | i |                |           |
|   |             |                     | n |                |           |
|   |             |                     | g |                |           |
|   |             |                     | , |                |           |
|   |             |                     | y |                |           |
|   |             |                     | o |                |           |
|   |             |                     | u |                |           |
|   |             |                     | d |                |           |
|   |             |                     | o |                |           |
|   |             |                     | n |                |           |
|   |             |                     | ' |                |           |
|   |             |                     | t |                |           |
|   |             |                     | n |                |           |
|   |             |                     | e |                |           |
|   |             |                     | e |                |           |
|   |             |                     | d |                |           |
|   |             |                     | t |                |           |
|   |             |                     | o |                |           |
|   |             |                     | r |                |           |
|   |             |                     | u |                |           |
|   |             |                     | n |                |           |
|   |             |                     | t |                |           |
|   |             |                     | h |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | t |                |           |
|   |             |                     | e |                |           |
|   |             |                     | p |                |           |
|   |             |                     | s |                |           |
|   |             |                     | . |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 1 | Update the  | Run the procedure   | P |                |           |
| 5 | staging     |                     | r |                |           |
|   | table       |                     | o |                |           |
|   | status      |                     | c |                |           |
|   | field, and  |                     | e |                |           |
|   | append      |                     | d |                |           |
|   | Inventory   |                     | u |                |           |
|   | Org to CID  |                     | r |                |           |
|   | if          |                     | e |                |           |
|   | necessary   |                     | c |                |           |
|   |             |                     | o |                |           |
|   | SQL\>exec   |                     | m |                |           |
|   | c_fa_c      |                     | p |                |           |
|   | onv.upd_cid |                     | l |                |           |
|   | _and_status |                     | e |                |           |
|   |             |                     | t |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | s |                |           |
|   |             |                     | u |                |           |
|   |             |                     | c |                |           |
|   |             |                     | c |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | s |                |           |
|   |             |                     | f |                |           |
|   |             |                     | u |                |           |
|   |             |                     | l |                |           |
|   |             |                     | l |                |           |
|   |             |                     | y |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 1 | Rollup      | Run the procedure   | P |                |           |
| 6 | Assets by   |                     | r |                |           |
|   | CID,        |                     | o |                |           |
|   | Asset_Type, |                     | c |                |           |
|   | and         |                     | e |                |           |
|   | Allottee    |                     | d |                |           |
|   |             |                     | u |                |           |
|   | SQL\>exec   |                     | r |                |           |
|   | c_fa_co     |                     | e |                |           |
|   | nv.roll_cid |                     | c |                |           |
|   |             |                     | o |                |           |
|   |             |                     | m |                |           |
|   |             |                     | p |                |           |
|   |             |                     | l |                |           |
|   |             |                     | e |                |           |
|   |             |                     | t |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | s |                |           |
|   |             |                     | u |                |           |
|   |             |                     | c |                |           |
|   |             |                     | c |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | s |                |           |
|   |             |                     | f |                |           |
|   |             |                     | u |                |           |
|   |             |                     | l |                |           |
|   |             |                     | l |                |           |
|   |             |                     | y |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 1 | Initially   | Run the procedure   | P |                |           |
| 7 | populate    |                     | r |                |           |
|   | the         |                     | o |                |           |
|   | FA_MAS      |                     | c |                |           |
|   | S_ADDITIONS |                     | e |                |           |
|   | table       |                     | d |                |           |
|   |             |                     | u |                |           |
|   | SQL\>exec   |                     | r |                |           |
|   | c_fa_c      |                     | e |                |           |
|   | onv.cre_mas |                     | c |                |           |
|   | s_additions |                     | o |                |           |
|   |             |                     | m |                |           |
|   |             |                     | p |                |           |
|   |             |                     | l |                |           |
|   |             |                     | e |                |           |
|   |             |                     | t |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | s |                |           |
|   |             |                     | u |                |           |
|   |             |                     | c |                |           |
|   |             |                     | c |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | s |                |           |
|   |             |                     | f |                |           |
|   |             |                     | u |                |           |
|   |             |                     | l |                |           |
|   |             |                     | l |                |           |
|   |             |                     | y |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 1 | Create new  | Run the procedure   | P |                |           |
| 8 | CCID's for  |                     | r |                |           |
|   | Payables    |                     | o |                |           |
|   | and Expense |                     | c |                |           |
|   | accounts if |                     | e |                |           |
|   | the CCID    |                     | d |                |           |
|   | values were |                     | u |                |           |
|   | not         |                     | r |                |           |
|   | preexisting |                     | e |                |           |
|   | during the  |                     | c |                |           |
|   | initial     |                     | o |                |           |
|   | FA_MAS      |                     | m |                |           |
|   | S_ADDITIONS |                     | p |                |           |
|   | load        |                     | l |                |           |
|   |             |                     | e |                |           |
|   | SQL\>exec   |                     | t |                |           |
|   | c           |                     | e |                |           |
|   | _fa_conv.cr |                     | s |                |           |
|   | e_new_ccids |                     | s |                |           |
|   |             |                     | u |                |           |
|   |             |                     | c |                |           |
|   |             |                     | c |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | s |                |           |
|   |             |                     | f |                |           |
|   |             |                     | u |                |           |
|   |             |                     | l |                |           |
|   |             |                     | l |                |           |
|   |             |                     | y |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 1 | Populate    | Run the procedure   | P |                |           |
| 9 | FA_MAS      |                     | r |                |           |
|   | S_ADDITIONS |                     | o |                |           |
|   | with any    |                     | c |                |           |
|   | new CCID    |                     | e |                |           |
|   | values      |                     | d |                |           |
|   | created in  |                     | u |                |           |
|   | the         |                     | r |                |           |
|   | previous    |                     | e |                |           |
|   | step        |                     | c |                |           |
|   |             |                     | o |                |           |
|   | SQL\>exec   |                     | m |                |           |
|   | c_fa_c      |                     | p |                |           |
|   | onv.cre_mas |                     | l |                |           |
|   | s_additions |                     | e |                |           |
|   |             |                     | t |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | s |                |           |
|   |             |                     | u |                |           |
|   |             |                     | c |                |           |
|   |             |                     | c |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | s |                |           |
|   |             |                     | f |                |           |
|   |             |                     | u |                |           |
|   |             |                     | l |                |           |
|   |             |                     | l |                |           |
|   |             |                     | y |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 2 | Run Post    | Log into 'DOE FA    | V |                |           |
| 0 | Mass        | Superuser',         | e |                |           |
|   | Additions   | navigate to Mass    | r |                |           |
|   | from the    | Additions -- Post   | i |                |           |
|   | Ap          | Mass Additions.     | f |                |           |
|   | plications. |                     | y |                |           |
|   |             | Run 'Mass Additions | r |                |           |
|   | Submit      | Post' with 'DOE FA  | e |                |           |
|   | request to  | BOOK'.              | q |                |           |
|   | run the     |                     | u |                |           |
|   | 'Mass       |                     | e |                |           |
|   | Additions   |                     | s |                |           |
|   | Post'       |                     | t |                |           |
|   | program     |                     | l |                |           |
|   | (Mass       |                     | o |                |           |
|   | Additions   |                     | g |                |           |
|   | Posting     |                     | s |                |           |
|   | Report is   |                     | t |                |           |
|   | also        |                     | h |                |           |
|   | included in |                     | a |                |           |
|   | this        |                     | t |                |           |
|   | request     |                     | t |                |           |
|   | set). Enter |                     | h |                |           |
|   | 'DOE FA     |                     | e |                |           |
|   | BOOK' as    |                     | p |                |           |
|   | the input   |                     | o |                |           |
|   | parameter.  |                     | s |                |           |
|   |             |                     | t |                |           |
|   |             |                     | m |                |           |
|   |             |                     | a |                |           |
|   |             |                     | s |                |           |
|   |             |                     | s |                |           |
|   |             |                     | a |                |           |
|   |             |                     | d |                |           |
|   |             |                     | d |                |           |
|   |             |                     | i |                |           |
|   |             |                     | t |                |           |
|   |             |                     | i |                |           |
|   |             |                     | o |                |           |
|   |             |                     | n |                |           |
|   |             |                     | s |                |           |
|   |             |                     | c |                |           |
|   |             |                     | o |                |           |
|   |             |                     | m |                |           |
|   |             |                     | p |                |           |
|   |             |                     | l |                |           |
|   |             |                     | e |                |           |
|   |             |                     | t |                |           |
|   |             |                     | e |                |           |
|   |             |                     | d |                |           |
|   |             |                     | . |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 2 | When        | View the logs. If   | S |                |           |
| 1 | request is  | there are errors,   | c |                |           |
|   | finished,   | run the script to   | r |                |           |
|   | check the   | flag the errors in  | i |                |           |
|   | Request Log | the staging table.  | p |                |           |
|   | for         |                     | t |                |           |
|   | possible    |                     | c |                |           |
|   | errors that |                     | o |                |           |
|   | occurred.   |                     | m |                |           |
|   | These       |                     | p |                |           |
|   | errors will |                     | l |                |           |
|   | also be     |                     | e |                |           |
|   | indicated   |                     | t |                |           |
|   | in          |                     | e |                |           |
|   | FA_MAS      |                     | s |                |           |
|   | S_ADDITIONS |                     | s |                |           |
|   | by the      |                     | u |                |           |
|   | pos         |                     | c |                |           |
|   | ting_status |                     | c |                |           |
|   | remaining   |                     | e |                |           |
|   | as 'POST'.  |                     | s |                |           |
|   | Execute the |                     | s |                |           |
|   | following   |                     | f |                |           |
|   | script as   |                     | u |                |           |
|   | CUSTOM to   |                     | l |                |           |
|   | flag these  |                     | l |                |           |
|   | errors in   |                     | y |                |           |
|   | the staging |                     |   |                |           |
|   | table for   |                     |   |                |           |
|   | later use.  |                     |   |                |           |
|   |             |                     |   |                |           |
|   | SQL\>@c:\   |                     |   |                |           |
|   | \temp\\upd_ |                     |   |                |           |
|   | status_mass |                     |   |                |           |
|   | add_err.sql |                     |   |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 2 | Log into    | Review Assets to    | A |                |           |
| 2 | 'DOE FA     | see if they have    | s |                |           |
|   | Superuser', | been imported       | s |                |           |
|   | navigate to | correctly.          | e |                |           |
|   | Assets:     |                     | t |                |           |
|   | Asset       |                     | s |                |           |
|   | Workbench   |                     | s |                |           |
|   |             |                     | h |                |           |
|   | Query       |                     | o |                |           |
|   | assets by   |                     | u |                |           |
|   | book, enter |                     | l |                |           |
|   | 'DOE FA     |                     | d |                |           |
|   | BOOK',      |                     | b |                |           |
|   | click Find  |                     | e |                |           |
|   |             |                     | l |                |           |
|   |             |                     | o |                |           |
|   |             |                     | a |                |           |
|   |             |                     | d |                |           |
|   |             |                     | e |                |           |
|   |             |                     | d |                |           |
|   |             |                     | i |                |           |
|   |             |                     | n |                |           |
|   |             |                     | t |                |           |
|   |             |                     | o |                |           |
|   |             |                     | t |                |           |
|   |             |                     | h |                |           |
|   |             |                     | e |                |           |
|   |             |                     | s |                |           |
|   |             |                     | y |                |           |
|   |             |                     | s |                |           |
|   |             |                     | t |                |           |
|   |             |                     | e |                |           |
|   |             |                     | m |                |           |
+---+-------------+---------------------+---+----------------+-----------+
| 2 | After the   | If the end users    | A |                |           |
| 3 | initial     | decide not to load  | s |                |           |
|   | attempt to  | assets manually     | s |                |           |
|   | load all    | that fail, then the | e |                |           |
|   | assets,     | steps to the left   | t |                |           |
|   | there may   | should be followed. | s |                |           |
|   | be some     |                     | w |                |           |
|   | errors,     |                     | i |                |           |
|   | marked as   |                     | l |                |           |
|   | 'M' in the  |                     | l |                |           |
|   | staging     |                     | b |                |           |
|   | table at    |                     | e |                |           |
|   | this point. |                     | l |                |           |
|   | If the user |                     | o |                |           |
|   | wants to    |                     | a |                |           |
|   | fix the     |                     | d |                |           |
|   | errors and  |                     | e |                |           |
|   | reprocess   |                     | d |                |           |
|   | the Mass    |                     | i |                |           |
|   | Additions,  |                     | n |                |           |
|   | follow      |                     | t |                |           |
|   | these       |                     | o |                |           |
|   | steps:      |                     | t |                |           |
|   |             |                     | h |                |           |
|   | -   As      |                     | e |                |           |
|   |     APPS,   |                     | s |                |           |
|   |             |                     | y |                |           |
|   |    truncate |                     | s |                |           |
|   |     FA_MAS  |                     | t |                |           |
|   | S_ADDITIONS |                     | e |                |           |
|   |     table   |                     | m |                |           |
|   |     (ensure |                     | c |                |           |
|   |     that    |                     | o |                |           |
|   |     the     |                     | r |                |           |
|   |             |                     | r |                |           |
|   |    existing |                     | e |                |           |
|   |     data    |                     | c |                |           |
|   |     was     |                     | t |                |           |
|   |     loaded  |                     | l |                |           |
|   |     only    |                     | y |                |           |
|   |     via FA  |                     | . |                |           |
|   |             |                     |   |                |           |
|   | conversion) |                     |   |                |           |
|   |             |                     |   |                |           |
|   | -   Login   |                     |   |                |           |
|   |     to sql  |                     |   |                |           |
|   |     plus as |                     |   |                |           |
|   |     CUSTOM  |                     |   |                |           |
|   |             |                     |   |                |           |
|   | -   Correct |                     |   |                |           |
|   |     any     |                     |   |                |           |
|   |     errors  |                     |   |                |           |
|   |     in the  |                     |   |                |           |
|   |     staging |                     |   |                |           |
|   |     table   |                     |   |                |           |
|   |     records |                     |   |                |           |
|   |     marked  |                     |   |                |           |
|   |     as 'M'  |                     |   |                |           |
|   |             |                     |   |                |           |
|   | -   Update  |                     |   |                |           |
|   |     any     |                     |   |                |           |
|   |             |                     |   |                |           |
|   |   corrected |                     |   |                |           |
|   |             |                     |   |                |           |
|   |  c_fa_stage |                     |   |                |           |
|   |             |                     |   |                |           |
|   |    records, |                     |   |                |           |
|   |     set the |                     |   |                |           |
|   |             |                     |   |                |           |
|   | conv_status |                     |   |                |           |
|   |     to 'U'  |                     |   |                |           |
|   |             |                     |   |                |           |
|   |    (instead |                     |   |                |           |
|   |     of 'M') |                     |   |                |           |
|   |             |                     |   |                |           |
|   | -           |                     |   |                |           |
|   |  Repopulate |                     |   |                |           |
|   |     FA_MAS  |                     |   |                |           |
|   | S_ADDITIONS |                     |   |                |           |
|   |             |                     |   |                |           |
|   | -   Login   |                     |   |                |           |
|   |     to sql  |                     |   |                |           |
|   |     plus as |                     |   |                |           |
|   |     APPS    |                     |   |                |           |
|   |             |                     |   |                |           |
|   | -           |                     |   |                |           |
|   |   SQL\>exec |                     |   |                |           |
|   |     c_fa_c  |                     |   |                |           |
|   | onv.cre_mas |                     |   |                |           |
|   | s_additions |                     |   |                |           |
|   |             |                     |   |                |           |
|   | -   Submit  |                     |   |                |           |
|   |     Mass    |                     |   |                |           |
|   |             |                     |   |                |           |
|   |   Additions |                     |   |                |           |
|   |     Post    |                     |   |                |           |
|   |     request |                     |   |                |           |
|   |     the     |                     |   |                |           |
|   |     same as |                     |   |                |           |
|   |     above   |                     |   |                |           |
+---+-------------+---------------------+---+----------------+-----------+