3 Replies Latest reply on Mar 18, 2015 12:13 PM by SH_INT

    Generating HFM Intercompany TRANSACTION_ID using FDMEE

    user4509356


      Hi,

       

      We have a requirement wherein we need to upload the Intercompany Transactions from a Flat File. However, the Flat File will not have a Transaction_ID. We need to generate the Transaction ID based on the ACCOUNT and ICP Combination.

       

      Is there a possibility of Generating the Transaction ID using some Script? I tried using Mapping Script and Putting LIKE Mapping Script with the following:

       

      Source Column : *  <Asterisk>

      Target Column : #SQL

      Expression : CASE WHEN ACCOUNT IN (<My List of Accounts>) THEN 'TXN1' ELSE 'INVALID' END

       

      However, the load is processed without these mappings

       

      We are using FDMEE 11.1.2.3.500

       

      Thanks!