You are browsing the archive for Oracle Trade Management.

Refresh Materialized View for Order Sales (Full Load)

 

NAME: Refresh Materialized View for Order Sales (Full Load)
SHORT CODE: OZFFBSMV
MODULE: Oracle Trade Management

Description: Refresh the Materialized View for Base Sales
Navigation: Oracle Trade Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_increment_mode : Specify if the refresh is incremental or full load

 

Refresh Materialized View

 

NAME: Refresh Materialized View
SHORT CODE: OZFEARNMV
MODULE: Oracle Trade Management

Description: Refresh Materialized Views for Promotional Payments and Indirect Inventorty Tracking
Navigation: Oracle Trade Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • mv_name : Name of the Materialized View

 

Claims Aging Populating

 

NAME: Claims Aging Populating
SHORT CODE: OZFCLAIMAGING
MODULE: Oracle Trade Management

Description: Populating Claims Aging records
Navigation: Oracle Trade Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_bucket_id :