Supply Chain Planning and Collaboration

Get Involved. Join the Conversation.

Topic

    Venkatesh Periketi
    Unable to import lookup values including DFF
    Topic posted May 22, 2019 by Venkatesh PeriketiGold Medal: 3,500+ Points, tagged How-to 
    122 Views, 3 Comments
    Title:
    Unable to import lookup values including DFF
    Content:

    Hi Experts,

    Created a custom lookup and looking to upload lookup values with additional values in DFF. We have enabled 5 attributes in the lookup DFF and trying to upload the values. But I am unable to load the data.

    As per the below notes, this issue was fixed in

    Bug 24740414 : ADD DFF ATTRIBUTES TO LOOKUP BULK LOADER AND OTHER BUGS #29389044.
    How to bulk import Lookup Types and Lookup Codes using File Based Loader ? ( Doc ID 2215378.1 )

    Error Log:

    INFO: Processing downloaded file:/tmp/XXDTV_INT059_DFLT_COL_MAPPING.csv_119950_1558475558
    INFO: Lookups Data upload process started at : Tue May 21 21:52:38 UTC 2019 Loader Name =STANDARD_CODE
    INFO: Downloaded File Name :/tmp/XXDTV_INT059_DFLT_COL_MAPPING.csv_119950_1558475558
    INFO: Done with User profiles Data Loader initialization process
    INFO: Found Header Columns List as : [LookupType, LookupCode, DisplaySequence, EnabledFlag, StartDateActive, EndDateActive, Meaning, Description, Tag, ATTRIBUTE1]
    ERROR: Invalid header column present : ATTRIBUTE1
    ERROR: Header Column Validation Failed :
    INFO: File Processing Completed
    INFO: Lookups Data upload process completed at Tue May 21 21:52:38 UTC 2019
    INFO: Total Time taken : 0 seconds
    INFO: ----------------------------------------------
    INFO: Total records processed :60
    INFO: Error count :60
    INFO: New records inserted :0
    INFO: Records updated :0
    INFO: ----------------------------------------------
     

    Thanks,

    Venkatesh

    Version:
    R13-19A update

    Comment

     

    • Cherry Bruns

      Supply Chain Planning isn't responsible for uploading lookups. I don't see a "middleware" forum, so I'd suggest calling support to see your question can be routed to the applicable team.

      Regards, Cherry

    • Tatiana Moscalu

      Hi Venkatesh,

      I have the same problem, please let me know if you managed to solve the issue.

      Thank you,

      Tatiana

      • Venkatesh Periketi

        Hi Tatiana,

        Still it is not fixed but as a workaround you can load the lookup without DFF values and update DFF values manually.

        Thanks,

        Venkatesh