Comments for Forum - For Oracle Apps Customization and Extensions at http://www.apps2fusion.com , comment 1 to 56 out of 20 comments http://www.apps2fusion.com Tue, 07 Feb 2012 19:12:05 +0100 FeedCreator 1.7.3 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-10640 hi. i am new to apps pls forward some material about modules in technical consultant point of u - gautham47 Mon, 02 Jan 2012 23:34:54 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-10633 i have written a simple db trigger on rcv_transactions_interface table . my requirement is just to check whether the expected receipt date entered at create ASN page on shipment header tab should be sysdate. so i wrote simple before insert trigger on rcv_transactions_interface table . i tried to display error message using raise application error and also with fnd_message , but in vain . trigger fires exactly on the event but the message i am expecting isn't there. it gives me something like this .. Error Page You have encountered an unexpected error. Please contact the System Administrator for assistance. Click here for exception details. so i want to know why i m not getting the expected error ? - amol m k Wed, 28 Dec 2011 11:04:56 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-8605 hi anil, we are upgraded the 11.5.10.2 to R12, in our 11i custom self service report(payslip) its working fine using SSWA jsp function and oracleOasis.jsp function.. but the same report in R12 its not working, If I click the report, 'page cannot be displayed' ,,please help to me.. - k Wed, 24 Nov 2010 02:38:45 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-8013 I am working in cost variance report in GL module. I want in which table we will store expense like general expenses selling and distributions marketing expenses staff cost financial expenses depriciation others please send me to my mail-binayb30@gmail.com - binay Fri, 02 Jul 2010 00:54:28 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-7933 Hi Anil, first thanks for helping.... I am a trainee in oracle.i have started from D2K part.i hace completed my PL/SQL part.now i am moving on report builder.Could you please tell from where can read good report article and start on it Thanks with Regards Jitender Kumar - Jitender Kumar Sat, 19 Jun 2010 14:49:53 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-7805 hi. i am new to apps pls forward some material about modules in technical consultant point of u - sbabavalli Tue, 18 May 2010 00:23:06 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-7756 why is form personalization getting called first and not custom.pll? - Ambica Thu, 29 Apr 2010 01:20:32 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-7687 Afternoon Forum, We are R12.0.6 - and our users love using spaces (trailing & leading) in the invoice numbers. Would it be possible to add personalization that would either clear the spaces or prevent them from being captured? - Craig Wed, 14 Apr 2010 07:03:00 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-7552 hi, please help me how to upload customer data in oracle apps r12 wiht the help of interface and which data fillup in the below table colums .my mail id:- de.sanjit@gmail.com 1>RA_CUSTOMERS_INTERFACE_ALL(ORIG_SYSTEM_CUSTOMER_REF,SITE_USE_CODE ,CUSTOMER_NUMBER ,CUSTOMER_NAME ,CUSTOMER_STATUS,INSERT_UPDATE_FLAG ,ORIG_SYSTEM_ADDRESS_REF,PRIMARY_SITE_USE_FLAG,ADDRESS1,COUNTRY ,LOCATION) 2>RA_CUSTOMER_PROFILES_INT_ALL(CUSTOMER_PROFILE_CLASS_NAME,ORIG_SYSTEM_CUSTOMER_REF,NSERT_UPDATE_FLAG,CREDIT_HOLD,ORIG_SYSTEM_ADDRESS_REF) 3>RA_CONTACT_PHONES_INT_ALL (ORIG_SYSTEM_CUSTOMER_REF,ORIG_SYSTEM_TELEPHONE_REF,TELEPHONE,TELEPHONE_TYPE,INSERT_UPDATE_FLAG,ORIG_SYSTEM_ADDRESS_REF,ORIG_SYSTEM_CONTACT_REF,CONTACT_LAST_NAME) 4>RA_CUSTOMER_BANKS_INT_ALL(ORIG_SYSTEM_CUSTOMER_REF,PRIMARY_FLAG,START_DATE,BANK_ACCOUNT_NAME,BANK_ACCOUNT_CURRENCY_CODE,BANK_ACCOUNT_NUM,BANK_BRANCH_NAME,ORIG_SYSTEM_ADDRESS_REF) 5>RA_CUST_PAY_METHOD_INT_ALL(ORIG_SYSTEM_CUSTOMER_REF,START_DATE,ORIG_SYSTEM_ADDRESS_REF,PRIMARY_FLAG,PAYMENT_METHOD_NAME) - sanjit Tue, 09 Mar 2010 01:22:40 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-7511 Hi Anil, First i want to thank you for the information and help that you have provided. Now i have a query.We are using Oracle E Business suite's Product Life Cycle Management application. I need to extend the controller so that i can validate a attribute in one attribute group based on a attribute in another attribute group. Now i used the following code, OAApplicationModule oaapplicationmodule1 = oapagecontext.getRootApplicationModule(); OAApplicationModule oaapplicationmodule2 = EgoExtFwkUtil.findNestedAM(oaapplicationmodule1, "EgoExtFwkAM"); OAViewObjectImpl vo = (OAViewObjectImpl)oaapplicationmodule2.findViewObject("EGO_ITEMMGMT_GROUP431ATTRNAME"); Row row = vo.first(); System.out.println("Value - " + row.getAttribute("CExtAttr1")); This code prints the value which is available while rendering the page and not the value modified before submitting the page. Please suggest the VO to get the new or modified values. Thanks. - Jeno J Tue, 23 Feb 2010 07:02:07 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-7430 Hi Anil, I have seen lot of your post, your ideas and solutions are impeccable. I am in need of your help. We have a requirement in which an existing OAF page need to be customized. An additional feature for downloading a file need to be introduced.My question is , whether we need to extend AM,VO for this or simple modification of page ie enough, expecting your reply :) - Narain Thu, 04 Feb 2010 01:27:21 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-7190 Hi Anil, I have one quick question, Like i want to use BAM in my current project to generate reports. So May i know in detail like: How to install BAM, what are the basic steps we need to follow before install. Thanks Uma - uma maheswar Tue, 01 Dec 2009 01:16:28 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-7061 Anil, Please provide me some solution... Thanx in advance - Prasenjit Mon, 02 Nov 2009 01:45:00 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-7060 Hi Anil, Sorry about the previous thread..... I have a problem. Suppose, a supplier has two sites. One of the site is attached to a bank account, where the onther bank account is not attached to none of the site... So, there are two bank account. One is supplier level another is site level. Now, For a batch payment (In R12 for Payment Process Request), we have a requirement to find out the supplier associated with that batch payment alond with Supplier bank account number. Now, for Bank account at supplier site level,its not a problem.. Problem occurs for bank account at supplier level. When an invoice is created against that supplier site which is not attached to any bank account, upon payment of that invoice, money should go to default Supplier level bank account. But, for a bank account at supplier level the corresponding value of column supplier_site_id will be NULL in table iby_external_payees_all table. Now, how could I join an invoice which have a definite vendor_site_id to a Bank account having supplier_site_id as NULL in table iby_external_payees_all. I am attaching my query herewith. SELECT substr(v.NUM_1099,3, , UPPER(substr(V.VENDOR_NAME,1,30)) , ia.INVOICE_NUM , TO_CHAR(ch.check_date,'YYYYMMDD') , LPAD(TO_CHAR(ip.AMOUNT*100),11) , ieb.bank_account_type , DECODE(ieb.bank_account_type, '1', '000', '2', '000', cbbv.branch_number), substr(ieb.bank_account_num,1,3)||DECODE(ieb.bank_account_type,'1','','2','0','3','0')||substr(ieb.bank_account_num,5,length(ieb.bank_account_num)) , ' ' FLAG , ' ' FLAG1, DECODE(v.num_1099,'20913339','20209133394',substr(v.num_1099,1,11)) FROM hz_party_sites hps ,apps.iby_external_payees_all iep ,apps.iby_pmt_instr_uses_all ipi ,apps.iby_ext_bank_accounts ieb ,apps.ce_bank_branches_v cbbv ,ap_invoice_payments_all ip ,ap_checks_all ch ,ap_invoices_all ia ,Po_vendors v ,po_vendor_sites_all vs WHERE ieb.branch_id =cbbv.branch_party_id AND ieb.bank_id = cbbv.bank_party_id AND ieb.ext_bank_account_id = ipi.instrument_id AND ipi.ext_pmt_party_id = iep.ext_payee_id AND cbbv.branch_party_id = hps.party_id (+) --AND iep.supplier_site_id = vs.vendor_site_id AND iep.supplier_site_id vs.vendor_site_id AND iep.supplier_site_id IS NULL AND iep.payee_party_id = v.party_id AND ip.CHECK_ID = ch.CHECK_ID AND ip.INVOICE_ID = ia.INVOICE_ID AND ch.VENDOR_ID = v.VENDOR_ID AND ia.VENDOR_ID = vs.VENDOR_ID AND ia.VENDOR_SITE_ID = vs.VENDOR_SITE_ID AND ch.AMOUNT > 0 AND ch.CHECKRUN_NAME = '&1' AND trunc(SYSDATE) BETWEEN nvl(ipi.start_date,SYSDATE-1) AND nvl(ipi.end_date,SYSDATE+1) - Prasenjit Mon, 02 Nov 2009 01:43:48 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-7059 SELECT * FROM (/*This part is for site level bank*/ SELECT substr(v.NUM_1099,3,8) RUC, UPPER(substr(V.VENDOR_NAME,1,30)) PROVEEDOR, ia.INVOICE_NUM FACTURA, TO_CHAR(ch.check_date,'YYYYMMDD') FECHA, LPAD(TO_CHAR(ip.AMOUNT*100),11) IMPORTE, ieb.bank_account_type FORMA_PAGO, DECODE(ieb.bank_account_type, '1', '000', '2', '000', cbbv.branch_number) CODIGO_OFICINA, ieb.bank_account_num--substr(ieb.bank_account_num,1,3)||DECODE(ieb.bank_account_type,'1','','2','0','3','0')||substr(ieb.bank_account_num,5,length(ieb.bank_account_num)) CODIGO_CUENTA , ,' ' FLAG , ' ' MARCA, DECODE(v.num_1099,'20913339','20209133394',substr(v.num_1099,1,11)) NIT ,iep.payee_party_id ,iep.party_site_id ,iep.supplier_site_id ,iep.ext_payee_id FROM /*hz_party_sites hps*/ apps.iby_external_payees_all iep ,apps.iby_pmt_instr_uses_all ipi ,apps.iby_ext_bank_accounts ieb ,apps.ce_bank_branches_v cbbv ,ap_invoice_payments_all ip ,ap_checks_all ch ,ap_invoices_all ia ,Po_vendors v ,po_vendor_sites_all vs WHERE ieb.branch_id =cbbv.branch_party_id AND ieb.bank_id = cbbv.bank_party_id AND ieb.ext_bank_account_id = ipi.instrument_id AND ipi.ext_pmt_party_id = iep.ext_payee_id /* AND cbbv.branch_party_id = hps.party_id (+) */ --AND iep.supplier_site_id = vs.vendor_site_id AND iep.supplier_site_id=vs.vendor_site_id AND iep.payee_party_id = v.party_id AND ip.CHECK_ID = ch.CHECK_ID AND ip.INVOICE_ID = ia.INVOICE_ID AND ch.VENDOR_ID = v.VENDOR_ID AND ia.VENDOR_ID = vs.VENDOR_ID AND ia.VENDOR_SITE_ID = vs.VENDOR_SITE_ID AND ch.AMOUNT > 0 AND ch.CHECKRUN_NAME = '&1' AND trunc(SYSDATE) BETWEEN nvl(ipi.start_date,SYSDATE-1) AND nvl(ipi.end_date,SYSDATE+1) UNION /*This part is for supplier level bank*/ SELECT substr(v.NUM_1099,3,8) RUC, UPPER(substr(V.VENDOR_NAME,1,30)) PROVEEDOR, ia.INVOICE_NUM FACTURA, TO_CHAR(ch.check_date,'YYYYMMDD') FECHA, LPAD(TO_CHAR(ip.AMOUNT*100),11) IMPORTE, ieb.bank_account_type FORMA_PAGO, DECODE(ieb.bank_account_type, '1', '000', '2', '000', cbbv.branch_number) CODIGO_OFICINA, substr(ieb.bank_account_num,1,3)||DECODE(ieb.bank_account_type,'1','','2','0','3','0')||substr(ieb.bank_account_num,5,length(ieb.bank_account_num)) CODIGO_CUENTA , ' ' FLAG , ' ' MARCA, DECODE(v.num_1099,'20913339','20209133394',substr(v.num_1099,1,11)) NIT ,iep.payee_party_id ,iep.party_site_id ,iep.supplier_site_id ,iep.ext_payee_id FROM --hz_party_sites hps apps.iby_external_payees_all iep ,apps.iby_pmt_instr_uses_all ipi ,apps.iby_ext_bank_accounts ieb ,apps.ce_bank_branches_v cbbv ,ap_invoice_payments_all ip ,ap_checks_all ch ,ap_invoices_all ia ,Po_vendors v WHERE ieb.branch_id =cbbv.branch_party_id AND ieb.bank_id = cbbv.bank_party_id AND ieb.ext_bank_account_id = ipi.instrument_id AND ipi.ext_pmt_party_id = iep.ext_payee_id --AND cbbv.branch_party_id = hps.party_id AND iep.payee_party_id = v.party_id AND iep.supplier_site_id IS null AND ip.CHECK_ID = ch.CHECK_ID AND ip.INVOICE_ID = ia.INVOICE_ID AND ch.VENDOR_ID = v.VENDOR_ID AND ia.VENDOR_ID = v.VENDOR_ID AND ch.AMOUNT > 0 AND ch.CHECKRUN_NAME = '&1' AND trunc(SYSDATE) BETWEEN nvl(ipi.start_date,SYSDATE-1) AND nvl(ipi.end_date,SYSDATE+1)) - Prasenjit Mon, 02 Nov 2009 01:40:01 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-7054 I will write a step by step article on this. Cheers, Anil Passi - Anil Passi- Sat, 31 Oct 2009 06:46:46 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-7053 Hi Anil, I asked in many forum dint get any reply, I have lot of expectation from you. How Flex plugin work with OAF ? Thanks, Amin - Amin Fri, 30 Oct 2009 17:00:24 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-6889 HashMap phm = new HashMap() ; phm.put("ParamEmpid",param); phm.put("xxParammainAction",mainAction); pageContext.setForwardURL( "OA.jsp?page=/oracle/apps/ak/employee/webui/ManagePG" ,null //not needed as we are retaining menu context ,OAWebBeanConstants.KEEP_MENU_CONTEXT ,null //not needed as we are retaining menu context //,null ,phm //pass the hashMap that contains values for all of the parameters ,true //retain AM ,OAWebBeanConstants.ADD_BREAD_CRUMB_NO ,OAWebBeanConstants.IGNORE_MESSAGES); i had created this code and its showing one error.. error is Error(59,25): method setForwardURL(java.lang.String, null, byte, null, java.util.HashMap, boolean, java.lang.String, byte) not found in interface oracle.apps.fnd.framework.webui.OAPageContext - sajeesh babu.k Fri, 18 Sep 2009 06:09:07 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-6854 Hi, iProc/Purchasing does have an option where you are restrict requisitions access either to your department, yourself. I will really appreciate if you can provide some pointer which enable to put a control that users can access there and some specific departments only. eg- User A sees requsitions corresponding to Dep C , Dep B , Dept A (His Dept) User B sees requsitions corresponding to Dep A , Dep C , Dept B (His Dept) Thanks Abhishek - abhgaur Wed, 09 Sep 2009 15:35:06 +0100 http://www.apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-6492 HI anil, This is the error stack.. oracle.apps.fnd.framework.OAException: java.lang.NullPointerException at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1408) at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2637) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1659) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418) at _oa__html._OA._jspService(_OA.java:88) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119) at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417) at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267) at oracle.jsp.JspServlet.internalService(JspServlet.java:186) at oracle.jsp.JspServlet.service(JspServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet.java:588) at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456) at org.apache.jserv.JServConnection.run(JServConnection.java:294) at java.lang.Thread.run(Thread.java:534) ## Detail 0 ## java.lang.NullPointerException at vtk.oracle.apps.pos.asn.webui.VtkPosAsnCreateCO.processFormRequest(VtkPosAsnCreateCO.java:84) I am not able to find the exact reason. Even i copied the standard Co class created a new one just changing the path in redirect url for submitt button. It doesnt even extend any other class still i am getting this error. Regards k.kritika - kritika Wed, 03 Jun 2009 02:18:21 +0100