+ Write Article

Oracle Articles Examples, Tutorials and Articles

Published by
Purpose

This code is a generic version of a function posted recently by Jagadekara to calculate the sum of all digits of a given number up to a single digit which was limited to a 12 digit number.

This new function aims at removing this restriction and works for any number ...
Read More Read More
Published by
Code sql:
SELECT fif.id_flex_name
      ,fifs.id_flex_structure_name
      ,ffksv.parent_segment_name
      ,ffvrv.flex_value_rule_name
      ,ffvrv.description
      ,ffvrv.error_message
      ,decode(ffvrl.include_exclude_indicator,'I','Include','E','Exclude')
...
Read More Read More
Published by
Code sql:
CREATE OR REPLACE FUNCTION XXST_SUM_OF_DIGITS(p_num NUMBER) RETURN NUMBER IS
  a NUMBER(12);
  b NUMBER;
  c NUMBER;
  d NUMBER;
  e NUMBER;
BEGIN
    a:=P_NUM;
    b:= nvl(substr(a,1,1),0)+nvl(substr(a,2,1),0)+nvl(substr(a,3,1),0)+nvl(substr(a,4,1),0)
...
Read More Read More 6 Comments
Published by
Hi All,

The following Query gives you the PO Details in R12 which have receipts and which don't have Invoices.

Code sql:
SELECT asp.vendor_name
      ,pha.segment1
      ,pha.creation_date po_date
      ,pha.type_lookup_code
      ,SUM(pla.unit_price*
...
Read More Read More
Published by
Opened Forms details Query

Code sql:
SELECT ffv.user_form_name, ff.FUNCTION_ID, ff.FUNCTION_name
    ,to_char(flr.end_time,'dd-mon-yyyy hh24:mi:ss')  end_time
    , to_char(flr.start_time,'dd-mon-yyyy hh24:mi:ss')  start_time,
      (flr.end_time - flr.start_time)*24*60 duration
...
Read More Read More
Published by
Query To Display All Forms and Pages for a Responsibility In Oracle Applications R12

Code sql:
SELECT  fmev.prompt , user_function_name,TYPE
FROM (SELECT * FROM fnd_menu_entries_vl WHERE prompt IS NOT NULL AND grant_flag ='Y' ) fmev
    , fnd_form_functions_vl ffv
WHERE fmev.function_id
...
Read More Read More
Published by
Query to Display Payables Options Details In Oracle Apps R12

Code sql:
-------------------------------------------------------------
SELECT hou.name "Operating unit"
-------Accounting Option Tab Details--------------------------------------------
      ,aspa.when_to_account_pmt
...
Read More Read More 1 Comment
Published by
Query to display Finacial Options details in Oracle apps R12

Payables
Set Up
Options
Financial Options

Code sql:
SELECT hou.name "Operating Unit"
      ,fsp.future_period_limit 
      ,gcck.concatenated_segments
...
Read More Read More
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

Page 1 of 10 1 2 3 4 5 6 7