I was unable to get to specific section for OTL in the forum so posted this in General EBIZ Discussion.Let me if know if this is not the correct path for posting question related to Oracle Time and Labour.
The issue which I am facing is I m trying to created timecard for me and below is the 1st API which need to be called. Somehow in the logs post the API runs I can see that timecard block id is returne as -2 which doesn't look to be correct. It should ideally be a positive integer value. The API doesn't have lot of parameters and whatever it has are very basic data requirement. So am not sure what could be the issue or if I am missing something in any configuration. This is little urgent as we are going to bring legacy data to OTL for loading.
I tested by using apps_initialize as well but everytime it returns -2. I tried for Employee/CW both.
DECLARE
l_tbl_timecard_info hxc_self_service_time_deposit.timecard_info;
l_tc_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
BEGIN
hxc_timestore_deposit.create_timecard_bb
(p_start_time => TO_DATE('31-JAN-2021'),--Start_time,
p_stop_time => TO_DATE('06-FEB-2021'),--End_time,
p_resource_id => 181431, -- Employee Person ID
p_approval_style_id => 2, -- We want OTL Autoapprove, so using corresponding approval_style_id i.e. 2
p_comment_text => 'Created using API: Weekly Project TC',
p_app_blocks => l_tbl_timecard_info,
p_time_building_block_id => l_tc_bb_id);
COMMIT;
DBMS_OUTPUT.PUT_LINE('Success'||'-'||l_tc_bb_id);
EXCEPTION
WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('Error');
END;
Can some one assist on this and help if I am missing some configuration/profile or any other prerequisite