Purchasing

Get Involved. Join the Conversation.

Topic

    Sabarish Ganda
    Cannot Upload Descriptive Flex Field value into Oracle Using...Answered
    Topic posted October 16, 2018 by Sabarish GandaGold Medal: 3,500+ Points, tagged How-To, Manage Procurement Catalog 
    161 Views, 14 Comments
    Title:
    Cannot Upload Descriptive Flex Field value into Oracle Using FBDI template.
    Summary:
    When trying to import the FBDI template for items import, the DFF value is not getting populated in Oracle.
    Content:

    We enabled a DFF on the item level and we wanted to update this field while we are importing items into the system. The DFF is Attribute6, so we used the same Attribute6 in FBDI template also and tried to import it, every filed is getting imported except the DFF value.

    So can anyone please let me know what is we missing here?

    Version:
    Oracle Fusion R13

    Best Comment

    Sunny Todkari

    Yes and it worked.

    Are you getting any error for those columns after uploading the FBDI template?

    Comment

     

    • Sunny Todkari

      Are you trying to insert the data for master org and child orgs through the same FBDI file?

      If yes, please check:

      Bug 28430483 : UNABLE TO UPDATE DATE DFF WHEN MULTIPLE ROWS HAS SAME ITEM/ORG - FBDI
      UNABLE TO UPDATE DATE DFF WHEN MULTIPLE ROWS HAVE SAME ITEM/ORG - FBDI (Doc ID 2445888.1)

    • Sachin Mistry

      Is there an API based method to update PO header and PO Line DFF's? 

    • Finn Veje

      I am experiencing an identical issue. Did you ever solve this problem?

       

      • Finn Veje

        I have been attempting to upload procurement DFFs using the FBDI Template. I have followed the instructions of adding the columns ATTRIBUTE_CATEGORY, ATTRIBUTE_1...ATTRIBUTE_30 into the Contract.csv file. Some potential issues may be:

        • What value goes underneath the ATTRIBUTE_CATEGORY 
        • Do ATTRIBUTE_1...ATTRIBUTE_30 represent Attribute1 and so on in the DFF config (we have been working off of this assumption)
        • Is there a certain area in the Contract.csv file where the DFF attributes need to be put

        Any and all help would be greatly appreciated. Thank you!

        • Sabarish Ganda

          Hi Finn,

          Attribute Category value is useful only if you have enabled context sensitive DFFs. 

          If you are just using Global DFFs then fill the values in Global Attribute1,..... Columns in a spreadsheet and test these.

           

          Can you please upload screenshot of you DFFs?

          • Finn Veje

            Thank you for your help, they were context sensitive, so we used the context code which enabled the DFFs to upload.