You are browsing the archive for Logistics & Warehouse.

Generate Party List for Market Qualifiers

 

NAME: Generate Party List for Market Qualifiers
SHORT CODE: OZFGENPT
MODULE: Oracle Trade Management

Description: Program to generate party list for territory and buying groups
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_terr_id : territory id
  • p_bg_id : buying group subject id

 

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