+ Write Article

Oracle Articles Examples, Tutorials and Articles

Published by
Introduction

This is a brief write up about the different Types of Purchase Orders in Oracle E-Business Suite

Background

A Standard Purchase Order is created when you know the Item, Price, Delivery schedule and Payment terms

A Planned Purchase Order ...
Read More Read More 7 Comments
Published by
Introduction

Steps to Integrate Payroll with Cash Management in R12

Background

New Payments Module for Funds Capture and Disbursement needs to be integrated to facilitate reconciliation of Transactions

Steps
  1. Define the Legal Entity
...
Read More Read More 2 Comments
Published by
Introduction

This article is related to the Accrual Process in Oracle Purchasing in Oracle EBS discussing the following:
  1. Purchase Order Receipt to Receiving Inspection
  2. Delivery From Receiving Inspection to Inventory
  3. Delivery From Receiving Inspection to Expense Destinations
  4. Purchase
...
Read More Read More 2 Comments
Published by
Introduction

This article provides a Step By Step Instructions to Install Oracle Business Accelerator for Oracle E-Business Suite on on Oracle Enterprise Linux 5.x or Redhat Enterprise Linux 5.x (64-Bit)

Process

Follow the steps listed in sequence in this ...
Read More Read More
Published by
Introduction

This article is about the changes which have been done to existing General Ledger tables in Release R12 as compared to 11i.

GL_BALANCES

Added quarter_to_date_dr_beq, quarter_to_date_cr_beq, project_to_date_dr_beq and project_to_date_cr_beq ...
Read More Read More 4 Comments
Published by
Introduction

Use the Below Query to get the Vendor Details.

The code

Use Below Parameters:

1. Give the Vendor Number From and To(Optional)
2. Vendor Name(Optional)

Code sql:
SELECT  
PO.SEGMENT1 VENDOR_NUMBER,
...
Read More Read More
Published by
Introduction

Query helps to find desired concurrent request set information .

Pass concurrent request set name as parameter

SQL Code:
Code sql:
 SELECT frt.responsibility_name, frg.request_group_name,
    frgu.request_unit_type,frgu.request_unit_id,
...
Read More Read More
Published by
Introduction

This query helps to get concurrent program details of to which responsibility attached and request group information. Thought it would be helpful ..

Pass Concurrent Program Name as parameter

SQL Code:
Code sql:
 SELECT frt.responsibility_name,
...
Read More Read More 1 Comment
Published by
A Brief introduction to ORACLE databases, kindly view attachment ...
Read More Read More 5 Comments
Published by
Creating Database manually under oracle RAC

Login into node1 as oracle user and set environment as follows

Code :
[oracle@node1 ~]$ . oraenv
ORACLE_SID = [oracle] ? test1
ORACLE_HOME = [/home/oracle] ? /orasoft/10g

Create the directory structure to ...
Read More Read More 1 Comment

Page 3 of 12 1 2 3 4 5 6 7 8 9