NAME: Collect Bookings Fact
SHORT CODE: ISC_EDW_BOOKINGS_F
MODULE: Oracle Supply Chain Intelligence

Description: Collect Bookings Fact
Navigation: Oracle Supply Chain Intelligence Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• p_from_date : Collect From Date
• p_from_date : Collect From Date
• p_to_date : Collect To Date
• p_to_date : Collect To Date
• p_coll_flag : Collect only if ALL rows have valid conversion rates (Uom and Currency)

NAME: Load Backlog Fact
SHORT CODE: ISC_EDW_BACKLOGS_F_T
MODULE: Oracle Supply Chain Intelligence

Description: Load Backlog Fact
Navigation: Oracle Supply Chain Intelligence Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• p_fact_name : Fact name

NAME: Purge Backlog Fact
SHORT CODE: ISC_EDW_BACKLOGS_F_PURGE
MODULE: Oracle Supply Chain Intelligence

Description: Purges the Backlog Fact given a date range or a period from today.
Navigation: Oracle Supply Chain Intelligence Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• nb_of_days : Number of days of data to KEEP from today
• p_from_date : Purge Data From
• p_to_date : Purge Data To