0 Replies Latest reply on May 11, 2018 4:44 AM by 3383498

    WHEN-VALIDATE-RECORD not working in Form Personlisation

    3383498

      Hello,

       

      I have a scenario where based upon the Customer Number the Packing Instructions Data will populate.The data been pulled from Attachments Section in Customer Account

       

       

      select

      fdst.short_text

        from hz_cust_accounts            hca,

           fnd_attached_documents   fad,

           FND_DOCUMENTS_TL FDT,

           fnd_documents                 fd,

           fnd_documents_short_text fdst

      where fdst.media_id = fd.media_id

         and fd.document_id = fad.document_id

         AND FDT.DOCUMENT_ID     = FD.DOCUMENT_ID

         and fad.pk1_value = hca.cust_account_id

         and fdt.title like '%Shipping%'

         and hca.account_number = :customer_number

       

       

      The data is not coming when I am in the Order Line.

       

      Please advise