Enviroment 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 MoreIntroduction: This post is to guide to Create a Custom Application top for EBS 12.2 Using AD Splice. Steps to create a Custom Application top for EBS 12.2 Using AD…
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 MoreIssue: During an adop online patching cycle, cutover phase failed while running the script txkADOPCutOverPhaseCtrlScript.pl [PROCEDURE] Starting Middle Tier Services [UNEXPECTED]Error occurred running “perl /u01/app/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPCutOverPhaseCtrlScript.pl -contextfile=/u01/app/fs1/inst/apps/EBSTEST_testebsmt111/appl/admin/EBSTEST_testebsmt111.xml -patchcontextfile=/u01/app/fs1/2/inst/apps/EBSTEST_testebsmt111/appl/admin/EBSTEST_testebsmt111.xml -promptmsg=hide -console=off -sessionid=14…
Read MoreORA-01012: not logged on error while trying to start the oracle database. Solution: To resolve this error remove the orphaned shared memory segment using sysresv utility. sysresv command will list…
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 MoreOPM – Intransit Value Details Introduction: This report will provide item wise intransit value detail for period wise. Cause of the issue: Every month needs to be run the lot…
Read More