Shipment and Booking History -Self Service to load not Populating t_src_item_tmpl
By JeffG-Oracle on Aug 14, 2012
I am running EBS Collections: Legacy Systems > Shipment and Booking History -Self Service to load DemHistory.dat sample data.
Only t_src_sales_tmpl table is populated, but t_src_item_tmpl and t_src_item_tmpl are not populated. This is expected, as I do
not have the same items and locations on EBS as this is sample data.
As per Implementation guide, Prior to launching this collection, complete ASCP collections for the legacy instance. I followed
document 402222.1 and downloaded QATempate. It includes many .dat files such as Category.dat, item.dat ....
1. Would you please advise if I need to load each set of *.dat file in order to load Booking&shipments data? Or only specific .dat
files like TradingPartner.dat and Item.dat?
2. It seems the sample data from TradingPartner.dat does not match what in DemHistory.dat sample file. Is this expected?
Yes, for a legacy instance, user first needs to load the reference data - Items, Trading Partners, Trading Partner Sites, Demand Classes, Sales Channel.
For hierarchies - they need to load Item Categories, Regions and Zone etc.
1. User needs to load the dat files required for the reference data only.
2. I am not sure about this question. Does he mean that the example given in TradingPartner.dat and DemHistory.dat do not match ?
If yes, then ok.
For the actual data load, they need to load the customer and sites first, and then load sales data for them using DemHistory.dat.