XML Publisher - Display Values Dynamically

In this section , i will explain how to display values dynamically column wise,

First Query your requirements and then consider that you have many organizations and more will be added later on stages. So you cannot go manually touch your design and add up the extra columns , this will hike up your work process. You can neglect it by following a simple method in BI Publisher.

First Draw up your table using the Wizard

Name	Sample	Number	Description
F NAME	SAMPLE	Number	DESCRIPTION  E

Then insert a column to the right and insert the organization field in between the for loop

Name	Sample	Number	Description	F  OU  E
F NAME	SAMPLE	Number	DESCRIPTION	F SOMEFIELD E E

Now double click on For loop (OU) and edit your xml from normal group to  Group_name;Column_name

Eg: <? for-each-grp:G_ORG;ORG ?>

And End it as 

<?end for-each-grp?>

After altering your xml script , you will finally get the output of OU column parallel format dynamically. 

R12 Views Set Display

We find many view tables showing empty or null records, as this is one of the advantage / performance increasing method that oracle has implemented in R12, but in 11i this feature is not made.

Showing off view tables will reduce the performance of the database , as these views are having records but does not show in the back-end. And this might get difficult for SCM / Finance Consultants to get the data.

To solve this simple pretty stuff , you have to run a small / simple procedure to activate the views. Just before you put your view table, execute the following line

" EXEC MO_GLOBAL.INIT('<TOP_NAME>') "  OR

" EXEC MO_GLOBAL.SET_CONTEXT_POLICY('S/M', ORG_ID) "

Where some of the TOP_NAME's are PO, ONT, AR, SQLAP. And S - Single / M - Multi Orgs.

Be advised , this method should not be followed while report development as this will affect most of your report's performance in short execution time will go up high.

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

Oracle Migration Tables - India Localization

Most annoying part in the migration of 11i to R12 is search of tables, so i will provide you some list where you can find some more tables for India localization.

Localization Tables

ja_in_receipt_tax_lines	JAI_RCV_LINE_TAXES
JAI_REGIMES	JAI_RGM_DEFINITIONS
JAI_RGM_REGNS	JAI_RGM_REGISTRATIONS
ja_in_po_line_location_taxes	JAI_PO_TAXES
ja_in_ap_tax_distributions	JAI_AP_MATCH_INV_TAXES
JA_IN_AP_FA_INV_DIST_ALL	JA_IN_AP_FA_INV_DIST_ALL_D
ja_in_ap_org_tan	JA_IN_AP_ORG_TAN_D
ja_in_pla	JAI_CMN_RG_PLA_TRXS
ja_in_rg23_part_ii	JAI_CMN_RG_23AC_II_TRXS
ja_in_customer_addresses	JAI_CMN_CUS_ADDRESSES
ja_in_ap_form16	JAI_AP_TDS_F16_HDRS_ALL
JA_IN_PLA_HDR	JAI_CMN_RG_PLA_HDRS
ja_in_hr_organization_units	JAI_CMN_INVENTORY_ORGS
ja_in_tax_codes	JAI_CMN_TAXES_ALL
ja_in_receipt_tax_lines	JAI_RCV_LINE_TAXES
ja_in_localization_errors	JAI_CMN_ERRORS_T
ja_in_tax_category_lines	JAI_CMN_TAX_CTG_LINES
ja_in_reqn_tax_lines	JAI_PO_REQ_LINE_TAXES
ja_in_po_line_locations	JAI_PO_LINE_LOCATIONS
ja_in_reqn_lines	JAI_PO_REQ_LINES
ja_in_so_lines	JAI_OM_OE_SO_LINES
Ja_In_Po_Vendor_Sites	JAI_CMN_VENDOR_SITES
JA_IN_MASS_TAX_UPDATE_REQ	JAI_CMN_MTAX_HDRS_ALL
ja_in_mass_tax_upd_req_details	JAI_CMN_MTAX_UPD_DTLS
ja_in_tax_pkg	JAI_CMN_TAX_DEFAULTATION_PKG
ja_in_so_picking_lines	JAI_OM_WSH_LINES_ALL
ja_in_receipt_lines	JAI_RCV_LINES
ja_in_gem_osp_hdr	JA_IN_GEM_OSP_HDR_260411
ja_in_rcv_receipt_lines_v	JAI_RCV_RECEIVE_LINES_V
ja_in_ra_customer_trx	JAI_AR_TRXS
ja_in_st_forms	JAI_CMN_ST_FORMS
ja_in_st_forms_hdr	JAI_CMN_STFORM_HDRS_ALL
ja_in_st_forms_dtl	JAI_CMN_ST_FORM_DTLS
ja_in_so_picking_tax_lines	JAI_OM_WSH_LINE_TAXES
ja_in_st_match_details	JAI_CMN_ST_MATCH_DTLS
ja_in_vendor_tds_info_hdr	JAI_AP_TDS_VENDOR_HDRS
JA_IN_RCV_ACCOUNTING_V	JA_IN_RCV_JOURNALS_B_NEW, JA_IN_RCV_JOURNALS_B_OLD, JAI_RCV_JOURNAL_ENTRIES
JA_IN_REGISTER_HDR	JAI_OM_OE_BOND_REG_HDRS
JA_IN_REGISTER_DTL	JAI_OM_OE_BOND_REG_DTLS
JA_IN_GEM_OSP_DTL	JAI_OPM_OSP_DTLS
JA_IN_GEM_TXN_EXT_HDR	JA_IN_GEM_TXN_EXT_HDR
JA_IN_WSH_DELIVERIES_V	WSH_NEW_DELIVERIES_V
ja_in_rg23_d	JAI_CMN_RG_23D_TRXS
ja_in_boe_dtl	JAI_CMN_BOE_DTLS
jai_rg_others	JAI_CMN_RG_OTHERS
JA_IN_RA_CUST_TRX_TAX_LINES	JAI_AR_TRX_TAX_LINES
ja_in_ra_customer_trx	JAI_AR_TRXS
JA_IN_RG_PERIOD_BALANCES	JAI_CMN_RG_PERIOD_BALS
ja_in_receipt_cenvat	JAI_RCV_CENVAT_CLAIMS
ja_in_mtl_system_items	JAI_INV_ITM_SETUPS
xla_ap_inv_ael_gl_v	JAI_AP_STREVIEW_AEL_GL_V

Blog's Plot !

Hello All,

Let me start with a short introduction about me.

I crawled out to this world on 88'th of 20th Century.

Went through the Education at my native and came out as an Engineer.

Worked as a Software Developer then shifted my career as an Oracle Consultant.

This Blog will completely engage with both Oracle (Techn. & Funcn.) and my Personal go through posts.

Hope you will have great time over here for informations !

d(^_^)b

Prashanth Loganda

Hope this blogging stuff helps others :D

This is Prashanth  Loganda !