Sales Daily Pick Report
1.Overview This document talks about getting the sales daily stock pick report in oracle apps r12 2.Technologies and Tools Used The following technologies have been used to achieve the expected…
Read MoreSolution to not logged on error and up the database
Solution to not logged on error and up the database ORA-01012: not logged on error ERROR ERROR at line 1: ORA-01012: not logged on Process ID: 0 Session ID:…
Read MoreSWITCH OVER IN DATAGUARD
SWITCH OVER IN DATAGUARD CHECK THE FOLLOWING IN PRIMARY AND STANDBY STEP-1 STANDBY -Keep the database in mount state -keep the standby in MRP mode STEP-2 FIND THE…
Read MoreSmart 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 More