ERPstuff - Oracle EBS Community

As you might know Oracle has changed the way it was installing ORDS so now instead of using java ords.war now syntax is changed. Here are steps to install ORDS for Oracle APEX in Wndows 2010 with deployment in Tomcat 9. 1. Download following softwares, a. JDK 11 or 17 b. ORDS 22.x r 23.1 c. Oracle A...

C:\OracleDB19c\ords>ords -–config /etc/ords/config install

C:\OracleDB19c\ords>ords --config C:\OracleDB19c\ords\config serve

select column_name||',' from user_tab_columns where table_name = 'JS_B2B_HEADER' order by COLUMN_ID

CREATE TABLE tinyMCE_tbl ( ID NUMBER(4,0) GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 90000 INCREMENT BY 1 START WITH 8000 NOCACHE, blog_text varchar2(4000), CONSTRAINT "tinyMCE_tbl_ID" PRIMARY KEY ("ID") USING INDEX ENABLE ) drop table tinyMCE_tbl select * from...

We are looking for onsite resources for 2 years in Muscat, Oman. Please share your cv with expectations and TTJ (time to join) if you have minimum of 5 years of experience. Share your CV as MS Word document at info@erpstuff.com (position no and name must be in the subject of your email. 1 Oracle Uti...

Page Processing Improvements Group a sequence of page processes to offload processing to the background or just simplify maintainability of conditional execution. Control Background Execution More control over processes executing in the background with the addition of monitoring to the Active Sessio...

Our community member of Oracle APEX asked few questions and best of my knowledge here are responses to each of them, 1. Database or APEX License will be required for APEX separate installation? >> There is no APEX separate license and it is part of Oracle Database Standard and Enterprise License. Fo...

BEGIN EXECUTE IMMEDIATE 'DROP TABLE ERPSTUFF_EMPS'; EXECUTE IMMEDIATE 'DROP TABLE ERPSTUFF_DEPTS'; EXCEPTION WHEN OTHERS THEN NULL; END; / CREATE TABLE "ERPSTUFF_EMPS" ( "EMPNO" NUMBER(4,0) GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 90000 INCREMENT BY 10 START ...

function js_authentication ( p_username in varchar2, p_password in varchar2 ) return boolean is l_user my_users.user_name%type := upper(p_username); l_id my_users.id%type; l_hash my_users.password_hash%type; begin begin select id , password_hash into l_id, l_hash from my_users where user_name = l_us...

This way field will be readonly while stillyou can assign values using code etc.

readonly="true"

Pictures are always of different diminsions and if you need to display them in a fixed size in Interactive/Classic Reports then enter following code in the page Inline, td[headers="PHOTO"] img { display: block; width: 60px; } here "PHOTO" is your column name of reports query.

Oracle APEX - Commenting Tips & Tricks The commenting feature in Oracle Application Express (APEX) allows developers to add notes or explanations to their code. This can be helpful for collaboration, debugging, or just keeping track of what different parts of the code do. Oracle PL/SQL Developer...

1-3 Primary Oracle DBA Duties: Oracle 12/19c administration and support (on-prem or cloud) Oracle Patch Management Coordination and implementation Oracle backup and recovery planning/testing Provide infrastructure support at all levels and after hours support as needed Coordinate Oracle DB work wit...

function(config) { config.reportSettingsArea = false; // may want to disable the highlights feature. Comment out this code to make initial highlight settings apex.util.getNestedObject(config, "views.grid.features").highlight = false; return config; } IG color.jpg IG color2.jpg