You use the OTL Rollback processes for payroll to roll back data populated into Oracle Payroll's BEE interface via the Transfer Time from OTL to BEE process, Transfer to BEE process, and Transfer to BEE (Retro) process.
Rollback of timecards (OTLR and Non OTLR) involves reversing the entries in Payroll and enabling the timecards for retrieval again.
OTLR timecards are the timecards for which OTL Rules Evaluation preference is set to Yes.
See: Self-Service in Default Preferences
OTLR timecards are coupled with Payroll period tightly, and hence the application require two different processes to effectively simplify the rollback processes for OTLR and Non OTLR timecards. An OTLR timecard can never be rolled back with OTL: Rollback Non OTLR timecards process and vice versa. These validations are built into the processes.
Additionally, note the following:
You cannot roll back deleted timecards. You can reverse a deleted timecard only by running the Transfer Time from OTL to BEE process once again for the time period. For Non OTLR timecards, the application considers a template override a delete and recreate of a new timecard. You cannot delete or overwrite OTLR timecards by templates.
The application does not consider timecards with preference changes between OTLR and Non OTLR for rollback and notifies this with an appropriate error message. You can roll back such timecards using manual batches.
This rollback process framework does not cover any new entry made in BEE. Such entries remain in BEE unless manually deleted.
All new reversal batches created by the process have a status of Unprocessed. You must move the batches to element entry.
If you opt for the reversal batches method, then the application creates reversal batches for the rollback process and the batches for reversal have a status Transfer in BEE. You cannot delete lines of such timecards from reversal batches and you must create a reversal batch to negate the entries. Ensure you follow the naming convention REV_XXXX_YYYY for reversal batches, where XXXX is the batch_id of the batch to reverse and YYYY is the concurrent request ID for the Rollback process.
Latest changes in the timecard are always accommodated in all Retrieval processes and this behavior will have no change.
The OTL Rollback Processes for Payroll include the following concurrent programs:
OTL: Rollback Non OTLR Timecards - use this to roll back data populated to Oracle Payroll's BEE interface via the Transfer Time from OTL to BEE process for Non OTLR Timecards.
OTL: Rollback OTLR Timecards - use this to roll back data populated to Oracle Payroll's BEE interface via the Transfer Time from OTL to BEE process for OTLR Timecards.
OTL: Rollback Batches from BEE - use this to roll back data populated to Oracle Payroll's BEE interface via the Transfer to BEE process.
OTL: Rollback Batches from BEE(Retro) - use this to roll back data populated to Oracle Payroll's BEE interface via the Transfer to BEE (Retro) process.
See: Running the OTL: Rollback Batches from BEE(Retro) Process
For more information, see: OTL: Rollback Framework for Payroll Retrieval Whitepaper, My Oracle Support Note: 1468700.1.
You use the OTL: Rollback Non OTLR Timecards Process to roll back data populated to Oracle Payroll's BEE interface via the Transfer Time from OTL to BEE process for Non OTLR timecards.
Run this process to rollback any Non OTLR timecards either fully or partially. Based on the parameters you select, this process displays a detailed output of all processed timecards and batches. The application displays a warning if at least one of the timecards processed ends in an error during Rollback.
You run the OTL: Rollback Non OTLR Timecards Process from the Submit Requests window.
To run the OTL: Rollback Non OTLR Timecards Process
In the Submit Requests window, enter OTL: Rollback Non OTLR Timecards as the Name.
In the Parameters window, select the Mode. This is a mandatory field. By default, this is Validate Only. Run the process in a validate mode to view information about how the Rollback would have processed. This mode does not actually execute the rollback. You can run the process repeatedly in this mode without rolling back the timecards to validate your results. Select the Validate and Execute mode to run the process in a complete mode, validating and executing the Rollback. You can run the process only once in the Validate and Execute mode.
Enter the Start Date. This defines the start of the date range for the timecard period. The application selects and processes only those timecards that are completely included in the date range. For example, if the timecard starts on 1 January, and start date specified is 3 January, then the application will not select that timecard.
Enter the End Date. This defines the end of the date range for the timecard period. The application selects and processes only those timecards that are completely included in the date range. For example, if the timecard ends on 1 January, and end date specified is 30 December, then the application will not select that timecard.
The following selections are optional and limit your rollback to the selection you make. If you select one or more of the following, your transfer will be specific to only the criteria entered for each option.
GRE - select the GRE to which you want to limit your rollback.
Organization - select the organization to which you want to limit your rollback
Location - select the location to which you want to limit your rollback
Payroll - select the payroll to which you want to limit your rollback
Person - select the employee who submitted the timecard
Select the Rollback Mode from the list. You can choose from:
Rollback As Per Selection: Choose this option to roll back the latest retrieval for a timecard based on details you specify. If the timecard's latest retrieval does not attribute to any of the selected parameters, the timecard would not be rolled back.
If you select this parameter, then the process rolls back the latest retrieval for the timecard per the details you specify. At the end of the rollback process, the latest timecard will be eligible for retrieval again. If you select this parameter, then you can additionally specify the following parameters:
Concurrent Request: use the list of values to select a specific request of Transfer Time from OTL to BEE process
Retrieval Transaction Code: use this list of values to select a Retrieval transaction code entered on a specific Transfer time from OTL to BEE.
Batch Name - use this list of values to select a specific batch to roll back.
The Dependent Batch Action field is enabled only when you select a Batch Name. You can choose from:
Error Out: When a dependent batch is encountered, the process displays an appropriate message and skips to the next timecard
Process Dependent batches: When a dependent batch is encountered, the process reverses dependent batch lines too
Batch Reference: use this to select a specific batch reference to target a list of batches.
Rollback All Timecard Details: Choose this option to roll back all the details of the timecard ever transferred to BEE.
7. Select a value from the Transferred Batch Action list to select how the process should complete if it encounters a batch with a status Transferred in BEE ( Batch lines transferred to Element Entry). You can choose from:
Error Out: Select this to ensure the process errors out if it encounters a transferred batch.
Create Reversal Batch: Select this to ensure the process reverses a transferred batch line by creating retro entries for the transferred lines, with negative hours.
Click OK and then click Submit your request.
You use the OTL: Rollback OTLR Timecards Process to roll back data populated to OTLR's Entry/Validation/Approval window via the Transfer Time from OTL to BEE process. Additionally, this program enables you to complete rollback of timecards transferred from OTLR to BEE using Validate and Transfer processes. The process creates an Output file that displays the details of the timecard in OTLR before and after rollback. There is also an option to define the extent of rollback, either from BEE to OTLR(OTM) or BEE to OTLR to OTL(Time Store). The application displays a warning when at least one of the timecards processed encounters an error.
You run the OTL: Rollback OTLR Timecards Process from the Submit Requests window.
To run the OTL: Rollback OTLR Timecards Process
In the Submit Requests window, enter OTL: Rollback OTLR Timecards as the Name.
In the Parameters window, select the Mode. This is a mandatory field. By default, this is Validate Only. Run the process in a validate mode to view information about how the Rollback would have processed. This mode does not actually execute the rollback. You can run the process repeatedly in this mode without rolling back the timecards to validate your results. Select the Validate and Execute mode to run the process in a complete mode, validating and executing the Rollback. You can run the process only once in the Validate and Execute mode.
Select the Payroll. This is a mandatory field and enables you to select the payroll to roll back.
Select the Time Period. You can select a time period only after you select a payroll to designate the payroll period.
The following selections are optional and limit your rollback to the selection you make. If you select one or more of the following, your transfer will be specific to only the criteria entered for each option.
GRE - select the GRE to which you want to limit your rollback.
Organization - select the organization to which you want to limit your rollback
Location - select the location to which you want to limit your rollback
Person - select the employee who submitted the timecard
Select the Batch Reference from the list.
Select a Batch Name from the list. These batches are not retro batches, but the actual batch that the timecard was first created in BEE.
Select the Transferred Batch Action from the list to indicate how the process should complete if it encounters a batch with a status Transferred in BEE ( Batch lines transferred to Element Entry). You can choose from:
Error Out: Select this to ensure the process errors out if it encounters a transferred batch.
Create Reversal Batch: Select this to ensure the process reverses a transferred batch line by creating retro entries for the transferred lines, with negative hours.
Select a value from the Rollback Timecards To list. You can choose between OTM and Time Store. Choose OTM to roll back timecards to remove all details from BEE, and have them transferred afresh from OTLR. Alternatively, choose Time Store if you require to roll back timecards completely from OTLR to OTL so that you attempt a transfer again.
If you selected Time Store from the Rollback Timecards To list, then the application enables you to select an option from the Action on Changes in OTM list. A timecard originally created via Self-Service/Time Keeper/API and transferred to OTLR with Transfer time from OTL to BEE is available in the Entry/Validation/Approval screen for modification. There may be additions to timecards entered in this screen. These details cannot be rolled back to OTL. You can choose from:
Error Out: If you select this option, then the process displays an error message and skips to the next timecard when it encounters a timecard with a manual entry from Entry/Validation/Approval window.
Delete Manual changes in OTM: If you select this option, then the application deletes any manual entry from E/V/A screen off OTLR before rolling back the changes to OTL.
Click OK and Submit your request.
You use the OTL: Rollback Batches from BEE process to roll back data populated to Oracle Payroll's BEE interface via the Transfer to BEE process.
The process is equipped with the same parameters as the Transfer to BEE process to identify batches. The process handles only Normal batches created from OTLR( not retro batches). An additional option of rolling back only a single person's timecard is provided. The process ends with a warning when at least one of the timecards processed encounters an error.
You run the OTL: Rollback Batches from BEE process from the Submit Requests window.
To run the OTL: Rollback Batches from BEE Process
In the Submit Requests window, enter OTL: Rollback Batches from BEE as the Name.
In the Parameters window, select the Mode. This is a mandatory field. By default, this is Validate Only. Run the process in a validate mode to view information about how the Rollback would have processed. This mode does not actually execute the rollback. You can run the process repeatedly in this mode without rolling back the timecards to validate your results. Select the Validate and Execute mode to run the process in a complete mode, validating and executing the Rollback. You can run the process only once in the Validate and Execute mode.
Select a Starting Batch from the list. This is a mandatory field and enables you to choose the batch name to rollback. If a given timecard is modified further with retro batches, it will not be available in the list.
Select a Ending Batch from the list. If a given timecard is modified further with retro batches, it will not be available in the list.
Select a Batch Reference from the list to select a batch reference for a batch that is transferred to BEE.
Select a Person from the list to rollback the specific person's timecard from the batch.
Select a value from the Transferred Batch Action list to choose how the process should complete if it encounters a transferred batch. This field is enabled only if you have selected a person. If a person parameter is not selected, a batch is eligible for rollback only if it is of status Unprocessed. You can choose from
Error Out: Select this to ensure the process errors out if it encounters a transferred batch.
Create Reversal Batch: Select this to ensure the process reverses a transferred batch line by creating retro entries for the transferred lines, with negative hours.
Click OK and Submit your request.
You use the OTL: Rollback Batches from BEE (Retro) process to roll back data populated to Oracle Payroll's BEE interface via the Transfer to BEE (Retro) process.
This has the same parameters as the Transfer to BEE (Retro) program. The process is equipped to rollback only Retro batches created from OTLR. The process completes with a warning when at least one timecard encounters an error. The application does not allow rollback by creating Reversal batches for this program because retro batches usually are one each per timecard. To roll back a retro batch with status Transfer (in BEE) to OTLR, use the BEE Batch Process (Rollback), without affecting other timecards. Run the OTL: Rollback Batches from BEE (Retro) process after you have run the BEE Batch Process (Rollback).
You run the OTL: Rollback Batches from BEE (Retro) process from the Submit Requests window.
To run the OTL: Rollback Batches from BEE (Retro) Process
In the Submit Requests window, enter OTL: Rollback Batches from BEE (Retro) as the Name.
In the Parameters window, select the Mode. This is a mandatory field. By default, this is Validate Only. Run the process in a validate mode to view information about how the Rollback would have processed. This mode does not actually execute the rollback. You can run the process repeatedly in this mode without rolling back the timecards to validate your results. Select the Validate and Execute mode to run the process in a complete mode, validating and executing the Rollback. You can run the process only once in the Validate and Execute mode.
Select a Starting Batch from the list. This is a mandatory field and enables you to choose the batch name to rollback. The list of values displays only retro batches. If a timecard is further modified with multiple retro batches, the list of values will display only the last retro batch.
Select a Ending Batch from the list.
Select a Batch Reference from the list to select a batch reference for a retro batch that is transferred to BEE.
Click OK and Submit your request.
There are two ways to run rollback of timecards from Projects Accounting. You can choose to run the rollback using the Launch Rollback page. Alternatively, you can run the OTL: Rollback Timecards from Projects Accounting process from the Submit Request window.
Rolling back timcards using the launch rollback page
Navigate to Rollback Timecards from Projects Accounting. The page displays the history of the rollback processes you have launched previously.
In the Search Requests region, enter a Start and End date, and click on Go. This limits the list of prior rollback requests to a date range and displays the list in the Recent Rollbacks region.
In the Recent Rollbacks region, you can view the following details about the rollback requests:
Request ID - click the link to view details of the selected request ID for the rollback process. The details display in the Recent Rollbacks - Details region.
Date Submitted
Date Started
Date Completed
Status
View Log - click the icon to view the concurrent process log file.
In the Recent Rollbacks – Details region, you can view the following details:
Timecard ID
Period Starting
Period Ending
Person Name
Click New Rollback to start a new rollback process. This opens the Launch Rollback page.
In the Search Timecards region, enter the From Date and the To Date, Organization or Person to search your timecards for rollback. Click Go.
The Timecards Search Results region displays the selected timecards available for Rollback. The details displayed are:
Timecard ID
Organization
Person Name
Period Starting
Period Ending
Timecard Hours
Projects Hours
Business Group
To rollback timecards, you can select individual timecards using the check box or select all timecards.
Click Add in the Timecards Search Results region to add the timecards to Timecards – Selected for Rollback region. You can continue to repeat the search and add timecards to the Timecards Selected for Rollback region. Once you have selected all timecards you need to rollback, choose the parameters for rollback.
In the Parameters for Rollback region, select the Rollback Method. You can choose from:
Rollback all history - if you select this then the application scans the database for all timecard versions and associated data in Projects Accounting to be rolled back for the selected timecards.
Rollback selected timecards - if you select this then the application rolls back the current version of the timecard and associated data in Projects Accounting.
In the Parameters for Rollback region, select the Rollback Mode. You can choose from:
Validate Only - use this to view information about how the rollback would have processed. This mode does not actually execute the rollback. You can run the process repeatedly in this mode without rolling back the timecards to validate your results.
Validate and Execute - us this mode to complete the rollback process, where the application validates and executes the Rollback. You can run the process only once in the Validate and Execute mode.
Click Launch Rollback to submit the OTL: Rollback Timecards from Projects Accounting.
Rolling back Timecards using the OTL: Rollback Timecards from Projects Accounting process
In the Submit Requests window, enter OTL: Rollback Timecards from Projects Accounting as the Name.
In the Parameters window, select the Rollback Mode. You can choose from:
Validate Only - use this to view information about how the rollback would have processed. This mode does not actually execute the rollback. You can run the process repeatedly in this mode without rolling back the timecards to validate your results.
Validate and Execute - us this mode to complete the rollback process, where the application validates and executes the Rollback. You can run the process only once in the Validate and Execute mode.
Select the Rollback Method. You can choose from:
Validate mode - use this to view information about how the rollback would have processed. This mode does not actually execute the rollback. You can run the process repeatedly in this mode without rolling back the timecards to validate your results.
Validate and Execute - us this mode to complete the rollback process, where the application validates and executes the Rollback. You can run the process only once in the Validate and Execute mode.
Enter the Start Dateand the End Date to define a date range for the rollback. This is a mandatory field and cannot be left blank.
Optionally select an Organization to select an Organization for rolling back timecards.
Optionally, select a Person to roll back timecards.
Click OK and Submit your request.