You are browsing the archive for Concurrent Requests & Reports.

Update LEAD_RANK_SCORE

 

NAME: Update LEAD_RANK_SCORE
SHORT CODE: ASXSLRS
MODULE: Oracle Sales Foundation

Description: Update lead_rank_score for as_sales_leads and as_accesses_all. This should be run from lead rank API only.
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_LEAD_RANK_ID : This lead_rank_id is to be updated.
  • X_LEAD_RANK_SCORE : This is new score of the rank.

 

Import Sales Leads

 

NAME: Import Sales Leads
SHORT CODE: ASXSLIMP
MODULE: Oracle Sales Foundation

Description: Batch prg. for importing sales leads
Navigation: Oracle Sales Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Source_System : Lead Source System
  • Debug_msg_flag : Debug Message Flag
  • Batch_id : Batch Identifier
  • Purge_errors_flag : Purge error messges table or not
  • Parent_request_id : Parent request identifier
  • Child_request_id : Child request identifier
  • Resource_id : Login user’s resource_id
  • Group_id : Login user’s group_id

 

Load Sales Lead Interface table from flat file (AS)

 

NAME: Load Sales Lead Interface table from flat file (AS)
SHORT CODE: ASXSFIMP
MODULE: Oracle Sales Foundation

Description: Import sales lead data into sales lead interface table from a flat file
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_DATAFILE : Data File