You are browsing the archive for Sales & Marketing.

Update close_reason for Opportunities – Main

 

NAME: Update close_reason for Opportunities – Main
SHORT CODE: ASXADFOM
MODULE: Oracle Sales Foundation

Description: Update close_reason for Opportunities – Main
Navigation: Oracle Sales Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • X_OPEN_FLAG : The value of the open flag to be updated in the as_accesses_all table.
  • X_STATUS_CODE : The value of the status_code based on which the update will be done.
  • p_num_workers : Number of workers
  • p_batch_size : No of records which will get commited at one shot
  • p_debug_flag : Debug flag

 

Update as_accesses_all denorm flag for Leads and opportunity

 

NAME: Update as_accesses_all denorm flag for Leads and opportunity
SHORT CODE: ASXADFLO
MODULE: Oracle Sales Foundation

Description: Update as_accesses_all denorm flag for Leads and opportunity
Navigation: Oracle Sales Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • X_OPEN_FLAG : The value of the open flag to be updated in the as_accesses_all table
  • X_STATUS_CODE : The value of the status_code based on which the update will be done.
  • p_num_workers : Number of workers
  • p_batch_size : Batch size which is commited at one shot
  • p_debug_flag : Debug flag

 

Update close_reason for Leads – Main

 

NAME: Update close_reason for Leads – Main
SHORT CODE: ASXADFLM
MODULE: Oracle Sales Foundation

Description: Update close_reason for Leads – Main
Navigation: Oracle Sales Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • X_OPEN_FLAG : The value of the open flag to be updated in the as_accesses_all table
  • X_STATUS_CODE : The value of the status_code based on which the update will be done.
  • p_num_workers : Number of workers
  • p_batch_size : Number of records commited at one shot
  • p_debug_flag : Debug flag