Demantra Forecast Not visible In ASCP and Export integration issue

Hi Team,

There is an problem for visiblity of forecast for an Item from demantra to ASCP.

Basically I have gone throught the Export integration profile for which export forecast Overide series which is exported and got populated in denorm table. I do see that the items for which final quantity which is entered is present in denorm table from there msd_upload_forecast proc is triggered and  ASCP is populated.

Now when I query for an item = Buy item defined and MRP planned , Consume and derive controlled attribute - which is not present in ASCP.

1. Basically when I query this in MRP plan which  when Order type = forecast , I could not see it in Plan data. At the same time I could not see this in Collected data. what could be possible reason?