Introduction: AP-query to get List of Suppliers which have not made payments since 2 years in Oracle EBS either invoice or payment. Query: select distinct a.vendor_id, b.ORG_ID, a.segment1 SUPPLIER_NUMBER, a.VENDOR_TYPE_LOOKUP_CODE…
Read MoreUser was unable to apply the 6 receipt to the invoices for UK and they were getting the below error , “Error message: FRM-40654: Record has been updated .Requery block…
Read Morebusiness noticed that the receipt application is missing and the missed transaction level balance is not updated .. means transaction is not applied any receipt but it is showing ZERO…
Read MoreEnviroment Details Primary Standby DB SID INDIA INDIA DB ROLE Primary Physical Standby DB Unique Name INDIA CHINA Server IP 192.168.25.159 192.168.25.158 DB Version 19.2.00 19.2.00 OS Oel7 Oel7 Switchover…
Read More1. Overview This document explains how to set dialogue page title dynamically. 2. Technologies and Tools Used The following technologies have been used to set page title dynamically. Oracle Apex JavaScript 3. Use…
Read MoreGST Query for Payables SELECT jeh.period_name period_name, gll.NAME ledger_name, a.concatenated_segments accounting_string, jeh.doc_sequence_value doc_num, gstl.user_je_source_name je_source, gctl.user_je_category_name je_category, jeb.NAME batch_name, jeb.description batch_desc, jeh.NAME je_name, jeh.description je_desc, jel.description line_desc, NULL h_desc,…
Read MoreUTL file for AR invoice Outbound to EBS CREATE OR REPLACE PROCEDURE APPS.xx_mintifi_sales_inv_ext ( p_from_date IN DATE, p_to_date IN DATE, p_org_id IN NUMBER ) AS x_id UTL_FILE.file_type; x_file…
Read MoreBusinesses around the world are facing a lot of disruptions due to Covid-19. Every industry is somehow affected by the pandemic, and retail is no different. Even after when the…
Read More1.Find which programs are stucked in OPP using below query. set lines 200; set pages 300; SELECT a.request_id, substr(e.user_concurrent_program_name,1,80) Program,d.sid, d.serial# ,d.status,to_char(d.logon_time,’DD-MON-YY HH24:MI:SS’)logon, round(d.last_call_et/60) LCT FROM apps.fnd_concurrent_requests a, apps.fnd_concurrent_processes b,…
Read More1. Overview This document talks about the example of changing modal dialogue title dynamically using JavaScript. 2. Technologies and Tools Used The following technologies have been used to achieve exporting IR data to Word format.…
Read More