Search found 2015 matches

by admin
Sun Nov 20, 2022 6:37 am
Forum: Oracle APEX
Topic: IG Manually processing data
Replies: 0
Views: 121

IG Manually processing data

You might need to process each row of IG manually so the following code will be executed as a loop for each changed row, Screenshot 2022-11-20 113639.jpg begin case :APEX$ROW_STATUS when 'I' then insert into emp ( empno, ename, deptno ) values ( :EMPNO, :ENAME, :DEPTNO ) returning rowid into :ROWID;...
by admin
Fri Nov 18, 2022 3:19 am
Forum: Oracle APEX
Topic: IG-Interactive Grid and JavaScript
Replies: 0
Views: 124

IG-Interactive Grid and JavaScript

Initialization JavaScript Function function(config) { if (!config.toolbar) { config.toolbar = {}; } config.reportSettingsArea = false; config.defaultGridViewOptions = { multiple: true, selectAll: true , footer: true, rowHeader: 'sequence' } // config.initActions = function( actions ) { // actions.r...
by admin
Wed Nov 02, 2022 5:25 am
Forum: Oracle APEX
Topic: Calculate schema size in MB
Replies: 0
Views: 90

Calculate schema size in MB

Normally companies are giving APEX as a service and they need to calculate the space used by each Schema/WS,

select owner, sum(bytes)/1024/1024 Size_MB from dba_segments
group by owner;
by admin
Tue Nov 01, 2022 2:50 pm
Forum: Oracle APEX
Topic: Public Holidays adjustment during Leaves
Replies: 0
Views: 95

Public Holidays adjustment during Leaves

This procedure is to count public holidays or any type of holidays that you don't want to count in the range of employee leaves and wants to adjust those number of days. For example, you have public holidays from the 4th to the 6th of a month means 3 days are public holidays. If an employee had appl...
by admin
Tue Nov 01, 2022 2:48 am
Forum: Oracle APEX
Topic: ACL Roles Views
Replies: 0
Views: 81

ACL Roles Views

APEX_APPL_ACL_USERS
APEX_APPL_ACL_USER_ROLES
APEX_APPL_ACL_ROLES
by admin
Wed Oct 19, 2022 6:24 am
Forum: Oracle APEX
Topic: Check which page button is pressed?
Replies: 0
Views: 144

Check which page button is pressed?

Begin
if V('REQUEST') = 'OK' Then -- Here OK is the button name which can be Submit, Cancel, Delete etc.
return true;
else
return false;
end if;
End;
by admin
Fri Sep 16, 2022 4:29 am
Forum: Application DBA & System Administration
Topic: JDeveloper Installation
Replies: 0
Views: 237

JDeveloper Installation

Unable to launch the Java Virtual Machine Located at path: ..\..\jdk\jre\bin\client\jvm.dll

C:\Oracle\OAF_p28163665_R12\jdevbin\jdev\bin\jdev.conf

SetJavaHome C:\Program Files (x86)\Java\jre1.8.0_201

https://www.oracle.com/java/technologie ... loads.html
by admin
Sat Sep 10, 2022 3:52 am
Forum: Oracle Forms & Reports
Topic: INST-07545: Unexpected Error java.lang.NullPointerException
Replies: 0
Views: 322

INST-07545: Unexpected Error java.lang.NullPointerException

Oracle WebLogic Server - Version 12.2.1.0.0 and later Oracle Fusion Middleware - Version 12.2.1.0.0 and later While installation of Forms and Reports Builder 12c selecting home you might get this error INST-07545. You need to set TEMP folder environment variable in windows OS, Set temp environment v...
by admin
Mon Sep 05, 2022 5:38 am
Forum: Reports (Only Oracle Apps Reports)
Topic: Upgrading form6i and report6i to 11g/12c?
Replies: 0
Views: 313

Upgrading form6i and report6i to 11g/12c?

It is always recommended to upgrade to the latest version of any product while Oracle Developer 6i is already obsolete by Oracle and de-supported. Few companies due to different factors can't upgrade so here we will share to stay with 6i and connect to 12c and higher versions or how to upgrade. Para...
by admin
Tue Aug 30, 2022 7:47 am
Forum: Oracle APEX
Topic: Oracle API Reference Document 21.2
Replies: 0
Views: 342

Oracle API Reference Document 21.2

Oracle apex api reference 21.2.zip
by admin
Sun Aug 28, 2022 8:51 am
Forum: Oracle APEX
Topic: Sum two tables column in single SQL
Replies: 0
Views: 483

Sum two tables column in single SQL

CREATE TABLE ALLOW (ANO NUMBER(3), ANAME VARCHAR2(15), CONSTRAINT ANO_PK PRIMARY KEY (ANO)); CREATE TABLE DED (DEDNO NUMBER(3), DEDNAME VARCHAR2(20), CONSTRAINT DEDNO_PK PRIMARY KEY (DEDNO)); CREATE TABLE EMP(ENO NUMBER(5), ENAME VARCHAR2(20), CONSTRAINT ENO_PK PRIMARY KEY(ENO)); CREATE TABLE EMPA(E...
by admin
Sun Aug 28, 2022 7:01 am
Forum: Oracle APEX
Topic: ORDS Standalone Start and Stop Linux
Replies: 0
Views: 188

ORDS Standalone Start and Stop Linux

Starting

!/bin/bash
cd /u01/ords
nohup java -Dorg.eclipse.jetty.server.Request.maxFormContentSize=20971520 -jar ords.war standalone &

Stopping

kill ps -ef | grep ords.war | awk '{print $2}'

or

ps -ef | grep ords.war | awk '{print $2}'

kill 1234 << output of ps if any
by admin
Mon Aug 22, 2022 9:45 am
Forum: Oracle APEX
Topic: Jasper: Message Class not found when loading object from file
Replies: 0
Views: 199

Jasper: Message Class not found when loading object from file

If Jasper Studio version is higher than 6.4 then following error expected in APEX, HTTP Status 500 – Internal Server Error Type Exception Report Message Class not found when loading object from file: /u01/ords/JasperReport/reports/inv.jasper. Description The server encountered an unexpected conditio...