You are browsing the archive for Oracle Sales Intelligence.

Delete Complete Data in Sales DBI Object

 

NAME: Delete Complete Data in Sales DBI Object
SHORT CODE: BIL_BI_TRUNC_OBJ
MODULE: Oracle Sales Intelligence

Description: Delete Complete Data in Sales DBI Object
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_obj_name : Object Name

 

Delete Partial Data From Sales DBI Object

 

NAME: Delete Partial Data From Sales DBI Object
SHORT CODE: BIL_BI_PURGE_OBJ
MODULE: Oracle Sales Intelligence

Description: Purge BIL Object Data
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_obj_name : Object Name
  • p_end_date : End Date of Purge

 

Load Sales Pipeline Base Summary

 

NAME: Load Sales Pipeline Base Summary
SHORT CODE: BIL_BI_PIPELINE_F
MODULE: Oracle Sales Intelligence

Description: Load Sales Pipeline 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_start_date : Collection Start Date
  • p_truncate : Purge Flag (Y/N)