APP132 -- DETAILED TEST PLAN:

Conversion Test 1 - FY2004 YE STARS Conversion

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

+------------------+---------------------------------------------------+
| Deliverable ID:  | APP132 -- DETAILED TEST PLAN: Conversion Test 1 - |
|                  | FY2004 YE STARS Conversion                        |
+------------------+---------------------------------------------------+
| Version number:  | 1.0                                               |
+------------------+---------------------------------------------------+
| Draft as of:     | *05 Nov 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

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 data
    conversion of General Ledger (GL) data from DISCAS and MARS into
    STARS for the Fiscal Year ending 2004. The execution of the
    conversion is comprised of the following steps:

-   Importing the data,

-   Cross walking the data into the STARS format,

-   Importing the journals into Oracle,

-   Posting the entries, and

-   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:

1.  The data load of legacy data files into custom tables,

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

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

4.  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.

    1.  **Work Items**

        A detailed list of the test plan is attached at the end of this
        document.

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

        Entry Criteria

-   Oracle Applications GL setup

-   Legacy data files exported

-   Conversion program and ctl files created

-   STARS baseline instance available

-   Data mapping and Crosswalk tables complete

    Exit Criteria

-   Journals entered and posted in the applications

-   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 GL 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

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

    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.

        ![](media/image1.wmf)Friday, October 29, 2004

```{=html}
<!-- -->
```
-   STARS instance turned over for conversion of the instance

-   STARS apps and custom passwords given

-   Access to GL given thru the applications

    Monday October 1, 2004 -- Friday October 5, 2004

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

-   Confirm values setup is accurate and complete

    Monday, November 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 data 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

    Tuesday, November 9, 2004

-   Execute the Journal Import program

-   Change of the GL Period, and posting of the Journals in the
    applications

    Wednesday, November 10, 2004 -- Friday, November 12, 2004

-   Review Journals and obtain sign off from the DCT team

    1.  **Test Environment Requirements**

        The following are requirements of the testing environment.

-   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 and Sysadmin responsibilities.

-   If errors are discovered prior to running Oracle's standard Journal
    Import process, 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.

+---+-------------------+----------------------+--------------+------+
| * | **Conversion      | **Testing Step**     | **Expected   | **Ac |
| * | Step**            |                      | Results**    | tual |
| U |                   |                      |              | R    |
| n |                   |                      |              | esul |
| i |                   |                      |              | ts** |
| t |                   |                      |              |      |
| T |                   |                      |              |      |
| e |                   |                      |              |      |
| s |                   |                      |              |      |
| t |                   |                      |              |      |
| i |                   |                      |              |      |
| n |                   |                      |              |      |
| g |                   |                      |              |      |
| S |                   |                      |              |      |
| t |                   |                      |              |      |
| e |                   |                      |              |      |
| p |                   |                      |              |      |
| * |                   |                      |              |      |
| * |                   |                      |              |      |
+===+===================+======================+==============+======+
| 1 | Verify that view  | Execute the          | Description  |      |
| . | c_aff_crosswalk_v | following command as | of the view  |      |
| 1 | exists in the     | custom:              | is displayed |      |
| . | CUSTOM schema     |                      | to verify    |      |
| 3 |                   | SQL\> desc custom.   | that the     |      |
|   |                   | c_aff_crosswalk_v    | view was     |      |
|   |                   |                      | created.     |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Ensure that the   | Execute the          | Should       |      |
| . | package           | following query as   | return a     |      |
| 1 | apps.c_co         | apps:                | value of     |      |
| . | mmon_routines_pkg |                      | 'VALID'      |      |
| 4 | is valid          | SQL\> select         |              |      |
|   |                   | distinct(status)     |              |      |
|   |                   |                      |              |      |
|   |                   | from dba_objects     |              |      |
|   |                   |                      |              |      |
|   |                   | where object_name    |              |      |
|   |                   | like                 |              |      |
|   |                   | \'C_C                |              |      |
|   |                   | OMMON_ROUTINES_PKG\' |              |      |
|   |                   |                      |              |      |
|   |                   | and owner = \'APPS\' |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Ensure that the   | Log into the         | Re           |      |
| . | 'DOE GL           | applications, and    | sponsibility |      |
| 1 | Superuser' exists | verify that the      | is setup     |      |
| . |                   | responsibility       |              |      |
| 5 |                   | exists.              |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Ensure that the   | Log into 'DOE GL     | Period       |      |
| . | period is open in | Superuser', navigate | 'SEPADJ1-04' |      |
| 1 | the applications  | to Setup:            | is 'Open';   |      |
| . | that the          | Open/Close,          |              |      |
| 6 | conversion is     |                      | 'SEP-04' is  |      |
|   | going to occur.   | verify that the      | 'Open'       |      |
|   | Ex. SEP-04.       | conversion           |              |      |
|   |                   | period'SEP-04' and   |              |      |
|   |                   | 'SEPADJ1-04' are     |              |      |
|   |                   | Open                 |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Verify DFFs are   | Log into 'DOE GL     | All the      |      |
| . | set up in the     | Superuser', navigate | DFF's are    |      |
| 1 | instance for CID, | to Setup:            | setup and    |      |
| 7 | Asset_type,       | Financials:          | they are set |      |
|   | Asset_status,     | Flexfields:          | to optional  |      |
|   | OPI, Environment  | Descriptive:         |              |      |
|   | Liability Type,   | Segments,            |              |      |
|   | and Trading       |                      |              |      |
|   | Partner. All DFFs | Query up the 'Enter  |              |      |
|   | should be set up  | Journals: Lines'     |              |      |
|   | to be optional.   | 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    |      |
| . | criteria exists   | Superuser', navigate | records      |      |
| 1 | and is set up to  | to Setup: Journal:   | setup, and   |      |
| 8 | automatically     | Autopost,            | they are set |      |
|   | post all batches  |                      | to           |      |
|   | created by        | Query all records    | a            |      |
|   | Journal Import    |                      | utomatically |      |
|   |                   |                      | post all     |      |
|   |                   |                      | batches      |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Remove all        | Log into 'DOE GL     | Query should |      |
| . | Summary Templates | Superuser', navigate | return with  |      |
| 2 |                   | to Setup: Accounts:  | no records   |      |
|   | Log into 'DOE GL  | Summary              |              |      |
|   | Superuser',       |                      |              |      |
|   | navigate to       | Query all templates  |              |      |
|   | Setup: Accounts:  |                      |              |      |
|   | Summary           |                      |              |      |
|   |                   |                      |              |      |
|   | Query all         |                      |              |      |
|   | templates         |                      |              |      |
|   |                   |                      |              |      |
|   | Delete all        |                      |              |      |
|   | templates using   |                      |              |      |
|   | the red X         |                      |              |      |
|   |                   |                      |              |      |
|   | Save records      |                      |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Download from     | On your computer,    | All the      |      |
| . | PVCS all of the   | open windows         | files from   |      |
| 3 | files in the      | explorer. Navigate   | the PVCS     |      |
|   | CustomSQL         | to c:\\temp, verify  | directory    |      |
|   | \\Conversions\\GL | files are in the     | are in the   |      |
|   | directory. Put    | directory            | directory    |      |
|   | them into a       |                      | c:\\temp:    |      |
|   | working           |                      |              |      |
|   | directory, for    |                      | c_cre_a      |      |
|   | example c:\\temp  |                      | lo_stage.sql |      |
|   |                   |                      |              |      |
|   |                   |                      | c_cre_c      |      |
|   |                   |                      | ap_stage.sql |      |
|   |                   |                      |              |      |
|   |                   |                      | c_cre_o      |      |
|   |                   |                      | ro_stage.sql |      |
|   |                   |                      |              |      |
|   |                   |                      | c_del_       |      |
|   |                   |                      | 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_c       |      |
|   |                   |                      | onv_mars.ctl |      |
|   |                   |                      |              |      |
|   |                   |                      | c            |      |
|   |                   |                      | _upd_alo_con |      |
|   |                   |                      | v_status.sql |      |
|   |                   |                      |              |      |
|   |                   |                      | c            |      |
|   |                   |                      | _upd_cap_con |      |
|   |                   |                      | v_status.sql |      |
|   |                   |                      |              |      |
|   |                   |                      | c_           |      |
|   |                   |                      | upd_mars_con |      |
|   |                   |                      | v_status.sql |      |
|   |                   |                      |              |      |
|   |                   |                      | c            |      |
|   |                   |                      | _upd_oro_con |      |
|   |                   |                      | v_status.sql |      |
|   |                   |                      |              |      |
|   |                   |                      | determine    |      |
|   |                   |                      | _org_ids.sql |      |
|   |                   |                      |              |      |
|   |                   |                      | load_g       |      |
|   |                   |                      | l_discas.bat |      |
|   |                   |                      |              |      |
|   |                   |                      | load         |      |
|   |                   |                      | _gl_mars.bat |      |
|   |                   |                      |              |      |
|   |                   |                      | split_dis    |      |
|   |                   |                      | cas_data.bat |      |
|   |                   |                      |              |      |
|   |                   |                      | split.exe    |      |
|   |                   |                      |              |      |
|   |                   |                      | SPLIT60I.DOC |      |
|   |                   |                      |              |      |
|   |                   |                      | c_           |      |
|   |                   |                      | gl_segment_b |      |
|   |                   |                      | alancing.sql |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Ensure that there | On your computer,    | Directory    |      |
| . | exists a          | open windows         | exists       |      |
| 4 | 'sourcedata'      | explorer. Navigate   |              |      |
|   | folder under the  | to                   |              |      |
|   | working directory | c                    |              |      |
|   | (c:\\             | :\\temp\\sourcedata, |              |      |
|   | temp\\sourcedata) | verify directory     |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Ensure that there | On your computer,    | Directory    |      |
| . | exists a 'logs'   | open windows         | exists       |      |
| 5 | folder under the  | explorer. Navigate   |              |      |
|   | working directory | to c:\\temp\\logs,   |              |      |
|   | (c:\\temp\\logs)  | verify directory     |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Check to see if   | Execute the          | Table Exists |      |
| . | trading partner   | following command as |              |      |
| 7 | lookup exists     | custom:              |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | custo                |              |      |
|   |                   | m.c_trad_part_lookup |              |      |
|   |                   |                      |              |      |
|   |                   | If table exists, do  |              |      |
|   |                   | nothing.             |              |      |
|   |                   |                      |              |      |
|   |                   | If table does not    |              |      |
|   |                   | exists, refer to the |              |      |
|   |                   | Vendor Conversion    |              |      |
|   |                   | Setup document,      |              |      |
|   |                   | Appendix A           |              |      |
|   |                   |                      |              |      |
|   |                   | Follow the           |              |      |
|   |                   | instructions to      |              |      |
|   |                   | create and populate  |              |      |
|   |                   | c_trad_part_lookup   |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | In the c_gl_conv  | In the c_gl_conv     | In 'DEV',    |      |
| . | package, set the  | package, verify that | IBMBV01 user |      |
| 8 | user id of the    | the                  | id = 1314    |      |
| . | person who will   | c_g                  |              |      |
| 1 | be executing      | l_conv.const_user_id |              |      |
|   | Journal Import.   | constant is set      |              |      |
|   |                   | correctly.           |              |      |
|   | Locate the user   |                      |              |      |
|   | id in             |                      |              |      |
|   | applsys           |                      |              |      |
|   | .fnd_user.user_id |                      |              |      |
|   | and set this      |                      |              |      |
|   | value to the      |                      |              |      |
|   | constant          |                      |              |      |
|   | c_gl_c            |                      |              |      |
|   | onv.const_user_id |                      |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | In the c_gl_conv  | In the c_gl_conv     | In DEV, "DOE |      |
| . | package, set the  | package, verify that | GL           |      |
| 8 | responsibility of | the                  | Superuser"   |      |
| . | the Journal       | c_gl_conv.const_resp | re           |      |
| 2 | Import execution  | constant is set      | sponsibility |      |
|   | to that of the    | correctly            | id = 50522   |      |
|   | DOE GL Superuser. |                      |              |      |
|   |                   |                      |              |      |
|   | Locate the        |                      |              |      |
|   | responsibility id |                      |              |      |
|   | in                |                      |              |      |
|   | applsys.fnd_r     |                      |              |      |
|   | esponsibility_tl. |                      |              |      |
|   | responsibility_id |                      |              |      |
|   | and set this      |                      |              |      |
|   | value to the      |                      |              |      |
|   | constant          |                      |              |      |
|   | c_g               |                      |              |      |
|   | l_conv.const_resp |                      |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | In the c_gl_conv  | In the c_gl_conv     | In DEV, "DOE |      |
| . | package, set the  | package, verify that | GL           |      |
| 8 | application id of | the                  | Superuser"   |      |
| . | the Journal       | c_gl_                | ap           |      |
| 3 | Import execution  | conv.const_resp_appl | plication_id |      |
|   | to that of the    | constant is set      | = 101        |      |
|   | DOE GL Superuser. | correctly            |              |      |
|   |                   |                      |              |      |
|   | Locate the        |                      |              |      |
|   | responsibility id |                      |              |      |
|   | in                |                      |              |      |
|   | applsys.fn        |                      |              |      |
|   | d_responsibility_ |                      |              |      |
|   | tl.application_id |                      |              |      |
|   | and set this      |                      |              |      |
|   | value to the      |                      |              |      |
|   | constant          |                      |              |      |
|   | c_gl_con          |                      |              |      |
|   | v.const_resp_appl |                      |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Ensure that the   | Log into 'DOE GL     | Source       |      |
| . | Journal Source    | Superuser', navigate | exists       |      |
| 9 | 'Conversion       | to Setup: Journal:   |              |      |
| . | Source' is setup. | Sources              |              |      |
| 1 |                   |                      |              |      |
|   |                   | Query source of      |              |      |
|   |                   | 'Conversion Source'  |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Ensure that the   | Log into 'DOE GL     | Category     |      |
| . | Journal Category  | Superuser', navigate | exists       |      |
| 9 | 'Conversion       | to Setup: Journal:   |              |      |
| . | Category' is      | Categories           |              |      |
| 2 | setup.            |                      |              |      |
|   |                   | Query source of      |              |      |
|   |                   | 'Conversion          |              |      |
|   |                   | Category'            |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Run the following | Execute the          | All 32       |      |
| . | script to create  | following to verify  | tables were  |      |
| 1 | the staging       | all 32 tables were   | described    |      |
| 0 | tables            | created:             | verifying    |      |
|   |                   |                      | that they    |      |
|   | As custom,        | SQL\> desc           | were         |      |
|   | execute the       | c_aff_seg_defaults   | created.     |      |
|   | following script: |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   | SQL\>@c:\\te      | c_gl_errors          |              |      |
|   | mp\\c_gl_conv.tab |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_conv_suspense   |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_wcf       |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_mars      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo       |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo1      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo2      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo3      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo4      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo5      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo6      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo7      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo8      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap       |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap1      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap2      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap3      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap4      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap5      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap6      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap7      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap8      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro       |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro1      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro2      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro3      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro4      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro5      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro6      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro7      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro8      |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Run the following | Execute the          | 1 view was   |      |
| . | script to create  | following to verify  | described    |      |
| 1 | the staging view  | 1 view was created:  | verifying    |      |
| 1 |                   |                      | that that it |      |
|   | As custom,        | SQL\> desc           | was created. |      |
|   | execute the       | c_gl_stage_v         |              |      |
|   | following script: |                      |              |      |
|   |                   |                      |              |      |
|   | SQL\>@c:\\t       |                      |              |      |
|   | emp\\c_gl_conv.vw |                      |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Run the following | Execute the          | Values were  |      |
| . | script to create  | following to verify  | returned for |      |
| 1 | sequences.        | 2 sequences were     | both calls   |      |
| 2 |                   | created:             |              |      |
|   | As custom,        |                      | First time   |      |
|   | execute the       | SQL\> select         | run, both of |      |
|   | following script: | c_gl_stage_s.nextval | these should |      |
|   |                   | from dual            | return =     |      |
|   | SQL\>@c:\\te      |                      | '1'.         |      |
|   | mp\\c_gl_conv.seq | SQL\> select         |              |      |
|   |                   | c                    |              |      |
|   |                   | _gl_errors_s.nextval |              |      |
|   |                   | from dual            |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Run the following | Execute the          | '6' and      |      |
| . | script to create  | following to verify  | 'Valid'      |      |
| 1 | indexes for the   | 6 indexes were       | should be    |      |
| 3 | staging tables    | created:             | returned     |      |
|   |                   |                      |              |      |
|   | As custom,        | SQL\> select         |              |      |
|   | execute the       | count(\*), status    |              |      |
|   | following script: |                      |              |      |
|   |                   | from all_indexes     |              |      |
|   | SQL\>@c:\\te      |                      |              |      |
|   | mp\\c_gl_conv.idx | where upper(owner) = |              |      |
|   |                   | \'CUSTOM\'           |              |      |
|   |                   |                      |              |      |
|   |                   | and                  |              |      |
|   |                   | lower(index_name) in |              |      |
|   |                   |                      |              |      |
|   |                   | (\'                  |              |      |
|   |                   | c_gl_err_code_idx\', |              |      |
|   |                   |                      |              |      |
|   |                   | \'c_gl_              |              |      |
|   |                   | err_sourceval_idx\', |              |      |
|   |                   |                      |              |      |
|   |                   | \'c_gl_f             |              |      |
|   |                   | ield_offc_cap_idx\', |              |      |
|   |                   |                      |              |      |
|   |                   | \'c_gl_f             |              |      |
|   |                   | ield_offc_alo_idx\', |              |      |
|   |                   |                      |              |      |
|   |                   | \'c_gl_f             |              |      |
|   |                   | ield_offc_oro_idx\', |              |      |
|   |                   |                      |              |      |
|   |                   | \'c_gl_fi            |              |      |
|   |                   | eld_offc_mars_idx\') |              |      |
|   |                   |                      |              |      |
|   |                   | group by status      |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Run the following | Execute the          | Should       |      |
| . | script to compile | following query as   | return a     |      |
| 1 | the package       | apps:                | value of     |      |
| 5 |                   |                      | 'VALID'      |      |
|   | As apps, execute  | SQL\> select         |              |      |
|   | the following     | distinct(status)     |              |      |
|   | script:           |                      |              |      |
|   |                   | from dba_objects     |              |      |
|   | SQL\>@c:\\te      |                      |              |      |
|   | mp\\c_gl_conv.pkg | where object_name =  |              |      |
|   |                   | \'C_GL_CONV\'        |              |      |
|   |                   |                      |              |      |
|   |                   | and owner = \'APPS\' |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Run the following | Execute the          | '2' should   |      |
| . | script to grant   | following query as   | be returned  |      |
| 1 | permissions to    | apps:                |              |      |
| 6 | custom for the    |                      |              |      |
|   | package           | SQL\> select         |              |      |
|   |                   | count(\*)            |              |      |
|   | As apps, execute  |                      |              |      |
|   | the following     | from all_tab_privs   |              |      |
|   | script:           |                      |              |      |
|   |                   | where table_name =   |              |      |
|   | SQL\>@c:\\te      | \'C_GL_CONV\'        |              |      |
|   | mp\\c_gl_conv.grt |                      |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | As custom,        | Execute the          | '10' should  |      |
| . | execute the       | following query as   | be returned  |      |
| 1 | following script: | apps:                |              |      |
| 9 |                   |                      |              |      |
|   | SQL\> exec        | select count(\*)     |              |      |
|   | apps.c_gl_conv.   | from                 |              |      |
|   | load_def_flexvals | custo                |              |      |
|   |                   | m.c_aff_seg_defaults |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Make sure that    | On your computer,    | There should |      |
| . | the names of the  | open windows         | be 3 files:  |      |
| 2 | DISCAS extract    | explorer. Navigate   |              |      |
| 0 | data files are    | to                   | flg          |      |
| . | flgl08            | c                    | l082_alo.dat |      |
| 1 | 2\_\<org_id\>.dat | :\\temp\\sourcedata. |              |      |
|   | where \<org_id\>  | Verify the files.    | flg          |      |
|   | represents the    |                      | l082_cap.dat |      |
|   | service center    |                      |              |      |
|   | (domain values    |                      | flg          |      |
|   | are 'cap', 'alo', |                      | l082_oro.dat |      |
|   | or 'oro')         |                      |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Split the DISCAS  | On your computer,    | The          |      |
| . | data files into 8 | open windows         | following    |      |
| 2 | subfiles for each | explorer. Navigate   | files should |      |
| 0 | service center.   | to                   | be located   |      |
| . | This will create  | c                    | in the       |      |
| 4 | 24 subfiles,      | :\\temp\\sourcedata. | directory    |      |
| . | which will allow  | Verify that 8 new    |              |      |
| 4 | you to have the   | files were created   | flgl082_     |      |
|   | max number of cmd | with a sequence      | alo_orig.dat |      |
|   | windows(XP        | appended to them,    |              |      |
|   | limitation) open  | and the orig file    | flgl         |      |
|   | at one time to    | had the word 'orig'  | 082_alo1.dat |      |
|   | load the files    | appended.            |              |      |
|   | concurrently.     |                      | flgl         |      |
|   |                   | Also, verify that    | 082_alo2.dat |      |
|   | Determine the amt | the number of        |              |      |
|   | of rows in each   | records in each      | flgl         |      |
|   | file and divide   | extract matches the  | 082_alo3.dat |      |
|   | by 8.             | number of "total     |              |      |
|   |                   | lines processed" as  | flgl         |      |
|   | From the command  | printed out by the   | 082_alo4.dat |      |
|   | line, run each of | split.exe            |              |      |
|   | the following     | application          | flgl         |      |
|   | statements:       |                      | 082_alo5.dat |      |
|   |                   |                      |              |      |
|   | C:\\temp\>        |                      | flgl         |      |
|   | spli              |                      | 082_alo6.dat |      |
|   | t_discas_data.bat |                      |              |      |
|   | alo 300000        |                      | flgl         |      |
|   |                   |                      | 082_alo7.dat |      |
|   | C:\\temp\>        |                      |              |      |
|   | spli              |                      | flgl         |      |
|   | t_discas_data.bat |                      | 082_alo8.dat |      |
|   | cap 300000        |                      |              |      |
|   |                   |                      | flgl082_     |      |
|   | C:\\temp\>        |                      | cap_orig.dat |      |
|   | spli              |                      |              |      |
|   | t_discas_data.bat |                      | flgl         |      |
|   | oro 300000        |                      | 082_cap1.dat |      |
|   |                   |                      |              |      |
|   | The 300000 number |                      | flgl         |      |
|   | is an example. It |                      | 082_cap2.dat |      |
|   | will be whatever  |                      |              |      |
|   | number you        |                      | flgl         |      |
|   | determined above  |                      | 082_cap3.dat |      |
|   |                   |                      |              |      |
|   |                   |                      | flgl         |      |
|   |                   |                      | 082_cap4.dat |      |
|   |                   |                      |              |      |
|   |                   |                      | flgl         |      |
|   |                   |                      | 082_cap5.dat |      |
|   |                   |                      |              |      |
|   |                   |                      | flgl         |      |
|   |                   |                      | 082_cap6.dat |      |
|   |                   |                      |              |      |
|   |                   |                      | flgl         |      |
|   |                   |                      | 082_cap7.dat |      |
|   |                   |                      |              |      |
|   |                   |                      | flgl         |      |
|   |                   |                      | 082_cap8.dat |      |
|   |                   |                      |              |      |
|   |                   |                      | flgl082_     |      |
|   |                   |                      | oro_orig.dat |      |
|   |                   |                      |              |      |
|   |                   |                      | flgl         |      |
|   |                   |                      | 082_oro1.dat |      |
|   |                   |                      |              |      |
|   |                   |                      | flgl         |      |
|   |                   |                      | 082_oro2.dat |      |
|   |                   |                      |              |      |
|   |                   |                      | flgl         |      |
|   |                   |                      | 082_oro3.dat |      |
|   |                   |                      |              |      |
|   |                   |                      | flgl         |      |
|   |                   |                      | 082_oro4.dat |      |
|   |                   |                      |              |      |
|   |                   |                      | flgl         |      |
|   |                   |                      | 082_oro5.dat |      |
|   |                   |                      |              |      |
|   |                   |                      | flgl         |      |
|   |                   |                      | 082_oro6.dat |      |
|   |                   |                      |              |      |
|   |                   |                      | flgl         |      |
|   |                   |                      | 082_oro7.dat |      |
|   |                   |                      |              |      |
|   |                   |                      | flgl         |      |
|   |                   |                      | 082_oro8.dat |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Make sure that    | On your computer,    | There should |      |
| . | the name of the   | open windows         | be a file    |      |
| 2 | MARS extract data | explorer. Navigate   | called:      |      |
| 1 | file is           | to                   |              |      |
| . | flgl082_mars.dat  | c                    | flgl         |      |
| 1 |                   | :\\temp\\sourcedata. | 082_mars.dat |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Stage the MARS    | Script generates a   | Verify that  |      |
| . | data file.        | log file called      | no errors    |      |
| 2 |                   | c:\\tem              | occurred     |      |
| 2 | Run the following | p\\logs\\gl_mars.log | while        |      |
| . | command line:     |                      | loading the  |      |
| 2 |                   |                      | data into    |      |
| . | C:\\temp\>        |                      | the staging  |      |
| 6 | load_gl_mars.bat  |                      | tables from  |      |
|   | custom            |                      | the log      |      |
|   | \<password\>      |                      | file.        |      |
|   | \<instance\>      |                      |              |      |
|   | c:\\temp          |                      | Near the     |      |
|   |                   |                      | bottom of    |      |
|   |                   |                      | the log file |      |
|   |                   |                      | verify that  |      |
|   |                   |                      | it says '0   |      |
|   |                   |                      | rows not     |      |
|   |                   |                      | loaded due   |      |
|   |                   |                      | to data      |      |
|   |                   |                      | errors'      |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Stage the DISCAS  | Script generates a   | Verify that  |      |
| . | data files.       | log file called      | no errors    |      |
| 2 |                   | c                    | occurred     |      |
| 4 | Run the following | :\\temp\\logs\\gl\_\ | while        |      |
| . | command line 24   | <org_id_suffix\>.log | loading the  |      |
| 1 | times:            |                      | data into    |      |
| . |                   |                      | the staging  |      |
| 7 | C:\\temp\>        |                      | tables from  |      |
|   | l                 |                      | the log file |      |
|   | oad_gl_discas.bat |                      |              |      |
|   | custom            |                      | Near the     |      |
|   | \<password\>      |                      | bottom of    |      |
|   | \<instance\>      |                      | the log file |      |
|   | c:\\temp          |                      | verify that  |      |
|   | \<org_id_suffix\> |                      | it says '0   |      |
|   |                   |                      | rows not     |      |
|   | Example of        |                      | loaded due   |      |
|   | org_id_suffix is  |                      | to data      |      |
|   | cap2.             |                      | errors'      |      |
|   |                   |                      |              |      |
|   | It is best to     |                      |              |      |
|   | open up a         |                      |              |      |
|   | separate window   |                      |              |      |
|   | for each call and |                      |              |      |
|   | run them at the   |                      |              |      |
|   | same time         |                      |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Run the following | Run the scripts      | Scripts      |      |
| . | scripts to load   |                      | complete     |      |
| 2 | the 8 sub-file    |                      | successfully |      |
| 9 | tables into one   |                      |              |      |
|   | table for each    |                      |              |      |
|   | service center    |                      |              |      |
|   |                   |                      |              |      |
|   | c:\\temp\\c_      |                      |              |      |
|   | cre_alo_stage.sql |                      |              |      |
|   |                   |                      |              |      |
|   | c:\\temp\\c_      |                      |              |      |
|   | cre_cap_stage.sql |                      |              |      |
|   |                   |                      |              |      |
|   | c:\\temp\\c_      |                      |              |      |
|   | cre_oro_stage.sql |                      |              |      |
|   |                   |                      |              |      |
|   | Then execute the  |                      |              |      |
|   | above scripts as  |                      |              |      |
|   | custom            |                      |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Run the following | Execute the          | This returns |      |
| . | scripts to set    | following query as   | values that  |      |
| 3 | rows in the table | custom:              | are errors   |      |
| 1 | to error if any   |                      | in the       |      |
|   | of the entries    | SQL\> select         | tables       |      |
|   | have missing      | conv_status, org_id, | before       |      |
|   | segment           | count(\*)            | loading into |      |
|   | information. With |                      | the          |      |
|   | the data cleanup  | from c_gl_stage_v    | gl_interface |      |
|   | down and the      |                      | table        |      |
|   | improved mapping, | group by             |              |      |
|   | this should be 0. | conv_status, org_id  |              |      |
|   |                   |                      |              |      |
|   | As custom,        |                      |              |      |
|   | execute the       |                      |              |      |
|   | following         |                      |              |      |
|   | scripts:          |                      |              |      |
|   |                   |                      |              |      |
|   | SQL\>             |                      |              |      |
|   | \@c               |                      |              |      |
|   | :\\temp\\c_upd_al |                      |              |      |
|   | o_conv_status.sql |                      |              |      |
|   |                   |                      |              |      |
|   | SQL\>             |                      |              |      |
|   | \@c               |                      |              |      |
|   | :\\temp\\c_upd_ca |                      |              |      |
|   | p_conv_status.sql |                      |              |      |
|   |                   |                      |              |      |
|   | SQL\>             |                      |              |      |
|   | \@c               |                      |              |      |
|   | :\\temp\\c_upd_or |                      |              |      |
|   | o_conv_status.sql |                      |              |      |
|   |                   |                      |              |      |
|   | SQL\>             |                      |              |      |
|   | \@c:              |                      |              |      |
|   | \\temp\\c_upd_mar |                      |              |      |
|   | s_conv_status.sql |                      |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Create balancing  | Run the script       | Script       |      |
| . | entries for Fund  |                      | completes    |      |
| 3 | Type 51/54 to     |                      | successfully |      |
| 2 | acct 33100000 and |                      |              |      |
| . | Segment 1 and 3   |                      | Select \*    |      |
| 1 | to acct 99980000  |                      | from         |      |
|   |                   |                      | c            |      |
|   | As custom,        |                      | ustom.c_gl_c |      |
|   | execute the       |                      | onv_suspense |      |
|   | following         |                      | ;            |      |
|   | scripts:          |                      |              |      |
|   |                   |                      | This tables  |      |
|   | SQL\> c:\\temp\\  |                      | will keep a  |      |
|   | c_gl_segm         |                      | log of the   |      |
|   | ent_balancing.sql |                      | balancing    |      |
|   |                   |                      | entries that |      |
|   |                   |                      | are kept.    |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Load the          | Execute the          | These are    |      |
| . | gl_interface and  | following query as   | the records  |      |
| 3 | gl_interface      | custom:              | that didn't  |      |
| 4 | control tables.   |                      | get loaded   |      |
|   | Then submits      | SQL\> select \*      | into the     |      |
|   | Journal Import in |                      | gl_interface |      |
|   | the applications. | from c_gl_stage_v    | table.       |      |
|   |                   |                      |              |      |
|   | As custom,        | where conv_status    | Verify that  |      |
|   | execute the       | \<\> 'P'             | the 2^nd^    |      |
|   | following         |                      | query, both  |      |
|   | scripts:          | Then compare that    | lines return |      |
|   |                   | the following        | the same     |      |
|   | SQL\>exec         | numbers equal by     | value.       |      |
|   | apps.c_gl_conv.cr | running the          |              |      |
|   | eate_gl_interface | following query:     |              |      |
|   |                   |                      |              |      |
|   |                   | select "Staged",     |              |      |
|   |                   | count(\*)            |              |      |
|   |                   |                      |              |      |
|   |                   | from                 |              |      |
|   |                   | custom.c_gl_stage_v  |              |      |
|   |                   |                      |              |      |
|   |                   | where conv_status    |              |      |
|   |                   | \<\> 'P'             |              |      |
|   |                   |                      |              |      |
|   |                   | union                |              |      |
|   |                   |                      |              |      |
|   |                   | select "GL           |              |      |
|   |                   | Interface",          |              |      |
|   |                   | count(\*)            |              |      |
|   |                   |                      |              |      |
|   |                   | from gl_interface;   |              |      |
|   |                   |                      |              |      |
|   |                   | After procedure      |              |      |
|   |                   | completes, Log into  |              |      |
|   |                   | 'DOE GL Superuser',  |              |      |
|   |                   | and check the output |              |      |
|   |                   | from the Journal     |              |      |
|   |                   | import request for   |              |      |
|   |                   | errors               |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Submit Journal    | After procedure      | Sql\*Plus    |      |
| . | Import to load    | completes, Log into  | will come    |      |
| 3 | the data into the | 'DOE GL Superuser',  | back with    |      |
| 5 | applications.     | and check the output | procedure    |      |
|   |                   | from the Journal     | successful.  |      |
|   | Execute the       | import request for   | You can then |      |
|   | following to kick | errors               | login into   |      |
|   | off he import:    |                      | the          |      |
|   |                   |                      | applications |      |
|   | SQL\>exec         |                      | and see the  |      |
|   | apps.c_gl         |                      | request      |      |
|   | _conv.submit_gl_r |                      | running.     |      |
|   | eq(2,v_group_id); |                      |              |      |
|   |                   |                      |              |      |
|   | SQL \>Commit;     |                      |              |      |
|   |                   |                      |              |      |
|   | Find the group_id |                      |              |      |
|   | for ones that     |                      |              |      |
|   | need to be run by |                      |              |      |
|   | running the       |                      |              |      |
|   | following query   |                      |              |      |
|   |                   |                      |              |      |
|   | select            |                      |              |      |
|   | set_of_books_id,  |                      |              |      |
|   | group_id,         |                      |              |      |
|   | count(1)          |                      |              |      |
|   |                   |                      |              |      |
|   | from gl_interface |                      |              |      |
|   |                   |                      |              |      |
|   | group by          |                      |              |      |
|   | set_of_books_id,  |                      |              |      |
|   | group_id          |                      |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Log into 'DOE GL  | Review batches to    | Batches      |      |
| . | Superuser',       | see if they were     | should be    |      |
| 3 | navigate to       | imported             | loaded into  |      |
| 6 | Inquiry: Journal: |                      | the system   |      |
|   | Find Journals.    | Run the following    |              |      |
|   |                   | query to determine   |              |      |
|   | Query batches.    | the number of        |              |      |
|   | There should be a | batches, and lines   |              |      |
|   | view dozen (19 in | for each batch:      |              |      |
|   | CONV) batches     |                      |              |      |
|   | beginning with    | select               |              |      |
|   | the prefix        | set_of_books_id,     |              |      |
|   | 'Conversion       | group_id, count(1)   |              |      |
|   | Source'.          |                      |              |      |
|   |                   | from gl_interface    |              |      |
|   |                   |                      |              |      |
|   |                   | group by             |              |      |
|   |                   | set_of_books_id,     |              |      |
|   |                   | group_id             |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Journals need to  | This should be done  | Batches      |      |
| . | have the period   | by the functional    | should have  |      |
| 3 | changed and then  | team.                | the period   |      |
| 7 | posted.           |                      | changed to   |      |
|   |                   |                      | 'SEPADJ1-04' |      |
|   | For 2004 year end |                      | and then be  |      |
|   | data, the period  |                      | posted.      |      |
|   | needs to be       |                      |              |      |
|   | changed to        |                      |              |      |
|   | 'SEPADJ1-04'.     |                      |              |      |
|   | Then the journals |                      |              |      |
|   | need to be posted |                      |              |      |
+---+-------------------+----------------------+--------------+------+
| 1 | Once conversion   | SQL\> desc           | None of the  |      |
| . | is done and       | c_aff_seg_defaults   | tables       |      |
| 3 | signed off, Clean |                      | should       |      |
| 8 | up the custom     | SQL\> desc           | return       |      |
|   | schema by         | c_gl_errors          |              |      |
|   | deleting custom   |                      |              |      |
|   | conversion tables | SQL\> desc           |              |      |
|   |                   | c_g                  |              |      |
|   | As custom,        | l_conv_5154_suspense |              |      |
|   | execute the       |                      |              |      |
|   | following         | SQL\> desc           |              |      |
|   | scripts:          | c_gl_stage_wcf       |              |      |
|   |                   |                      |              |      |
|   | SQL\>@c:\\temp\\  | SQL\> desc           |              |      |
|   | c_del_g_stage.sql | c_gl_stage_mars      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo       |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo1      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo2      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo3      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo4      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo5      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo6      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo7      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_alo8      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap       |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap1      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap2      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap3      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap4      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap5      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap6      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap7      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_cap8      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro       |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro1      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro2      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro3      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro4      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro5      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro6      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro7      |              |      |
|   |                   |                      |              |      |
|   |                   | SQL\> desc           |              |      |
|   |                   | c_gl_stage_oro8      |              |      |
+---+-------------------+----------------------+--------------+------+