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 Moreselect * 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 Moreimport 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 MoreTo 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 MoreLower 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 MoreSupplier 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 MoreOPM – 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 MoreOPM – 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 MoreOPM – 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 MoreIntroduction: 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