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

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Time and Labor - Version 11.5.10 and later
Information in this document applies to any platform.
***Checked for relevance on 23-NOV-2010***


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

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 hundreds of Community platforms