How to migrate Fast Formulas using HDL file in Oracle HCM Cloud environment

Step 1 : Save the whole Fast Formula text in a .txt file. In this example I have save the
             Fast Formula in a .txt file named "SM_TEST_FF_Text_1.txt".

Step 2 : Create a folder named "ClobFiles" and put the SM_TEST_FF_Text_1.txt file
             in the "ClobFiles" folder.
 

            Note : Repeat the same steps, if you have more than 1 Fast Formula to migrate.
            Suppose, if you have 3 different Fast Formulas to migrate, save the 3 different
            Fast Formulas in 3 different .txt files and put all the 3 .txt file in the "ClobFiles" folder.

Step 3 : Sample HDL File for Fast Formulas load as below. HDL file name should
              be  "FastFormula.dat". Save the HDL details in FastFormula.dat file.

             METADATA|FastFormula|FormulaCode|FormulaName|FormulaTypeCode
             |LegislativeDataGroupName|EffectiveStartDate|EffectiveEndDate|FormulaText
            MERGE|FastFormula|SM_TEST_FF_1|SM_TEST_FF_1|Extract Rule|#NULL|1901/01/01
            |4712/12/31|SM_TEST_FF_Text_1.txt

            In the upper HDL 2 lines, 1st line is the Header(starting with METADATA) and the
            2nd line is the Data line (starting with MERGE).
            Pass the Fast Formula details accordingly in the Data line. But in the "FormulaText"
            attribute, pass the Fast Fomula .txt file name where the exact Fast Formula has been
            written (example : for Fast Formula SM_TEST_FF_1, Fast Fomula text has been saved
            in the  "SM_TEST_FF_Text_1.txt file" and has been put in the "ClobFiles" folder.
            In the HDL Data line, this file name has been passed in the FormulaText attribute)

Step 4 : Now create a single .zip file with both FastFormula.dat file and ClobFiles folder.

Step 5 : Load the .zip file in the HCM Data Loader in target environment.



Additional Steps : Load the Fast Formula description
Step 6 : Sample HDL File for Fast Formulas description load as below. HDL file name should
              be "FastFormulaTranslation.dat".
              Save the HDL details in FastFormulaTranslation.dat file and pass the details accordingly.

              METADATA|FastFormulaTranslation|FormulaId|Language|FormulaCode|FormulaName
              |Description|FormulaTypeCode|LegislativeDatGroupName|SourceLang
              MERGE|FastFormulaTranslation|XXXXXXXXXX|US|SM_TEST_FF_1|SM_TEST_FF_1
              |Test Fast Formula Load 1 using HDL|Extract Rule|#NNULL|US

              <get the Formula Id value from database and replace the Formula Id value here
                for XXXXXXXXXX>

Step 7 : Now create a single .zip file with FastFormulaTranslation.dat file.

Step 8 : Load the .zip file in the HCM Data Loader in target environment.