Search found 2062 matches

by admin
Sun Dec 18, 2022 6:45 am
Forum: Oracle APEX
Topic: Steps to stop and start Apache Tomcat on Linux/Solaris
Replies: 0
Views: 87016

Steps to stop and start Apache Tomcat on Linux/Solaris

Here are steps to stop and start Apache Tomcat on Linux/Solaris

cd to /bin folder inside tomcat folder.

Stop
./shutdown.sh

Start
./startup.sh
by admin
Wed Dec 14, 2022 3:44 am
Forum: Oracle APEX
Topic: Unlock and Change Oracle APEX Password
Replies: 0
Views: 88307

Unlock and Change Oracle APEX Password

Here are steps to change your Oracle APEX admin password, APEX_220200 schema is your current schema as per your version of APEX, SELECT * FROM APEX_220200.WWV_FLOW_FND_USER A WHERE ACCOUNT_LOCKED = 'Y'; BEGIN APEX_UTIL.SET_SECURITY_GROUP_ID(P_SECURITY_GROUP_ID => 10); APEX_UTIL.UNLOCK_ACCOUNT(P_USER...
by admin
Sun Nov 20, 2022 6:37 am
Forum: Oracle APEX
Topic: IG Manually processing data
Replies: 0
Views: 87978

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: 5
Views: 56352

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: 1
Views: 3669

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: 91670

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: 91741

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: 93201

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: 22300

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: 12738

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: 14671

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: 11257

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: 11402

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: 11187

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