Oracle Articles Examples, Tutorials and Articles

Accrual Process for Perpetual Accruals

Published by

Introduction

This article is related to the Accrual Process in Oracle Purchasing in Oracle EBS discussing the following:

Purchase Order Receipt to Receiving Inspection
Delivery From Receiving Inspection to Inventory
Delivery From Receiving Inspection to Expense Destinations
Purchase

...

Oracle Business Accelerator for E-Business Suite (R12.x) Installation on Oracle Enterprise Linux 5.x or Redhat Enterprise Linux 5.x (64-Bit)

Published by

user1

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 ...

Query to get the Vendor Details in Oracle E-Business Suite

Published by

prudhvi_karanam

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,

...

Table Changes in Oracle General Ledger Tables Release 12 from 11i

Published by

abhi

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 ...

Query to Find Concurrent Program Responsibility

Published by

malli_18arjun

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,

...

Query to Find Details of Request Set

Published by

malli_18arjun

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,

...

Introducation to Oracle Databases

Published by

salmankhalid

A Brief introduction to ORACLE databases, kindly view attachment ...

4 Comments

Oracle RAC Database manual creation

Published by

basavraju

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 ...

1 Comment

Oracle Workflow Key tables

Published by

amut_1

Introduction

This article list the key tables in workflow and the uploaded code give a way to release a stuck workflow.

Key-Tables

WF_ACTIVITIES table stores the definition of an activity. Activities can be processes, notifications, functions or folders. ...

Value Sets In Oracle Apps

Published by

bhaskarlella

Introduction

Value Set is a collection of values. It validates the values entered by the user for a flex-field, report parameters or a concurrent.

The navigation path: Application :- Validation :- Sets

Value Set is associated with the following validations which ...

1 Comment