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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.