Smart Filters in Classic Reports
Introduction This document talks about how to use smart filters in classic reports. It provides users to filter the data easily and find the necessary records. It is used in…
Read MoreCreating Pie and Combination Charts in Oracle Apex 22.2
Introduction This document talks about how to create pie and combination charts in Oracle Apex 22.2. This will depict a clear picture to understand for users. Why we need…
Read MoreInvoke API Process using PLSQL in Oracle Apex 22.2
INTRODUCTION : The Invoke API process in Oracle Apex allows developers to make API calls from within an Oracle Apex application to retrieve data or perform actions on external systems. This…
Read MoreApproval workflow with Oracle Apex
INTRODUCTION : This feature lets users change an employee’s salary or job, or order a new laptop for them, after getting the approval of an appropriate individual. It highlights the key features of the Oracle APEX Approvals components.A strong workflow engine add on for Oracle APEX applications is called Flows for APEX. The Apex its able to create the process stages, and the Flows for APEX application to track the progress of your active processes. The approvals component allows Oracle APEX to create tasks for user approval. One place to manage approval tasks in the apex application. WHY WE NEED TO DO / CAUSES : A user should able to analyze the workflow of an approval request which was sent by the senior official. So that, the user can able to identify and solve the issue on required basis. There are several reasons why an Oracle Apex approval procedure could not perform as planned. Some frequent causes are as follows: 1) Missing input parameters 2) Incorrect Procedure 3) Incorrect Branch Logic 4) Incorrect Validations 5) Database Connection Issue 6) Concurrency Issue. HOW DO WE SOLVE : Create a new procedure in the database that will handle the approval process. This procedure should take any necessary…
Read MoreInstalling oracle database 19.3 in Docker
Use the yum-utils package to enable and install all the required repositories. yum install -y yum-utils zip unzip Then enable all the necessary repositories which are needed to install dockers 1.yum-config-manager…
Read MoreUPGRADE 12C to 19C IN PDB USING AUTOUPGRADE METHOD
UPGRADE 12C to 19C IN PDB USING AUTOUPGRADE METHOD LOG INTO THE DATABASE AND MAKE SURE THE CORRECT ORACLE HOME HAS BEEN SET. CHECK STATUS OF ARCHIVELOG MODE IN…
Read MoreGENERATING RANDOM NUMBERS IN OUTSYSTEMS
OUTSYSTEMS: Outsystems is an excellent and rapid Application Development platform for mobile and web-based applications. Outsystems is a low-code programming system which run in cloud, on premises and in hybrid environments.…
Read MoreHow Oracle Cloud Infrastructure Powers Fusion Applications?
Businesses are finding innovative ways to use Oracle Cloud Infrastructure (OCI) every year to foster innovation and development. This year is no exception, with Oracle releasing a plethora of new…
Read MoreTXK Delta 13 failed due to missing files
TXK Delta 13(32392507) plus critical TXK patches 33550674, 33535778 failed because of missing files adsign.txt and adkeystore.dat under $APPL_TOP_NE/ad/admin The Solution: The apply phase failed twice, once when looking for…
Read MoreAdop Phase=cutover Failing With AutoPatch – AidafoGetFileDbVersion: INFO: ORA-01403: No Data Found
AutoPatch – aidafoGetFileDbVersion: INFO: ORA-01403: no data found when apply adop phase=cutover failing with AutoPatch Please follow below steps to overcome this issue Confirm that value for READ_ONLY_FLAG and ENABLED_FLAG…
Read More