I'm trying to update the descriptors on segment ID 5 using DTW and the OASC template but getting the error record already exists. Just wondering is it possible to update the OASC table using the template or is it just used for creation and additions?
Thanks for your reply. The DTW doesn't seem to allow AbsID to be define in the upload, the file I'm using has the following headers, SegmentID; Code; Name; Shortname.
I've updated one database with the correct information including additions & admendments and ran the query in OASC to obtain the correct data and populate the above file i.e. SegmentID, Code etc.. and this is where I ran into the problem previously. I have another 35 DBs to update.
Is there another file template that I should be using?
Segment ID I think refers to which segment (1,2 or 3 etc) and the code is the unique segment code (or vice versa). eg if your gl account is 123-456-789, the last 3 will be segment 3.
Then run as update existing data. The name & shortname can be changed, but not the ID or code
Within Segment 5, I have 90+ codes and it's the descriptors on these that I have been trying to change using the SAP OASC Template. So for example, the initial entry on the template was 5,001,Accountancy,AAAA the new entry is revised to 5,001,Accountancy & Finance,AAAA. Using the update facility within DTW returns the error that the record already exists.
Which is true, 5,001 does exist but obviously the DTW does not seem to allow updates to the descriptor or "Name" of the segment.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.