on 10-28-2016 2:33 PM
I was migrating one data source (data source for master data attribute) from 3.x to 7.x.
But the data source got inactive giving the error "Field_1 :Missing currency field / unit field FIXCUKY".
Can anyone help me .
Hi Ipsita,
You need to add some conditional logic in your transformation rules to populate the amount fields.
If CURRENCY = USD then KF1 = AMOUNT else KF1 = 0
If CURRENCY = EUR then KF2 = AMOUNT else KF2 = 0
If CURRENCY = GBP then KF3 = AMOUNT else KF3 = 0
Don't forget to record your final solution.
John Hawk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ipsita,
Review the key figure InfoObjects which contain FIXCUKY.
It appears that one or more require a fixed currency, but none has been defined in the InfoObject.
John Hawk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What info objects you used for your fields(2,3 and 4) at data source level?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
previous data source is working well at production???
previous data source is active at your present system and worked well?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
as per your screen shot, You have fields and curr/unit but no info objects which need to hold amount value along with currency and hence you are getting above error.
so please assign required info objects for amounts and check it.
The error is showing in the production??
What does it mean, have you transported your migrated data source to production? or your migrating to 7.x directly at production system??
Thanks
Hello Raman,
No my changes are not moved.
In production it is still in 3.x and when I clicked on check button of the data source the same error is showing in production but data is loading perfectly in production.
Info-Objects are also there I have hided that in my previous screenshot.
Find the attached screenshot.
Thanks,
Ipsita
Hi ipsita,
Thank you for clarification.
please try to do below suggestion at dev system.
i assumed as your 3 assigned info objects are amount related and assigned fixed currency at info object maintenance level. if yes then please remove FIXCUKY object from under curr/unit column. save and activate your data source. later test your data source functionality and see. whether it pulls data same as previous data source or not. if it pulls same as old data source then just continue to go ahead.
Thanks
Hello Raman,
I have deleted FIXCUKY but getting the same error message.
But when I am changing data type of these 3 info-objects from "CURR" to "CUKY",it is deleting the "FIXCUKY" from cur/unit column automatically showing the message "FIXCUKY is obsolete type " and working fine.
But we can not change the data type of the Info-Objects as we need to migrate it only.
Hi,
As per your data source, which info objects are you assigned to your field,3 and 4 records?
Am unable to see assign info objects at your screen.
Actually when we create amount or quantity info objects at RSA1, we assign related currency/units field there itself(Tab type/unit).
So at data source curr/unit column - you don't need to enter any objects there.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
please share your data source fields screen shot.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Can you let me know which is the datasource you are trying to migrate.
Regards
Gajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can anyone help me on this issue....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Seems like one currency/unit field was inactive or not part of your data source. please activate or add required field and later you can migrate Your data source to 7.x.
please check your 3.x data source have Amount/Quantity objects along currency/units objects.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Raman,
I have checked the info Objects assigned to the fields are active.
But the info object's cur/unit column is FIXCUKY. Is there any table to check FIXCUKY??
Please see the screenshot.
data are like that:
Field Description Data Type Length Format Cur/Unit
Field1 Desc1 CHAR 18 xternal
Field 2 Desc2 CURR 17 External FIXCUKY
Field 3 Desc3 CURR 17 External FIXCUKY
Thanks,
Ipsita.
User | Count |
---|---|
67 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.