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

    Generating HFM Intercompany TRANSACTION_ID using FDMEE




      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