1. Administering Payroll for United States Electronic Income Withholding Orders
  2. e-IWO Process

e-IWO Process

The e-IWO Process flow retrieves any new inbound order info from the Electronic Income Withholding Order (e-IWO) storage tables and performs the necessary actions on the obligor Involuntary Deductions calculation cards.

It consists of these flows.

e-IWO flow

What it does

e-IWO HCM Data Loader Process

Uses HCM Data Loader to load the e-IWO data into the storage tables.

The e-IWO Process flow only runs this flow during an automatically scheduled run. If you start e-IWO Process manually, it doesn't include this flow. You must load your e-IWO data into the storage tables manually.

Note: If you're using any web service solution to perform e-IWO processing automatically, you must pass the required HCM Data Loader (HDL) parameters to ensure proper execution of this flow. For further info, see the following technical briefs on My Oracle Support.

e-IWO Validation Process

This flow:

  1. Checks the data loaded into the e-IWO storage tables.

  2. Validates each order according to Office of Child Support Services (OCSS) criteria and sets the status.

  3. Issues the appropriate warning messages if needed in the Audit Report.

For further info, see e-IWO Validation Process in the Help Center.

e-IWO Involuntary Deductions Card Load Process

This flow:

  1. Associates the payee in the order with a third-party payee.

  2. If you haven't defined the payee, it attempts to use a default payee as defined through the user-defined tables.

  3. Uploads valid e-IWOs to the obligor's Involuntary Deductions card, and creates card components as necessary.

    • If the child support amount on the order is greater than $0, the flow creates a Child Support component.

    • If the spousal support amount on the order is greater than $0, the flow creates a Spousal Support component.

    • If both amounts exist, it combines them and applies them to a Child Support component.

  4. Creates a card if the obligor doesn't already have one.

    It creates the card and card component with an effective date as defined on the Document Date field of the e-IWO file. In the unlikely event that this date is earlier than the existing card effective date, the flow raises an error.

  5. For cases where the obligor has multiple payroll relationships, it performs additional steps.

    For further info, see How e-IWOs Are Processed When an Obligor has Multiple Payroll Relationships in the Help Center.

For further info, see e-IWO Involuntary Deductions Card Load Process in the Help Center.

e-IWO Inbound Audit Report

Generates the e-IWO Audit Report output file.

For further info, see e-IWO Inbound Audit Report in the Help Center.

e-IWO Employee Notification Report

Generates PDF reports for all new or amended e-IWOs. It stores these files in Document Records and emails them to the employees.

For further info, see e-IWO Employee Notification Report in the Help Center.

Configure this flow to run automatically on a daily basis to uptake and process incoming e-IWOs.

To run it manually:

  1. From My Client Groups, click Payroll.

  2. Click Submit a Flow.

  3. Enter your US legislative data group (LDG).

  4. Search for and select e-IWO Process.

Before You Start

Retrieve the inbound order file from your secure FTP server.

Convert the e-IWO file into a .dat format supported by HDL

If you're running this flow manually, use HDL to load the .dat file into the e-IWO storage tables.

For further info, see Set Up Processing of e-IWOs in the Help Center.

Report Parameters

Legislative Data Group

Your US LDG.

Start Date

Start date on the inbound e-IWO file. The flow includes any unprocessed e-IWOs received within this range.

Note: When configuring the automatic schedule for this flow, leave this parameter blank.

End Date

End of the date range for e-IWO processing. The flow includes any unprocessed e-IWOs received within this range.

Note: When configuring the automatic schedule for this flow, leave this parameter blank.

Output Reports

This flow generates the following.

  • e-IWO Inbound Audit Report

  • e-IWO Employee Notification Reports

e-IWO Inbound Audit Report

The e-IWO Inbound Audit Report flow generates this report when you run it either as part of the e-IWO Process flow or as an independent flow.

If you processed multiple inbound files, this report includes results for all files, sorted by file name.

The e-IWO Process flow sends an email notification with this report as an attachment. For further info about how to specify the email recipients, see Set Up Processing of e-IWOs in the Help Center. There's no email notification if you generate this report through the e-IWO Inbound Audit Report flow.

For further info, see e-IWO Audit Report in the Help Center.

e-IWO Employee Notification Report

The e-IWO Employee Notification Report flow generates these PDF files when you run it either as part of the e-IWO Process flow or as an independent flow.

These files contain details on each new and amended e-IWO you have successfully processed, suitable for delivery to your employees. The flow stores these files in Document Records and emails them to the appropriate employees.

Note: These aren't the same documents as issued by the OCSS.

Related Topics