You are browsing the archive for Concurrent Requests & Reports.

Task Purge Program

 

NAME: Task Purge Program
SHORT CODE: CACTKPUR
MODULE: Oracle CRM Foundation

Description: Standalone Task Purge Program
Navigation: Oracle CRM Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_creation_date_from : Start Date of the range for creation date
  • p_creation_date_to : End Date of the range for creation date
  • p_last_updation_date_from : Start Date of the range for last updation date
  • p_last_updation_date_to : End Date of the range for last updation date
  • p_planned_end_date_from : Start date of the range for planned end date
  • p_planned_end_date_to : End date of the range for planned end date
  • p_scheduled_end_date_from : Start Date of the range for scheduled end date
  • p_scheduled_end_date_to : End Date of the range for scheduled end date
  • p_actual_end_date_from : Start Date of the range for actual end date
  • p_actual_end_date_to : End Date of the range for actual end date
  • p_task_type_id : Task Type
  • p_task_status_id : Task Status
  • p_delete_closed_task_only : Flag to purge only closed tasks
  • p_delete_deleted_task_only : Flag to purge only soft deleted tasks
  • p_no

 

Child Task Purge Program

 

NAME: Child Task Purge Program
SHORT CODE: CACTKCHPUR
MODULE: Oracle CRM Foundation

Description: Child Concurrent Task Purge Program
Navigation: Oracle CRM Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_api_version : API version
  • p_init_msg_list : Intialize Message List
  • p_commit : Commit
  • p_worker_id : Worker Id
  • p_concurrent_request_id : Concurrent request Id

 

CAC SYNC PURGE/CLEANUP

 

NAME: CAC SYNC PURGE/CLEANUP
SHORT CODE: CACSYNCP
MODULE: Oracle CRM Foundation

Description:
Navigation: Oracle CRM Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Expiry : Purge data expiry # days since last update.