cognos to oracle reports movement - technical perspective and approach
dear friends and mentors ,
I have to undertake an activity where cognos reports such as below :
Inventory Cycle Count Accuracy [Planner Code] (ICC 028 TCO Operational) |
Inventory Cycle Count Actual vs. Expected (ICC 027 TCO Operational) |
Inventory In Transit Details (IIT 034 TCO Operational) |
Inventory In Transit Value (IIT 024 TCO Operational) |
Inventory Transaction Account Details (TRX 033 TCO Operational) |
Inventory Transaction Details (TRX 018 TCO Operational) |
Inventory Transaction Details [Athens] (TRX 001 TCO Operational) |
Inventory Transaction Lot Split Merge Details (TRX 025 TCO Operational) |
Inventory Transaction WIP Assembly Completion (TRX 008 TCO Operational) |
Inventory Transaction WIP Assembly Completion by Commodity (TRX 054 Operational) |
are to be migrated to oracle ERP 11i production instance itself. this will involve creating rdfs and rtfs to display the information as displayed by above reports. However I am not very clear regarding the approach that i should take for accomplishing this , for example , my questions are :