Password Feed Back Form In APEX
Overview In Oracle APEX, a “Password Feedback” form is often used to provide feedback to users when they are creating or updating their passwords. This form typically includes elements such as…
Read MoreCompare Two Excel Files and send report as E-mail in Oracle Apex
1. Overview This document talks about Compare Two Excel Files with same column name and send report to E-mail in Oracle Apex. This has been achieved using Apex Collection. 2. Technologies and…
Read MoreFocus on First editable Page item in Oracle Apex
1. Overview This document talks about Focus on first editable page item on page load. This has been achieved using SQL and JavaScript. 2. Technologies and Tools Used The following technologies has…
Read MoreDynamically set Decimal value Using JavaScript
1. Overview This document talks about dynamically setting decimal value for a particular column in an Interactive Grid report or Item using JavaScript. 2. Technologies and Tools Used The following…
Read MoreMigrating Oracle E-Business Suite to Oracle Cloud Infrastructure
This blog post offers insights into the optimal options and best practices for migrating your Oracle E-Business Suite (EBS) from on-premises to Oracle Cloud Infrastructure (OCI), harnessing the capabilities of…
Read MoreOn closure of the popup set focus to IG column
1. Overview This document talks about how to set focus to a particular column in an Interactive Grid report on the closure of inline pop up region using JavaScript. 2.Technologies…
Read MoreEBS ADOP Woes: Tackling ORA-20001 in Cleanup Phase
This blog aims to support DBAs who encounter issues during the EBS application R12.2 ADOP phase=cleanup, specifically when it fails with the ORA-20001 error message: ‘Error while calling ad_zd.cleanupORA-01555: snapshot too old.’ The steps provided here offer guidance in identifying and addressing the challenges associated with the ADOP phase=Cleanup problem. Below Step: Issue: We encountered the following issue during the application of the adpatch ADOP patching cycle when executing the adop phase=cleanup [applmgr@r122 ~]$ adop phase=cleanup Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Please wait. Validating credentials… RUN file system context file: /u01/applmgr/UAT_TEST/fs2/inst/apps/UAT_TEST_r122/appl/admin/UAT_TEST_r122.xml PATCH file system context file: /u01/applmgr/UAT_TEST/fs1/inst/apps/UAT_TEST_r122/appl/admin/UAT_TEST_r122.xml ************* Start of session ************* version: 12.2.0 started at: Wed May 24 2021 03:34:53 APPL_TOP is set to /u01/applmgr/UAT_TEST/fs2/EBSapps/appl [STATEMENT] Using 4 workers (Default: 4, Recommended maximum limit: 62) Cleanup is not done in earlier session [START 2021/05/24 03:35:27] adzdoptl.pl run ADOP Session ID: 4 Phase: cleanup Log file: /u01/applmgr/UAT_TEST/fs_ne/EBSapps/log/adop/4/adop_20210524_033421.log [START 2021/05/24 03:35:48] cleanup phase [EVENT] [START 2021/05/24 03:35:52] Performing Cleanup steps [EVENT] [START 2021/05/24 03:35:57] Running CLEANUP ddls in ddl handler table Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=4 restart=no abandon=yes defaultsfile=/u01/applmgr/UAT_TEST/fs2/EBSapps/appl/admin/UAT_TEST/adalldefaults.txt patchtop=/u01/applmgr/UAT_TEST/fs2/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cleanup.log driver=ucleanup.drv ADPATCH Log directory: /u01/applmgr/UAT_TEST/fs_ne/EBSapps/log/adop/4/cleanup_20210524_033421/UAT_TEST_r122/log [EVENT] [END 2021/05/24 03:39:43] Running CLEANUP ddls in ddl handler table [EVENT] Cleaning up ABORT DDL from DDL Handler Table [START 2021/05/24 03:39:54] Generating All DDL Report [EVENT] Report: /u01/applmgr/UAT_TEST/fs2/EBSapps/appl/ad/12.0.0/sql/ADZDALLDDLS.sql…
Read MoreBehind the ORA-02020 Error: A Deep Dive into Database Link Troubleshooting.
This blog is intended for DBA’s who have error while using a database links.Let’s work on a journey to decode, troubleshoot, and over the challenge posed by the ORA-02020 error. Issue: Error While Fetching data against a database link, got below error.ORA-02020: Too Many Database Links In Use Sql>select sysdate from dual@Daatbase_link5; * ERROR at line 1: ORA-02020: too many database links in use CAUSE & SOLUTION: n open_links parameter control, the number of database links each session can use without closing it. n If you access a database link in a session, then the link remains open until you close the session. Check the below parameter: SQL> show parameter open_link NAME TYPE VALUE ———————————— ———– —————————— open_links integer 4 open_links_per_instance integer 4 Here open_links is set to a session can access only 4 open database links in that session.When the open db_link connection reaches the limit(open_links), it throws ORA-02020: too many database links in use. Solution:1 n Close the open db_link connections n Increase the open_links parameter (bounce required) Let’s reproduce this error. SQL> select sysdate from dual@Database_link1; SYSDATE ——— 30-JUL-17 SQL> select sysdate from dual@Database_link2; SYSDATE ——— 30-JUL-17 SQL> select sysdate from dual@Database_link3;…
Read MoreCreate users and assign access in DynamoDB
Introduction: Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. When working with DynamoDB, creating users and assigning access rights is…
Read MoreSteps to backup Dynamo DB
Introduction: DynamoDB, Amazon’s managed NoSQL database service, is a scalable and highly available solution for storing and retrieving data. Despite its robust infrastructure, it is essential to implement regular backups…
Read More