Create Balance Initialization Batches for the US

When it's time to do the initialization, use HCM Data Loader (HDL) to load your balance values to these interface tables.

  • PAY_BAL_BATCH_HEADERS

  • PAY_BAL_BATCH_LINES

To do this:

  1. Make your first balance conversion a small one. Build separate HDL files for each group of 20 balances you prepared in the previous section.

    Use one assignment number per balance, and use it for all elements.

    This creates the necessary balance initialization elements.

    For further info, see Set Initial Balance Values for the US in the Help Center.

  2. When configuring HDL, set the transfer group size to 20000.

    This forces the process to use 10 threads.

  3. For subsequent batch files, don't exceed 200,000 records.

  4. Use the Delete Stage Table Data task to purge all staging data.

    Do this periodically during your HDL batch loads, such as after loading every 10 HDL files.

    For further info, see Overview of Maintaining the Stage Tables in the Help Center.