<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-2833436010938528932</id><updated>2026-09-11T18:22:09.940+05:30</updated><category term="Accounts Receivables"/><category term="Apps useful info"/><category term="AOL"/><category term="Accounts Payables"/><category term="General Ledger"/><category term="AppsTechnical"/><category term="XML Publisher"/><category term="DBA"/><category term="Financials"/><category term="Oracle Discoverer"/><category term="R12 Upgrade"/><category term="PL/SQL"/><category term="AppsDBA"/><category term="EBTax"/><category term="Form Personalization"/><category term="Manufacturing"/><category term="Web ADI"/><category term="Alert"/><category term="OAF"/><category term="12.2"/><category term="Fixed Assets"/><category term="Oracle Internet Expenses"/><category term="SLA"/><category term="Suppliers"/><category term="TCA"/><title type='text'>Oracle Applications, SQL, PL/SQL</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>147</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-339522507224899517</id><published>2023-06-26T15:02:00.007+05:30</published><updated>2023-06-26T15:02:42.482+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Accounts Payables"/><category scheme="http://www.blogger.com/atom/ns#" term="Suppliers"/><title type='text'>Script to list Bank accounts setup for Suppliers at any level</title><content type='html'>&lt;p&gt;&lt;b&gt;Background:&lt;/b&gt;&lt;br /&gt;The following script lists all the Bank Accounts set any level for each Supplier. Namely, Supplier Site level, Supplier Level, Address + OU level, Address level&lt;/p&gt;&lt;p&gt;&lt;b&gt;SQL Script:&lt;/b&gt;&lt;/p&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;SELECT &#39;Bank Account at Supplier Site Level&#39; AcctLevel,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;sup.segment1 vendor_num,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;sup.vendor_name,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;epa.org_id,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ss.vendor_site_code,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;NULL Party_Site_Code,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;eba.bank_account_num,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;piu.order_of_preference priority,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;eba.ext_bank_account_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; FROM ap_suppliers&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; sup,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ap_supplier_sites_all&amp;nbsp; &amp;nbsp;ss,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;iby_external_payees_all epa,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;iby_pmt_instr_uses_all&amp;nbsp; piu,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;iby_ext_bank_accounts&amp;nbsp; &amp;nbsp;eba&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp;WHERE sup.vendor_id = ss.vendor_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND ss.vendor_site_id = epa.supplier_site_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND epa.ext_payee_id = piu.ext_pmt_party_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND piu.instrument_id = eba.ext_bank_account_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;UNION&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;SELECT &#39;Bank Account at Supplier Level&#39;,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;sup.segment1 vendor_num,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;sup.vendor_name,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;epa.org_id,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;NULL,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;NULL,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;eba.bank_account_num,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;piu.order_of_preference priority,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;eba.ext_bank_account_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; FROM ap_suppliers&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; sup,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;iby_external_payees_all epa,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;iby_pmt_instr_uses_all&amp;nbsp; piu,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;iby_ext_bank_accounts&amp;nbsp; &amp;nbsp;eba&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp;WHERE sup.party_id = epa.payee_party_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND epa.ext_payee_id = piu.ext_pmt_party_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND piu.instrument_id = eba.ext_bank_account_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND supplier_site_id IS NULL&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND party_site_id IS NULL&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;UNION&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;SELECT &#39;Bank Account at Address + Operating Unit Level&#39;,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;sup.segment1 vendor_num,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;sup.vendor_name,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;epa.org_id,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;NULL,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;psite.party_site_name,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;eba.bank_account_num,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;piu.order_of_preference priority,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;eba.ext_bank_account_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; FROM ap_suppliers&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; sup,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;hz_party_sites&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; psite,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;iby_external_payees_all epa,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;iby_pmt_instr_uses_all&amp;nbsp; piu,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;iby_ext_bank_accounts&amp;nbsp; &amp;nbsp;eba&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp;WHERE sup.party_id = psite.party_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND psite.party_site_id = epa.party_site_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND epa.ext_payee_id = piu.ext_pmt_party_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND piu.instrument_id = eba.ext_bank_account_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND supplier_site_id IS NULL&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND epa.org_id IS NOT NULL&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;UNION&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;SELECT &#39;Bank Account at Address Level&#39;,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;sup.segment1 vendor_num,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;sup.vendor_name,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;epa.org_id,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;NULL,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;psite.party_site_name,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;eba.bank_account_num,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;piu.order_of_preference priority,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;eba.ext_bank_account_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; FROM ap_suppliers&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; sup,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;hz_party_sites&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; psite,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;iby_external_payees_all epa,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;iby_pmt_instr_uses_all&amp;nbsp; piu,&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;iby_ext_bank_accounts&amp;nbsp; &amp;nbsp;eba&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp;WHERE sup.party_id = psite.party_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND psite.party_site_id = epa.party_site_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND epa.ext_payee_id = piu.ext_pmt_party_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND piu.instrument_id = eba.ext_bank_account_id&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND supplier_site_id IS NULL&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp; &amp;nbsp;AND epa.org_id IS NULL&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;&amp;nbsp;ORDER BY vendor_num;&lt;/span&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/339522507224899517/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2023/06/script-to-list-bank-accounts-setup-for.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/339522507224899517'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/339522507224899517'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2023/06/script-to-list-bank-accounts-setup-for.html' title='Script to list Bank accounts setup for Suppliers at any level'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-1024266951026388664</id><published>2021-08-31T12:06:00.006+05:30</published><updated>2021-08-31T12:08:25.676+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="12.2"/><category scheme="http://www.blogger.com/atom/ns#" term="AppsDBA"/><title type='text'>12.2: Not able to download patch 32052267</title><content type='html'>&lt;p&gt;&lt;b&gt;Background:&lt;/b&gt;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;While we are upgrading our EBS system to 12.2, we needed the following patch&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;background-color: white; font-size: 14px; font-weight: 700; white-space: nowrap;&quot;&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;Patch 32052267: WLS PATCH SET UPDATE 10.3.6.0.210119&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;But when we try to download the patch, Oracle is not allowing to do so. It says&amp;nbsp;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;b style=&quot;background-color: white; color: #003d5b;&quot;&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;You do not have privileges to download Software Extended Support patches. See&amp;nbsp;&lt;a href=&quot;https://support.oracle.com/epmos/faces/DocContentDisplay?id=1369860.1&quot; target=&quot;_blank&quot;&gt;How Patches and Updates Entitlements Works&lt;/a&gt;&amp;nbsp;for more information.&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;p&gt;&lt;span face=&quot;Tahoma, Verdana, Helvetica, sans-serif&quot; style=&quot;background-color: white; font-size: 14px; font-weight: 700; white-space: nowrap;&quot;&gt;&lt;/span&gt;&lt;/p&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3HqynmO060YlTANJBNyGYQauwQrARq1bv9YNatTSBC_KkqkzalsZaNgSO4zQhmV3l7G2QBO9xLrNEUB9IndDrhGxE9qcdhTdOIbJubEoFFsBC_o3Vubtx5k0R_q6IHnhlMU1IKaTmFaY/&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img alt=&quot;&quot; data-original-height=&quot;284&quot; data-original-width=&quot;345&quot; height=&quot;240&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3HqynmO060YlTANJBNyGYQauwQrARq1bv9YNatTSBC_KkqkzalsZaNgSO4zQhmV3l7G2QBO9xLrNEUB9IndDrhGxE9qcdhTdOIbJubEoFFsBC_o3Vubtx5k0R_q6IHnhlMU1IKaTmFaY/&quot; width=&quot;292&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;&lt;b&gt;Solution:&lt;/b&gt;&lt;p&gt;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;background-color: white; font-size: 14px; white-space: nowrap;&quot;&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;Patch 32746843: WLS PATCH SET UPDATE 10.3.6.0.210420 FOR ORACLE E-BUSINESS SUITE&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;background-color: white; font-size: 14px; white-space: nowrap;&quot;&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;This patch contains the WebLogic Server (WLS) PSU 10.3.6.0.210420 (patch 32403651)&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;background-color: white; font-size: 14px; white-space: nowrap;&quot;&gt;&lt;span style=&quot;font-family: courier;&quot;&gt;EBS Customer has ability to download this patch.&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/1024266951026388664/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2021/08/background-while-we-are-upgrading-our.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/1024266951026388664'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/1024266951026388664'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2021/08/background-while-we-are-upgrading-our.html' title='12.2: Not able to download patch 32052267'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3HqynmO060YlTANJBNyGYQauwQrARq1bv9YNatTSBC_KkqkzalsZaNgSO4zQhmV3l7G2QBO9xLrNEUB9IndDrhGxE9qcdhTdOIbJubEoFFsBC_o3Vubtx5k0R_q6IHnhlMU1IKaTmFaY/s72-c" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-8791603282150716992</id><published>2017-12-01T17:28:00.004+05:30</published><updated>2018-08-31T14:05:01.229+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="AOL"/><category scheme="http://www.blogger.com/atom/ns#" term="Apps useful info"/><category scheme="http://www.blogger.com/atom/ns#" term="AppsDBA"/><category scheme="http://www.blogger.com/atom/ns#" term="DBA"/><title type='text'>Sending email from Application Server</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Background:&lt;br /&gt;
It would be handy when we would like to email Output Files and Log Files to ourselves when we need them to debug&lt;br /&gt;
&lt;br /&gt;
Command:&lt;br /&gt;
Goto the respective [log/output] location and run following command&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;echo &amp;lt;email_body&amp;gt; | mailx -a &amp;lt;file_name1&amp;gt; -a &amp;lt;file_name2&amp;gt; -s &amp;lt;subject_line&amp;gt; abc.def@gmail.com&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/8791603282150716992/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2017/12/sending-email-from-application-server.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/8791603282150716992'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/8791603282150716992'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2017/12/sending-email-from-application-server.html' title='Sending email from Application Server'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-6852054356883094223</id><published>2017-11-20T15:25:00.002+05:30</published><updated>2017-11-20T15:25:54.580+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Alert"/><category scheme="http://www.blogger.com/atom/ns#" term="Apps useful info"/><category scheme="http://www.blogger.com/atom/ns#" term="DBA"/><title type='text'>How to check Workflow Notification Mailer is up or not</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Run the following query to check the status of all service components including &lt;i&gt;Workflow Notification Mailer&lt;/i&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;&amp;nbsp; SELECT sc.component_type,&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;sc.component_name,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;fnd_svc_component.get_component_status(sc.component_name) component_status&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; FROM fnd_svc_components sc&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;ORDER BY sc.component_type,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;sc.component_name;&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/6852054356883094223/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2017/11/how-to-check-workflow-notification.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/6852054356883094223'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/6852054356883094223'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2017/11/how-to-check-workflow-notification.html' title='How to check Workflow Notification Mailer is up or not'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-3228322875548701986</id><published>2017-02-22T14:42:00.000+05:30</published><updated>2017-02-23T11:14:09.914+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Accounts Payables"/><category scheme="http://www.blogger.com/atom/ns#" term="AppsTechnical"/><title type='text'>R12: Attach URL to AP Invoice through API/Script</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;b&gt;Background:&lt;/b&gt;&lt;br /&gt;
This post illustrates implementing attachment functionality in Oracle Applications through&amp;nbsp;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;fnd_webattch.add_attachment&lt;/span&gt; API&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Script:&lt;/b&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;declare&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; v_category_id NUMBER;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; v_description VARCHAR2(200) &amp;nbsp; &amp;nbsp; &amp;nbsp; := &#39;Attach the url to AP Inv&#39;;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; v_invoice_image_url VARCHAR2(200) := &#39;https://www.google.co.in&#39;;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; v_function_name VARCHAR2(50) &amp;nbsp; &amp;nbsp; &amp;nbsp;:= &#39;APXINWKB&#39;;--Invoice Form&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; v_entity_name VARCHAR2(50) &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;:= &#39;AP_INVOICES&#39;;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; v_invoice_id NUMBER;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; v_user_id NUMBER &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;:= fnd_global.user_id;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;begin&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; /*Set Org Context. Give Org_id accordingly*/&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; mo_global.set_policy_context(&#39;S&#39;,&amp;amp;Org_id);&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; /*Getting Category_id of &quot;FromSupplier&quot;.&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; Change it according to your requirement*/&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; SELECT category_id into v_category_id&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; FROM fnd_document_categories&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp;WHERE name &amp;nbsp;= &amp;nbsp;&#39;FromSupplier&#39;;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; /*Give appropriate Invoice number*/&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; SELECT invoice_id into v_invoice_id&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; FROM ap_invoices_all&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp;WHERE invoice_num = &#39;&amp;amp;Inv_num&#39;;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; fnd_webattch.add_attachment(&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; seq_num &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; =&amp;gt; 100&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;,category_id &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; =&amp;gt; v_category_id&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;,document_description &amp;nbsp; &amp;nbsp;=&amp;gt; v_description&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;,datatype_id &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; =&amp;gt; 5 --url&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;,text &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;=&amp;gt; NULL&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;,file_name &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; =&amp;gt; NULL&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;,url &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; =&amp;gt; v_invoice_image_url&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;,function_name &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; =&amp;gt; v_function_name&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;,entity_name &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; =&amp;gt; v_entity_name&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;,pk1_value &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; =&amp;gt; v_invoice_id&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;,pk2_value &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; =&amp;gt; NULL&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;,pk3_value &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; =&amp;gt; NULL&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;,pk4_value &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; =&amp;gt; NULL&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;,pk5_value &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; =&amp;gt; NULL&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;,media_id &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;=&amp;gt; NULL&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;,user_id &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; =&amp;gt; v_user_id&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;);&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;EXCEPTION&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;WHEN OTHERS THEN&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; raise_application_error (-20002, &#39;An error has occurred inserting attaching an url to the invoice.&#39;);&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;end;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Test:&lt;/b&gt;&lt;br /&gt;
Invoice Workbench &amp;gt; View &amp;gt; Attachments&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwe31fsutAzbsklAGCGjAxuGLrkUgWZTNEvQ-BO-9JgGlkDPX4TJfbkF_q7LEg4uCYnMN6r9pKwRavAJggCDVYoDgc5YFrPF3SX3Q5Hacv3qiGr_YRD3hnBmEKX0hIOVWC1CJRC9H-LYM/s1600/Attach1.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;246&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwe31fsutAzbsklAGCGjAxuGLrkUgWZTNEvQ-BO-9JgGlkDPX4TJfbkF_q7LEg4uCYnMN6r9pKwRavAJggCDVYoDgc5YFrPF3SX3Q5Hacv3qiGr_YRD3hnBmEKX0hIOVWC1CJRC9H-LYM/s640/Attach1.JPG&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRMo7euNRB3WZssa9Bhzd3_9hcFOLqyZboyfz87i0hlJefl3TgVHpupEiLfjymZiCINfWw-fHJ-N3V2rVxPvRc4UTWArIsQCDOKWh0CPIWHEkZ_GYOP4keKS5anRk4iB2nNs1cd2CpqZA/s1600/Attach2.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;240&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRMo7euNRB3WZssa9Bhzd3_9hcFOLqyZboyfz87i0hlJefl3TgVHpupEiLfjymZiCINfWw-fHJ-N3V2rVxPvRc4UTWArIsQCDOKWh0CPIWHEkZ_GYOP4keKS5anRk4iB2nNs1cd2CpqZA/s640/Attach2.JPG&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/3228322875548701986/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2017/02/r12-how-to-attach-url-to-ap-invoice.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/3228322875548701986'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/3228322875548701986'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2017/02/r12-how-to-attach-url-to-ap-invoice.html' title='R12: Attach URL to AP Invoice through API/Script'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwe31fsutAzbsklAGCGjAxuGLrkUgWZTNEvQ-BO-9JgGlkDPX4TJfbkF_q7LEg4uCYnMN6r9pKwRavAJggCDVYoDgc5YFrPF3SX3Q5Hacv3qiGr_YRD3hnBmEKX0hIOVWC1CJRC9H-LYM/s72-c/Attach1.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-5727227309109171861</id><published>2016-12-09T20:38:00.001+05:30</published><updated>2016-12-09T20:45:57.899+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Accounts Receivables"/><title type='text'>Script to get Profile Class and Credit Term of a Customer</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;b&gt;Background:&lt;/b&gt;&lt;br /&gt;
Following script when run shows Profile Class and Credit Term associated with &amp;nbsp;all active customers&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQDoDd4E8Z84ude76qnj2al_8qhRnhriQ-brQpi2oH-16Jyx5cFh7diiCMG38_W3TIpcJUAMdgOh2WLBm6_wLqopulPtEwurDKKshLnpVRTdGKAoZf2brRvaI93yTChp5TCUs2pV4raYs/s1600/CustPaymentTerm.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;268&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQDoDd4E8Z84ude76qnj2al_8qhRnhriQ-brQpi2oH-16Jyx5cFh7diiCMG38_W3TIpcJUAMdgOh2WLBm6_wLqopulPtEwurDKKshLnpVRTdGKAoZf2brRvaI93yTChp5TCUs2pV4raYs/s640/CustPaymentTerm.JPG&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;b&gt;Script:&lt;/b&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; select hca.account_number,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;hp.party_name,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;hcpc.name PROFILE_CLASS,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;rt.NAME CREDIT_TERM&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; from apps.ra_terms rt,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;apps.hz_cust_profile_classes hcpc,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;apps.hz_customer_profiles hcp,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;apps.hz_cust_accounts hca,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;apps.hz_parties hp&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp;where rt.term_id = hcp.standard_terms&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;and hcpc.profile_class_id = hcp.profile_class_id&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;and hcp.party_id = hca.party_id&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;and hca.party_id = hp.party_id&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;and hca.status = &#39;A&#39;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;order by hca.account_number;&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/5727227309109171861/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2016/12/script-to-get-profile-class-and-credit.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/5727227309109171861'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/5727227309109171861'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2016/12/script-to-get-profile-class-and-credit.html' title='Script to get Profile Class and Credit Term of a Customer'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQDoDd4E8Z84ude76qnj2al_8qhRnhriQ-brQpi2oH-16Jyx5cFh7diiCMG38_W3TIpcJUAMdgOh2WLBm6_wLqopulPtEwurDKKshLnpVRTdGKAoZf2brRvaI93yTChp5TCUs2pV4raYs/s72-c/CustPaymentTerm.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-1349083383590293886</id><published>2016-10-05T18:09:00.002+05:30</published><updated>2018-12-24T15:34:25.332+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Accounts Payables"/><category scheme="http://www.blogger.com/atom/ns#" term="EBTax"/><title type='text'>Scripts on EB Tax</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
1. Under General Tax Accounts, we give &lt;i&gt;Tax Recoverable/Liability account&lt;/i&gt; while creating the Tax Code. Here is the query/script to find out from database&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;SELECT zr.tax_rate_code,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;gcck.concatenated_segments&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;&amp;nbsp; FROM gl_code_combinations_kfv gcck,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;zx_rates_b zr,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;zx_accounts zc&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;&amp;nbsp;WHERE zc.tax_account_entity_code = &#39;RATES&#39;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;&amp;nbsp; &amp;nbsp;AND zc.tax_account_entity_id = zr.tax_rate_id&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;&amp;nbsp; &amp;nbsp;AND zc.tax_account_ccid = gcck.code_combination_id&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;&amp;nbsp; &amp;nbsp;AND zr.tax_rate_code = &#39;&amp;amp;Give_Tax_Code&#39;;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
2. SQL query to list all active Tax Codes&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;select tax_rate_code,&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;tax,&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;tax_regime_code,&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;tax_status_code,&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;percentage_rate,&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;rate_type_code,&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;effective_from,&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;effective_to&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; from apps.zx_rates_b&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp;where nvl(effective_to, sysdate) &amp;gt;= sysdate;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;Note:&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;R12: Recoverable Tax Setup and Transaction Flow in Payables (Doc ID 1280147.1)&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/1349083383590293886/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2016/10/script-to-list-tax-codes.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/1349083383590293886'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/1349083383590293886'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2016/10/script-to-list-tax-codes.html' title='Scripts on EB Tax'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-6892610278097485714</id><published>2016-08-11T14:48:00.003+05:30</published><updated>2016-09-29T16:29:33.732+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Accounts Payables"/><title type='text'>R12: Script to get Supplier Bank and Pay Group details</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;b&gt;Background:&lt;/b&gt;&lt;br /&gt;
&lt;div&gt;
When running the following script, it gives Supplier Name, Supplier Site Code, Pay Group, Branch Number, Bank Account Number and Bank Account Name&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;Script:&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;SELECT aps.vendor_name,&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;apss.vendor_site_code,&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;apss.pay_group_lookup_code,&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;iebb.branch_number,&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ieba.bank_account_num,&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ieba.bank_account_name&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; FROM apps.ap_suppliers aps,&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;apps.ap_supplier_sites_all apss,&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;apps.iby_ext_bank_accounts ieba,&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;apps.iby_account_owners iao,&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;apps.iby_ext_banks_v ieb,&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;apps.iby_ext_bank_branches_v iebb&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp;WHERE aps.enabled_flag = &#39;Y&#39;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp;and aps.vendor_id = apss.vendor_id&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp;and apss.inactive_date is null&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp;and iao.account_owner_party_id = aps.party_id&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp;and ieba.ext_bank_account_id = iao.ext_bank_account_id&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp;and ieb.bank_party_id = iebb.bank_party_id&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp;and ieba.branch_id = iebb.branch_party_id&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp;and ieba.bank_id = ieb.bank_party_id;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/6892610278097485714/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2016/08/r12-script-to-get-supplier-bank-and-pay.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/6892610278097485714'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/6892610278097485714'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2016/08/r12-script-to-get-supplier-bank-and-pay.html' title='R12: Script to get Supplier Bank and Pay Group details'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-5610806053423839115</id><published>2016-07-01T12:33:00.001+05:30</published><updated>2016-07-01T12:33:22.066+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Accounts Receivables"/><title type='text'>How to resubmit a Receipt Batch</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;b&gt;Background:&lt;/b&gt;&lt;br /&gt;
We have submitted a receipt batch and Process Status went to &quot;&lt;i&gt;Completed Approval&lt;/i&gt;&quot;.&lt;br /&gt;
But &quot;&lt;i&gt;Automatic Receipts Execution Report&lt;/i&gt;&quot; showed some Exception.&lt;br /&gt;
&lt;br /&gt;
We have fixed the exception/issue but when we tried to Submit a fresh Receipt Batch, it says there are no invoices/transactions. This is because these transactions are stuck with previous Receipt Batch.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Solution:&lt;/b&gt;&lt;br /&gt;
Update the &lt;i&gt;CC_ERROR_FLAG&lt;/i&gt; to &lt;i&gt;N&lt;/i&gt; in &lt;i&gt;RA_CUSTOMER_TRX_ALL&lt;/i&gt; for all these problematic Invoices/Transactions which are not being picked up.&lt;br /&gt;
&lt;br /&gt;
You may update the&amp;nbsp;CC_ERROR_FLAG&amp;nbsp;flag for all Invoices at one go using below script&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;update RA_CUSTOMER_TRX_ALL&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;&amp;nbsp; &amp;nbsp;set CC_ERROR_FLAG = &#39;N&#39;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;&amp;nbsp;where request_id = &amp;lt;Req_Id of &lt;i&gt;Automatic Receipts Creation Program (API)&lt;/i&gt;&amp;gt;;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
Then submit a &lt;i&gt;&lt;u&gt;fresh&lt;/u&gt;&lt;/i&gt; Receipt Batch.&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/5610806053423839115/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2016/07/how-to-resubmit-receipt-batch.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/5610806053423839115'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/5610806053423839115'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2016/07/how-to-resubmit-receipt-batch.html' title='How to resubmit a Receipt Batch'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-8115483575851049365</id><published>2016-05-11T16:11:00.005+05:30</published><updated>2016-05-11T16:15:35.019+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Apps useful info"/><category scheme="http://www.blogger.com/atom/ns#" term="AppsDBA"/><category scheme="http://www.blogger.com/atom/ns#" term="DBA"/><title type='text'>Concurrent Managers are not going up after bounce/switchover</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;b&gt;Background:&lt;/b&gt;&lt;br /&gt;
We have tried to Bounce/Switchover the application.&lt;br /&gt;
When the application is up, Concurrent Managers are still down&lt;br /&gt;
[&lt;i&gt;Navigation&lt;/i&gt;: System Administrator &amp;gt; Concurrent &amp;gt; Manager &amp;gt; Administer] &lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Root Cause:&lt;/b&gt;&lt;br /&gt;
&lt;i&gt;APPS&lt;/i&gt;, &lt;i&gt;APPLSYS&lt;/i&gt;, &lt;i&gt;APPLSYSPUB&lt;/i&gt; schema passwords went into &lt;u&gt;Expired (Grace)&lt;/u&gt; status&lt;u&gt;.&lt;/u&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Solution:&lt;/b&gt;&lt;br /&gt;
Change these schema passwords through FNDCPASS.&lt;br /&gt;
Concurrent Managers went up&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Intermediate Issue that occurred:&amp;nbsp;&lt;/b&gt;&lt;br /&gt;
We have tried to change the APPS schema password through FNDCPASS&lt;br /&gt;
But it is not changing password on EBS R12.1.3. No errors were reported in log.&lt;br /&gt;
We have followed Doc ID &lt;u&gt;1997559.1&lt;/u&gt; to fix this issue.&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/8115483575851049365/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2016/05/concurrent-managers-are-not-going-up.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/8115483575851049365'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/8115483575851049365'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2016/05/concurrent-managers-are-not-going-up.html' title='Concurrent Managers are not going up after bounce/switchover'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-4737652523809959827</id><published>2016-05-10T18:42:00.002+05:30</published><updated>2016-05-10T18:44:18.910+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Accounts Receivables"/><title type='text'>Script to list Receivable Activities</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;b&gt;Background:&amp;nbsp;&lt;/b&gt;&lt;br /&gt;
This script lists all the Receivable Activities.&lt;br /&gt;
Navigation: Setup &amp;gt; Receipts &amp;gt; Receivable Activities.&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiepYKnx8XbVvsgVBO30zW-EurUK9L6Jp7TO11chHFwqRdYtjQXuVC4YIrYrcqXsq2TkkrUK_Men1CAasboUDTfB09ZAfoGPardGmmgmbmUus0VQL2XivW4G-6aLg4dzLiNATbQeOK4_tI/s1600/ReceivablesActivities.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;203&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiepYKnx8XbVvsgVBO30zW-EurUK9L6Jp7TO11chHFwqRdYtjQXuVC4YIrYrcqXsq2TkkrUK_Men1CAasboUDTfB09ZAfoGPardGmmgmbmUus0VQL2XivW4G-6aLg4dzLiNATbQeOK4_tI/s400/ReceivablesActivities.JPG&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;b&gt;Script:&lt;/b&gt;&lt;br /&gt;
First set the &lt;u&gt;multi-org&lt;/u&gt;&lt;br /&gt;
&lt;i&gt;begin&lt;br /&gt;mo_global.set_policy_context(&#39;S&#39;,Org_id);&lt;br /&gt;end;&lt;/i&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;
then run the following script&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;select art.name, &lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; art.description,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; decode(art.type,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;EDISC&#39;, &#39;Earned Discount&#39;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;MISCCASH&#39;, &#39;Miscellaneous Cash&#39;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;ADJUST&#39;, &#39;Adjustment&#39;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;NETTING&#39;, &#39;Payment Netting&#39;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;UNEDISC&#39;, &#39;Unearned Discount&#39;, art.type) type,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; decode(art.gl_account_source, &lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;ACTIVITY_GL_ACCOUNT&#39;, &#39;Activity GL Account&#39;, &lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;TAX_CODE_ON_INVOICE&#39;, &#39;Tax Code On Invoice&#39;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; art.gl_account_source),&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; art.tax_code_source,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; gcc.concatenated_segments,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; art.asset_tax_code asset_tax_rate_code,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; art.liability_tax_code liability_tax_rate_code&lt;br /&gt;&amp;nbsp; from AR_RECEIVABLES_TRX art,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; GL_CODE_COMBINATIONS_KFV gcc&lt;br /&gt;&amp;nbsp;where art.status = &#39;A&#39;&lt;br /&gt;&amp;nbsp;&amp;nbsp; and art.code_combination_id = gcc.code_combination_id(+);&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/4737652523809959827/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2016/05/script-to-list-receivable-activities.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/4737652523809959827'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/4737652523809959827'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2016/05/script-to-list-receivable-activities.html' title='Script to list Receivable Activities'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiepYKnx8XbVvsgVBO30zW-EurUK9L6Jp7TO11chHFwqRdYtjQXuVC4YIrYrcqXsq2TkkrUK_Men1CAasboUDTfB09ZAfoGPardGmmgmbmUus0VQL2XivW4G-6aLg4dzLiNATbQeOK4_tI/s72-c/ReceivablesActivities.JPG" height="72" width="72"/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-4522159141814840607</id><published>2016-03-15T15:27:00.002+05:30</published><updated>2016-03-15T15:27:57.974+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Web ADI"/><title type='text'>Script to List all WebADI integrators</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Following script lists all the Seeded/Custom integrators available in WebADI.&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;&amp;nbsp; select ig.user_name integrator,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; fa.application_name application&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; from bne_integrators_vl ig, &lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; fnd_application_vl fa&lt;br /&gt;&amp;nbsp;&amp;nbsp; where ig.enabled_flag = &#39;Y&#39;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; and ig.application_id = fa.application_id&lt;br /&gt;order by ig.application_id;&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/4522159141814840607/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2016/03/script-to-list-all-webadi-integrators.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/4522159141814840607'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/4522159141814840607'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2016/03/script-to-list-all-webadi-integrators.html' title='Script to List all WebADI integrators'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-1255934927684959988</id><published>2016-01-06T18:13:00.000+05:30</published><updated>2016-01-06T18:18:28.812+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Accounts Payables"/><title type='text'>SQL script to find an AP invoice is validated or not</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;div&gt;
&lt;b&gt;Task:&lt;/b&gt;&lt;br /&gt;
How to find a AP invoice is validated or not through a SQL query&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Script:&lt;/b&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;SELECT i.invoice_id,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; i.invoice_amount,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DECODE(APPS.AP_INVOICES_PKG.GET_APPROVAL_STATUS(i.invoice_id, i.invoice_amount,i.payment_status_flag,i.invoice_type_lookup_code),&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;NEVER APPROVED&#39;, &#39;Never Validated&#39;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;NEEDS REAPPROVAL&#39;, &#39;Needs Revalidation&#39;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;CANCELLED&#39;, &#39;Cancelled&#39;, &lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;Validated&#39;) INVOICE_STATUS&lt;br /&gt;&amp;nbsp; FROM ap_invoices_all i&lt;br /&gt;&amp;nbsp;WHERE i.invoice_num = &#39;&amp;amp;Invoice_Number&#39;;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Notes:&lt;/b&gt;&lt;br /&gt;
Invoice Distributions are&amp;nbsp;validated individually and the status is 
stored at AP_INVOICE_DISTRIBUTIONS_ALL.match_status_flag&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-size: large;&quot;&gt;&lt;i&gt;Validated&lt;/i&gt;&lt;/span&gt;&lt;br /&gt;
&lt;i&gt;&lt;/i&gt;- If ALL of the invoice distributions have a MATCH_STATUS_FLAG = &#39;A&#39; &lt;br /&gt;
- If MATCH_STATUS_FLAG is &#39;T&#39; on ALL the distributions and org has no encumbrance enabled then Invoice would show Validated (provided there is no Unreleased Hold)&lt;br /&gt;
&lt;span style=&quot;font-size: large;&quot;&gt;&lt;i&gt;Never Validated&lt;/i&gt;&lt;/span&gt;&lt;br /&gt;
- If all of the invoice distributions have a MATCH_STATUS_FLAG = null or &#39;N&#39;&lt;br /&gt;
&lt;span style=&quot;font-size: large;&quot;&gt;&lt;i&gt;Needs Re-validation&lt;/i&gt;&lt;/span&gt;&lt;br /&gt;
- If any of the invoice distributions have a MATCH_STATUS_FLAG = &#39;T&#39; and the org has Encumbrance enabled&lt;br /&gt;
- If the invoice distributions have MATCH_STATUS_FLAG values = &#39;N&#39;, null and &#39;A&#39; (mixed)&lt;br /&gt;
- If the invoice distributions have MATCH_STATUS_FLAG value = &#39;S&#39; (stopped)&lt;br /&gt;
- If there are any rows in AP_HOLDS that do not have a release code&lt;br /&gt;
&lt;br /&gt;
MATCH_STATUS_FLAG would remain &#39;T&#39; if invoice has hold which does not allow Accounting. &lt;br /&gt;
As soon as Hold is released from Holds Tab/Invoice Workbench event status is set to &#39;U&#39;. &lt;br /&gt;
Invoice is shown as Validated and accounting is allowed. Match_Status_Flag still remains &#39;T&#39;.&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/1255934927684959988/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2016/01/sql-script-to-find-ap-invoice-is.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/1255934927684959988'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/1255934927684959988'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2016/01/sql-script-to-find-ap-invoice-is.html' title='SQL script to find an AP invoice is validated or not'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-7550675523056221217</id><published>2016-01-06T12:04:00.001+05:30</published><updated>2016-03-24T18:43:11.034+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Alert"/><category scheme="http://www.blogger.com/atom/ns#" term="AOL"/><category scheme="http://www.blogger.com/atom/ns#" term="AppsTechnical"/><title type='text'>Alert to list all Error Concurrent Programs in the previous day</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Task:&lt;br /&gt;
Configure an alert to list all the concurrent programs completed in Error everyday&lt;br /&gt;
&lt;br /&gt;
Solution:&lt;br /&gt;
1. Navigate to Alert Manager &amp;gt; Alert &amp;gt; Define&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAnjhu22prAlE9JwjIHGHx1vOjZJyZXYjO1Cc5gzdHpH9ouR4_0zUmOauiJoEqyG-nNQ1Eyy_wpScaNA4_UEbxqlPIHYJ672ADg_4BTVJDvi5N0sdBl_a-tfi0G-jhGCGvHdJUl-qeTNA/s1600/Alert.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;350&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAnjhu22prAlE9JwjIHGHx1vOjZJyZXYjO1Cc5gzdHpH9ouR4_0zUmOauiJoEqyG-nNQ1Eyy_wpScaNA4_UEbxqlPIHYJ672ADg_4BTVJDvi5N0sdBl_a-tfi0G-jhGCGvHdJUl-qeTNA/s640/Alert.JPG&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Name: XX Concurrent Request Monitor&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Frequency: Every N Calendar Days&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Days: 1&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Start Time: 00:00:00&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Keep: 1 Days [Very Important]&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Select Statement:&amp;nbsp;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
select FCR.request_id,&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;FU.user_name,&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;FCPT.user_concurrent_program_name,&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;to_char(FCR.actual_start_date,&#39;DD-MON-YYYY HH24:MI:SS&#39;),&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;to_char(FCR.actual_completion_date,&#39;DD-MON-YYYY HH24:MI:SS&#39;),&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;FCR.logfile_name&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; into &amp;amp;request_id,&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;amp;user_name,&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;amp;user_concurrent_program_name,&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;amp;actual_start_date,&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;amp;actual_completion_date,&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;amp;logfile_name&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; from fnd_concurrent_requests FCR,&amp;nbsp;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;fnd_concurrent_programs_tl FCPT,&amp;nbsp;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;fnd_user FU&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp;where FCR.program_application_id = FCPT.application_id&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp;and FCR.concurrent_program_id = FCPT.concurrent_program_id&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp;and FCR.requested_by = FU.user_id&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp;and FCR.phase_code=&#39;C&#39;&amp;nbsp;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp;and FCR.status_code = &#39;E&#39;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&amp;nbsp; &amp;nbsp;and FCR.actual_completion_date between TO_DATE (:DATE_LAST_CHECKED,&#39;DD-MON-YYYY HH24:MI:SS&#39;) and sysdate&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
order by 1&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
=&amp;gt; Save&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
2. Click on Actions&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYM3WYRQ3yBvXs_P5R2AXYf1zBxj-tn_uGHe0jbcZ1N0Qhdf3bn8_AOoONJayFsneEBDUegq3ZnqMkGUhDGy-ojWIOvpCR2-SvuAc9bWmygmD-kCaxwrRrhlhrfAPdvpbGd8PJmuDU5Bw/s1600/Actions.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;284&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYM3WYRQ3yBvXs_P5R2AXYf1zBxj-tn_uGHe0jbcZ1N0Qhdf3bn8_AOoONJayFsneEBDUegq3ZnqMkGUhDGy-ojWIOvpCR2-SvuAc9bWmygmD-kCaxwrRrhlhrfAPdvpbGd8PJmuDU5Bw/s640/Actions.JPG&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Action Name: XX Concurrent Request Monitor&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Action Level: Summary&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
3. Click on Action Details&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkv6CUM8bXmm9bzYVPPCyQ03ayvFRmI0eAIhLtZdy6lW_ysItv4QHUpCvud4LHaPpKzAZfMbQTyiYLn9nCdF0v_Wev2XonArBM2FymP4BkGzu1f_Yw0hymHTjxAzsjHToZtFVywbr1Pko/s1600/ActionDetails.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;424&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkv6CUM8bXmm9bzYVPPCyQ03ayvFRmI0eAIhLtZdy6lW_ysItv4QHUpCvud4LHaPpKzAZfMbQTyiYLn9nCdF0v_Wev2XonArBM2FymP4BkGzu1f_Yw0hymHTjxAzsjHToZtFVywbr1Pko/s640/ActionDetails.JPG&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Action Type: Message&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
To: Your email id. It could be a DL&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Subject: Email Subject&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Text:&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
Please check the following failed concurrent requests.&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
=**= Enter summary template below this line =**=&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
Request ID: &amp;amp;request_id&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
User Name: &amp;amp;user_name&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
Program Name: &amp;amp;user_concurrent_program_name&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
Start Time: &amp;amp;actual_start_date&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
End Time: &amp;amp;actual_completion_date&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
Log File: &amp;amp;logfile_name&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
***&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
=**= Enter summary template above this line =**=&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
4. Comeback to Alerts Screen. Click on Action Sets&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhU5P9sf5FX0wTAxBsdNGdPAnzCfOpKmlXpzo8AU8u1NgDOIh5SQceD4mq8k-NmwKC3hRCXzeKpGMu5Phx2zrBVXcZm7kt0IDftTjjx5GNjIIZEv9RRLYkAYXHY_Fog54D8dfU-6rTV1Ic/s1600/ActionSets.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;222&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhU5P9sf5FX0wTAxBsdNGdPAnzCfOpKmlXpzo8AU8u1NgDOIh5SQceD4mq8k-NmwKC3hRCXzeKpGMu5Phx2zrBVXcZm7kt0IDftTjjx5GNjIIZEv9RRLYkAYXHY_Fog54D8dfU-6rTV1Ic/s640/ActionSets.JPG&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Seq: 1&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Action Set Name: XX Concurrent Request Monitor&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
5. Click on Action Set Details. Click on Members Tab&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgslDgdUfbaq5cc9QHjxah-PcAiwwYdvNvgcnLRpg4LKafZmQVqQiqO5o5tM1V_WjMsHHcOT3IleNm9z_lHhQDfSYaphP3T3kE74hRk54XtBp8cvI_Vgk1WHzW_SSYlvgaNbLWXrZvwr-k/s1600/ActionSetDetails.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;240&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgslDgdUfbaq5cc9QHjxah-PcAiwwYdvNvgcnLRpg4LKafZmQVqQiqO5o5tM1V_WjMsHHcOT3IleNm9z_lHhQDfSYaphP3T3kE74hRk54XtBp8cvI_Vgk1WHzW_SSYlvgaNbLWXrZvwr-k/s640/ActionSetDetails.JPG&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Seq: 1&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Action: XX Concurrent Request Monitor&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Type: Action: Message&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
On Error Action: Abort&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
6. Comeback to the Alerts screen and click on Verify&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIo4nanw5Lsw3I3-yWeGkNVOKCbq1n8HXQul8ruqdhRyE_VX2xuciPV4tA5QMQkY_6koaCKXBGwo8i4pCtBduA3sn4YxMn-DsOS_DFEt4qwpDVI4EZiGfhlGb_5IzIGnaPndJPFzi7M90/s1600/Verify.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;123&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIo4nanw5Lsw3I3-yWeGkNVOKCbq1n8HXQul8ruqdhRyE_VX2xuciPV4tA5QMQkY_6koaCKXBGwo8i4pCtBduA3sn4YxMn-DsOS_DFEt4qwpDVI4EZiGfhlGb_5IzIGnaPndJPFzi7M90/s400/Verify.JPG&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
7. Click on Run&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioiP3HR7YHYfh04UIlrWe4CJG-VGbkGfi8oaX9hBta0s39V0iviVaZiXUNAT555aZTtxwxaya_mMzBzcyLWLSc2yU1P5s0HEpq1zF6k8pxbRlf40_QYkBEmRxLSmpKe83-reAh0zQ1rqk/s1600/Run.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;172&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioiP3HR7YHYfh04UIlrWe4CJG-VGbkGfi8oaX9hBta0s39V0iviVaZiXUNAT555aZTtxwxaya_mMzBzcyLWLSc2yU1P5s0HEpq1zF6k8pxbRlf40_QYkBEmRxLSmpKe83-reAh0zQ1rqk/s400/Run.JPG&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
8. Navigate to Alert Manager &amp;gt; Request &amp;gt; Check&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibIzxRpHzYtppvXMCL5iuGTR2g8cEJYKpBGdBDDc0h0aBEbN2WxvNCbPPcT1HCGN1-o56tWT8ieGo_pRfH5I_xxB7EtN6XHF6xms6Q6vXd8pyReKGr-JbQJ5IPfdCvhBb_Slze4pGhJ3Y/s1600/Run2.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;170&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibIzxRpHzYtppvXMCL5iuGTR2g8cEJYKpBGdBDDc0h0aBEbN2WxvNCbPPcT1HCGN1-o56tWT8ieGo_pRfH5I_xxB7EtN6XHF6xms6Q6vXd8pyReKGr-JbQJ5IPfdCvhBb_Slze4pGhJ3Y/s400/Run2.JPG&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Application: Alert&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Alert: XX Concurrent Request Monitor&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Start Date: Give date&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
[28-DEC-2015 00:00:00 mean this alert runs everyday at night 12 am starting 28th December]&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
Click on Submit Request&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;u&gt;Debugging steps if alerts are NOT firing:&lt;/u&gt;&lt;br /&gt;
1. Email Notifications are not Sent, and Mailer Log File Shows Error &quot;Replyto Must Be a Valid Email Address&quot; (Doc ID 743567.1)&lt;br /&gt;
2. Navigation: System Administrator &amp;gt; Oracle Applications Manager &amp;gt; Workflow &lt;br /&gt;
Make sure &lt;i&gt;Notification Mailers&lt;/i&gt;, &lt;i&gt;Agent Listeners&lt;/i&gt; are UP&lt;br /&gt;
3. Click on Service Components&lt;br /&gt;
Make sure &lt;i&gt;Workflow Notification Mailer&lt;/i&gt; is in &lt;i&gt;Running&lt;/i&gt; Status&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/7550675523056221217/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2016/01/alert-to-list-all-error-concurrent.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/7550675523056221217'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/7550675523056221217'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2016/01/alert-to-list-all-error-concurrent.html' title='Alert to list all Error Concurrent Programs in the previous day'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAnjhu22prAlE9JwjIHGHx1vOjZJyZXYjO1Cc5gzdHpH9ouR4_0zUmOauiJoEqyG-nNQ1Eyy_wpScaNA4_UEbxqlPIHYJ672ADg_4BTVJDvi5N0sdBl_a-tfi0G-jhGCGvHdJUl-qeTNA/s72-c/Alert.JPG" height="72" width="72"/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-8809018064720178877</id><published>2015-12-24T17:59:00.003+05:30</published><updated>2015-12-24T17:59:51.276+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Accounts Payables"/><title type='text'>R12: How to update Bank details of invoices having inactive/end dated Bank account</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;b&gt;Issue:&lt;/b&gt;&lt;br /&gt;
How To Change Supplier Bank Account Or Inactivate Bank Account, When Invoices For The Old Bank Account Exist?&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Solution:&lt;/b&gt; [Follow the steps in the same sequence]&lt;br /&gt;
1. Create Invoice Batch/Invoice. Validate. Account.&lt;br /&gt;
Make a note of &lt;i&gt;Remit-To Bank Account Number&lt;/i&gt;&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipiEL9PwlGbDdyX-KGb4ylkuw3s9-laK8dGOK8Fmbj4Wd9Gt2R1Zdicgs3lS9VwB0GeDjI3230U4N_QRuLXirXFC59SFT2PXzYQwUP3sbszTVmsHyNt_JQix2fsoJ-CUyAKZEF6VrcSuY/s1600/APInvoice.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;235&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipiEL9PwlGbDdyX-KGb4ylkuw3s9-laK8dGOK8Fmbj4Wd9Gt2R1Zdicgs3lS9VwB0GeDjI3230U4N_QRuLXirXFC59SFT2PXzYQwUP3sbszTVmsHyNt_JQix2fsoJ-CUyAKZEF6VrcSuY/s640/APInvoice.jpg&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
2. Navigate to the Supplier&lt;br /&gt;
Payables Manager &amp;gt; Suppliers &amp;gt; Entry &amp;gt; Query Supplier &amp;gt; Click on Banking Details&lt;br /&gt;
Create NEW Bank account.&lt;br /&gt;
&lt;br /&gt;
3. Now End Date the old Bank Account, which is noted in Step-1&lt;br /&gt;
Your receive following Warning.&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMWj9Tm5ECG_OttXnV3fWvU7cx2ZuwmwUuC8pv5e0u27R3zPTSCb2ryxheV5Ipu1_pEdAI1BrZD12vqdlpHn43LjyvLZcyyNinAM0kw-XLO8514zSSeyNodI3rCHYauisAe4zV8u4o-Qs/s1600/Warning.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;188&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMWj9Tm5ECG_OttXnV3fWvU7cx2ZuwmwUuC8pv5e0u27R3zPTSCb2ryxheV5Ipu1_pEdAI1BrZD12vqdlpHn43LjyvLZcyyNinAM0kw-XLO8514zSSeyNodI3rCHYauisAe4zV8u4o-Qs/s640/Warning.jpg&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
Warning: This bank account is attached to 1 documents payable. Would you like to 
replace the bank account in the documents payable with other available 
bank account as per priority&lt;br /&gt;
&amp;gt;&amp;gt; Click on Yes&lt;br /&gt;
&lt;br /&gt;
4. Go ahead and run PPR&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1zTW3pTjZCkGOyQQ9OUZCnxIoToURfdojba5aAjQ-W-YbsDLN5RegJ28fNuLyaGF7q-NazqCaEm1JwW5bSJf4pp9sOyzyZDurHo_ifiNzQPhxT6JnfoOlf-gxL9v7FfIilPBDwFi-fQ0/s1600/PPR.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;195&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1zTW3pTjZCkGOyQQ9OUZCnxIoToURfdojba5aAjQ-W-YbsDLN5RegJ28fNuLyaGF7q-NazqCaEm1JwW5bSJf4pp9sOyzyZDurHo_ifiNzQPhxT6JnfoOlf-gxL9v7FfIilPBDwFi-fQ0/s640/PPR.JPG&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
5. Now Invoice is fully paid. Query the same Invoice Batch and now you see NEW Bank details under Scheduled Payments tab (You can still see Old Bank details in the Header section of the Invoice)&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh27OfoIu8XbbTl3H-dO_W2G8Chorhy6Y5ku-NGdmy1wqoWcsRqAjW261pYl7dzRlsF_1bY7X7X-JkGqqEeD0vj3WS2LrF_7rB3U16mV6WirgggIJVqF5gEuuCwdRGMNofvNwAsoN-iNRk/s1600/OldNewBankAccts.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;390&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh27OfoIu8XbbTl3H-dO_W2G8Chorhy6Y5ku-NGdmy1wqoWcsRqAjW261pYl7dzRlsF_1bY7X7X-JkGqqEeD0vj3WS2LrF_7rB3U16mV6WirgggIJVqF5gEuuCwdRGMNofvNwAsoN-iNRk/s640/OldNewBankAccts.JPG&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/8809018064720178877/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2015/12/r12-how-to-update-bank-details-of.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/8809018064720178877'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/8809018064720178877'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2015/12/r12-how-to-update-bank-details-of.html' title='R12: How to update Bank details of invoices having inactive/end dated Bank account'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipiEL9PwlGbDdyX-KGb4ylkuw3s9-laK8dGOK8Fmbj4Wd9Gt2R1Zdicgs3lS9VwB0GeDjI3230U4N_QRuLXirXFC59SFT2PXzYQwUP3sbszTVmsHyNt_JQix2fsoJ-CUyAKZEF6VrcSuY/s72-c/APInvoice.jpg" height="72" width="72"/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-2466690087726260663</id><published>2015-12-08T17:25:00.000+05:30</published><updated>2015-12-08T17:30:00.558+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="DBA"/><title type='text'>How to Disable SSL on port 4443 at Apps level</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;b&gt;Background: &lt;/b&gt;&lt;br /&gt;
If you configure SSL at Load Balancer level in R12.1 Application, at 4443 port, SSL is exposed to the weak algorithms. This creates security vulnerability for the Application server.&lt;br /&gt;
To avoid this we need to disable SSL at port 4443.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Solution/Fix:&lt;/b&gt;&lt;br /&gt;
Please follow below steps:&lt;br /&gt;
&lt;br /&gt;
1. Make custom directory in template folder.&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Set Apps environment&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; cd $FND_TOP/admin/template;&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; mkdir custom;&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; cd custom;&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; cp $FND_TOP/admin/template/httpd_conf_1013.tmp .;&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; --Modify copied file as comment below line.&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; include &quot;%s_ora_config_home%/10.1.3/Apache/Apache/conf/ssl.conf&quot;&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; and save it.&lt;br /&gt;
&lt;br /&gt;
2. Run autoconfig at Apps tier&lt;br /&gt;
3. Stop application&lt;br /&gt;
4. Start application&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; now SSL (Port 4443) will not run.&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/2466690087726260663/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2015/12/how-to-disable-ssl-on-port-4443-at-apps.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/2466690087726260663'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/2466690087726260663'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2015/12/how-to-disable-ssl-on-port-4443-at-apps.html' title='How to Disable SSL on port 4443 at Apps level'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-8454762444373757148</id><published>2015-12-08T15:55:00.002+05:30</published><updated>2015-12-08T17:05:52.249+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Accounts Receivables"/><title type='text'>Automatic Receipts credit card transaction failed issue with Load Balancer</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;b&gt;Background:&lt;/b&gt;&lt;br /&gt;
Automatic Receipts Execution Report For Approval shows following error.&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;Authorization of credit card transaction failed. Failure in Authorization&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;i&gt;&lt;u&gt;Log file/FND Logs shows:&lt;/u&gt;&lt;/i&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;SSL url; setting wallet&lt;br /&gt;starting req&lt;br /&gt;err code=-28759&lt;br /&gt;err msg=ORA-28759: failure to open file&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Special Note:&lt;/b&gt;&lt;br /&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;We have Oracle Payments &lt;i&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;Minimum/Dummy Setup&lt;/span&gt;&lt;/i&gt; For Direct Debit Funds Capture Processing (Doc ID 471418.1) is in place!!&lt;/li&gt;
&lt;li&gt;We have configured SSL at Load Balancer level. Meaning URL is &quot;https&quot; rather than &quot;http&quot; &lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;b&gt;Solution/Fix:&lt;/b&gt;&lt;br /&gt;
Since SSL at Load Balancer level, system will require a database wallet to be created.&lt;br /&gt;
Follow following Oracle Note to fix the issue.&lt;br /&gt;
&lt;i&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;Automatic Receipts Fails With &quot;ORA-28759: failure to open file&quot; (Doc ID 1280022.1)&lt;/span&gt;&lt;/i&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/8454762444373757148/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2015/12/automatic-receipts-credit-card.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/8454762444373757148'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/8454762444373757148'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2015/12/automatic-receipts-credit-card.html' title='Automatic Receipts credit card transaction failed issue with Load Balancer'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-5427797899550261435</id><published>2015-09-07T18:50:00.001+05:30</published><updated>2015-09-07T18:54:11.700+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Accounts Receivables"/><title type='text'>AR to GL Query (For AR Receipt)</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Provide RECEIPT NUMBER to the following SQL query/Script.&lt;br /&gt;
It identifies the GL Batch, JE Category, Period, JE Source etc.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&lt;u&gt;Important:&lt;/u&gt;&lt;/b&gt;&lt;br /&gt;
Set &lt;i&gt;Org Context&lt;/i&gt; first&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;begin&lt;br /&gt;mo_global.set_policy_context(&#39;S&#39;,&amp;amp;Org_id);&lt;br /&gt;end;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;u&gt;&lt;b&gt;SQL Query:&lt;/b&gt;&lt;/u&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;SELECT gjb.name GL_batch_name,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; gjh.name Journal_Name,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; gjl.period_name,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; gjh.JE_CATEGORY,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; gjh.JE_SOURCE,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; gjh.currency_code,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DECODE (gjh.actual_flag, &#39;A&#39;, &#39;Actual&#39;,&#39;B&#39;, &#39;Budget&#39;,&#39;E&#39;, &#39;Encumbrance&#39;) Balance_Type,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DECODE (gjl.status,&amp;nbsp; &#39;P&#39;, &#39;Posted&#39;,&amp;nbsp; &#39;U&#39;, &#39;Unposted&#39;,&amp;nbsp; gjl.status) Batch_Status,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; gjh.posted_date,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; acra.receipt_number,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; acra.doc_sequence_value&lt;br /&gt;&amp;nbsp; FROM apps.gl_je_lines gjl,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; apps.gl_je_headers gjh,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; apps.gl_je_batches gjb,&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; apps.gl_import_references gir,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; apps.xla_ae_lines xal,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; apps.xla_ae_headers xah,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; apps.xla_events xe,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; apps.xla_transaction_entities xte,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; apps.ar_cash_receipts_all acra&lt;br /&gt;&amp;nbsp;WHERE gjb.je_batch_id&amp;nbsp; = gjh.je_batch_id&lt;br /&gt;&amp;nbsp;&amp;nbsp; and gjl.je_header_id = gjh.je_header_id&lt;br /&gt;&amp;nbsp;&amp;nbsp; and gjl.je_header_id = gir.je_header_id&lt;br /&gt;&amp;nbsp;&amp;nbsp; and gjl.je_line_num&amp;nbsp; = gir.je_line_num&lt;br /&gt;&amp;nbsp;&amp;nbsp; and gir.gl_sl_link_table = xal.gl_sl_link_table&lt;br /&gt;&amp;nbsp;&amp;nbsp; and gir.gl_sl_link_id&amp;nbsp;&amp;nbsp;&amp;nbsp; = xal.gl_sl_link_id&lt;br /&gt;&amp;nbsp;&amp;nbsp; and xal.application_id = xah.application_id&lt;br /&gt;&amp;nbsp;&amp;nbsp; and xal.ae_header_id&amp;nbsp;&amp;nbsp; = xah.ae_header_id&lt;br /&gt;&amp;nbsp;&amp;nbsp; --and xal.ae_line_num = 1&lt;br /&gt;&amp;nbsp;&amp;nbsp; and xah.application_id = xe.application_id&lt;br /&gt;&amp;nbsp;&amp;nbsp; and xah.event_id&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; = xe.event_id&lt;br /&gt;&amp;nbsp;&amp;nbsp; and xe.application_id = xte.application_id&lt;br /&gt;&amp;nbsp;&amp;nbsp; and xe.entity_id&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; = xte.entity_id&lt;br /&gt;&amp;nbsp;&amp;nbsp; and xte.application_id&amp;nbsp;&amp;nbsp;&amp;nbsp; = 222&lt;br /&gt;&amp;nbsp;&amp;nbsp; and xte.entity_code&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; = &#39;RECEIPTS&#39;&lt;br /&gt;&amp;nbsp;&amp;nbsp; and xte.source_id_int_1&amp;nbsp;&amp;nbsp; = acra.cash_receipt_id&lt;br /&gt;&amp;nbsp;&amp;nbsp; and trim(acra.receipt_number) = trim(&#39;&amp;amp;AR_receipt_number&#39;);&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: Times,&amp;quot;Times New Roman&amp;quot;,serif;&quot;&gt;&lt;b&gt;Note:&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Times,&amp;quot;Times New Roman&amp;quot;,serif;&quot;&gt;For AR to GL query for AR Transaction/Invoice refer below link&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;&lt;a href=&quot;http://orclapp.blogspot.in/2015/01/r12-ar-to-gl-query.html&quot;&gt;http://orclapp.blogspot.in/2015/01/r12-ar-to-gl-query.html&lt;/a&gt;&amp;nbsp;&lt;/span&gt;&lt;b&gt;&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt; &lt;/span&gt;&lt;/b&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/5427797899550261435/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2015/09/ar-to-gl-query-for-ar-receipt.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/5427797899550261435'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/5427797899550261435'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2015/09/ar-to-gl-query-for-ar-receipt.html' title='AR to GL Query (For AR Receipt)'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-5064952423191139889</id><published>2015-09-07T14:33:00.000+05:30</published><updated>2016-10-04T12:31:03.614+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="AOL"/><category scheme="http://www.blogger.com/atom/ns#" term="Apps useful info"/><category scheme="http://www.blogger.com/atom/ns#" term="AppsTechnical"/><title type='text'>How to find the version of a file through SQL script</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
Run the following SQL Script to find the version of the file from Oracle without touching Unix Box/Application Tier&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; SELECT fav.application_name,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;$&#39;||fav.basepath||&#39;/&#39;||af.subdir base_path,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; af.filename,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; afv.VERSION,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; afv.creation_date&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; FROM apps.ad_files af,&lt;br /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;, courier, monospace;&quot;&gt;apps.&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;, courier, monospace;&quot;&gt;ad_file_versions afv,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;, courier, monospace;&quot;&gt;apps.&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot;, courier, monospace;&quot;&gt;fnd_application_vl fav&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&amp;nbsp;&amp;nbsp; WHERE fav.application_short_name = af.app_short_name&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; AND afv.file_id = af.file_id &lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; AND af.filename IN (&#39;&amp;amp;Give_File_Name&#39;) --Eg.&#39;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;APXINWKB.fmb&lt;/span&gt;&#39;&lt;br /&gt;ORDER BY af.filename, afv.version DESC;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
File names could be anything say, &lt;i&gt;APXINWKB.fmb&lt;/i&gt; or &lt;i&gt;ARPRCPKB.pls&lt;/i&gt; or &lt;i&gt;APXVDVSR.rdf&lt;/i&gt; etc.&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/5064952423191139889/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2015/09/how-to-find-version-of-file-through-sql.html#comment-form' title='4 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/5064952423191139889'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/5064952423191139889'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2015/09/how-to-find-version-of-file-through-sql.html' title='How to find the version of a file through SQL script'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>4</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-7609321125206944337</id><published>2015-08-05T18:33:00.003+05:30</published><updated>2015-08-05T18:34:24.470+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Accounts Receivables"/><title type='text'>Automatic Receipts Creation Program (API) has poor performance</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;u&gt;Background:&lt;/u&gt;&lt;br /&gt;
We had a terrible performance issue with Automatic Receipts Creation Program (API) has poor performance program. After generating the level 12 trace and tkprof from it, it is evident that two important tables do not have updated stats.&lt;br /&gt;
&lt;br /&gt;
&lt;u&gt;Solution:&lt;/u&gt;&lt;br /&gt;
Gather stats for the following two important tables.&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;exec fnd_stats.gather_table_stats(&#39;IBY&#39;,&#39;IBY_FNDCPT_TX_OPERATIONS&#39;,PERCENT=&amp;gt;100,cascade=&amp;gt;True);&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;exec &lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;fnd_stats.gather_table_stats(&#39;IBY&#39;,&#39;IBY_TRXN_SUMMARIES_ALL&#39;,PERCENT=&amp;gt;100,cascade=&amp;gt;True);&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Note:&lt;/b&gt;&lt;br /&gt;
If it did not work for you,&lt;br /&gt;
1. Take the level-12 trace&lt;br /&gt;
2. Generate tkprof&lt;br /&gt;
3. Find out the costliest query and take appropriate action.&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/7609321125206944337/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2015/08/automatic-receipts-creation-program-api.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/7609321125206944337'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/7609321125206944337'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2015/08/automatic-receipts-creation-program-api.html' title='Automatic Receipts Creation Program (API) has poor performance'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-7256421071833419342</id><published>2015-06-04T19:39:00.004+05:30</published><updated>2020-06-04T11:33:24.116+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Apps useful info"/><title type='text'>Useful links from from other blogs</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;b&gt;General:&lt;/b&gt; &lt;br /&gt;
How to download Oracle Student Guides &lt;br /&gt;
&lt;a href=&quot;http://oracle.anilrpatil.com/2014/11/05/how-to-download-oracle-student-guides/&quot;&gt;http://oracle.anilrpatil.com/2014/11/05/how-to-download-oracle-student-guides/&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Soft Link or Symbolic Link &lt;br /&gt;
&lt;a href=&quot;http://oa-learning.blogspot.in/2011/10/soft-link-or-symbolic-link.html&quot;&gt;http://oa-learning.blogspot.in/2011/10/soft-link-or-symbolic-link.html&lt;/a&gt; &lt;br /&gt;
&lt;br /&gt;
How to register a custom table using script&lt;br /&gt;
&lt;a href=&quot;http://www.oracleappsnfusion.com/2014/02/register-custom-table-script.html&quot;&gt;http://www.oracleappsnfusion.com/2014/02/register-custom-table-script.html&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
The code execution cannot proceed because oranfsodm12.dll&lt;br /&gt;
&lt;a href=&quot;https://mistheorist.blogspot.com/2018/01/sqlloader-sqlldrexe-system-error.html&quot;&gt;https://mistheorist.blogspot.com/2018/01/sqlloader-sqlldrexe-system-error.html&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&lt;span style=&quot;font-family: &amp;quot;tahoma&amp;quot; , sans-serif; font-size: 10.5pt;&quot;&gt;Generating the log and
trace for self service/OAF issues (Doc ID 1564962.1)&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;GL:&lt;/b&gt;&lt;br /&gt;
All Profile Options in General Ledger&lt;br /&gt;
&lt;a href=&quot;http://docs.oracle.com/cd/E18727_01/doc.121/e13626/T451028T314712.htm#2219735&quot;&gt;http://docs.oracle.com/cd/E18727_01/doc.121/e13626/T451028T314712.htm#2219735&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;AP:&lt;/b&gt;&lt;br /&gt;
&lt;!--[if gte mso 9]&gt;&lt;xml&gt;
 &lt;o:OfficeDocumentSettings&gt;
  &lt;o:AllowPNG/&gt;
 &lt;/o:OfficeDocumentSettings&gt;
&lt;/xml&gt;&lt;![endif]--&gt;Payment for AP invoice in a different currency from the
invoice Currency R12.1.3 &lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;a href=&quot;https://community.oracle.com/thread/3722285?sr=stream&amp;amp;ru=2662565&quot;&gt;https://community.oracle.com/thread/3722285?sr=stream&amp;amp;ru=2662565&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Validate an IBAN&lt;br /&gt;
&lt;a href=&quot;http://www.ibancalculator.com/iban_validieren.html&quot;&gt;http://www.ibancalculator.com/iban_validieren.html&lt;/a&gt; &lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;br /&gt;
&lt;b&gt;BI Publisher:&lt;/b&gt;&lt;br /&gt;
How to Display Leading Zeros in XMLP Report – Excel Output&lt;br /&gt;
&lt;a href=&quot;http://oracleappsdna.com/2013/07/how-to-display-leading-zeros-in-xmlp-report-excel-output/&quot;&gt;http://oracleappsdna.com/2013/07/how-to-display-leading-zeros-in-xmlp-report-excel-output/&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
The macro cannot be found or has been disabled because of your Macro security settings &lt;br /&gt;
&lt;a href=&quot;http://damir-vadas.blogspot.in/2011/02/macro-cannot-be-found-or-has-been.html&quot;&gt;http://damir-vadas.blogspot.in/2011/02/macro-cannot-be-found-or-has-been.html&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Joining multiple queries in Data template XML Publisher&lt;br /&gt;
&lt;a href=&quot;http://oracleappsengineering.blogspot.com/2015/11/joining-multiple-queries-in-data.html&quot;&gt;http://oracleappsengineering.blogspot.com/2015/11/joining-multiple-queries-in-data.html&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Custom Web ADI (Download/Upload)&lt;br /&gt;
&lt;a href=&quot;http://abhayappssolution.blogspot.com/2015/09/custom-web-adi-downloadupload.html&quot;&gt;http://abhayappssolution.blogspot.com/2015/09/custom-web-adi-downloadupload.html&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;OAF&lt;/b&gt;&lt;br /&gt;
OA Framework Personalization&lt;br /&gt;
&lt;a href=&quot;https://blogs.oracle.com/manojmadhusoodanan/oa-framework-personalization&quot;&gt;https://blogs.oracle.com/manojmadhusoodanan/oa-framework-personalization&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
How to Enable Personalization link for OAF Pages&lt;br /&gt;
&lt;a href=&quot;https://blogs.oracle.com/prajkumar/how-to-enable-personalization-link-for-oaf-pages&quot;&gt;https://blogs.oracle.com/prajkumar/how-to-enable-personalization-link-for-oaf-pages&lt;/a&gt;&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/7256421071833419342/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2015/06/useful-links-from-from-other-blogs.html#comment-form' title='3 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/7256421071833419342'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/7256421071833419342'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2015/06/useful-links-from-from-other-blogs.html' title='Useful links from from other blogs'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>3</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-8776936388194201510</id><published>2015-06-04T19:32:00.002+05:30</published><updated>2015-06-04T19:37:27.361+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Apps useful info"/><title type='text'>Application Workbench is not opening after upgrading Java or IE</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;b&gt;This article solves following Issues:&lt;/b&gt;&lt;br /&gt;
1. Can&#39;t open Workbench after Java upgrade on my machine&lt;br /&gt;
2. How to open application workbench after installing Java 8 Update 45&lt;br /&gt;
3. After upgrading Java and while opening application following popup comes and after install it never goes beyond&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKfC45QSGXDd5g2Fg01sb98RTQqOXOzoc0T2UKeW9cGHBcyNEMX2tUZL60dRkLe6_5e9Hs-K99MTIPzSV1RTvgyxQpY06KV_X0MqwoiASUw9lPlcvTlsH6BJ9eQovHzGOxE4JGI1wY5UQ/s1600/error.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKfC45QSGXDd5g2Fg01sb98RTQqOXOzoc0T2UKeW9cGHBcyNEMX2tUZL60dRkLe6_5e9Hs-K99MTIPzSV1RTvgyxQpY06KV_X0MqwoiASUw9lPlcvTlsH6BJ9eQovHzGOxE4JGI1wY5UQ/s1600/error.JPG&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
4. Can NOT open application workbench in Internet Explorer [IE11]&lt;br /&gt;
5. While opening application in Firefox following application Error arises&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; ClassNotFoundException&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; oracle.apps.fnd.formsClient.FormsLauncher.class&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiuesP62am-PkGFhM4Idvawpf7TmQIQHBN3YfDWPvAhsf8syQPoNQuxst-ylV0BZ66T7vjlnyTheddhcyJ3mMFT-xySEnxU9fDMuyBG7HKutEKaxVVzwTM3lJkbw6dKgPIjfdsMSL7gug/s1600/firefox.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;123&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiuesP62am-PkGFhM4Idvawpf7TmQIQHBN3YfDWPvAhsf8syQPoNQuxst-ylV0BZ66T7vjlnyTheddhcyJ3mMFT-xySEnxU9fDMuyBG7HKutEKaxVVzwTM3lJkbw6dKgPIjfdsMSL7gug/s320/firefox.jpg&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;b&gt;Solution:&lt;/b&gt;&lt;br /&gt;
1. Download and Install latest java version (As of now it is Java 8 Update 45)&lt;br /&gt;
Go To ‘https://java.com/en/download/’&lt;br /&gt;
Click on ‘Free Java Download’ -&amp;gt; Then Agree and Start Free Download -&amp;gt; Then Install&lt;br /&gt;
&lt;br /&gt;
2. After installation, allow JAVA add-on in IE and Mozilla browsers&lt;br /&gt;
&lt;u&gt;IE: &lt;/u&gt;&lt;br /&gt;
Click the Tools button, and then click Manage Add-ons. Make sure Status is Enabled. &lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdlmhH5XDswi8XiEzpJ_5HuOJ0BEA5sSmHLqyohrVTPtEgiqVdEG9yAYwjVZftx0RYsbjg0n31sLv36cOe1f_2sLdlpOpL3Rp7FCdarm0Qus4qV4DVihRF-KZDlCL_JW48__Mp7BdogEc/s1600/IE.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;266&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdlmhH5XDswi8XiEzpJ_5HuOJ0BEA5sSmHLqyohrVTPtEgiqVdEG9yAYwjVZftx0RYsbjg0n31sLv36cOe1f_2sLdlpOpL3Rp7FCdarm0Qus4qV4DVihRF-KZDlCL_JW48__Mp7BdogEc/s640/IE.jpg&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;u&gt;Firefox:&lt;/u&gt;&lt;br /&gt;
Click on the Tools menu, and then click Add-ons &lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJxjXWPXX9GnkAZLKOzp3f8Wi2somUePaZXjWOi2d6so4iXlkotSVwbIgQkK-0cW_7iz6Ymjg_CdyJUZmUfEkjRzMv9f3fd3Y1Cx02vgO_lx3ozcGundvKdepu3jiEzP-UNwEt3631AKs/s1600/ff.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;210&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJxjXWPXX9GnkAZLKOzp3f8Wi2somUePaZXjWOi2d6so4iXlkotSVwbIgQkK-0cW_7iz6Ymjg_CdyJUZmUfEkjRzMv9f3fd3Y1Cx02vgO_lx3ozcGundvKdepu3jiEzP-UNwEt3631AKs/s640/ff.jpg&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
3. Goto Java Control Panel&lt;br /&gt;
Windows Start menu -&amp;gt; Click on Programs -&amp;gt; Find the Java program listing -&amp;gt; Click Configure Java to launch the Java Control Panel&lt;br /&gt;
[Refer this link for help &lt;a href=&quot;https://java.com/en/download/help/win_controlpanel.xml&quot;&gt;https://java.com/en/download/help/win_controlpanel.xml&lt;/a&gt;] &lt;br /&gt;
Click on &lt;i&gt;Java&lt;/i&gt; Tab&lt;br /&gt;
Add &lt;span style=&quot;color: red;&quot;&gt;&lt;i&gt;-Djava.vendor=&quot;Sun Microsystems Inc.&lt;/i&gt;&quot;&lt;/span&gt; in &lt;i&gt;Runtime Parameters&lt;/i&gt;&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirI15ggtklRteW6SKRcVmLf-C3OaQUd8QVhuMPYC2S2WSUX6lik0K2Wr0rGFbK51cSl1T7YceUkQPM4isLZtCBoFGZ2dafJ0kHFrDBtkdivku_zCwhVyL9HE6TMZ6gG1O2kz09N3gYRu8/s1600/JWB.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;358&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirI15ggtklRteW6SKRcVmLf-C3OaQUd8QVhuMPYC2S2WSUX6lik0K2Wr0rGFbK51cSl1T7YceUkQPM4isLZtCBoFGZ2dafJ0kHFrDBtkdivku_zCwhVyL9HE6TMZ6gG1O2kz09N3gYRu8/s640/JWB.jpg&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
4. Goto Security tab and click on Edit Site List.&lt;br /&gt;
Enter your application URL&#39;s there&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZvP_vyzijxQRASnRnVf8U07sUtq7PrNApsVJ-RPJFItFGoXIzPhSZUk_5D4r_eUUYb6CszhYB2dG38xJDR24Mrjbex6IreoGgXZoAEqytOjATgGcbuBekyiQWAH8UvbusIEkga39P1RI/s1600/IEexception.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;396&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZvP_vyzijxQRASnRnVf8U07sUtq7PrNApsVJ-RPJFItFGoXIzPhSZUk_5D4r_eUUYb6CszhYB2dG38xJDR24Mrjbex6IreoGgXZoAEqytOjATgGcbuBekyiQWAH8UvbusIEkga39P1RI/s400/IEexception.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
5. Click on Advanced tab&lt;br /&gt;
Uncheck TLS 1.1 and 1.2 (Check/Enable after applying the patches)&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZ1muu5BY0Cmb0BkO8rA0qoL2-EtmS__uZmUj7Zxpx5FKHpWk716bfUBjQLjxTQLPYeeDXCaH17NvubWDtJH43IBiTIPwKVJP59ckAl59cbb7GYvi3wPMUECkZmhJxW1tZzdAxObbZrqA/s1600/TLS.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;160&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZ1muu5BY0Cmb0BkO8rA0qoL2-EtmS__uZmUj7Zxpx5FKHpWk716bfUBjQLjxTQLPYeeDXCaH17NvubWDtJH43IBiTIPwKVJP59ckAl59cbb7GYvi3wPMUECkZmhJxW1tZzdAxObbZrqA/s400/TLS.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;b&gt;Questions&lt;/b&gt;? Please drop a comment. I will try to resolve.&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/8776936388194201510/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2015/06/this-article-solves-following-issues-1.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/8776936388194201510'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/8776936388194201510'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2015/06/this-article-solves-following-issues-1.html' title='Application Workbench is not opening after upgrading Java or IE'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKfC45QSGXDd5g2Fg01sb98RTQqOXOzoc0T2UKeW9cGHBcyNEMX2tUZL60dRkLe6_5e9Hs-K99MTIPzSV1RTvgyxQpY06KV_X0MqwoiASUw9lPlcvTlsH6BJ9eQovHzGOxE4JGI1wY5UQ/s72-c/error.JPG" height="72" width="72"/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-215352574832222812</id><published>2015-06-04T18:19:00.001+05:30</published><updated>2015-06-04T18:25:11.412+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Accounts Receivables"/><title type='text'>Script to resubmit Autoinvoice Master Program</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Background: &lt;br /&gt;
This article describes how to resubmit &lt;i&gt;Autoinvoice Master Program&lt;/i&gt; when the records are stuck in the RA_INTERFACE_LINES_ALL interface table&lt;br /&gt;
&lt;br /&gt;
SQL Script:&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;UPDATE ra_interface_lines_all&lt;br /&gt;&amp;nbsp;&amp;nbsp; SET interface_line_id = null,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; customer_trx_id = null,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; request_id = null,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; link_to_line_id = null&lt;br /&gt;&amp;nbsp;WHERE NVL(interface_status,&#39;z&#39;) &amp;lt;&amp;gt; &#39;P&#39;;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
Issue commit; Then re-run Autoinvoice program. &lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/215352574832222812/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2015/06/script-to-resubmit-autoinvoice-master.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/215352574832222812'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/215352574832222812'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2015/06/script-to-resubmit-autoinvoice-master.html' title='Script to resubmit Autoinvoice Master Program'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-1369805270742432630</id><published>2015-05-13T14:26:00.004+05:30</published><updated>2015-05-13T14:29:34.198+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Apps useful info"/><category scheme="http://www.blogger.com/atom/ns#" term="AppsTechnical"/><title type='text'>How to get list of all API&#39;s of a different modules</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Background:&lt;br /&gt;
This post describes to find appropriate API&#39;s under each module/responsibility for implementation.&lt;br /&gt;
&lt;br /&gt;
Solution:&lt;br /&gt;
Use &lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;&lt;i&gt;Integrated SOA Gateway&lt;/i&gt;&lt;/span&gt; responsibility and navigate to corresponding suite to find out detail APIs for each module.&lt;br /&gt;
&lt;br /&gt;
Please find detailed explanation as below. &lt;br /&gt;
Navigate to &lt;i&gt;Integrated SOA Gateway&lt;/i&gt; responsibility.&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEDO65BiXHi8Uvshw52v8lf77ZdQ4rnHUPYisamP3zp1CoK-CE2nOSZNKWyw2Pj2J_7dTwdv5Z2fb7n_kst_P1vm_K3XpWmd5cuoyctFSQ5BJwZycZyC3lFlJmvo6fIcqo-l-fx6gY0Yo/s1600/Resp.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;400&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEDO65BiXHi8Uvshw52v8lf77ZdQ4rnHUPYisamP3zp1CoK-CE2nOSZNKWyw2Pj2J_7dTwdv5Z2fb7n_kst_P1vm_K3XpWmd5cuoyctFSQ5BJwZycZyC3lFlJmvo6fIcqo-l-fx6gY0Yo/s1600/Resp.jpg&quot; width=&quot;273&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
Integration Repository home page looks like following&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijsG8rAcXzmfEvfRI3bD1Rrz6N-ckYC-DiO7yxILjk3myJj0BSp5Bc235NzRsZheOmkuWcbilzeeVmWBuui8B9T77nvKcS8PAtSh4L-IHKg9HoJocLYHUOnoheBJ4wfA9ab4F7MkO2lmM/s1600/API+Home.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;168&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijsG8rAcXzmfEvfRI3bD1Rrz6N-ckYC-DiO7yxILjk3myJj0BSp5Bc235NzRsZheOmkuWcbilzeeVmWBuui8B9T77nvKcS8PAtSh4L-IHKg9HoJocLYHUOnoheBJ4wfA9ab4F7MkO2lmM/s1600/API+Home.jpg&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
Navigate to appropriate Module and check for appropriate APIs&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHY7wqXJmR8gDkUjai_uERRoL9E-HmLsVlxaVvHwXoxDOKlmlWqma6m5uME9uPO2aR3yhSKUE6g_5tKvXd4vuiA8yvjpfAl43PunXjtbXjH40GfsnMbMlxldlvC6m4XBCJCuxboVv_jo0/s1600/API+List.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;280&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHY7wqXJmR8gDkUjai_uERRoL9E-HmLsVlxaVvHwXoxDOKlmlWqma6m5uME9uPO2aR3yhSKUE6g_5tKvXd4vuiA8yvjpfAl43PunXjtbXjH40GfsnMbMlxldlvC6m4XBCJCuxboVv_jo0/s1600/API+List.JPG&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
Click on Supplier APIs, it lists all the Supplier APIs available&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRROMs7BfGqDbylq78eehfT92FDuhQMWxJqai0Tn8jO782kWfeHCn941fedZlTjD_QEB6FJ3SRJG-f7IzPZsdFtp0rqHkKfkC7GxTct1xt4o1BK-_V3D6BOt3SWM7voVAokWSslvsxitg/s1600/Supplier+API.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;278&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRROMs7BfGqDbylq78eehfT92FDuhQMWxJqai0Tn8jO782kWfeHCn941fedZlTjD_QEB6FJ3SRJG-f7IzPZsdFtp0rqHkKfkC7GxTct1xt4o1BK-_V3D6BOt3SWM7voVAokWSslvsxitg/s1600/Supplier+API.JPG&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
To get more information on any API listed, just click on it. Here for example i have clicked on &lt;i&gt;Create Supplier&lt;/i&gt;&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidUIfhpaIGk3s3XWahGoH9yOVWHTghDVAxMGmdNAw1r3d5Lm2abS13gsHEBqsbDrdMX6i2R914X9un1QUvmPRHc6RveL7zsEDlzWcO0-PwYkTnjBUYmt0CvCVUetfLlOpPhdu-7fvvz2s/s1600/CreateSupplier.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;318&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidUIfhpaIGk3s3XWahGoH9yOVWHTghDVAxMGmdNAw1r3d5Lm2abS13gsHEBqsbDrdMX6i2R914X9un1QUvmPRHc6RveL7zsEDlzWcO0-PwYkTnjBUYmt0CvCVUetfLlOpPhdu-7fvvz2s/s1600/CreateSupplier.JPG&quot; width=&quot;640&quot; /&gt;&lt;/a&gt; &lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/1369805270742432630/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2015/05/how-to-get-apis-of-different-modules.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/1369805270742432630'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/1369805270742432630'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2015/05/how-to-get-apis-of-different-modules.html' title='How to get list of all API&#39;s of a different modules'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEDO65BiXHi8Uvshw52v8lf77ZdQ4rnHUPYisamP3zp1CoK-CE2nOSZNKWyw2Pj2J_7dTwdv5Z2fb7n_kst_P1vm_K3XpWmd5cuoyctFSQ5BJwZycZyC3lFlJmvo6fIcqo-l-fx6gY0Yo/s72-c/Resp.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2833436010938528932.post-535037123871690004</id><published>2015-04-22T15:49:00.004+05:30</published><updated>2015-04-22T16:22:36.437+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="General Ledger"/><title type='text'>Script to find GL Period Status</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;b&gt;Background:&lt;/b&gt;&lt;br /&gt;
Run the following script to lists all the periods of a year and their current status, who closed the period etc.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;SQL Script:&lt;/b&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;&amp;nbsp; SELECT gps.period_num,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; gps.Period_name,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; TO_CHAR(gps.START_DATE, &#39;DD-MON-YYYY&#39;) START_DATE,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; TO_CHAR(gps.END_DATE, &#39;DD-MON-YYYY&#39;) END_DATE,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; gps.quarter_num,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; gps.period_year,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DECODE (gps.closing_status,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;C&#39;, &#39;Closed&#39;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;O&#39;, &#39;Open&#39;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;F&#39;, &#39;Future - Entry&#39;,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;N&#39;, &#39;Never Opened&#39;) status,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DECODE(gps.adjustment_period_flag,&#39;N&#39;,&#39;No&#39;,&#39;Yes&#39;) ADJUSTMENT_PERIOD,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; gps.last_update_date,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; fu.user_name last_updated_by&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; FROM gl_period_statuses gps, &lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; fnd_user fu&lt;br /&gt;&amp;nbsp;&amp;nbsp; WHERE gps.period_year = &amp;amp;Enter_Year_YYYY&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; AND gps.application_id = 101&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; AND gps.last_updated_by = fu.user_id&lt;br /&gt;ORDER BY gps.period_year, gps.start_date;&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://orclapp.blogspot.com/feeds/535037123871690004/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://orclapp.blogspot.com/2015/04/script-to-find-gl-period-status.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/535037123871690004'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2833436010938528932/posts/default/535037123871690004'/><link rel='alternate' type='text/html' href='http://orclapp.blogspot.com/2015/04/script-to-find-gl-period-status.html' title='Script to find GL Period Status'/><author><name>Srini</name><uri>http://www.blogger.com/profile/02614419017216400419</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>