1. Direct Migration to JD Edwards EnterpriseOne Guide
  2. To find the temporary tables:

To find the temporary tables:

  1. Enter the following commands:

    STRSQL

    SELECT SYSTEM_TABLE_SCHEMA, TABLE_NAME FROM SYSTABLES WHERE TABLE_NAME LIKE 'F%TCTEMP'

    DROP TABLE PRODDTA/F0101TCTEMP

    Do not drop temp tables for conversions still running.

    Drop the F00165T in the JD Edwards World Business Data library.

  2. Enter this command to clear out tables:

    CLR PFM PRODDTA/<table_name>

    Clear out these tables: F40941, F40942, F40943, F0618TA, F42140A, F42150A, F42160A, F3201, F3211, F3215, F3216, F3290.

    See the Programmers Guide for any additional instructions when rerunning Table Conversions.

  3. When the table conversion engine runs an in-place table conversion, the temporary table required for the conversion could be created and never dropped. In this case, rerunning the conversion program fails when creating the temporary table because the table already exists. To resolve this, drop or rename the temporary table before rerunning the table conversion. The naming convention for temporary tables is <table_name>tc<object_name>, for example, F03B20tcR8903B20.

  4. When the migration is complete and you are satisfied with the results, delete all SY = 89 tables from their data sources.