The p_datetract_update_mode control parameter
enables one to define the type of DateTrack deletion that has to be made. This parameter
is mandatory and must be set to one of
the following said values:
ZAP - Completely remove from the database
DELETE - Set end date to effective date
FUTURE_CHANGE - Remove all scheduled changes
DELETE_NEXT_CHANGE - Remove next change
ZAP - Completely remove from the database
DELETE - Set end date to effective date
FUTURE_CHANGE - Remove all scheduled changes
DELETE_NEXT_CHANGE - Remove next change
I'm trying to update effective_end_date using Hr_Person_Api.Update_Person API. But failed. I try to set DELETE as p_datetrack_update_mode but raise an error: ORA-20001: The datetrack update mode supplied is invalid. Please help.
ReplyDeleteThanks in advance.