You are browsing the archive for Concurrent Requests & Reports.

Auto create opportunity from sales lead

 

NAME: Auto create opportunity from sales lead
SHORT CODE: ASXAUOPP
MODULE: Oracle Sales Foundation

Description: Auto create opportunity from sales lead
Navigation: Oracle Sales Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_debug_mode :
  • p_trace_mode :

 

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