Oracle Apps Technical Examples, Tutorials and Articles

Oracle Apps TCA Tables

Published by

Introduction

Oracle Applications R12 Trading Community Architecture Tables

Background

What is TCA?
Oracle Trading Community Architecture (TCA) is a data model that allows you to manage complex information about the parties, or customers.
Trading ...

Standard Query To Get Account Description

Published by

mshali

Code sql:

-- Function and procedure implementations
  FUNCTION To_Get_Account_Desc  (I_LEDGER_ID IN NUMBER,
                                 I_SEGMENT3  IN VARCHAR2,
                                 I_SEGMENT4  IN VARCHAR2,
                                 I_SEGMENT5  IN VARCHAR2)

...

Introduction to Oracle Application (OA) Framework

Published by

sudheerjohn

Introduction to Oracle Application (OA) Framework

OA Framework is a J2EE (Enterprise Edition) based application development platform to develop HTML based Oracle EBS applications. OA Framework is designed around the simple Model-View-Controller (MVC) architecture design pattern.The MVC ...

2 Comments

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

4 Comments

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,

...

1 Comment

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,

...

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

Query for Identifying the Concurrent Program Trace file Path location

Published by

malli_18arjun

Introduction

The following query helps to identify the Trace file path location for a particular Concurrent Request

Pass the request id as parameter

SQL Code:

Code sql:

 SELECT
    req.request_id
    ,req.logfile_node_name node

...

4 Comments

Identifying Unposted Journals in Oracle General Ledger

Published by

prashantrais

Here is the code to identify Unposted Journals in General Ledger, these journals are from gl_interface

Code sql:

SELECT          user_je_source_name,
                  accounting_date, COUNT(accounting_date),
                  SUM(accounted_dr), SUM(accounted_cr)
FROM   gl_interface

...