Hxc_timestore_deposit.Create_time_entry Errors With ORA-06502

Last updated on MAY 10, 2018

Applies to:

Symptoms

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

DECLARE
*
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
);

Cause