This content has been marked as final. Show 4 replies
See : "What information will convert from Product Management to P3? [ID 892486.1]"
Excerpt from the above:
P3 only supports 10 characters for the activity codes, the converter will f irst truncate the first 10 characters from the Product Management activity codes being converted.
It will then take the maximum amount of activity codes that can be converted equaling 64 characters total.
This doesn't have anything to do with re-ordering of activity codes.
I created my codes with the proper amount of characters and lengths in P6, when converting to P3, the codes and their respective character lengths held, they just got jumbled up.
IE: in P6 I have:
Act Code Char Length
FOW 2 10
in P3 it becomes:
I need the P3 file to maintain the same order of Activity Codes I have in P6. WRKP must be first, followed by RESP, etc.
hmmm... not sure what is causing this. It could be ordering by the primary key on the P6 table.
Assumming you have access to the P6 database try taking a look at the ACTVTYPE table and check if the P3 order matches the sequential order of ACTVTYPE.ACTV_CODE_TYPE_ID.
Without knowing the detail of your data structure it's hard for me to write an exact SQL query to extract this data but you can try the below:
SELECT actv_code_type_id, actv_code_type
WHERE actv_code_type IN ('WRKP','RESP','AREA','MODF','BIDI','PHAS','CATW','FOW1','FOW2','FOW3');