Skip to main content
Question

Aggregate historical data

  • October 10, 2024
  • 1 reply
  • 48 views

Rasika Lakmal
Superhero (Customer)
Forum|alt.badge.img+18

Does Demand Planning use 'SHIPTRAN' transactions as well when aggregating historical data from External_Invent_Part_Issue_Pub, or is it solely based on OESHIP transactions?

1 reply

Rasika Lakmal
Superhero (Customer)
Forum|alt.badge.img+18
  • Author
  • Superhero (Customer)
  • October 10, 2024

For an example, if I have a base flow like this SELECT Contract, Part_no, ISSUE_DATE, ISSUE_QTY FROM ifsapp.External_Invent_Part_Issue_Pub WHERE ISSUE_DATE > to_date ('2022-01-01','yyyy-mm-dd'); will it only consider OESHIP transactions or SHIPTRAN as well?