Need Ship to Details and Item details in VRM Fact tables

User_JC1F2

Hi Team,

I am creating this Idea on basis of SR# 4-0001310008.

when we are trying to create with Item details/ship to customer details along with Revenue Management Subject areas (Financials - Revenue Management Contracts, Financials - Revenue Management Accounting Events, Financials - Revenue Management Accounting) we are seeing ~NOVALUE~ for ship to customer and item details.

following columns in Fact tables are populating as -99999

OAX$OAC.DW_VRM_SLA_PERF_OBLIG_LIN_DISTS_CF_SEC.SRC_DOC_LINES_SHIP_TO_CUSTOMER_PARTY_ID
OAX$OAC.DW_VRM_SLA_PERF_OBLIG_LIN_DISTS_CF_SEC.SRC_DOC_LINES_SHIP_TO_CUSTOMER_ID
OAX$OAC.DW_VRM_SLA_PERF_OBLIG_LIN_DISTS_CF_SEC.SRC_DOC_LINES_SHIP_TO_LOCATION_ID
OAX$OAC.DW_VRM_SLA_PERF_OBLIG_LIN_DISTS_CF_SEC.SRC_DOC_LINES_INVENTORY_ORG_ID
OAX$OAC.DW_VRM_SLA_PERF_OBLIG_LIN_DISTS_CF_SEC.PRICING_LINES_ITEM_ID

OAX$OAC.DW_VRM_ACCOUNTING_EVENTS_CF_SEC.SRC_DOC_LINES_SHIP_TO_CUSTOMER_PARTY_ID
OAX$OAC.DW_VRM_ACCOUNTING_EVENTS_CF_SEC.SRC_DOC_LINES_SHIP_TO_CUSTOMER_ID
OAX$OAC.DW_VRM_ACCOUNTING_EVENTS_CF_SEC.SRC_DOC_LINES_SHIP_TO_LOCATION_ID
OAX$OAC.DW_VRM_ACCOUNTING_EVENTS_CF_SEC.SRC_DOC_LINES_INVENTORY_ORG_ID
OAX$OAC.DW_VRM_ACCOUNTING_EVENTS_CF_SEC.PRICING_LINES_ITEM_ID

OAX$OAC.DW_VRM_PERF_OBLIGATION_LINES_CF_SEC.SRC_DOC_LINES_SHIP_TO_CUSTOMER_PARTY_ID
OAX$OAC.DW_VRM_PERF_OBLIGATION_LINES_CF_SEC.SRC_DOC_LINES_SHIP_TO_CUSTOMER_ID
OAX$OAC.DW_VRM_PERF_OBLIGATION_LINES_CF_SEC.SRC_DOC_LINES_SHIP_TO_LOCATION_ID
OAX$OAC.DW_VRM_PERF_OBLIGATION_LINES_CF_SEC.SRC_DOC_LINES_INVENTORY_ORG_ID
OAX$OAC.DW_VRM_PERF_OBLIGATION_LINES_CF_SEC.PRICING_LINES_ITEM_ID

request you to please check and populate these reference columns with valid values as these are showing wrong values now as this critical requirement for Business users

Thanks