Submit the Load Data From File Flow

On the Home page, click the Submit a Flow quick action under the My Clients Groups tab. On the Flow Submission page, submit the Load Data from File flow pattern to transform data in your source file into the HDL format.

Assumptions

This procedure has these assumptions.

  • You have the Human Capital Management Integration Specialist role.

  • You have the source file ready to upload to Oracle WebCenter Content.

  • If you have already uploaded the source file, you have the content ID handy.

Note: To upload files to the content server, browse to the source file on your file system, check it in to the content server, and retrieve its Content ID. For more information, see Oracle Fusion Middleware Using Oracle WebCenter Content guide.

Before You Begin

Before you submit the flow, ensure that you meet these prerequisites.

Characteristics

What You Should Do

Data transformation

If the data in the source file requires transformation, create and compile a transformation formula using the HCM Data Loader formula type.

On the Home page, click the Fast Formulas quick action under the My Clients Group tab.

You can now specify the processing parameters for your process configuration group.

File encryption

Before loading encrypted files, ensure that the encryption keys exist for the secure file transfer. This process involves creating a service request, generating PGP key pairs, and sharing the encryption keys.

Specify the Payroll Batch Loader Encryption Type parameter value for the process configuration group you select when running the flow or the web service. Valid values are PGPSIGNED, PGPUNSIGNED, and NONE.

On the Home page, click the Process Payroll Configuration quick action under the My Clients group tab. Now, you can specify the processing parameters for your process configuration group.

Other processing parameters

Use the Payroll Process Configuration task to add parameters for the process configuration group.

Examples of processing parameters include Batch Error Mode, Logging Area, Logging Category, and Threads.

  1. On the Home page, click the Submit a Payroll Flow quick action under the My Clients Groups tab.

  2. In the Legislative Data Group option, select a legislative data group.

  3. Search for and select the Load Data from File flow pattern.

  4. Click Next.

  5. Enter the parameters, as shown in this table.

    Field

    Value

    Payroll Flow

    Descriptive name for this specific flow process.

    Content Id

    Enter the Content Id. The source file must already exist on the content server.

    Transformation Formula

    Select the required transformation formula. The type of the formula should be HCM Data Loader.

    Process Configuration Group

    Select your process configuration group.

  6. On the Enter Parameters page, click Next.

  7. On the Enter Flow Interaction page, click Next.

  8. On the Schedule page, click Next.

  9. On the Review page, click Submit.

  10. In the confirmation dialog box, click OK and View Checklist.

  11. On the Payroll Flow page, Task Details tab you should see a green check mark in the Generate Data Loader File and Initiate Data Loader rows, Task Type column. If not, on the toolbar, click the Refresh icon intermittently until you do.

  12. Close the Payroll Flow page.

  13. On the Overview page, search for and click your payroll flow.

  14. View the process results.

  15. Check for any errors or warnings.