1. Setting Up and Configuring Account Reconciliation
  2. Setting Up Reconciliation Compliance
  3. Configuring Reconciliation Compliance
  4. Defining System Attributes
  5. Defining Profile Segments
  6. About Profile Segments

About Profile Segments

Profile Segments are the components of the Account ID used to uniquely identify profiles and reconciliations.

For example, if you typically reconcile accounts at the Company-Account level, then you should define two segments: one for Company, and one for Account.

Carefully design your profile segments since once you create them, they can only be edited to adjust the sub-segment settings under the following conditions:

  • No balances have been loaded while one or more sub-segments have been enabled.

    Note:

    If this has been done, the only way to remove all the balances is to delete the period OR load an empty file through each data management location for each Period & Category that previously loaded balances.

  • No formats have the Group Reconciliation check box enabled.

  • No reconciliations exist that had the Group Reconciliation option enabled when they were created.

Profile Segment values are labels. They don’t control the mapping of balances to reconciliations that occur through mapping rules added in the data load definitions or by pre-mapping balances before import.

When defining profiles, the profile account ID is stored in segments to facilitate filtering and reporting on the values. The number of profile segments is configurable and unlimited. For example, the account ID 100-1200-ABC contains three profile segments.

Note:

Oracle recommends as a best practice to limit to 10 profile segments or less, however up to 20 profile segments are supported. The total of all the segment labels (and dividers) can be up to a maximum of 1000 characters, although this may be less for non-English characters

You can specify different profile segment types:

Integer

Values ranging from 0-9. Use number segments for segments that require only numeric values.

List

Values entered into the profile segment are predefined; restrict them to an authorized set of values.

Text

Numbers, letters, and most special characters. Use hyphens (-) to delimit profile segments so they cannot be used as a segment value. Use Text segments when segment values are not restricted to a defined list and may contain a wide range of values.

Note:

Account Reconciliation treats NULL segment values in the middle of an ACCOUNT ID as three blank spaces and trims trailing NULL segments. The ACCOUNT ID in Data Management for a data load must map to the exact ACCOUNT ID in Account Reconciliation so you may see three blank spaces. For example, a profile with the following values for five profile segments: 001, NULL, NULL, NULL, and 1925 XXX (NULL is completely void of characters) will have ACCOUNT ID "001 - - - - 1925 XXX" in Account Reconciliation.

Defining Sub-Segments for Group Reconciliations

For information about setting up profile sub-segments for group reconciliations, see Administrator Set Up Tasks for Group Reconciliations.