1 Reply Latest reply: Nov 5, 2012 11:47 AM by user8854370 RSS

    permisssion for executing procedure from different schema

    user488418
      Hi ,

      I am executing following procedure in different package and, I am getting error. Following procedure and error:
      Procedrue:
      DECLARE
      l_tbl_timecard_info APPS.HXC_self_service_time_deposit.timecard_info;
      l_tbl_attributes_info APPS.HXC_self_service_time_deposit.app_attributes_info;
      l_tbl_messages APPS.HXC_self_service_time_deposit.message_table;
      l_new_timecard_id NUMBER;
      l_new_timecard_ovn NUMBER;
      l_time_building_block_id APPS.HXC_time_building_blocks.time_building_block_id%TYPE;
      begin
      --FND_GLOBAL.APPS_INITIALIZE( user_id => 12345,resp_id => 56789,resp_appl_id => 809 );
      APPS.HXC_timestore_deposit.create_time_entry ( p_measure=> 7, p_day => APPS.fnd_date.canonical_to_date ('2002/09/02'), p_resource_id=> 9389, -- Identifies a person on our DB, REPLACE WITH YOUR IDs
      p_app_blocks=> l_tbl_timecard_info, p_app_attributes=> l_tbl_attributes_info, p_time_building_block_id=> l_time_building_block_id);
      end;
      /
      Error:

      Error starting at line 1 in command:
      DECLARE
      l_tbl_timecard_info APPS.HXC_self_service_time_deposit.timecard_info;
      l_tbl_attributes_info APPS.HXC_self_service_time_deposit.app_attributes_info;
      l_tbl_messages APPS.HXC_self_service_time_deposit.message_table;
      l_new_timecard_id NUMBER;
      l_new_timecard_ovn NUMBER;
      l_time_building_block_id APPS.HXC_time_building_blocks.time_building_block_id%TYPE;
      begin
      --FND_GLOBAL.APPS_INITIALIZE( user_id => 12345,resp_id => 56789,resp_appl_id => 809 );
      APPS.HXC_timestore_deposit.create_time_entry ( p_measure=> 7, p_day => APPS.fnd_date.canonical_to_date ('2002/09/02'), p_resource_id=> 9389, -- Identifies a person on our DB, REPLACE WITH YOUR IDs
      p_app_blocks=> l_tbl_timecard_info, p_app_attributes=> l_tbl_attributes_info, p_time_building_block_id=> l_time_building_block_id);
      end;
      Error report:
      ORA-00942: table or view does not exist
      ORA-06512: at "APPS.HXC_TIMESTORE_DEPOSIT_UTIL", line 1519
      ORA-06512: at "APPS.HXC_TIMESTORE_DEPOSIT_UTIL", line 1599
      ORA-06512: at "APPS.HXC_TIMESTORE_DEPOSIT", line 1233
      ORA-06512: at "APPS.HXC_TIMESTORE_DEPOSIT", line 1327
      ORA-06512: at line 10
      00942. 00000 - "table or view does not exist"
      *Cause:   
      *Action: