Transfer Pricing Rollover

At the close of each period, the system needs to be moved from the current time period into the next. This process is called a rollover. The rollover is run at period end and at year end. The Transfer Pricing rollover process will advance the period and /or year independently of Tax Provision and Pillar Two. Prior to executing the rollover, it is advised that you take a backup of the database, either using the export function in server manager or taking a RDBMS backup.

The Transfer Pricing Period End rollover process performs the following steps:

1. Updates time period alternate hierarchies.
2. Updates these system attributes to reflect the current period:

   1. ASLTPCPer (Transfer Pricing - Current Period ).

3. Copies automations settings for Profitability Analysis to the next period.
4. Copies the Allocation settings to the next period.
5. Copies the Transfer Price Targets to the next period.

If the rollover is a year end rollover, and the rollover for tax provision has not been executed yet, the Transfer Pricing rollover process will also:

1. Create time period symbols for next year for the actuals timeframe (Months, Quarters, Year, YTD Months, YTD Year, and Return time periods).
2. Delete the seventh prior year time period symbols for actuals timeframe (Months, Quarters, Year, YTD Months, YTD Year, and Return time periods).

Note: In a system with Tax Provision and Pillar Two, whichever rollover is executed first will perform the create and delete steps.

The following time period hierarchies are updated during the period end rollover:

The following time period hierarchies are updated during the year end rollover:

Preparing for a rollover

Before you perform a rollover in Longview Transfer Pricing, make sure the following conditions are met:

• Ensure that all data intersections and the associated criteria have been defined for the period end or year end and return rollovers.
• Inform all users that a rollover is imminent and make sure they have time to exit the system, then ensure no users are in the system.
• Ensure all events are completed prior to beginning the rollover.
• Ensure all data submissions are completed prior to beginning the rollover.
• Ensure there are no outstanding locks.
• Create a backup of the Longview production database and copy to a safe place by running an Export through Longview Server Manager.

Running the transfer Pricing process (Period end and year end)

You can use the Rollover tool to run the transfer Pricing rollover process for the end of the current period. The rollover procedure in the Rollover tool is the same for period end and year end rollovers.

The rollover type in the Rollover tool is determined by the following:

• If the current period is the last period for the year in the ASLTPCPer attribute, the rollover is a year end rollover.
• If the current period is any other period in the ASLTPCPer attribute, the rollover is a period end rollover.

Caution: Be sure to have a complete and recent backup of your database prior to running the rollover process.

To perform a rollover:

1. In the Transfer Pricing navigation pane, click Administration.
2. Expand Rollover.
3. Click Rollover. The Rollover tool opens in the workspace. If there are any locks in the target period, a message displays. Locks can prevent the rollover from running successfully. Click Data Locks to open the Data Locks tool and review the conflicting locks. Clicking Data Locks will end the rollover process.
4. If there are any user submissions in progress, a message displays. You must wait until all user submissions are complete before you start the rollover process. Click User Submissions to open the User Submissions tool and monitor any user submissions in progress. Clicking User Submissions will end the rollover process.
5. If there are any events in progress a message displays. You must wait until all events are complete before you start the rollover process. Click Events to open the Events tool and monitor any events in progress. Clicking Events will end the rollover process.
6. Click Start Rollover. The progress message appears. When the rollover is complete, the summary page appears.

   Note: If the rollover fails, you must restore the database by running an Import of your backup through Longview Server Manager. For more information, see the Longview Server Manager Guide.

7. If you want to view the rollover log file, click View Log File. The log file is saved to the following location:

   C:\Users\<userID>\Documents\Longview\Rollover\

8. When you are finished, click Close.