Automated Bank Import Scheduling via Financial Institution Format Profiles

What changed

A new Import Schedule subtab is available on Format Profile records (under Financial Institution records) when the Profile Type is set to Bank Reconciliation and a connectivity plug-in is selected as the Connectivity Method. This enables fully automated, recurring bank transaction imports without manual intervention.

Scheduling details

• Path: Setup > Accounting > Financial Institution > List > [select institution] > Format Profile > Import Schedule subtab.
• Alternate access: Match Bank Data page > Manage Import Schedules link.
• Unit of time: Hour or Day.
• Default values when the subtab opens: unit = Day, frequency = 1 day, a system-chosen import date, and a randomized import time between 04:00–07:00 AM Pacific.
• Prerequisite: At least one GL account must be linked on the Account Linking subtab before the scheduling fields become active.
• Validation rule: All scheduling fields must be either fully populated or entirely blank. Partial entries are rejected on save.

Earliest Transaction Date for Import

The Earliest Transaction Date for Import field (on the Account Linking subtab) controls how far back imported transactions will reach. If any of the following SuiteApps are installed, this date is hard-coded to 60 days before the current date and the field/column is hidden:

• Australia Bank Feeds
• Auto Bank Statement Import
• Brazil Banking Integration

Time-zone behavior

Imported transaction timestamps reflect the time zone selected during schedule configuration, not the user's or system's default time zone. However, the "last successful import time" shown on the Format Profile and Match Bank Data pages is converted to the viewing user's time zone.

What to do

1. Verify connectivity plug-in: Confirm the Format Profile's Connectivity Method is set to a connectivity plug-in (not CSV or other manual method). Scheduling is only available with plug-in-based connectivity.
2. Link at least one GL account: Open the Account Linking subtab and map one or more bank accounts to GL accounts. Save. Without this, the Import Schedule subtab fields remain inactive.
3. Configure or accept defaults: Navigate to the Import Schedule subtab. Either accept the pre-populated defaults or set your preferred unit (hour/day), frequency, date, time, and time zone. Remember the all-or-nothing validation — do not leave fields partially filled.
4. Check Earliest Transaction Date: If you are not using the Australia Bank Feeds, Auto Bank Statement Import, or Brazil Banking Integration SuiteApps, set the Earliest Transaction Date for Import on the Account Linking subtab to control the lookback window. If you are using one of those SuiteApps, be aware the lookback is fixed at 60 days.
5. Review time-zone selection carefully: The time zone you choose on the schedule drives the timestamps in imported data. Ensure it aligns with your bank's reporting time zone to avoid date-boundary mismatches during reconciliation.
6. Save and monitor: After saving, review the Match Bank Data page to confirm imports are running as expected. For failures, consult Oracle's Troubleshooting Bank Import Schedule Issues documentation.

Note: Oracle's documentation does not specify which release introduced this feature or whether it requires a specific SuiteApp bundle. The feature appears on the core Financial Institution record, but administrators should verify availability in their account under Setup > Accounting > Financial Institution. If the Import Schedule subtab does not appear, check that your role has the necessary permissions and that the Format Profile meets the prerequisites above.