Upgrading from 8.10 or Below
This section contains a list of all the Table Conversions required when upgrading from 8.10 or below.
Upgrading from 8.10 or Below |
||||
|---|---|---|---|---|
Conversion Program |
Run this Job |
Requirements |
Purpose |
Notes |
R8901151 |
To move Email Address from F0111 to F01151 when upgrading from 8.10 or below. |
Four pocessing Options exist for this conversion: 1 - Run in Proof or Final Mode. 2 - Do you want to reset the remark field in F0101 to blank or not. 3 - Enter the default value of the Email Hierarchy field. 4 - Process all records or only records with an associated User ID. |
This conversion moves Email addresses from the Who's Who table (F0111) to the Electronic Address table (F01151). If this is not run, Email addresses will not be accessible. |
The UBE prints out a pdf listing the records processed and displays how the F01151 columns were updated. |
R891755B |
To convert F1755 for Case when upgrading from 8.10 or below. |
Three Processing Options exist for this TC: 1 - Enter the time zone of the system date and time. 2 - Enter the daylight savings rule of the system date and time. 3 - Do you want to update the work order table with the case number of the record being converted? "0" - Do Not Update. "1" Update. |
To convert the existing dates and times in F1755 to UTC time. To blank out the work order number in F1755 and to populate case number in F4801. |
|
R3210CFGID |
To convert Config ID when upgrading from 8.10 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. |
R01302 |
To convert F0101 Compressed Description when upgrading from 8.10 or below. |
Run this UBE when UDC H95|SC has changed. The values shipped with the software are: ~!@#^&*()_+`-={}|[]\:";'<>?,.\ |
This UBE strips off special characters from the DC field in F0101 as a result of changing the UDC H95|SC (Word Search Special Characters). |
If the UDC H95|SC values are changed and an address book record is added, this will cause inconsistencies in the DC fields. An example of this would be the blank value. If blank is part of the list, the "Digger Corporation" will be stripped to be "DIGGERCORPORATION" in the DC field else it would be "DIGGER CORPORATION". |
R890911CA |
To populate F0911 Foreign Amount when upgrading from 8.10 or below. |
Run after the table conversions have completed. |
A new foreign amount field (GLACR) is added to the AccountLedger table. The TC will populate the new foreign amount field based on the existing CA ledger records. |
A new foreign amount field (GLACR) is added to the Account Ledger table so all of the currency information is available in one F0911 record and the extra CA record is no longer needed. The system continues to write the CA ledger records during this first phase. |
R890911PCA |
To populate F0911P Foreign Amount when upgrading from 8.10 or below. |
Run after the table conversions have completed. |
A new foreign amount field (GLACR) is added to the Account Ledger Purge table. The TC will populate the new foreign amount field based on the existing CA ledger records. |
A new foreign amount field (GLACR) is added to the Account Ledger Purge table so all of the currency information is available in one F0911 record and the extra CA record is no longer needed. The system continues to write the CA ledger records during this first phase. |
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:
|