Why Is HXC_TIMESTORE_DEPOSIT API Not Changing the Timecard Status From WORKING to SUBMITTED, And Giving "HXC_AUDIT_MSG" Error (Doc ID 1997991.1)

Last updated on MARCH 31, 2023

Applies to:

Goal

You have a program which will pick timecards in WORKING status and change them to SUBMITTED status using API hxc_timestore_deposit.execute_deposit_process. 

1. Use the below API for a given timecard id:

 hxc_timestore_deposit.update_building_block(p_building_block_id =><timecard_id>,
                                                    p_app_blocks => l_timecard_blocks,
            p_app_attributes =>l_timecard_app_attributes);

2. Call below API to submit the timecard:

 hxc_timestore_deposit.execute_deposit_process ( p_validate=> FALSE,
  p_app_blocks=> l_timecard_blocks,
  p_app_attributes=> l_timecard_app_attributes,
  p_messages=> l_tbl_messages,
  p_mode=> 'SUBMIT',
  p_deposit_process=> 'OTL Deposit Process',
  p_timecard_id=> l_out_timecard_id,
  p_timecard_ovn=> l_out_timecard_ovn);

But even after this, timecard status does not change to SUBMITTED and the error message returned by API is HXC_AUDIT_MSG.

Why is it not working?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.