Close Management and Consolidation Sync SuiteApp: SuiteQL Queries, Auto-Prefixed Allowlists, and Period Terminology

Overview

This page consolidates release notes for the Close Management and Consolidation Sync SuiteApp, which bridges NetSuite and Oracle Financial Consolidation and Close (FCCS). The SuiteApp depends on the NetSuite EPM Connector SuiteApp and surfaces its configuration under the NetSuite EPM tab. Versions covered: 25.1 (initial release, March 2025) through 26.1.1 (July 2026).

What Changed in 26.1 (January 13, 2026)

SuiteQL Query Support

You can now author SuiteQL queries directly within the SuiteApp to load data from NetSuite into FCCS. This is a significant addition for teams that need joins, analytic functions, or other constructs not easily expressed in saved searches or datasets. Refer to Oracle's Managing SuiteQL Queries in Close Management and Consolidation Sync help topic for syntax and configuration.

Automatic Allowlist Prefixing

Previously, admins had to manually register the customsearch_nsfc_ (saved searches) and custdataset_nsfc_ (datasets) prefixes in the NetSuite EPM Connector data-source allowlist. The SuiteApp now injects these prefixes automatically when default saved searches and datasets are created. If you previously added them manually, no action is required—the entries are harmless—but you can clean them up if desired.

Inbound Connection Verification

A new checkbox, Use Entered URL to Verify Inbound Connections, lets you validate that the correct FCCS instance is the one connecting to your NetSuite account. This is configured in the connection setup (step 4 of Setting Up the Connection to Financial Consolidation and Close). Enable this in any environment where you need to guard against misconfigured or rogue inbound calls.

Relative Period Terminology Renamed

The relative-period options in Data Load Rule, Group, and Import Enterprise Journal jobs have been renamed:

• This Month → This Period
• Last Month → Last Period
• Month Before Last → Period Before Last

Additionally, Period Before Last is now available for Data Load Rule and Group jobs (previously it was not). If you reference these values in any scripted automation or documentation, update them to match the new labels.

Localization and Help Links

The SuiteApp is now localized in all supported NetSuite languages. A Help On This Topic link is available in the upper-right corner (or under the More menu) of every SuiteApp page.

What Changed in 26.1.1 (July 7, 2026)

Oracle describes this as a “security-related improvement” with no further detail. No specific CVE, field, or record is named. If your organization tracks SuiteApp patch provenance, note the version bump and verify the update is applied in your sandbox before production.

What Changed in 25.1.1 (April 8, 2025)

Fixed a bug where Import Enterprise Journal jobs failed for accounts using basic authentication to connect to FCCS. The fix requires you to re-enter your basic-auth credentials in NetSuite. See Using Basic Authentication to Connect to Financial Consolidation and Close.

What Changed in 25.1 (March 18, 2025)

Initial release of the SuiteApp. Requires the NetSuite EPM Connector SuiteApp as a prerequisite. After installing both, the NetSuite EPM tab includes Close Management and Consolidation navigation menus.

What to Do

1. Update the SuiteApp — Ensure you are on version 26.1.1 to pick up the security fix. Test in sandbox first.
2. Review allowlist entries — If you manually added customsearch_nsfc_ or custdataset_nsfc_ prefixes to the EPM Connector allowlist, they are now redundant. You may remove them or leave them in place.
3. Enable URL verification — If you run multiple FCCS environments (e.g., dev, UAT, prod), enable Use Entered URL to Verify Inbound Connections to prevent cross-environment mis-routing.
4. Evaluate SuiteQL for data loads — If your current saved-search-based data loads are hitting governance or complexity limits, consider migrating to SuiteQL queries within the SuiteApp.
5. Update scripts or docs referencing period labels — Any automation that keys on the old label strings (This Month, Last Month, Month Before Last) must be updated to use the new This Period / Last Period / Period Before Last values.
6. Re-enter basic-auth credentials (if on 25.1) — If you upgraded from 25.1 to 25.1.1 and use basic auth, re-enter credentials per Oracle's instructions to resolve Import Enterprise Journal failures.