+ Write Article

Oracle Articles Examples, Tutorials and Articles

Published by
The following is a Query to fetch employee details in Oracle HRMS

Code sql:
SELECT 	 papf.person_id 		person_no
		,papf.employee_number 	empno
		,papf.full_name 		emp_name
		,papf.date_of_birth		dob
		,pj.job_id			job_no
		,pj.name			job_name
		,pap.position_id
...
Read More Read More
Published by
Create Employee API

The hr_employee_api.create_employee procedure holds the script to do interface to create employee

Code:

Code sql:
DECLARE
 
 
 LC_EMPLOYEE_NUMBER                                PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE
...
Read More Read More
Published by
The following is a Query to get PR and PO Details

Code sql:
SELECT poh.segment1 po_number, pol.line_num, pol.item_description,
       ploc.quantity, mtl.segment1 || ',' || mtl.segment2 po_item,
       prh.segment1 req_num, fnd.user_name requestor, prl.need_by_date
...
Read More Read More
Published by
The following is a Query To get List of Employees which has Supervisors.

Code sql:
SELECT ppf.full_name emp_name
      ,ppf1.full_name supervisor_name
FROM per_all_people_f ppf
,per_all_assignments_f paaf
,per_all_people_f ppf1
WHERE 1=1
AND ppf.person_id=paaf.person_id
...
Read More Read More 2 Comments
Published by
The following is a Query To get List of Employees which Dont have Supervisors.


Code sql:
SELECT ppf.full_name
  FROM per_all_people_f ppf
      ,per_all_assignments_f paaf
 WHERE 1=1
   AND ppf.person_id=paaf.person_id
   AND ppf.employee_number IS NOT
...
Read More Read More
Published by
Introduction

While creating setup for OLM, there is requirement for creating cataloge objects. Course is of the main component for OLM Cataloge objects. Here in this article, i am explaining Course Creation API by providing a copy of working example for it.

Background ...
Read More Read More
Published by
Introduction

API to Apply AR Receipts


The code

This script is used to Apply an AR Receipt that is already created to a Customer Transaction.

Code sql:
 
DECLARE
    --local Variables
	g_loc               		NUMBER :=0;
...
Read More Read More
Published by
Introduction

API to Create AR Receipts

The code

Below script is used to create AR receipt that is not specific to any customers. The receipt created can be applied to any specific customers.


Code sql:
 
DECLARE
...
Read More Read More
Published by
Introduction

This article explains how to customize defaulting logic of Requisitions/Lines and Distributions.

Background

For defaulting any column values of requisitions, requisition lines or requisition distributions during the time or creation, a specific ...
Read More Read More
Published by
The following is code for an API to Create Project and Task in Oracle Apps

Code sql:
DECLARE
   -- Variables needed to create task hierachy
   level1                 NUMBER;
   level2                 NUMBER;
   level3                 NUMBER;
   a
...
Read More Read More

Page 1 of 10 1 2 3 4 5 6 7