My Oracle Support Banner

Some Timecard Adjustments Are Not Getting Picked Up And Transferred (Doc ID 1436945.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Time and Labor - Version 12.1.3 to 12.1 HRMS RUP6 [Release 12.1]
Information in this document applies to any platform.


On  12.1

After running the retrieval process for adjusted timecards, find not all of the adjustments are being picked up - causing differences between the timecard and the downstream systems.

In analyzing the timecard building blocks that are out of sync, noticed that for the timecards with issues, that the time_building_block_id in the HXC_LATEST_DETAILS table reference object_version_number that does not exist and is one higher than the highest one in the hxc_time_building_blocks table.

Expect after retrieval, the number of hours in receiving modules and OTL should be the same.

The issue can be reproduced at will with the following steps:
1. Select a timecard that was successfully interfaced to Projects and BEE/Payroll
2. Adjust the timecard (in this example, changes hours entered on Thu to Vacation)
3. Run retro retrieval process for BEE/Payoll
4. Run projects retrieval process
5. Compare data in BEE/Payoll with timecard - NOT EQUAL
6. Compare data in Projects with timecard - NOT EQUAL


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.