My Oracle Support Banner

Hxc_timestore_deposit.Create_time_entry Errors With ORA-06502 (Doc ID 562668.1)

Last updated on JULY 13, 2020

Applies to:

Oracle Time and Labor - Version 11.5.10 and later
Information in this document applies to any platform.


Creating a timecard using the HXC_TIMESTORE_DEPOSIT.Create_Time_Entry API causes the following error:

ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.HXC_TIMESTORE_DEPOSIT", line 891
ORA-06512: at "APPS.HXC_TIMESTORE_DEPOSIT", line 1245
ORA-06512: at "APPS.HXC_TIMESTORE_DEPOSIT", line 1327
ORA-06512: at line 39

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Make sure there is a period in the past with no data.
2. Make sure that the period is farther back than the "Past Number of days" segment of the "Self Service Timecard Status that Allows User Edits" preference allows.
3. Run the following code...

HXC_TIMESTORE_DEPOSIT.Create_Time_Entry ( p_measure => 8
, p_day => fnd_date.canonical_to_date ('2007/11/12')
, p_resource_id => 23797
, p_resource_type => 'PERSON'
, p_comment_text => null
, p_deposit_process => 'OTL Deposit Process'
, p_app_blocks => l_tbl_timecard_info
, p_app_attributes => l_tbl_attributes_info
, p_time_building_block_id => l_bb_id




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

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