Friday, January 25, 2013

Migration of OPM Tables from 11i

One of the hardest thing in migration is with the OPM Module, as Oracle has differentiated clearly the OPM items and Discrete items in R12. So if you are going to do report migration activity , you better start off with the OPM activity first.

 Here i would share some of my OPM migration activity.

 While doing the report / form personalization activity kindly take note of 11i details and ask functional team / OPM team for the functionality or process workflow then move into with the work. I will also share the R12 with 11i OPM tables as there are no specific 11i matching tables with R12.

11i 
1. gl_subr_tst_vw
 2. pm_btch_hdr
3. ic_tran_VW1
4. gme_batch_header_vw
5. IC_ITEM_MST
6. PMITS_QC_SAMPLES_V
7. PMIFV_LOT_LIST_V

R12 
1. gmf_xla_extract_headers
2. gmf_xla_extract_lines
3. MTL_material_transactions
4. MTL_system_items_b
5. MTL_TRANSACTION_REASONS
6. gmd_specifications_b
7. gmd_samples
8. GMD_QC_RESULTS_TREE_V
9. MTL_TRANSACTION_TYPES

No comments:

Post a Comment