How to Add Validation Using Dynamic Action in Oracle Apex
Overview In Oracle Apex, The validation is used to validate the business logic on the submission of the page. Oracle Apex has different types of in-build validation with it. The…
Read MoreHow to download an Oracle Apex report with an HTML formatted column excluding HTML tags
Overview Oracle Apex has different types of reports. All reports have their default function it’s an advantage. Suppose you want to achieve some different functionalities other than the default. We…
Read MoreApply Dark & Light Mode In APEX Applications During Runtime
Overview Dark and light modes in APEX applications is a user interface design enhancement that allows users to choose between different color schemes to suit their preferences or environmental conditions.…
Read MorePassword 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 More