JD Edwards EnterpriseOne Tools Release 9.2 Table Conversions
Sequence/ Dependency |
TC Input |
TCF/TC Version |
Inputs/ Outputs |
Run this Job |
Requirements |
Purpose |
Notes |
|---|---|---|---|---|---|---|---|
45/ 0 |
F98950 |
R89952450A XJDE0001 |
F98950 F952450 |
To convert Cafe1 data in F98950 (UOTY = 'RI' andSEQ = '4') when upgrading from 9.1. |
None |
Converts old Cafe1 objects, inserts records to F98950T, creates XML Document BLOB to update F952450 from F98950, F952330, F952331 and F952334. Populates Object Librarian records in F9860W and F9861W. |
Writes all the language data into F952450, which will be converted and deleted later. |
46/ 45 |
F952334 |
R89952450C XJDE0001 |
F952334 F952450 |
To convert Related Application Information Framework (RAIF) content when upgrading from 9.1. |
R89952450A |
Converts RAIF content, creates the XML Document BLOB to update F952450 from F952330, F952331 andF952334. Populates Object Librarian records in F9860W and F9861W. |
None |
47/ 0 |
F952430 |
R89952430 XJDE0001 |
F98950 F952430 |
To convert Query (AQ) data in F98950 (UOTY ='AQ' andIDLST!='1') when upgrading from 9.1. |
None |
Convert query data to F952430 and write AQ information to F98950T. Populates Object Librarian records in F9860W and F9861W. |
None |
47/ 0 |
F952440 |
R89952440 XJDE0001 |
F98950 F952440 |
To convert Grid Format (GF) data in F98950 (UOTY='GD')when upgrading from 9.1. |
None |
Retrieves Grid Tab Name from BLOB, write Grid Format Record to F952440, and populates Object Librarian records in F9860W and F9861W. |
None |
48/ 47 |
F952440 |
R89952440B XJDE0001 |
F952440 F9860WD |
To convert Grid Format (GF) language data in F952440 (WOFU1='L') whenupgrading from 9.1. |
R89952440 |
Convert GF language data to F9860WD, and delete language data in F952440 after TC. |
None |
48/ 47 |
F952440 |
R89952440A XJDE0001 |
F98950 F9860WD |
To convert Grid Format (GF) data in F98950 (UOTY='GD'and USER='*PUBLIC') when upgrading from 9.1. |
R89952440 |
Fetches GF language data from F98950D and populates GF data in F9860WD. |
None |
49/ 0 |
F952400 |
R89952400 XJDE0001 |
F952400 F952400 |
In-place convert for OneView Report (OVR) and E1Page (E1P) when upgrading from 9.1. |
None |
Converts old OVR and E1P objects to new format of F952400. Populates Object Librarian records in F9860W and F9861W. |
Writes the E1P language data into F952400, which will be converted and deleted later. There is no language data for OVR. |
49/ 47 |
F952420 |
R89952420 XJDE0001 |
F952420 F952420 |
In-place convert for Watchlist when upgrading from 9.1. |
R89952430 |
Converts old Watchlist objects to new format of F952420. Populates Object Librarian records in F9860W and F9861W. |
Retrieves Advanced Query Object ID (AQOID) from F98950T. |
49/ 47 |
F952430 |
R89952430L XJDE0001 |
F98950 F9860WD |
To convert Query (AQ) language data in F98950 (UOTY ='AQ' and IDLST!='1')when upgrading from 9.1. |
R89952430 |
Fetches language data from F98950D and F98950T. Populates AQ language data in F9860WD. |
None |
50/ 49 |
F952400 |
R89952400O XJDE0001 |
F952400 F952400 |
To delete extra OneView Report (OVR) data after TC R89952400 |
R89952400 |
Deletes the extra OVR checkout record if the reserved user is equal to the UGCOWNER in F952400. |
None |
50/ 49 |
F952400 |
R89952400L XJDE0001 |
F952400 F9860WD |
To convert E1Page (E1P) language data in F952400 (LNGP>Blank) when upgrading from 9.1. |
R89952400 |
Converts E1P language data to F9860WD, and deletes language data in F952400 after TC. |
None |
50/ 45 |
F98950 |
R89952450B XJDE0001 |
F98950 F952460 |
To convert Cafe2 data in F98950 (UOTY="RI") when upgrading from 9.1 |
R89952450A |
To fetch the WOBNM data from F98950D and insert to F9860WD. |
None |
51/ 50 |
F9312 |
R9312TC XJDE0001 |
F9312 F9312 |
F9312 Table Primary Unique Key index has changed. |
This table conversion must run prior to any other security table conversion. |
||
52/ 51 |
F00950W |
R00950WF XJDE0001 |
F00950W F00950W |
1. F00950W Table columns and index changes 2. User with Action Security of Share automatically has Modify Security set. |
This table conversion must be run prior to any other security table conversion. |
||
53/ 52 |
F00950 |
R00950WTE XJDE0001 |
F00950 F00950W |
Select on SECTY security type value equals H |
1. Create View Security. 2. Automatically create *PUBLIC for Create Action Security. |
||
53/ 52 |
F98950 |
R00950WTD XJDE0001 |
F958974 F00950W |
Select on TAREC feature type value equals 3 |
1. Create Action Security based on authorization definition. 2. Create View Security based on authorization. |
1. Web Enable has to be turned on for Environment. 2. The environment has to be in the same path code as the source environment. |
|
53/ 52 |
F98950 |
R00950WTA XJDE0001 |
F98950 F00950W |
Select UO data type value equals GF |
1. TF00950W Table columns and index changes. 2. User with Action Security of Share automatically has modify security set. |
None |
|
53/ 52 |
F98950 |
R00950WTB XJDE0001 |
F98950 F00950W |
Select UO data type value equals AQ and Sequence value equals 4 |
1. The View Security records are written for value *PUBLIC and E1 Role for specific application andform. 2. Action Security is created automatically with *PUBLIC and Create only actions. |
None |
|
53/ 52 |
F98950 |
R00950WTC XJDE0001 |
F98950 F00950W |
Select UO data type value equals RI |
1. The View Security records are written for *PUBLIC and E1 Role for specific applications and forms. |
None |
|
53/ 52 |
F98950 |
R00950WTG XJDE0001 |
F952332 F00950W |
1. Create Action Security based on authorization definition. 2. Create View Security based on authorization. |
1. Web Enable has to be turned on for Environment. 2. The environment has to be in the same path code as the source environment. |
||
54/ 53 |
F9000 |
R9000OVR XJDE0001 |
F9000 F9000 |
1. A non-task type of 23, the records are directly copied. 2. For task type 23, the One View report ID is changed to UDO generated ID. 3. For task type 23, the query ID is changed to UDO generated ID. |
. |