ERPstuff - Oracle EBS Community

1. Write an SQL as below, select EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO, (select d.dname from dept d where d.deptno = emp.deptno) DEPT_NAME from EMP IG1.PNG 2. Keep all settings default and now click this DEPT_NAME column under IG and change the property to Query Only. ig2.PNG

Steps to add a background image on Oracle APEX Login page, background.PNG 1. upload your image file in Oracle APEX, Application 75605 > Shared Components > Static Application Files 2. Once uploaded copy reference of uploaded file #APP_FILES#technology.jpg 3. Open the login page and enter the followi...

Oracle had introduced an identity column in 12C and it is to generate auto sequence no for a primary key in a table. A table can have only a single identity column and it has GENERATED [ ALWAYS | BY DEFAULT [ ON NULL ] ] AS IDENTITY [ ( identity_options ) ] create table emp2 ( id number generated al...

DECLARE l_workspace_id := apex_util.find_security_group_id (p_workspace => 'ERPSTUFF'); apex_util.set_security_group_id (p_security_group_id => l_workspace_id); BEGIN APEX_UTIL.CREATE_USER( p_user_name => 'SIKANDAR', p_first_name => 'Malik Sikandar', p_last_name => 'Hayat', p_description => 'This sc...

declare p_user_name varchar2(50) default 'erpstuff'; v_new_password varchar2(50) default 'ERPstuff_123'; BEGIN --select dbms_random.string('A',6) into v_new_password from dual; fnd_user_pkg.updateuser( x_user_name => p_user_name , x_owner => NULL , x_unencrypted_password => v_new_password, x_passwor...

Table script CREATE TABLE "JS_PRODUCTS" ( "PRODUCT_NAME" VARCHAR2(100), "PRODUCT_PRICE" NUMBER, "PRODUCT_BARCODE" VARCHAR2(32) ) / insert into JS_PRODUCTS (PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_BARCODE) Values ('Orange',34,'123456789012'); insert into JS_PRODUCT...

Here you can find sample code to practice procedure, function, and packages explained in the following video in youtube, https://youtu.be/_FdPeyjfols --select my_procedure(10,10) from dual; exec my_package.myprocedure(10); declare D number; begin my_procedure(A => 10, B => 10); --DBMS_OUTPUT.PUT_LIN...

Please note that indentation is important in the code, # settings = db: "18c", apex: true, api: true, schema: "erpstuff", prefix: "JS" # PK: "seq", genPK: true, history: true, verbose: true # auditcols: true, createdByCol: "created_by", createdCol: &...

select * from table(apex_string.split('1,2,3',','))

select * from table(apex_string.split('1:2:3',':'))

Output will be
1
2
3

Oracle APEX 19.2 or below installation on Pluggable Database 12C or greater version of Oracle database, 1. Download and install the Oracle 19C database 2. Install APEX 19.2 3. Go inside APEX folder Login from sqlplus as sys/sysdba 4. show pdbs and switch to ORCLPDB SQL> show pdbs CON_ID CON_NAME OPE...

APEX_UTIL.PREPARE_URL ( p_url IN VARCHAR2, p_url_charset IN VARCHAR2 default null, p_checksum_type IN VARCHAR2 default null, p_triggering_element IN VARCHAR2 default 'this') RETURN VARCHAR2; Note: As shown below each dot is mandatory so don't remove even a dot as without dot it will give an error li...

How to get certain value using substitution strings, Examples: f?p=&APP_ID.:&APP_PAGE_ID.:&APP_SESSION. the above is to create a URL and if you see &APP_PAGE_ID. will bring page ID and note the last dot must be there. In this URL 3 substitutions are there &APP_ID., &APP_PAGE_...

These days security of information is a real concern no matter it is personal or business. Normally people keep very simple passwords while thinking no one can guess it but believe me these days cracking a password is very easy and simple. So setting personal passwords of your social media account l...

1- Create Dynamic List in Shared Components SELECT null, FUNCTION label, Page_URL target, 'NO' is_current, 'fa-plus-square' icon << FROM My_Table List of icons: https://apex.oracle.com/pls/apex/f?p=42:icons 2- Creation List region and assign list item created above. 3- Select the list region and in ...

There are 2 aspects, in RMA one is revenue reversal and the other is COGS reversal. Revenue would get reserved at Selling Prices which is does via. Credit Note creation, on the other, had Receipt of the Material would be reversed at COGS value of parent sales order issue. and also get debited to Inv...