APEX

Avoid wrapping of fields in APEX Interactive reports

Description: Due to many columns in the report, the Data will be wrapped automatically. Resolution:   In report attributes, assign the static ID for the column that you want not…

Read More

APEX – Report Rows Clickable to detailed page

    Description: This document describes how to make an Apex Reports clickable to a detailed page with an option of entire row selection. In Apex, Report is an important…

Read More

How to Set Interactive Report Filter with URL Parameters

Description: Interactive Reports are very powerful; the end-user can set filters, highlighting, add computed columns, do control breaks or groupings, and much more. As a Developer, you might sometimes have…

Read More

How to Highlight Tabular Form Rows on addition from Pop-up

Description: This is often used to show additional information about a row, particularly when you wish to convey more information about a row than there is space for in the…

Read More

Apex used to call the Oracle JOB scheduler and Java

Description: The below steps describe who Apex used to call the Oracle JOB scheduler and Java users to create in oracle EBS with examples.   l Create the HTML link on…

Read More

APEX upgrade from 4.0 to 4.2 – Technical Issues

Description: Upgrading Oracle Application Express creates new database objects in a new schema and migrates the application metadata to the latest release. Problem:Login issue – unable to login to the…

Read More

Add Row on the Top in the APEX Tabular Form

                                  Description: Query explains how to add row on the top in the APEX…

Read More

ORA-01741: illegal zero-length identifier

Posted by : Saravanan   Introduction This Post demonstrates about error ORA-01741 : illegal zero-length identifier Scenario While adding multiple schemas to a single workspace, we get the following error in…

Read More

ORA-27492: unable to run job “APEX_040200.ORACLE_APEX_MAIL_QUEUE”: scheduler unavailable

Posted by Venkateshwaran Govindaraj ISSUE: ———- ORA-27492: unable to run job “APEX_040200.ORACLE_APEX_MAIL_QUEUE”: scheduler unavailable SOLUTIONS: —————— Alter system set job_queue_processes=1000;

Read More

ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property during Apex install in 12.2

Posted by Sathiyaseelan Mariappan Hi .. Lets find out the solution for below issue. Issue: Fresh apex install failed with the below error. ORA-38824: A CREATE OR REPLACE command may…

Read More