+ Write Article

Oracle Articles Examples, Tutorials and Articles

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
Published by
What is an attachment in Oracle applications?

The attachments feature in oracle application enables users to link unstructured data, such as images, word-processing documents, spreadsheets, or text to their application data. For example, users can link images to items or video to operations ...
Read More Read More
Published by
The following is a test case Query to insert or display serial numbers in Oracle.

Code sql:
CREATE TABLE test(sno NUMBER);

Here I am inserting 9 crore records.

Code sql:
DECLARE
a NUMBER;
BEGIN
FOR i IN 1..90000000 loop
INSERT INTO test3 VALUES(i);
...
Read More Read More 1 Comment
Published by
Introduction

Function to find PO number for a Requisition.

The code

Code sql:
 
CREATE OR REPLACE FUNCTION	XXC_GETPO( p_req_num	IN	VARCHAR2)
RETURN NUMBER
IS
	l_po_num	VARCHAR2(20);
BEGIN
	SELECT DISTINCT	PH.segment1
...
Read More Read More

Page 1 of 10 1 2 3 4 5 6 7