Pipeline Job Support Added to Account Reconciliation Sync via Data Exchange

Oracle has added the ability to configure, schedule, and execute Data Exchange pipeline jobs from within the NetSuite Account Reconciliation module. Previously, pipeline orchestration lived entirely inside Data Exchange; this change lets admins manage the job lifecycle at NetSuite EPM > Account Reconciliation > Manage Jobs.

Note: The source documentation is purely procedural and does not specify which NetSuite release introduced this capability or what prior behavior it replaces. Verify the availability of the pipeline job type in your account's release notes or sandbox before relying on it in production.

What changed

Pipeline job configuration in Manage Jobs

• A new pipeline job type appears in the Manage Jobs list. You can click Edit on an existing pipeline job or use Add Job to create one.
• The Job Parameters subtab exposes:
  • Period Type — Relative (e.g., This Fiscal Year, Last Period, Period Before Last) or Absolute (explicit start/end accounting periods). When a fiscal year or quarter is selected for Start Period, the first month is used; for End Period, the last month is used.
  • Import Mode — Replace, Append, No Import, Map and Validate.
  • Export Mode — Merge, Accumulate, Replace, No Export.
  • Attach Logs — zips execution logs into the email notification attachment (default: No).
  • Send Mail / Send To — email notification triggers (No, Always, On Failure, On Success) and recipient address.

Scheduling

Pipeline jobs can be scheduled via the Schedule subtab, using the same scheduling mechanism as other Account Reconciliation jobs.

Post-processing plug-ins

The Options subtab exposes a Post-Processing Plug-ins picker (default: None). This hook can be used to load Account Reconciliation data back into NetSuite after pipeline execution.

Accounting period alignment

When using Relative period type, the accounting periods configured in Data Exchange must match those defined at Setup > Accounting > Manage Accounting Periods. A mismatch will cause incorrect period resolution at runtime.

What to do

1. Check availability — Confirm the pipeline job type is visible in your sandbox at NetSuite EPM > Account Reconciliation > Manage Jobs. If it is not present, the feature may not yet be enabled for your account or release.
2. Audit accounting periods — If you plan to use Relative period types, verify that the periods in Data Exchange align with those at Setup > Accounting > Manage Accounting Periods.
3. Fill all required fields — Data Exchange will fail the job silently if any required parameter is left blank in NetSuite. Review the Job Parameters subtab completely before saving.
4. Set up notifications — Configure Send Mail to at least On Failure with a monitored email address so pipeline failures surface promptly.
5. Test post-processing plug-ins — If you use a plug-in to load reconciliation data back into NetSuite, test the full pipeline-to-plug-in flow in sandbox before scheduling in production.