Posts by Brahmaiah kolla

Query to get the tax type and tax accounts details.

SELECT hou.name Entity_name, tax_type_id, tax_type_code, tax_type_name, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=interim_recovery_ccid) interim_recovery_ccid, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=recovery_ccid) recovery_ccid, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=interim_liability_ccid) interim_liability_ccid, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=liability_ccid) liability_ccid FROM apps.jai_tax_types_v tv, apps.jai_tax_accounts…

Read More

Query to get ship to and Dist location mismatch invoices details.

select distinct hou.name,         a.org_id, a.invoice_id, a.invoice_num, a.invoice_date, a.attribute11 ship_to d.segment4 dist_loc, aps.vendor_name, apsa.vendor_site_code from apps.ap_invoices_all a, apps.ap_invoice_lines_all b, apps.ap_invoice_distributions_all c, apps.gl_code_combinations d, apps.hr_operating_units hou, apps.ap_suppliers aps,…

Read More

Query to get Accounting issue invoice details

select org_id, customer_trx_id, sum(tax) tax, sum(rev) rev, sum(rec) rec, sum(tax)+sum(rev) acutal_rec from ( select org_id, customer_trx_id, case when account_class=’TAX’ then sum(amount) else 0 end tax, case when account_class=’REV’ then sum(amount)…

Read More

Query to get the AR Netting details

select * from (select fnar.batch_id, fnar.customer_trx_id, rct.bill_to_customer_id cust_acct_id, rct.bill_to_site_use_id cust_site_use_id, fnar.ar_txn_rank, nvl(fnar.netted_amt,0) as netted_amt, fnb.batch_currency as reckoning_currency, rct.trx_number, rct.invoice_currency_code as transaction_currency, rctt.description as transaction_type, hp.party_name as cust_acct_name, hca.account_number as cust_acct_number,…

Read More

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