ERPstuff - Oracle EBS Community

ifconfig eth0 192.168.1.10 netmask 255.255.255.0

select fnd_web_sec.validate_login(‘SYSADMIN’,’sysadmin’) from dual;

It should return Y or N.

In Oracle EBS VM's normally GUI is not there so only terminal will be there for the command line. To install/enable GUI following these steps as root user, Enable 1 - $ yum update 2 - $ yum groupinstall "Server with GUI" 3 - Start Oracle Linux GUI on system startup $ ln -sf /lib/systemd/sy...

1. Download Linux 8.0 (example). linux1.png 2. There are 3 files in it you need V983280-01 V983278-01 V983279-01 V983280-01 3. Now need to download a Bootable Creator USB/DVD better use USB 8GB or above. https://www.balena.io/etcher/ https://rufus.ie/en 4. I used Etcher as it is open source while Ru...

CREATE TABLE "DEPT" ( "DEPTNO" NUMBER(2,0), "DNAME" VARCHAR2(14 BYTE), "LOC" VARCHAR2(13 BYTE) ) ; ALTER TABLE "DEPT" ADD PRIMARY KEY ("DEPTNO"); CREATE TABLE "EMP" ( "EMPNO" NUMBER(4,0) NOT NULL, "ENAME" VARC...

Oracle VM Virtual Appliances for Oracle E-Business Suite 12.2.10 Here steps to install and configure Oracle EBS 12.2.10 in VirtualBox are explained so anyone can configure on a laptop/desktop to use and practice. space.png 1. Download Oracle VM VirtualBox vm.png https://www.oracle.com/virtualizatio...

The built-in substitution names are:

&APP_USER.
&APP_ID.
&APP_PAGE_ID.
&APP_SESSION.
&APP_FILES.
&WORKSPACE_FILES.
&REQUEST.
&DEBUG.
&APEX_FILES.
&IMAGE_PREFIX. (legacy- use &APEX_FILES. instead)
&APEX_VERSION.

CREATE TABLE ERPSTUFF_FILES ( ID NUMBER, PROJECT_ID NUMBER, FILENAME VARCHAR2(255), FILE_MIMETYPE VARCHAR2(512), FILE_CHARSET VARCHAR2(512), FILE_BLOB BLOB, FILE_COMMENTS VARCHAR2(500), TAGS VARCHAR2(500), CREATED TIMESTAMP (6), CREATED_BY VARCHAR2(255), UPDATED TIMESTAMP (6), UPDATED_BY VARCHAR2(25...

GET declare l_clob clob; json_content APEX_JSON.t_values; v_lines number; begin l_clob:= apex_web_service.make_rest_request( p_url => 'https://apex.oracle.com/pls/apex/erpstuffords/hr/dept', p_http_method => 'GET', p_parm_name => apex_util.string_to_table('deptno'), p_parm_value => apex_util.string_...

DECLARE v_module_name VARCHAR2 (200) DEFAULT 'erpstuff.com.hr'; v_pattern VARCHAR2 (200) DEFAULT 'dept/:deptno'; /* This code is only for demo purposes so use this code in your environment at your own risk. https://erpstuff.com version:demo_1 22-JAN-2022 */ BEGIN ORDS.define_module (p_module_name =...

Please explore following,

Equipment Lease - A New functionality in Oracle Property Manager

chrome://flags/#pwa-uninstall-in-windows-os

UTL_SMTP Email Procedure create or replace procedure html_email( p_to in varchar2, p_from in varchar2, p_subject in varchar2, p_text in varchar2 default null, p_html in varchar2 default null, p_smtp_hostname in varchar2, p_smtp_portnum in varchar2) is l_boundary varchar2(255) default 'a1b2c3d4e3f2g...

BEGIN APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_HOST_ADDRESS', 'smtp.us-phoenix-1.oraclecloud.com'); APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_USERNAME', 'ocid1.user.oc1.username'); APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_PASSWORD', 'password'); APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_HOST_PORT',587); C...

body{ background-image: url('#APP_FILES#technology.jpg?auto=compress&cs=tinysrgb&dpr=2&h=650&w=940'); background-position: center; background-repeat: no-repeat; background-size: cover; } .t-Login-logo { background-image: url('#APP_FILES#erpstuff logo.png'); background-repeat: no-repe...