+ Write Article

Oracle Articles Examples, Tutorials and Articles

Published by
Finding islands – 4 methods in Oracle

SQL & PL/SQL

Finding islands are classic problems in PL/SQL. The basic concept is that you have some sort of numbers, like these: 1, 2, 3, 5, 6, 8, 9, 10, 15, 20, 21, 22, 23, 25, 26. The islands problem involves identifying ranges ...
Read More Read More
Published by
Introduction

Query to get the Concurrent Programs Details from backend.

SQL Code:
Code sql:
SELECT DISTINCT fcp.user_concurrent_program_name "Concurrent Program Name",fcp.description "Concurrent Program Description",
fef.executable_name"Executable
...
Read More Read More
Published by
Easy Customization

Flexibility is important. There is no way for you to anticipate all the form and database fields your end users might want, nor how each field should look as end user needs change. Using Key and Descriptive flexfields, you give end users the ability to customize your ...
Read More Read More
Published by
Query to Find list of peoples Locking AP Object

Code sql:
SELECT c.owner, c.object_name, c.object_type, fu.user_name locking_user_name,
fl.start_time, vs.module, vs.machine, vs.osuser, vs.SID, vp.pid,
vp.spid AS os_process_to_kill, vs.serial#, vs.STATUS, vs.saddr,
vs.audsid,
...
Read More Read More
Published by
View SQL Statement from OAF Page

Below are the detailed steps:

1) Update the following Profile Option Values to Yes at User level.
• FND: Diagnostics
• Personalize Self-Service Defn

2) Go to the Java OAF Page where the SQL Query executes ...
Read More Read More
Published by
Overview

1) The Application Programming Interface or API is a PL/SQL packaged procedure which can be used as an alternative entry point into the system to the traditional online forms

2) The advantage being that the same logic used by the seeded online forms can also be ...
Read More Read More
Published by
On the CLIENT machine create a FOLDER as say: c:\custom_test

In custom_test folder creates 2 folders forms, resource

Copy TEMPLATE.fmb, APPSTAND.fmb, .pll files to CLIENT

• Copy TEMPLATE.fmb , APPSTAND.fmb from AU_TOP/forms/US to c:\custom_test\ forms directory ...
Read More Read More
Published by
Article Preview
Introduction

Finding gaps is classic problem in PL/SQL. The basic concept is that you have some sort of numbers (like these: 1, 2, 3, 5, 6, 8, 9, 10, 15, 20, 21, 22, 23, 25, 26), where there’s supposed to be a fixed interval between the entries, but some entries could be missing. The ...
Read More Read More
Published by
Let’s see what the term Invoice Aging means? Why is it called Aging report? Where is the Aging report used? How does the Aging report work?

Why called Aging Report?

: Aging comes from the word Age. “Age” is the chronological representation of any phenomenon. Be it a person, ...
Read More Read More
Published by
Introduction

The following script helps you to create Table through Oracle Report.

Srw.do_sql (sqlstatement char);


Examples:
SRW.USER_EXIT('FND SRWINIT');

srw.do_sql('create table xxg4_y(ename varchar2(10))');
...
Read More Read More

Page 1 of 10 1 2 3 4 5 6 7