Comments for Forum - For Oracle Apps Customization and Extensions at http://apps2fusion.com , comment 1 to 48 out of 20 comments http://apps2fusion.com Sun, 14 Mar 2010 04:01:35 +0100 FeedCreator 1.7.3 http://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://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://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://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://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://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://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://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://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://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://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://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 http://apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-6419 Prior to some practical issues, I read and learned the theory. There is a good article in wiwapia.com - [url]http://wiwapia.com/en/linux[/url] . Afterwards everything becomes easier. - timert Mon, 18 May 2009 08:27:36 +0100 http://apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-6301 i want information about the file upload api in form - geetar Tue, 28 Apr 2009 09:34:09 +0100 http://apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-6258 Hi Anil This is the first time i am writing, I need your help. I need to develop a form Filed: Item: When user scans any Item (Barcode ) then Item should be populated. in the filed and in the details block - It should populate the Item,Description, quantity, Po# and Supplier. So user i wlll be scanning many items that means all the items with details must be populated in t he details block. Can you please suggest me how to go ahead. Please send me a mail to naveen.papineni@gmail.com if possible. Thank you Naveen - Naveen Mon, 20 Apr 2009 21:33:46 +0100 http://apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-6210 I want to run a concurrent request(a pdf report)through a special menu in POXPOEPO invokin FP. After giving the parameter for the request the request will be submitted. Then I want the FIND REQUEST Form to be displayed automatically as it happens when you submit a request through SRS Screen. How to do that through FP? - Utpal Fri, 10 Apr 2009 23:50:52 +0100 http://apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-6020 Hi All, I have to do Expense Report Import interface. Can you explain about how to import expense reports in IExpenses. Can you explain how to populate the interface tables? - RAMKUMAR A Thu, 05 Mar 2009 20:02:05 +0100 http://apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-5990 Anil, In our company we are upgrading Oracle Apps from 1158 to 12i. Can you tell me the process of converting suppliers from 1158 to 12i. Thanks, Vamsi - VamsiKrishna Sun, 01 Mar 2009 14:04:36 +0100 http://apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-5958 I am working in GE energy project.I would like to add 2 new fields in the notification summary.For example I have crreated one internal requisition and it needs to be approved and I would like to display the priority of the requisition and part number which is in the IR.it is not there n existing notification summary screen. Hi anilpassi and ranu , Pl help me on this issue. Regards, Bommudurai - Bommudurai Vairamuthu Thu, 19 Feb 2009 22:07:12 +0100 http://apps2fusion.com/apps/apps/326-oracle-apps-forum#comment-5954 Hi Anil I want to attach some SIT functions with the Employee Self Service Menu. could you please tell me what informations need to provide at Create Function screen, to create this SIT function whcih I need to attach at Employee Self Service function. I used seeded 'Special Information' function, and copied the same HTML call and Parameter for my custom function. when I click on this function from Employee self service Menu, I am geting an error. Error message I am geting is, Can not access function XXX_PASSPORT. This installation does not manage mode pl/sql. Please contact your System Administrator. Please suggest what is the issue and how to overcome from this. Regards Kartik T - Kartik T Thu, 19 Feb 2009 01:01:51 +0100