User login
Sponsored links
Recent blog posts
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
- Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?
- Difference between Custom and Customised objects in Peoplesoft?
You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.
Peoplesoft DataConversion
Fri, 12/04/2009 - 7:52am
Hi All,
We are implementing the DataConversion Process for ePerformance 8.9 to 9.0.Im new for this implementation. Now Im struck at an instance.We have data in a table T1 with 90 rows in 8.9 and 160 rows in 9.0.And the problem is that some rows with key fields are carrying different data in both the databases for the same key fields.
In 8.9:
key:a1
col1:120
col2:130
In 9.0
key:a1
col1:124
col2:130
Can anyone help me how to move this data to the upgraded database with out loss of data..
Thanks,
Ashok K.
Bookmark/Search this post with
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| MD5 - SHA checksum of a file. | PeopleSoft Technical | 02/07/2012 - 5:29am |
| nVision Tabular Report through PIA with prompts | PeopleSoft Technical | 02/02/2012 - 10:07pm |
| Can we create an AE to mass update Position - Jobcode data? | PeopleSoft Technical | 01/18/2012 - 3:11am |
| Pay Components on job data can be defaulted and setup based on the rules? | PeopleSoft Functional | 01/05/2012 - 4:58am |
Hi Ashok,
If your database is on oracle then give a try to this,
1. Disable the constraint on your table .
2. Run your script to load the data.
3. Enable the constraint with novalidate option.
I hope this must help you.
Please let me know whether it works for you or not.
Regards,
Rahul Khandelwal
That is some trick rahul - Thanks for sharing this with us!
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
Hi Rahul,
Its great of you..It worked..Thanks a lot for your help Rahul..
Thanks,
Ashok K.
Post new comment