Overview This document talks about how to display report column values as bar codes in Oracle Apex. this has been achieved using JavaScript. Technologies and Tools Used The following technologies…
Read MoreOverview This document talks about generating bar code in Oracle Apex using input value and bar code type. this has been achieved using JavaScript. Technologies and Tools Used The following…
Read MoreIntroduction: This blog is intended for DBA’s who have issues in completing rman backup, we tried to take a rman full backup, but it failed with the below error message.…
Read MoreIntroduction: I get to work in export and import of particular schema, but ended up with some fatal error. While EXPDP the schema (EXPDP fails with ORA-39126 Worker unexpected fatal…
Read MoreThis blog is intended for DBA’s who have issues in Oracle standby MRP (Managed Recovery Process) and MRP process stops with below ORA error. ” ORA-00600: internal error code, arguments:…
Read MoreThe purpose of this blog is to assist DBAs encountering performance issues in locating the problematic query by taking a trace of the session. The steps shared here will help…
Read MoreINTRODUCTION : 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 MoreINTRODUCTION : 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 MorePlease use the below query for a period. SELECT to_char(rollup_timestamp,’DD-MON-YY HH24′) “Date”, average “CPU Usage %” FROM sysman.MGMT\$METRIC_HOURLY WHERE target_name like ‘%servername%’ AND metric_name = ‘Load’ AND metric_column =…
Read MoreUse 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 More