Posts by Brahmaiah kolla

Display the multiple errors in OAF

import com.sun.java.util.collections.ArrayList; import oracle.apps.fnd.framework.OAException; import oracle.apps.fnd.common.MessageToken; ArrayList errorMsg= new ArrayList(); for (int i=0; i< hMember.size(); i++) { MessageToken[] token = {new MessageToken(“USER”, getOADBTransaction().getUserName()),new MessageToken(“NUM”,hMember.getChildNumber())}; errorMsg.add(new OAException((String)(getOADBTransaction().getMessage(“XXFKI”,”XXFKI_ERRORS”,token)))); } OAException.raiseBundledOAException(errorMsg);

Read More

How to change the column header dynamically in advance table.

To change the column of a header dynamically use the following code in your controller. import oracle.apps.fnd.framework.webui.beans.table.OAAdvancedTableBean; import oracle.apps.fnd.framework.webui.beans.table.OAColumnBean; import oracle.apps.fnd.framework.webui.beans.table.OASortableHeaderBean; OAAdvancedTableBean tableBean = (OAAdvancedTableBean)webBean.findIndexedChildRecursive(“VendordtlRN”); OAColumnBean columnBean = (OAColumnBean)tableBean.findIndexedChildRecursive(“SupplierID”); OASortableHeaderBean…

Read More

Lower Deduction Cost

Lower Deduction Cost Details Introduction: This report will provide LDC details. Cause of the issue: To get the remaining amount pan wise. How do we solve: So, extract the LDC…

Read More

Supplier Contact Details

Supplier Contact Details Introduction: This report will provide active supplier contact details. Cause of the issue: To apply TDS tax deduction against open invoice. How do we solve: So, extract…

Read More

OPM – Inventory Reconciliation Report

OPM – Inventory Reconciliation Report Introduction: This report will provide item wise inventory reconciliation value detail for period wise. Cause of the issue: Every month needs to be run the…

Read More

OPM – Intransit Value Report

OPM – Intransit Value Details Introduction: This report will provide item wise intransit value detail for period wise. Cause of the issue: Every month needs to be run the lot…

Read More

OPM – Work in Process Report

OPM – Work in Process Report Introduction: This report will provide Work in Process items detail period wise. Cause of the issue: Every month needs to be run the lot…

Read More

Deferred Cost of Goods Sold Report

Introduction: This report will provide deferred cost of the good sold. Cause of the issue: Every month needs to be run the lot of programs to process the transaction for…

Read More

Account Preprocessor Period details Query

SELECT DISTINCT glp.period_num, glp.period_name, glp.period_set_name, sts.start_date, sts.end_date, sts.closing_status, gsob.set_of_books_id, sts.set_of_books_id sts_sob_id, plcy.legal_entity_id, glp.period_year FROM gl_periods glp, gl_period_statuses sts, gl_sets_of_books gsob, gmf_fiscal_policies plcy WHERE glp.period_set_name = gsob.period_set_name AND glp.period_type = gsob.accounted_period_type…

Read More

Cost Comparison Report Of OPM

select Item_code ,Item_description ,round(Cost_in_Curr_Period,2)Cost_in_Curr_Period ,round(Cost_in_Comparison_Period,2)Cost_in_Comparison_Period ,round((Cost_in_Comparison_Period-Cost_in_Curr_Period),2)Cost_Varaice ,decode(Cost_in_Comparison_Period,0,0,(round(((Cost_in_Comparison_Period-Cost_in_Curr_Period)/Cost_in_Comparison_Period),2)*100)) Cost_Varaice_prec ,ORGANIZATION_CODE ,Current_period ,Comp_period from(select msi.SEGMENT1 Item_code ,msi.DESCRIPTION Item_description ,nvl(cst.ACCTG_COST,0) Cost_in_Curr_Period ,nvl((select cst1.ACCTG_COST from gl_item_cst cst1 ,gmf_period_statuses gps1 where 1=1 and cst1.INVENTORY_ITEM_ID=cst.INVENTORY_ITEM_ID and…

Read More