+ Write Article

Oracle Articles Examples, Tutorials and Articles

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
Published by
This is a Query To Display Vendor wise Remit To Bank Account Number

Code sql:
SELECT DISTINCT pv.vendor_name,
            ie.masked_bank_account_num,
            invoice_num,
           cb.bank_name
  FROM po_vendors pv,
           ap_invoices_all ap,
...
Read More Read More
Published by
Introduction

This article shows step by step actions to enable Audit Trail in Oracle Apps.

Background

Standard features are provided by Oracle to Audit manipulations of transacitons that hit base tables. This article explains how to enable the Audit Trail ...
Read More Read More

Page 1 of 10 1 2 3 4 5 6 7