$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content

Data source Migration Issue

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 .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • Nov 01, 2016 at 01:44 PM

    Hi,

    Can you let me know which is the datasource you are trying to migrate.

    Regards

    Gajesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 31, 2016 at 09:40 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • Nov 01, 2016 at 09:43 AM

    Can anyone help me on this issue....

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2016 at 02:51 PM

    Hi,

    please share your data source fields screen shot.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2016 at 09:07 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • hello Raman,

      I was just migrating the data source.

      Previously the info objects were created and FIXCUKY is assigned to that info-object's curr/unit column already.

      I think I should not change it as I am only migrating it.

      Thanks,

      Ipsita

  • avatar image
    Former Member
    Nov 03, 2016 at 09:45 AM

    Hi,

    previous data source is working well at production???

    previous data source is active at your present system and worked well?

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • avatar image
    Former Member
    Nov 03, 2016 at 10:42 AM

    Hi,

    What info objects you used for your fields(2,3 and 4) at data source level?

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 03, 2016 at 01:17 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Hello John,

      There are 3 key figure info objects.

      In key figure property ,fixed currency of the 1st info-object is USD, for 2nd it is EUR and ,for 3rd it is GBP.

      Thanks,

      Ipsita

  • Nov 03, 2016 at 02:17 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Hello John,

      What do you mean by conditional logic.

      Are you suggesting me to use routine or formula or anything else to incorporate this logic in the transformation.

      Thanks,

      Ipsita