Yearly Archives: 2021

19c Performing a Oracle Data Guard Manual Switchover

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 More

To Set Dynamically Normal/Dialogue Page Title in Oracle Apex

1. 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 More

GST Query for Payables

GST 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 More

UTL file for AR invoice Outbound to EBS

UTL 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 More

Step by step Creating a Custom Application top for EBS 12.2 Using AD Splice

Introduction: 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 More

Ways Retailers Can Turn the Pandemic into Opportunities

Businesses 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 More

ADOP Cutover failed while running txkADOPCutOverPhaseCtrlScript.pl

Issue: 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 More

ORA-01012: not logged on error

ORA-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 More

TERMINATE THE CONCURRENT PROGRAMS WHILE STUCKED IN A OPP (Output Post Processor) in R12.1.3

1.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 More

OPM – Intransit Value Report

OPM – 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