Upgrading from 8.9 or Below
This section contains a list of all the Table Conversions required when upgrading from 8.9 or below.
Upgrading from 8.9 or Below |
||||
|---|---|---|---|---|
Conversion Program |
Run this Job |
Requirements |
Purpose |
Notes |
R48803 |
Convert Document Type for existing orders by running the post install JD Edwards EnterpriseOne UBE R48803. |
Review who should run the UBE, requirements of the UBE, and the purpose of this UBE. |
Not applicable. |
This is not a Table conversion for converting data from prior release. This is a post install UBE that needs to be run one time to convert Order Types for existing records. This conversion is necessary because of changes made to Document Types, based on EPM requirements. The new document type is defined in the processing options. For the orders selected in the data selection, the document type is converted. |
R891207B |
To update PDFG in F1207 when upgrading from 8.9 or below. |
The TC should be run over the entire F1207 table. |
This post-install job reads through existing maintenance schedules in the F1207 and updates the schedule type (PDFG) field with a "1" for those schedules that have no service intervals defined. |
As part of the Condition-Based Maintenance enhancement, the schedule type (PDFG) field is now utilized on the Equipment PM Schedule (F1207) record to identify the type of maintenance. A value of blanks is for Interval Based Maintenance. A value of "1" is for Unschedule Maintenance. A value of "2" is for Condition-Based Maintenance. |
R8912071B |
To update PDFG in F12071 when upgrading from 8.9 or below. |
The TC should be run over the entire F12071 table. |
This post-install job reads through existing model maintenance schedules in the F12071 and updates the schedule type (PDFG) field with a "1" for those schedules that have no service intervals defined. |
As part of the Condition-Based Maintenance enhancement, the schedule type (PDFG) field is now utilized on the Equipment PM Schedule Model (F12071) record to identify the type of maintenance. A value of blank is for Interval Based Maintenance. A value of "1" is for Unscheduled Maintenance. A value of "2" is for Condition-Based Maintenance. |
R3210CFGID |
To convert Config ID when upgrading from 8.9 or below. |
None. |
This UBE determines the highest seed from F3201 and writes it to Bucket 2 of Next Numbers System 32. |
The Configuration ID (which is the primary key field of Configurator F3201 Master File) will now be retrieved from Next Number instead of using the "seed" record in F3201 Configurator Master Table. |
R8931CTSX |
To convert CTS1, CTS2, CTS3, and CTS9 (collectively referred to as CTSx) data item values from 2 display decimals to match the display decimals of the TRQT data item (4 decimals). |
You must run this program to increase the decimal precision of the CTSx data items if you use these data items to store unaccounted units. |
The R8931CTSX table conversion program retrieves the TRQT data dictionary display decimals and converts the values of the CTSx data items in all affected tables to match the TRQT display decimals. The R8931CTSX program calls the Data Decimal Conversion business function (B8900010) for each CTSx data item. The UBE locates all tables containing the data item and selects non-zero values for conversion. The program converts the CTSx value and updates the table. |
The default setting of the CTSx data items to 2 display decimals may cause rounding discrepancies. Therefore, Oracle recommends that you run this table conversion program to increase the decimal precision of the CTSx data items. After running the R8931CTSX program, change the display decimal setting of the CTSx data items in the E920 data dictionary to 4 to match the display decimal setting of the TRQT data item. For more information, refer to the Data Conversion Updates for Decimal Precision of Unaccounted Units document (2438553.1) on My Oracle Support:
|