Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Use of Secondary Tracking Segment

Posted on March 25th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Did you know in 11i with Family Pack E, a new flexfield qualifier has been added to enable you to nominate a segment in your chart of accounts to act as your secondary tracking segment.

This segment will be paired with the balancing segment when generating account balances for the Retained Earnings account, Unrealized Gains or Losses accounts, and the Cumulative Translation Adjustment account.

"Oracle define this feature as:
A segment in the chart of accounts can be designated as a secondary tracking segment, in addition to the balancing segment, to perform more detailed analysis within Oracle General Ledger. The secondary tracking segment is used in the revaluation, translation, and fiscal year-end close processes. The system will automatically maintain unrealized gain/loss, retained earnings, and cumulative translation adjustments by unique pairs of balancing segment and secondary tracking segment values."

Therefore, you can use any segment, except the balancing segment or natural account segment, can be specified as the secondary tracking segment.

secondary Segement

If you specified to use a Secondary Tracking Segment for Revaluation, the Unrealized Gains/Losses account will be tracked by the balancing segment and secondary tracking segment.

If you specified to use a Secondary Tracking Segment for Closing and Translation, the Retained Earnings account and the Cumulative Translation Adjustment (CTA) accounts will be tracked by both the balancing segment and secondary tracking segment.

This allows you to maintain accounting data at a finer level of detail for these accounts.

You should also note, Year-End Close refers to the standard process of closing out the year-to-date balances for your revenue and expense accounts to retained earnings when you open the first period of a new year. This does not apply to the Year-End Closing Journals feature. However, as per documentation you can achieve the same result using Income Statement Closing Journals by specifying different retained earnings accounts for a range of revenue and expense accounts.

You don't get confused with secondary tracking segment is not a second balancing segment for journal entry. The control is still for only one balancing segment. The posting is effected only in the measure of the Retained Earnings Account effect (these accounts will also track for the secondary segment instead of just the balancing segment).

Usage with Secondary Segment

Lets try to understand with two example

Case 1:

If Secondary tracking segment/qualifier is to breakdown the retained earnings balance (brought forward) at the beginning of the new financial year. Here is an example how the system will breakdown the retained earnings.

If you enable Secondary tracking for the state segment:-
01.NY.3000.000 $60,000
01.CA.3000.000 $40,000

Without Secondary Tracking
01.00.3000.000 $100,000

Case 2:

Enabling Secondary and Translation Check box. The Retained Earnings Account and CTA Account will be tracked by the Pair of Balancing as well as Secondary Tracking Segment.

Suppose the following are the Entries made during the year:

Account USD Balance Cumulative Rate Translated INR
01.100.Revenue 1000 50 50,000 CR
01.100.Expense 500 50 25,000 DR
01.200.Revenue 2000 45 90,000 CR
01.200.Expense 750 50 35,000 DR

At the Year End Closing and Translation, the following pair of Accounts are created :

Account USD Balance Calculated Rate Translated INR
01.100.Retained Earnings 500 60 30,000 CR
01.200. Retained Earnings 1250 50 62,500 CR

Secondary Tracking Segment Benefits

  • Secondary tracking segments provide better audit and analysis capabilities.

You now have more visibility into the detailed components of Retained Earnings, Cumulative Translation Adjustment, and Unrealized Gains and Losses. Instead of tracking these accounts by a balancing segment alone, you can track them by the balancing segment and another segment of your choice, such as Department, Line of Business, or Cost Center.

  • A secondary tracking segment also provides better control and consistency of similar transactions because this option is set at the ledger level instead of through a profile option.
  • By being able to nominate any segment other than your primary balancing segment or natural account segment to act as your secondary tracking segment, you have greater flexibility in tracking accounts by pairs of segments.

How to Set Up Secondary Tracking Segment

Very simple, what you have to do it you need to navigate to:

(N) Setup > Financials > Flexfields > Key > Segments (B) Segments

Now you can choose any segment, other than your balancing segment or natural account segment, to be your secondary tracking segment.

You can set the Secondary Tracking Segment flexfield qualifier for new or existing charts of accounts at any time.

If you are currently using the Revaluation by Cost Center feature and wish to retain it, you do not have to do anything, this is very important.

(N) Setup > Financials > Flexfields > Books > Define

There is a new Secondary Segment Tracking region in the ledger form. Enable the Closing and Translation option to maintain account balances generated from the Closing and Translation process. Enable the Revaluation option to track account balances generated from the Revaluation process at a finer level of detail.

Both of these options are optional and can be turned on together or separately.

Oracle recommended that the Closing/Translation option be enabled when the ledger is first defined. This option cannot be disabled in the future.
The Revaluation option can be turned on and off at any time, but for consistency in processing, the setting should remain consistent throughout the life of your ledger.

There is separate process, who want to enable this feature in there existing setup, you can Follow Note 261961.1 for Enabling this feature for an Existing SOB, which requires some pre-requisite steps.

Some of query that end user or Finance Core user might interested

(1) Is the Secondary tracking segment qualifier mandatory

No, it is not mandatory.

(2) What is the benefit for using it during my closing process?

Very same as Better Audit and Analysis,Better Control and Consistency, Greater Flexibility are main key benefits as discussed above.

(3)Enabling a segment for secondary tracking does mean that you will get a tallied trial balance?

Enabling a segment for secondary tracking does NOT mean that you will get a tallied trial balance. What it means is that for some of the transactions you will get additional details.

(4) Which Version of Oracle Can use this functionality?

  • 11.5.5-11.5.9+ Patch 2930577
  • 11.5.10/11.5.10.2
  • R12

(5)Two Balancing Segments at a time...

The scenario is FICO would like to have balance sheet/trial balance balanced by entity (company) and division (responsibility center).Is there any way that we can have two segments in COA enabled as balancing segment?

The answer would be : you cannot have two balancing segments. Please have a look at the secondary Tracking segment feature if it suits your requirements.

(6) Any Limitation for this Functionlity?

You should not forgot secondary tracking segment does not support suspense adjustment, intercompany segment value balancing and rounding imbalnce processing.

Reference Note :

  • Note 237968.1, the Secondary Tracking Segment qualifier is new to 11i with Family Pack E
  • Note 261961.1 Enabling Secondary Tracking Segment for an Existing Set of Books
  • Note 277888.1 Setup Checklist to Enable the Secondary Tracking Segment in Oracle General Ledger
  • Note 268393.1 How Do Secondary Tracking Segment's Features Work
  • Note.268391.1 How to Enable Secondary Tracking Segment For A New SOB

Similar Post:

Related Posts

Posted in Oracle General Ledger | 4 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
4 Responses
  1. Sunil Says:

    Really appreciate your effort to add the note numbers too

    Good explanation.

  2. ballboy Says:

    In your example, it may be more realistic to use STS on Line of Business segment, and Cost Center on Department, this is how it is in real world. Also, Subsidiary is not the same as Intercompany. But overall, thanks.

  3. Vijender Says:

    Boss truely great…very well explained…thanks a lots..

  4. Harry Says:

    Fantastic explanation….Read Oracle User Guide but could not understand the concept in full until I read your posting above. Thanks for such a brilliant effort in providing the explanation on secondary tracking segment.

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.