Notes on setting up Extra Information Type EIT

Submitted by code_admin on Thu, 07/12/2018 - 15:56

How to setup an extra information type

  1. System Admin->Application->Flexfield->Descriptive->Segments
  2. Query Back (Extra Person, etc)
  3. Create a new row and fill out
  4. Compile it
  5. Goto HRMS responsibility
  6. Submit Register Extra Information Types (EITs)
  7. Goto Security->Information Type Security and add it here

Search

EIT

Tags

002 Set up Custom Oracle Application

Submitted by code_admin on Thu, 07/12/2018 - 15:46

Prerequisites

This tutorial assumes you have the following prerequisites

Step 1 - Choose name

Choose a name for the custom app. By convention it must start with XX. In my case I am using XXRJM.

Step 2 - Create directory structure

Make the main directory (Check the APPL_TOP command worked)

Oracle Enviroment Variables in unix

Submitted by code_admin on Thu, 07/12/2018 - 15:42

Oracle supplies some environment variables that point to specific directories in the file system. This page explains how to setup individual users so that these environment variables are always available.
Once this is done you can test the environment is set up by using the env command or typing echo $APPL_TOP at the bash prompt.

Redhat Linux - including Oracle Enterprise Linux

In the users home directory there is a file called .bash_profile (It starts with a leading dot) Put something like the following in it:

Tags

MySQL

Submitted by code_admin on Wed, 07/11/2018 - 18:46

Login

mysql -h127.0.0.1 -uroot -p<>

Usage

No Database
show databases;
drop database $$DB Name$$;
create database $$DB Name$$;
use $$DB Name$$;
source $$FILENAME$$Run a pre-prepared script

Tags

Subscribe to