+ Write Article

Oracle Articles Examples, Tutorials and Articles

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
Published by
Introduction

Script to User and ADD responsibility from backend


The code

Code sql:
DECLARE
  v_user_name  VARCHAR2(30):=UPPER('&Enter_User_Name');
  v_password   VARCHAR2(30):='&Enter_Password';
  v_session_id INTEGER     := USERENV('sessionid');
...
Read More Read More 1 Comment
Published by
Introduction

Get information about concurrent programs without the need to query through forms.

The code

Code sql:
SELECT fcr.request_id, 
         fcpt.user_concurrent_program_name,
         fcr.phase_code,
         fcr.status_code,
...
Read More Read More 2 Comments
Published by
Query To Display Items which are not assigned to VAT Template

Code sql:
SELECT ood.organization_name
         ,msi.*
   FROM mtl_system_items_b msi
       ,org_organization_definitions ood
   WHERE 1=1
   AND msi.organization_id=ood.organization_id
   AND
...
Read More Read More
Published by
The following is a Query to check if Oracle Apps Modules Licensed or not

Code sql:
SELECT fat.application_name
      ,fa.application_id
      ,fpi.patch_level
      ,decode(fpi.STATUS,'I','Licensed', 'N','Not Licensed','S','Shared','Undetermined') STATUS
  FROM fnd_product_installations
...
Read More Read More

Page 1 of 10 1 2 3 4 5 6 7