Convert F00165 from World to Oneworld (8.11) ??

JDE kid

Active Member
I need to convert the data from the F00165 from World (A73) to Oneworld (Apps Rel 8.11, tols rel 8.96). One of the problems that I am facing

I have never done a conversion from World to Oneworld so don't have a direction at all from where to start. I would appreciate if someone who has done this could share the process step by step.

Thanks in anticipation!!

Regards,
JDE Kid :)
JDE Technical Consultant|Apps Rel 8.11|Tools Rel 8.96|SQL Server 2005|Worldsoft A73|Win 2K
 
There are Direct Migration patches you can apply to the A73 install and some reports you can run in 8.11 that will validate some of the control data (in A73) and create tables (in both) for transferring the data. The only docs I have on hand are the 8.12 direct migration stuff, but take a look on the Customer Connection (peoplesoft.com) site and see what you can find.

I will be starting a A73 to 8.12, TR 8.96.F1 here in the next week or so I will keep you in the loop on anything I find.

In any case I have attache the A73 to 8.12 doc.
 
We recently went live on E811 from world. Our conversion path was from AS400 to SQL so we had to use custom methods from migration.
F00165 E1 table has to be populated from F00163 and F0016 files from world.Best approach would be to build custom files on E1 with the same fields and copy F0016 and F00163 from world. F4314 world file contains the SO and PO attachments. Based on the order type you can build GT4301, GT4201A, GT4311, and GT4211A.
F0016 and F00163 are related by SERK field.
WAPP world field needs to be mapped to OBNM on E1.
Example: *VOUCHER GT0411S
If there are more WAPP's you need to map the same
In E1 for the Generic text key each component will be separated by a pipeline(|). Build key for TXKY field.
Use B90CA892 to write to F00165 E1 file.
F0016 all the line text (WTXT) has to be concatenated for every unique SERK combination with respect to F00163.

Function To Migrate Long Text To Media Object
SL StartTime -> BF EnteredDateTime
SL StartTime -> BF ModifiedDateTime
VA rpt_TXVC -> BF NOTESTXT
VA rpt_OBNM -> BF szNameObject
VA rpt_TXKY-> BF GenericTextKey

TXVC-GenericText From World
OBNM-GTXXXX
TXKY - Key build for the GT

If you have any more questions let me know.
 
F0016 and F00163 are related by SERK. Based on the join you have once you know the application type (WAPP) you can parse the key field. Use the BSFN to load the values into F00165.
 
I am trying to identify where GT03B11 records are in WORLD. I cannot find them in F00165. I believe those can be in F00163/F0016. So, I need to know how many tables are there in WORLD related to media objects and if I am missing any tables. Also, how are these tables linked. There is no link between F00165 to F0016/F00163.
 
Back
Top