OracleApps Epicenter Use of Secondary Tracking Segment Print

Page 1 of 5

- OracleApps Epicenter - http://www.oracleappshub.com -

Use of Secondary Tracking Segment

Posted By Sanjit Anand On March 25, 2008 @ 4:11 am In Oracle General Ledger | 4 Comments

R12 Upgrade Project Plan Free Guide: Top 10 Considerations for Oracle R12 Upgrade Planning. Delphix.com/Free-R12-Upgrade Who's in 2012 Top 20 ERP? 2012 Top 20 ERP Software Rankings Download Report from Top IT Analyst
Business-Software.com/BestERP

Bookkeeping Training Study at home and receive a voucher for the AIPB certification exam. www.PennFoster.edu

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.

If you specified to use a Secondary Tracking Segment for Revaluation [1], 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 [2], 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 [3] 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.

http://www.oracleappshub.com/general-ledger/use-of-secondary-tracking-segment/print/

2/27/2012

OracleApps Epicenter Use of Secondary Tracking Segment Print

Page 2 of 5

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

http://www.oracleappshub.com/general-ledger/use-of-secondary-tracking-segment/print/

2/27/2012

OracleApps Epicenter Use of Secondary Tracking Segment Print

Page 3 of 5

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?

R12 Upgrade Project Plan

Free Guide: Top 10 Considerations for Oracle R12 Upgrade Planning.
Delphix.com/Free-R12-Upg...

Financial Accounting Demo

Online Business Accounting Without IT Hassles. View Demo Today!
www.Intacct.com/Financial...

Bookkeeping Training
Study at home and receive a voucher for the AIPB certification exam.
www.PennFoster.edu

Class: AX 2012 Financials

5-day course, certified Microsoft instructor. Jumpstart your AX setup
www.streamlinesys.com/AX...

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?

Download Google Chrome

Now faster than ever. Check out new features today! Learn more.
www.google.com/chrome

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:

Does the "Year End Close" is different than "Month end close" - Part -1 [3]

http://www.oracleappshub.com/general-ledger/use-of-secondary-tracking-segment/print/

2/27/2012

OracleApps Epicenter Use of Secondary Tracking Segment Print

Page 4 of 5

General Ledger Software

Powerful General Ledger and Financial Reporting Software.
www.prophix.com/reporting

Free Business Bookkeeping

Familiar Forms Make Accounting Easy So You Can Save Time. Sign Up Free!
www.QuickBooksOnline.com

Learn To Be An Accountant
Get the Accounting Skills You Need. Research Schools & Request Info!
www.AccountingPrograms....

University of Phoenix
Official Site. College Degrees for the Real World. Learn More Today.
Phoenix.edu

QuickBooks Inventory
Inventory Management Software Free 14 Day Trial.
www.Fishbowlinventory.com

4 Comments To "Use of Secondary Tracking Segment"

#1 Comment By Sunil On March 28, 2008 @ 7:22 am

Really appreciate your effort to add the note numbers too Good explanation.

#2 Comment By ballboy On September 1, 2009 @ 1:19 pm

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 Comment By Vijender On June 21, 2010 @ 12:57 am

Boss truely greatvery well explainedthanks a lots..

#4 Comment By Harry On November 17, 2010 @ 7:55 am

http://www.oracleappshub.com/general-ledger/use-of-secondary-tracking-segment/print/

2/27/2012

OracleApps Epicenter Use of Secondary Tracking Segment Print

Page 5 of 5

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.

Article printed from OracleApps Epicenter: http://www.oracleappshub.com URL to article: http://www.oracleappshub.com/general-ledger/use-of-secondary-tracking-segment/ URLs in this post: [1] Revaluation: http://www.oracleappshub.com/ebs-suite/dealing-with-foreign-currency-revaluation/ [2] Translation: http://www.oracleappshub.com/oracle-application/translation/ [3] Year-End Close: http://www.oracleappshub.com/general-ledger/does-the-year-end-close-is-differentthan-month-end-close-part-1/

Disclaimer The opinions expressed here represent solely my own represent personal conjecture based upon experience, practice and observation and does not represent the thoughts, intentions, plans or strategies of my current & previous employers and their clients. Copyright 2007-2010 OracleApps Epicenter. All rights reserved.

http://www.oracleappshub.com/general-ledger/use-of-secondary-tracking-segment/print/

2/27/2012