You are browsing the archive for Oracle Sales Intelligence.

Load Sales Opportunity Base Summary

 

NAME: Load Sales Opportunity Base Summary
SHORT CODE: BIL_BI_OPTY_DTL_F_INIT
MODULE: Oracle Sales Intelligence

Description: Load Sales Opportunity Base Summary
Navigation: Oracle Sales Intelligence Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_from_date : Collection Start Date
  • p_truncate : Truncate Flag(Y/N)

 

Sales Forecast Base Summary Subworker

 

NAME: Sales Forecast Base Summary Subworker
SHORT CODE: BIL_BI_FST_SUMWRK
MODULE: Oracle Sales Intelligence

Description: Sub Worker of Forecast Summary for DBI
Navigation: Oracle Sales Intelligence Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_worker_no : Sub Worker Number
  • p_insert_flag : Wether to insert into stage table or not

 

Load Sales Forecast Base Summary

 

NAME: Load Sales Forecast Base Summary
SHORT CODE: BIL_BI_FST_SUMINIT
MODULE: Oracle Sales Intelligence

Description: Initial Load of Forecast Summary for DBI.
Navigation: Oracle Sales Intelligence Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_from_date : Collection From Date
  • p_truncate : Truncate(Y/N)