Hxc_timestore_deposit.Create_time_entry Errors With ORA-06502
Last updated on MAY 10, 2018
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
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